In this article
This command imports and updates the current market prices of your securities by reading data from either a CSV file or Excel. Once you confirm the operation, the new prices are written to the UnitPriceCurrent column in the Items table.
You can gather current market prices from various financial portals (e.g., Yahoo Finance, Google Finance, ecc), directly copying the latest quotes into an Excel or CSV file. Ensure each security’s ISIN and current price are correctly aligned with the required format (one ISIN-price pair per line). When you’re satisfied with the data, save it or copy it into the format required for importing. The ISIN must have the same format as the ISIN inserited into the Items table.
Data Format
The extension expects the data to be in the following two-column format, with ISIN and Current Price separated by a semicolon (;):
US123456789;11.04873
IT000792468;10.98732
...
- First column: The ISIN (or security identifier).
- Second column: The latest market price, without thousands separators and using a period (".") as the decimal separator.
How It Works
- Open the command: Choose Import & Update Current Prices from the menu or toolbar.
- Select the file: In the dialog, you can either browse to a CSV file or paste data directly from Excel containing ISIN and price pairs.
- Preview and confirm: The extension parses the data, matching each ISIN to the corresponding security in your accounting file. You will see a confirmation dialog listing the changes, so you can verify them before they are applied.
- Update current prices: Upon confirmation, the program updates the UnitPriceCurrent column in the Items table with the new market prices.
