Hi!
I see cases when Capitally is taking the currency rate using the expected dividend date and not the actual payment date. The value is incorrect, even though the label below the exchange rate is showing the correct date.
See the last dividend on the attached report screenshot.
Thanks for reporting this. I’ve double checked on my side, and it actually resolves correctly
the FX date is 13 dec, as 16th is Monday, so -1 is 13th - the same as in your case
and the FX rate is the one you found at the source
What might have happened in your case, is that for some strange reason, the FX price for 13.12 wasn’t fetched into the cache and the last known price was returned instead.
I’ve modified the code that collects date ranges to be fetched, so that it includes paymentDate +/- 5 days as well (it didn’t).
Thank you, Rafał. Clearing site data helped.
Perhaps the logic around the FX in tax reports could be made stricter, to distinguish between “rate not fetched” and “rate not published”, so that we never use an FX rate from an incorrect date. Even if that means potentially displaying “NaN” with a warning icon suggesting to reload site data, if something goes wrong.