This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Download of UK unit trust prices

Tags: None
(comma "," separated)
plucas
Registered Member
Posts
21
Karma
0

Download of UK unit trust prices

Mon Aug 19, 2013 9:45 am
I have used the software for a month and all my data has downloaded from MS money fine. My M&S Shares update fine via Yahoo. I cannot for the life of me get my M&G Recovery Unit Trust to update. I have tried more or less all the sources.
Most of them fail totally :'( Yahoo finds a zero price and it comes up "invalid price". I know I have the correct ticker number and am familiar with the setup of these on other software. Can anyone please help. ^-^
KMY Money really is the answer to MS Money ending.
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS

Re: Download of UK unit trust prices

Mon Aug 19, 2013 10:20 am
Which version of KMyMoney are you using, and on which platform (Linux, Windows, etc)?


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
plucas
Registered Member
Posts
21
Karma
0
Thanks for answering :-

I am currently using KMy Money version 4. 6. 3. on Windows 7 platform :)
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS
Have you verified that the ticker ID required by the other services is the same for your unit trust?


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
Most important are your exact settings: See "Settings/Configure KMyMoney/Online Quotes". Select the Source and give us the settings. Also important is the symbol to be used for your investment. You can find that in the listing provided by "Tools/Update Stock and Currency Prices" in the symbol column.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
plucas
Registered Member
Posts
21
Karma
0
Hi

Thanks for the answers. On my other software I used you use MSN UK. That worked perfectly. That is not on KMy Money
So I have used Yahoo. Yahoo UK will not work at all

My Marks & Spencer shares update wonderfully and the M&G Recovery Unit Trust will not.
This is what I get on updating

Fetching URL http://finance.yahoo.com/d/quotes.csv?s=MKS.L&f=sl1d1...
Symbol found: MKS.L
Price found: 470.81 (470.81)
Price for MKS.L updated (id E000010)
Fetching URL http://finance.yahoo.com/d/quotes.csv?s ... &f=sl1d1...
Symbol found: GB0031959702.L
Price found: 0.00 (0)
Received an invalid price for GB0031959702.L, unable to update.

It seems the price is being found but somehow sending a zero price. I have tried FT UK and other options on this software but all seem to fail totally. I even adjust the ticker number according to the source. Any suggestions will be helpful. I think perhaps the additional option of Google finance and MSN UK on the software could help Pete
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
Thanks for the details. Here's what I did: visited http://finance.yahoo.com/ and looked for GB0031959702.L using the Search Finance button which yields http://finance.yahoo.com/q;_ylt=AgfEfYB ... nce_uh3_02 and shows data. Scrolling down, one can find a link on the right labeled Download Data (delayed) http://download.finance.yahoo.com/d/quo ... hgv&e=.csv which looks very similar to http://finance.yahoo.com/d/quotes.csv?s ... .L&f=sl1d1 which you used to download data. So I gave both a try. Here are the results:

http://download.finance.yahoo.com/d/quo ... hgv&e=.csv
Code: Select all
"GB0031959702.L",0.00,"N/A","N/A",N/A,N/A,N/A,N/A,N/A

http://finance.yahoo.com/d/quotes.csv?s ... .L&f=sl1d1
Code: Select all
"GB0031959702.L",0.00,"N/A"


Both empty. Looks like yahoo knows the symbol but does not present any data. So it could be an idea to try to extract the data from the web-page using http://finance.yahoo.com/q?s=GB0031959702.L The resulting page does contain the date in two spots:

Code: Select all
<!-- xslt1.finance.bf1.yahoo.com uncompressed/chunked Sat Aug 24 19:42:30 UTC 2013 -->
<span id="yfs_market_time">Sat, Aug 24, 2013, 3:42PM EDT - U.S. Markets closed</span>
I am not sure, if KMyMoney could handle either date format at all.

The symbol can be found in
Code: Select all
>Set Alert for GB0031959702.L<

and the price is here
Code: Select all
<span class="time_rtq_ticker"><span id="yfs_l10_gb0031959702.l">286.00</span></span>


Looking a bit further around, I stumbled across a link to download historical data which could be of help as well: http://ichart.finance.yahoo.com/table.c ... gnore=.csv . http://ichart.finance.yahoo.com/table.c ... 31959702.L works even better, since we don't supply a date as part of the link. Not sure if KMyMoney can deal with a list of data at this point.

Hopefully, this shows you a couple of options on how to extract prices.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
plucas
Registered Member
Posts
21
Karma
0

Re: Download of UK unit trust prices

Sat Aug 24, 2013 10:03 pm
Thanks so much for the info. I have just tried to make it work for the last two hours :'( . I got a download of a price but there must have been an error as it downloaded a similar figure for M&S. :-\ Its such a pity. I guess I will just have to update this stock price manually a couple of times a week. The software as a whole is probably on a par with MS Money so easy use and downloads my bank statements easily. ^-^
User avatar
Hei Ku
Registered Member
Posts
784
Karma
3
OS
Have you tried using finance::quote for this one?


Hei Ku, proud to be a member of the KMyMoney Development Team since January-2008
plucas
Registered Member
Posts
21
Karma
0
Hi
Yes I have tried that with the same result :'( I think if we had MSN UK on here as a source it would work. That's what I used on other software and it worked wonderfully!!!
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
You know, that you could add MSN UK as a source yourself to KMyMoney (we can certainly provide help to finish it up). A sample on how to analyze the web output is contained above in this thread. Once the details are clear, we are happy to add it as a pre-installed source to the project.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
plucas
Registered Member
Posts
21
Karma
0
Wow. I could give it a go. I am not really au fait with setting up these things at all. I can pull computers apart and put them together set up networks but programming script :-0 ... Well here goes :-)
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
Well, it's not really programming a script. It's more configuring an application at that point.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
plucas
Registered Member
Posts
21
Karma
0
Well This is what I have so far

URL http://uk.moneycentral.msn.com/investor ... px?symbol=
Symbol Empty
Price (\d+\.\d+) [+-]\d+.\d+
Date Time of last trade (\d+/\d+/\d+)
Date Format %d %m %y


Obviously not working this is what it comes back with
Fetching URL http://uk.moneycentral.msn.com/investor ... ?symbol=...
Symbol found:
Unable to update price for GB0031959702.L (no price or no date)

This happens for both Marks and Spencer and M&G Recover Acc
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
Loading http://uk.moneycentral.msn.com/investor ... uotes.aspx and entering GB0031959702.L as the symbol and doing a search on their web-site yields no search results. I don't wonder that we don't get anything. Please try using a web-browser to get some results so that we know what to look for. TIA.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5


Bookmarks



Who is online

Registered users: Bing [Bot], Evergrowing, Google [Bot], q.ignora, watchstar