You can customize the market price data in Capitally for any asset in your portfolio. This allows you to track any asset, whether publicly traded or not, and tweak the market data if it does not match your records.
You can set custom prices on any asset apart from cash, even the ones that have market prices updated automatically. Your custom prices will simply override the market price for that date.
Open the asset details and go to the
Click the blue
+ in the prices table.
Enter the date and price.
You can add multiple custom prices by copying and pasting rows from a spreadsheet with two columns for date and price.
You can set prices in the future as well. By enabling
Approximate prices with a straight line option below the table you can emulate interest-based assets, just like in our demo.
When editing a Buy, Sell or Balance transaction you have an option to specify the current market price. Just click the pencil ✏ icon next to the
Market Price and save the transaction.
When viewing the
Positions tab in Portfolio, you can double click on a row, or choose
Edit position from the context menu. You can change both the Quantity and Market Price there, so it's great to quickly update your account balances and market prices of custom assets.
The quantity and price is set for the date you are currently viewing - so
today by default.
You can change that date in the Date Period selector above the graph.
You can download or prepare a CSV file with columns for Date, Asset Name/Ticker, and Market Price. Then just follow the guide on importing from the file. For the Transaction Type you want to choose
Account Balance or
Update Market Price and remember to assign the price column to
This is a great way to import prices for a single asset, but you can also use it to import prices for a bunch of assets. It's especially useful if you have a custom asset like bonds, and your broker provides you with a table of current prices or value of your assets.
If you have assets that require manual price or balance updates, you can streamline updating them by:
Adding a Tag to the asset (eg.
Last Manual Price Update in the Assets tab and sorting on that column in descending order
Now you can navigate to the
Manual Updates tag, open the
Positions tab and see the list of assets that need to be updated (with the ones being the most out-of-date on top). You can then update both the price and balance by double-clicking the table rows.
You can bookmark that view to quickly open it in the future with the same settings.