Bug 360044

Summary: Online updater finds data but doesn't understand it.
Product: [Applications] kmymoney Reporter: Cameron <cambarc>
Component: generalAssignee: KMyMoney Devel Mailing List <kmymoney-devel>
Status: RESOLVED NOT A BUG    
Severity: major CC: agander93
Priority: NOR    
Version: 4.7.2   
Target Milestone: ---   
Platform: Microsoft Windows   
OS: Microsoft Windows   
Latest Commit: Version Fixed In:

Description Cameron 2016-03-03 23:18:36 UTC
INVP.L (Investec stock) appears on Yahoo UK with a current price and time stamp. The online updater finds the data but says it has no price or no date.

Similar outcome with a fund.

GB0032494576.L (Aviva Investors Higher Inc Pls A GBP Inc)

Reproducible: Always

Steps to Reproduce:
1.Create stock / fund and set relevant lookup ID and set to Yahoo UK
2.Run Online Price Update
3.

Actual Results:  
1) INVP.L (Investec stock)
Message on price up date popup: Failed to retrieve a quote for INVP.L from Yahoo UK. Press No to remove the online price source from this security permanently, Yes to continue updating this security during future price updates or Cancel to stop the current update operation.

Status on "Update Stock and Currency Prices" dialogue: Fetching URL http://uk.finance.yahoo.com/d/quotes.csv?s=INVP.L&f=sl1d3...
Symbol found: "INVP.L"
Price found: 488.80 (488.8)
Unable to update price for INVP.L (no price or no date)

2) GB0032494576.L (Aviva Investors Higher Inc Pls A GBP Inc)
Message on price up date popup: Failed to retrieve a quote for GB0032494576.l from Yahoo UK. Press No to remove the online price source from this security permanently, Yes to continue updating this security during future price updates or Cancel to stop the current update operation.

Status on "Update Stock and Currency Prices" dialogue: Fetching URL http://uk.finance.yahoo.com/d/quotes.csv?s=GB0032494576.l&f=sl1d3...
Symbol found: "GB0032494576.l"
Price found: 55.0000 (55)
Unable to update price for GB0032494576.l (no price or no date)

Expected Results:  
Since the page isn't displaying a date, should the application not assume 'today' and interpret the price data.


Similar outcome with a fund.
Comment 1 allan 2016-03-04 00:11:49 UTC
(In reply to Cameron from comment #0)
> INVP.L (Investec stock) appears on Yahoo UK with a current price and time
> stamp. The online updater finds the data but says it has no price or no date.
> 
> Similar outcome with a fund.
> 
> GB0032494576.L (Aviva Investors Higher Inc Pls A GBP Inc)
> 
> Reproducible: Always
> 
> Steps to Reproduce:
> 1.Create stock / fund and set relevant lookup ID and set to Yahoo UK
> 2.Run Online Price Update
> 3.
> 
> Actual Results:  
> 1) INVP.L (Investec stock)
> Message on price up date popup: Failed to retrieve a quote for INVP.L from
> Yahoo UK. Press No to remove the online price source from this security
> permanently, Yes to continue updating this security during future price
> updates or Cancel to stop the current update operation.
> 
> Status on "Update Stock and Currency Prices" dialogue: Fetching URL
> http://uk.finance.yahoo.com/d/quotes.csv?s=INVP.L&f=sl1d3...
> Symbol found: "INVP.L"
> Price found: 488.80 (488.8)
> Unable to update price for INVP.L (no price or no date)
> 
> 2) GB0032494576.L (Aviva Investors Higher Inc Pls A GBP Inc)
> Message on price up date popup: Failed to retrieve a quote for
> GB0032494576.l from Yahoo UK. Press No to remove the online price source
> from this security permanently, Yes to continue updating this security
> during future price updates or Cancel to stop the current update operation.
> 
> Status on "Update Stock and Currency Prices" dialogue: Fetching URL
> http://uk.finance.yahoo.com/d/quotes.csv?s=GB0032494576.l&f=sl1d3...
> Symbol found: "GB0032494576.l"
> Price found: 55.0000 (55)
> Unable to update price for GB0032494576.l (no price or no date)
> 
> Expected Results:  
> Since the page isn't displaying a date, should the application not assume
> 'today' and interpret the price data.
> 
> 
> Similar outcome with a fund.

I'm not sure that your suggested 'Fix' is a good idea, and does nothing to resolve the problem.  So, next time you try to update, if you do actually retrieve a valid price, it too will receive  today's date and will overwrite your previous entry.

Retrieving pricing information from different web-sites is error-prone, I'm afraid as the sites have a tendency to change the data format, with little regard for their users.

There is more than one possible 'solution'.  The first is to try a different web-site.  I tried ft.com, inputting your fund name and was able to get an up-to-date quote.  The other way is to examine the web-page source data and look for the details you require.  You would then need to amend the settings in your kmymoney file to suit the actual data format in use.  That involves some knowledge of interpreting regex formats, however.

In both cases, though, the process may need to be repeated from time to time.