You can import a file of dated prices into an existing Custom Investment in Navexa web. This is useful when you have several historical valuations or a series of unit prices to add.
Price imports update the holding’s valuation history. Buys, sells, quantities and income are managed separately. Custom Investments still have no automatic price feed.
Prepare your price file
Import prices for one Custom Investment holding at a time. Use a CSV (.csv) or Excel (.xlsx) file.
Open the Custom Investment holding in Navexa web.
Select Actions → Import Prices.
Select Download template and replace the example rows with your prices.
The template contains these columns:
Date: The date the valuation applies from. Follow the date format in the downloaded template.
Price: The price per unit, in the Custom Investment’s currency.
Note: Optional context, such as the source of the valuation.
Use prices consistent with how you recorded the holding’s quantity. For example, if you track 1,000 units worth AUD $2,500 in total, enter a price of 2.50. If you track an entire property as a quantity of 1, its price is the total property valuation.
This price template is separate from the Unlisted template used to import buy and sell trades. For trade imports, see Importing Custom Investments from a Spreadsheet (property, bonds, art & more).
Upload and review the prices
In Import Prices, select Choose file and choose your completed file.
Select Upload and wait for the Preview.
Compare the holding name, date range, price count, dates, prices and notes with your source records. If the columns were picked automatically, check that the dates and prices were identified correctly.
If the preview is incorrect, correct your file and upload it again before confirming.
Example price data shown in the Import Prices preview.
Choose whether to replace existing prices
Replace prices on dates that already have one is unticked by default.
Leave it unticked to keep existing prices on dates already recorded.
Tick it when you intend to replace prices for matching dates with the values in your file.
Check this choice before selecting Confirm, especially when your file overlaps the holding’s existing price history.
Save and check the price history
Select Confirm to save the import.
Check the imported-price confirmation.
Open the holding’s Prices tab and check the saved dates and prices against your file.
For a single valuation, you can still use Add Price. For individual price changes and the relationship between trades and prices, see Add a Custom Investment.
Remember, this is general information, not personal financial advice.