My earlier post used screenshots taken from my Linux Mint laptop.
This new post was created using my Windows 11 desktop PC.
It looks like the issue isn’t specific to a machine/OS, but they do share the same database file synchronised in my cloud storage.
When I select the previous trading day, the change should be -4.07%, but the application TTWROR and Capital Gains % FIFO show +1.77%. Unfortunately, there isn’t a pop-up displayed when I hover over that value.
Thanks for the screenshots. Can you also take a screenshot of the “Historical Prices” tab (the one next to the price chart). Those are the prices actually stored in the file.
(The dialog retrieves files ad hoc - the idea being one wants to change the configuration. But if you do not change the configuration, it will not necessarily update the prices.)
The calculations have gone back to using correct values. I think I noticed this behaviour a few weeks ago when I was on holiday - i.e. the calculation problems may be isolated to Monday and Tuesday.
Some comments: there are cases where the TWR Last Trading Day and Delta% should be different :
If there wasn’t a price update today. The Delta% will show the delta 12 Sept vs 11 Sept. But TWR Last Trading Day calculate 15 Sept vs 12 Sept, no price change, 0%.
If the reporting currency is not the same as the instrument currency. The Delta% with show the change in the currency of the security. But the TWR uses not only the change in price but also the change in exchange rate.
Outside of those cases, I guess it can be investigated.
Example case 1 :
The definition of Last Trading Day is from end of Sept 12 - to end of Sept 15
But for a stock without a price update today (some price supplier can be late), the delta% therefore is not updated and stays between the last two previous price : from Sept 11 to Sept 12
Hi, I see that the IT, Ashoka India Equity has been mentioned a couple of times in this thread. Just wondering if the pricing data for this has been sourced from Yahoo Finance? I say this as its the 18th today, yet the latest data it lists is as of the 17th - AIE.L/history. This Yahoo Finance oddity seems to apply to all ITs - a further reason why its not to be trusted!!
Good luck with that then. Incidentally something seems strange with the latest quote / Day’s low @£265.50. According to LSEs website Ashoka hasn’t dropped below £269 today
The TTWROR correctly shows the day’s change as zero, but the change on previous day is still showing yesterday’s calculation.
Could this be part of the problem - i.e. change on previous day is calculated using the quotes from latest and historical with no reference to the current date?
Yes, in my post 10 days ago, this was what I described as “Case 1” and for which an example was provided.
In this case, it is the intended behaviour that those two values are different.
