First of all, I really love this application. It’s quite extensive and full of features. Might not be suitable for beginners, but I happen to like it a lot. Thanks for the great work.
I do have found an issue I’d like to address. I have a few positions on ETFS on LSE in USD. Unfortunately the online historical quotes provided by ICE Data Services are wrong (and thus also wrong on Yahoo & Alpha Vantage). So I havo to use the „Create historical quotes from transactions“ feature. Sounds great, except it screws up the currency conversion to EUR. I don’t know exactly why this happens, but it doesn’t work as it should.
Hm, this looks strange but did you already check a buy transaction how the quote in USD is calculated? I assume (based on the min/max gap of 0,60 USD) the buy plots screwed up due to additional fees and/or taxes.
A screen dump of one of your latest buy transaction could may clarify the applied quote calculation.
Here’s a screenshot of a transaction. A few things to note:
Note there’s a comma in the EUR/USD exchange rate (circled in red) and the share price (right of ‚Quote‘). I found that to be peculiar, as everything else has decimal symbol point.
The fund is not listed in GBP. That cannot be the issue.
Unfortunately these prices are wrong. £468 does not equal $5.5 or €5. I already informed ICE Data Services about this. Could take a while before these are fixed.
I think I found one more clue. When I export all quotes from PP (from the ‚All securities‘ screen) I get all quotes in EUR. These should be in USD, as the currency of the fund is in USD.