Prices

Overview

These files provide the market price of one unit of each asset you own at different points in time. You have to provide the market price of each asset for each snapshot so the program is able to determine the valuations of your assets, as well as the latent capital gains or losses. The program is currently not able to automatically retrieve these prices hence these have to be provided manually. The prices should be expressed in the currency in which the investments are bought and sold. For stocks and funds, this is the trading currency. In other words, you should provide the price using the currency which you used to buy and sell each asset. The program will use the exchange rates provided to automatically convert the trading currency into the primary currency.

Examples

Here is how the demo prices are defined in the example files.

-------------------------------------------
| Asset | Date       | Currency | Price   |
-------------------------------------------
| BTC   | 2024-12-31 | GBP      | 76103   |
| ETH   | 2024-12-31 | GBP      | 2713    |
| VEVE  | 2024-03-31 | GBP      | 78.13   |
| VEVE  | 2024-06-30 | GBP      | 80.6    |
| VEVE  | 2024-09-30 | GBP      | 80.26   |
| VEVE  | 2024-12-31 | GBP      | 85.43   |
| VWRD  | 2024-03-31 | USD      | 127.81  |
| VWRD  | 2024-06-30 | USD      | 131.76  |
| VWRD  | 2024-09-30 | USD      | 139.21  |
| VWRD  | 2024-12-31 | USD      | 137.79  |
-------------------------------------------

Asset

The asset column refers to identifiers of assets.

Date

The date column contains to the data for which the price is provided.

Currency

The Currency column contains the name of the currency in which the asset price is provided. This should normally be the trading currency, ie the currency which is used to buy or sell this asset.

Price

The Price column contains the price of one unit of the asset at the date specified. Some snapshots may not be relevant for all of your assets. For example, you may have decided to buy a new type of stock very recently. In which case there is no need to provide any price for this assets for previous snapshots.