Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
PS v3.0 and v2.4 exchange rate differences
I run both versions of Portfolio Slicer, and each runs in its own directories.
I've noticed a discrepancy between the USD accounts on the Overview tab. When in USD, the numbers match in both; however, when changing to CAD, the numbers are off between the two - by $59.
Do the two versions handle exchange differently? I've looked at the exchange rates in the CurrExch and CurrExchIntraDay folders, and they are the same in both.
Thank you
I've noticed a discrepancy between the USD accounts on the Overview tab. When in USD, the numbers match in both; however, when changing to CAD, the numbers are off between the two - by $59.
Do the two versions handle exchange differently? I've looked at the exchange rates in the CurrExch and CurrExchIntraDay folders, and they are the same in both.
Thank you
Comments
Qty * PriceOriginalCurrency * ExchangeRate
So this formula is used for each symbol and then results are added up to get Equity value.
There is a slight difference between v2.4 and v3.1 on how Exchange Rate for each symbol is calculated.
In version 2.4 we choose Exchange rate from the latest date when the symbol had quote.
In version 3.* we choose Exchange rate from the latest date when there is an exchange rate record in CurrencyConv table.
Probably you have symbols that do not have quotes for each day and because of that in v2.4 is used from a day before. This introduces this slight difference in results.