Converting currency is difficult, but this task is made more difficult with my dividend portfolio tracker spreadsheet, which appeared to be converting currencies twice. This didn’t have an impact on the main market tabs, only the main summary view for the charts.
I’m not entirely sure how I managed to configure the spreadsheet to convert currencies twice, but there we go. Luckily, this wouldn’t have impacted figures in the main market tabs, nor the summary table where you can quickly glance at your portfolio performance.
It’s a quick and easy fix, which you can find below.
- Fixed incorrect conversions in the Data tab.
How do I update my tracker?
This is an easy update to apply to your template. Simply follow these steps:
- Select each cell
Datatab. Remove the last part of the formula after the closing bracket. Should be something like
*H16. This is converting the already converted number.
- Do the same for the cells
Q14. Note that some of these cells may not have that part of the formula, which should be your base currency/market.
- Drag each cell all the way to the end of the spreadsheet to copy the code to the corresponding cells.