Update market prices

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.

Import procedure

As metioned, you can import the data in two different ways.

Import *.csv file

1. Select the extension from the menu Extensions->Investment accounting->Update market prices
2. Select the*.csv file.
3. Check the changes preview in the 'Commit changes' dialog and confirm them.

Import from clipboard

1. Via the menu Actions > Import to accounting > select Import File box
2. Choose the extension to be used, in this case: '2. Update market prices'.
3. Open the Excel file, press Ctrl+A to select all the data, then Ctrl+C to copy the data to the clipboard.
4. In the dialog in the dialogue check the box Import data from clipboard.
5. Press OK Button.
6. Check the changes preview in the 'Commit changes' dialog and confirm them.

Error Messages

• Unrecognised *.csv file format: The format of the *.csv file you are trying to import does not match the format.
  • Check that you have chosen the correct file.
  • If the file you have chosen is correct, the format of the data could not be the correct. See the Data Format paragraph on the current page for more information about the format to use.