Skip to content
TurbobullsDocs
DocsAssets

Import a price history from a file

A custom asset can take years of prices from a CSV or Excel file, read on your device: you see every price before it goes in, and nothing is kept until you save the asset.

A guide4 minutes
Before you start. Prices from a file go into a custom asset, one you added because the market does not price it, such as a pension fund or a private fund: see Add a custom asset. An asset from the market has its prices already. You need a file with a date and a price on each line.

Open the import

Open the asset's page on Assets, press Edit, then Prices, and press Import from file. With no prices yet, the asset's chart offers Import prices, and the empty price list Import from file: both open the same window.

AssetsEditPricesImport from file

The window is called Import prices, with the asset's name and its currency under it, such as Pension fund · prices in EUR. Back, at the foot, or the arrow at the top left takes you back to the prices.

Drop your file

Drop the file on Drop your price file here, or click it to choose one, CSV or Excel. Under it, three promises: Read on this device, never uploaded, You see every price before it goes in and Nothing is kept until you save the asset.

What the file needs says it in one line: A date and a price on each line. Other columns are left alone. Where to find one lists three places: your fund or pension provider's site, under Price history or NAV history (the value of one unit of the fund, day by day), then Download; a market site's Historical data page, saved as CSV; or your own spreadsheet, saved as CSV or Excel. Any date order and either decimal mark will do: you check how they were read next.

Check what it read

The file's name comes first, with how many lines and columns it has, and Choose another file. Four tiles sum it up: Prices, with how often they come, such as monthly; First and Latest, each with its date and price; and Change, over the whole file. A chart, From your file, draws them.

Columns shows which column holds the Date and which the Price, picked from the file's headings: pick another if one is wrong. When every date could be read either way round, it shows how one of them reads, such as Every date fits both orders. 04/03/2025 reads as Mar 4, 2025., with Day first and Month first. Dates read the wrong way round? Pick the other. Prices that could be read two ways, such as 1,250, get Dot decimal and Comma decimal the same way. When the file settles it, a tick says so instead, such as Dates read day before month: 31/01/2025 can only be read that way.

Decide about the prices you typed

If the asset has prices already, a card under Columns compares them with the file, such as Your 12 prices, with 8 of their dates are in the file. On a date both have, the file's price is used, and the card lists each price of yours that changes, such as The file's price is used on those 8 dates. 2 of yours change:, with your price crossed out and the file's beside it.

Your prices on dates the file does not have stay, unless you tick Also remove your 4 prices on dates the file does not have. The list then holds the file's prices alone.

Add them, then save the asset

The button at the foot says what it does, such as Add 16 prices, Update 2 prices when the file has no date you lack, or Nothing new to add. Press it: you are back on Prices, a message says Added 16 prices. with Undo, and a note above the list says 16 prices from navs.csv are in the list, and 2 of yours were replaced by the file's. Save the asset to keep them.

Add 16 pricesPricesSave asset

Press Save asset to keep them. Until then nothing is kept: Undo puts the list back as it was, and closing the window asks Discard your changes? first.

Worked example

You keep a pension fund as a custom asset, in euros, with 12 prices you typed: the last day of each quarter of 2023, 2024 and 2025. Its provider's file has a price for the last day of each month of 2024 and 2025, and 2 lines with no price.

Count
Your prices, one a quarter from 2023 to 202512
Rows of prices in the file: 24 month ends, and 2 with no price26
Dates in both: the quarter ends of 2024 and 20258
24On the Prices tile: 26 rows, less the 2 left out
16Added, so the button reads Add 16 prices: 24, less the 8 dates you had already
2Of yours that change, where the file's price differs: the other 6 are the same
28On the list once you save: 12 + 16. Ticking Also remove your 4 prices on dates the file does not have leaves 24.

Good to know

Lines left out

A card such as 2 lines left out lists each one with its row and why, such as dated after today, no price, a price of 0 or not a date: fix them in the file and import it again. A day given twice keeps one line: the later time of day, or with no time, the line further down.

Prices in another currency

A file can name its currency: in a column of its own, beside each price, or in the price column's heading, such as Close (USD). When it differs from the asset's, the window says This file's prices are in USD, and this asset's are in EUR. They are added as they are, not converted. If the file is right, change the asset's currency on General first. An asset with no currency yet takes the file's.

Up to 10,000 prices

An asset keeps up to 10,000 prices, nearly 40 years of weekday prices. A longer file adds its newest 10,000 and says from which day. If your own prices take it past 10,000, the oldest are left out, and the window says where the list then starts.

On a linked asset

An asset that takes its prices from your own price source shows Add older prices from a file instead, and the window is called Add older prices. The file then fills only the days with no price, such as those before the first close: every price the asset has stays, and so does the link.

A file it cannot read

No dates and prices in navs.csv. means no line held both: open the file to check, or download the price history again. When two rows write their dates or their prices two ways, the window names both rows: fix the file, then choose it again.

Between two prices

The asset keeps a price until the next one. With Estimate prices between points on, it follows a straight line from one price to the next instead, which suits a monthly file.

Something missing, or not what you see in the app?Tell us in the community