Wrong high values with Google in some cases

[Djobydjoba]

Hi, me again...

Most of my index investments use the Google (Real Time) as primary server and Google (Historical) as secondary server. I have regularly big spikes in my TA graphs for these index investments (let's say 5 spikes per quarter), due to a wrong high value (a very low high value to be precise) that is retrieved. These mess up the graph. The spikes are for several (or many, or all) indexes for a same day, so it is not related to a problem with a particular investment. I've investigated the problem, I think it can be reproduced when the price retrieval is done the week-end with Google (Real Time), and so the wrong high value is retrieved for the prior Friday. So most of the time the problem is with Friday prices, but there can be other days than Friday where a wrong high price has been retrieved. For example, I have wrong high values for the 23/11 for some US indices. Perhaps it could be related to public holiday.

When I delete the prices with wrong high values and do an historical price retrieval with Google (Historical), the prices are always correctly retrieved then. But often too the prices may not be retrieved for some days, so this could prove that some days perhaps there was no quotation, and that Google (Real Time) had retrieved an invalid / non existent price. It's my guess. For example, if I delete the problematic price for the 23/11 and do a download with Google (Historical), no prices are retrieved for this day. Because of this, just doing an historical retrieval of prices doesn't fix all the spikes, manual deletion is often necessary for some.

Here's a screenshot of the S&P 500 graph:
https://img15.hostingpics.net/pics/9226 ... 1h4701.png

The spikes and very low high values can be seen for the 23 and 24/11. (PS : and the volume is 0 too)

With the symbol of the S&P500 (INDEXSP:.INX) for example, you should be able to reproduce the problem (at least a part of it) if you do a retrieval with Google (Real Time) the week-end.

Thanks!

[Mark]

Hi Djobydjoba,

Is the problem that Google is reporting an incorrect price, or Fund Manager is importing it incorrectly? If you're using Google (Real-time) FM should be pulling in the exact price shown on their website. If this isn't the case, you can confirm if FM is pulling in some wrong data by looking at the detailed price retrieve log (Help / Logs / Price Retrieve (Detailed)...), and the imported price in FM. If FM is pulling in a wrong price, please email me the detailed log, and the price FM pulled in versus what it should have been based on what is in the log.

[Djobydjoba]

Hi Mark,

In fact the problem (wrong High and Volume values retrieved with Google Real Time quote server) seems at any time.

Here are the prices displayed on the webpage:

20171128-mar.20h04-01.png (17.23 KiB) Viewed 2599 times

What is retrieved:

20171128-mar.20h27-01.png (19.62 KiB) Viewed 2599 times

The Close, Open and Low are correct (the Close value is refreshed constantly, so it have changed the time of the screenshot). High and Volume are incorrect. High: the first number is missing (621,31 instead of 2,621.31)

For information, I use the 1.000,00 Number Format in General Preferences (don't know it this is useful to know).

The Price Retrieve (Detailed) log is attached to this post.

Thanks.

[Mark]

Hi Djobydjoba,

Thanks for the nicely detailed problem report. I see the same issue, and will investigate.

[Mark]

Hi Djobydjoba,

We've just released quote module 526 to fix this issue. Please let me know if you see any more problems.

[Djobydjoba]

That was fast! Seems fixed, thanks!