Daily movement calculation is incorrect?

I’ve noticed that there is a problem with the price change calculation in the tool.

For example, this security AIE.L

07/07/25 = 281
08/07/25 = 280

The price change is -0.36%.

The tool shows the price change as -0.09%.

The historical and latest quotes are showing today’s price as 280.

Google is showing the price change as -0.36%

Is this a bug or does the tool calculate the price change in an unusual way?

What’s your reporting currency? GBX?

Yes, AIE is reported in GBX.

image

No the question is about your reporting currency not the stock currency. Cause when they are not the same, I assume the fx is calculated as well.

I am in the UK and my reporting currency should be GBP/GBX.

Where can I check that setting?

Statement of Assets top right corner:
image

I see, no fx then.

So it’s a bug?

I don’t think so, cause it’s quite impossible you discover a bug as the first person for a generic feature which exists for years.

@omit9154

When you hover the mouse pointer over -0.09 in the “%” column and -0.25 in the “amount” column, PP should show you the exact values and dates on which the calculation is based:

The ‘Latest’ price doesn’t match the ‘pop-up’ price.

and it doesn’t match either the historical or current prices.

The value in the ‘Latest’ column appears to be taken from the ‘Historical Quotes’ feed, rather than the ‘Latest Quote’ feed.

The ‘Latest Price’ pop-up value isn’t in either feed?

As I was trying to replicate the issue, I added AIE.L as a security, and initially it looked like this:

Then after updating prices for the first time, prices were more consistent:

Then, after waiting a little while to let the cache expire, another price update:

After a few more updates, I managed to get the “Latest price” in the pop-up to not match the prices in any of the other locations. So yes, I agree that something doesn’t seem to add up.

I reported a similar bug only last month (here) and I thought it had been fixed, but this issue seems related. My PP version is 0.77.3, are you using the same version?

I’m using the latest version.

Thanks @melita for the screenshots.

Keep in mind that the “edit dialog” - the two lower screenshots in your screen - fetch prices from the provider. That is what the provider returns at that point in time (yes, possibly returning it from the cache). But unless you press ok, the prices in the local file are not updated. The idea being: as a user, I want to check alternatives configurations - but only when 'ok’ing, I want to update. (Maybe I have to reconsider and always update at least the prices :thinking:)

Long story short: there can be cases where the “latest price” in the dialog differs from the one in the tables. The dialog shows the one just fetched, but unless you do not press ok, that is not immediately taken over (in a regular interval latest prices are updated in the background).

Again, this is by intention. The idea being: the “Latest Quote” provides a price at any time during the day. If PP gets a “Historical Price” for the same date, then it assumes that price is a better price point for the day because it is most likely the “end of day” price.

This “Δ %” tables always uses the last known prices. It could be the latest price plus the last historic price, but it could also be the last two historic prices - if there is no latest price available or it is not newer than the last historic price.

But…

I agree something is off. The 284.445 for 9 Jul seem not to match the historical prices (what I would expect) and not the latest prices. I have to investigate. Thanks for your patience.

Should I be using the ‘Portfolio Performance (built-in)’ feed for the ‘Latest Quote’ as well as the ‘Historical Quote’?


Could this issue be related to this issue?

I’m seeing strange calculations when setting the view to 1 month, etc.

The Delta Amount and Delta % are locked and don’t change when the time period is changed.

This is 1 month

image

This is 1 year.

image

** Edit **

Sorry, i didn’t realise these columns were purely based upon the previous day.

I’m seeing strange results when the time period is set to ‘previous trading day’.

The securities have data for the previous day.

** Edit **

I closed and reopened the app and it completely changed the calculations for the current and previous trading days.

Unfortunately, I didn’t think to get the logs before restarting the app.

image

I’ve been noticing some incorrect calculations recently. I usually have my view set to ‘1 trading day’, but the calculated gain/loss doesn’t reflect the current or historical prices.

For example, this security is showing a price drop of 8%, but the actual drop is 2.39%.

The historical quotes and latest quotes don’t appear to be used in the calculations.

Is it using yesterday’s ‘high’ to perform the calculation? Yesterday’s High was 3.5p, but the Close was 3.3p

Actually, the “high” is not saved in the file. Only the close. Here PP thinks yesterday’s close was 3.501

Can you show how you have configured the “Latest quote” (the next tab).
And can you show what the lower right part (next to the price chart) shows as “Latest price”.

The column looks at the last to known prices (here 2 and 1 September).

Or, alternatively, create a copy of your file, delete all transactions and instruments but this one and share it with at portfolio dot performance dot help at gmail dot com.