The Market Price tab in the Excel Transaction Loader allows you to load market prices for community-level and business-level securities where the market code is USER or ASX.
Instructions for setting up business-level security can be found here.
Use this tab to record security prices that should be recognised on a specific date for valuation and reporting purposes.
- Validation - Indicates whether all mandatory fields in the row have been completed correctly.
- Security Code - Enter the security code for the security you want to load the price for.
- Price Date - Enter the date on which the price should be recognised.
- Price - Enter the price of the security on the specified price date.
- Buy price - Enter the buy price of the security on the price date. This field is only applicable when Price Type is set to Sell.
- Price Type - Select the type of price being loaded. Available options are: Ex Div, NAV, Sell.
-
Continuing Price? - Indicates whether the price should continue to apply beyond the price date.
- False (default): The price is treated as a terminating price
- True: The price continues to apply until a new price is load