Reply to topic

KMyMoney & no stock quotes

mcarpino
Registered Member
Posts
28
Karma
0

Re: KMyMoney & no stock quotes

Mon Nov 13, 2017 9:33 pm
mbeenham wrote:I've populated my online stock quote field as per mcarpino (many thanks), but get the following error when trying an online update:
Fetching URL https://finance.google.com/finance?q=AZN.L...
Unable to update price for AZN.L (no price or no date)

I am running Linux, but cannot identify a "Google fix" from the URL provided.
I'm happy to dig in and try to find the cause of this issue, but if anybody has solved this problem already I'd appreciate a steer.


mbeenham Google recognizes AstraZeneca plc with a different symbol than yahoo. Yahoo requires the symbol AZN.L and it appears that Google looks for this symbol LON:AZN Try changing the trading symbol to LON:AZN I think it will work. Here's the web link for the stock as a reference https://finance.google.com/finance?q=LON:AZN
mbeenham
Registered Member
Posts
94
Karma
0
OS

Re: KMyMoney & no stock quotes

Tue Nov 14, 2017 12:31 am
mcarpino wrote:
mbeenham Google recognizes AstraZeneca plc with a different symbol than yahoo. Yahoo requires the symbol AZN.L and it appears that Google looks for this symbol LON:AZN Try changing the trading symbol to LON:AZN I think it will work. Here's the web link for the stock as a reference https://finance.google.com/finance?q=LON:AZN


I tried your suggestion but with the same result. From the browser the result of using LON:AZN and AZN.L are identical, both give a good report of AZN. I suspect the problem is in the parsing of the regular expressions, either date or price so I'll check those manually.

Thanks for your help.


Linux Mint 17.2
KMyMoney Version 4.7.2
Using KDE Development Platform 4.14.2
mbeenham
Registered Member
Posts
94
Karma
0
OS

Re: KMyMoney & no stock quotes

Tue Nov 14, 2017 2:55 am
My problem - when I copied and pasted the price REGEX I accumulated an extra character at the end...
All OK now, just got to go through and set all stocks to Google.


Linux Mint 17.2
KMyMoney Version 4.7.2
Using KDE Development Platform 4.14.2
aperali
Registered Member
Posts
16
Karma
0

Re: KMyMoney & no stock quotes

Tue Nov 14, 2017 10:00 pm
Is it possible to use %1 in Price and Date parameters? Im asking this because I have a HTLM source which has MANY mutual funds prices and dates inside it. All of them are grouped by their mutual fund codes (Symbol) which have the format like this 22.222.222/2222-22 followed by their prices and dates.
Example:
<td>22.222.222/2222-22</td>
<td>100.00000</td>
<td>2017-11-11</td>
<td>33.333.333/3333-33</td>
<td>111.11111</td>
<td>2017-11-11</td>

And for the Price should be something like this (I think):
<td>%1<\/td>\r?<td>(\d+.\d+)<\/td>
And for the Date:
<td>%1<\/td>\r?<td>\d+.\d+<\/td>\r?<td>(\d{4}-\d{2}-\d{2})<\/td>

Im trying to do this but it returns "Fetching URL http://teste.pythonanywhere.com/static/cotacoes.html...
Unable to update price for 22.222.222/2222-22 (no price or no date)"

Is it something related to "." or "/" in the fund code? Tried to use only numbers but doesn't work either.

If I replace the %1 by the fund code everything runs perfect.

Thank you,
User avatar ipwizard
KDE Developer
Posts
491
Karma
1
OS

Re: KMyMoney & no stock quotes

Wed Nov 15, 2017 6:47 am
aperali wrote:Is it possible to use %1 in Price and Date parameters?


The short answer: no, that is not supported. :( Please file a wish on our bugtracker, so that it does not get lost. Maybe link back to this forum entry.


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

Re: KMyMoney & no stock quotes

Wed Nov 15, 2017 9:04 am
ipwizard wrote:Please file a wish on our bugtracker, so that it does not get lost. Maybe link back to this forum entry.


Done! Do you have an idea when they are planning to release a new version of KMM (for Windows included)?
User avatar ipwizard
KDE Developer
Posts
491
Karma
1
OS

Re: KMyMoney & no stock quotes

Wed Nov 15, 2017 9:18 am
aperali wrote:
ipwizard wrote:Please file a wish on our bugtracker, so that it does not get lost. Maybe link back to this forum entry.

Done! Do you have an idea when they are planning to release a new version of KMM (for Windows included)?

For reference: the following link shows the entry 386939 on the tracker. Regarding the question about the next release: 4.8.x with x>0 has some momentum and includes a Windows build (since the main developer working on this branch of the software is using Windows). The KF5 port is still ongoing. A few things are still missing. Btw: they includes me ;) .


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

Re: KMyMoney & no stock quotes

Wed Nov 15, 2017 5:36 pm
I applied the "google fix" and was pleased to see the quotes update. However, I did this on Nov. 3, and the date reported in the list was Nov. 2. The quotes had not been updated since the last working Yahoo update. Today (Nov 6) I ran the update again. No errors were reported. However, the date associated with the quotes was still Nov 2, and from all appearances, nothing was updated.


I'm seeing a similar issue. For Vanguard mutual funds I get the correct price but the prior day's date.
dhochmuth
Registered Member
Posts
4
Karma
0

Re: KMyMoney & no stock quotes

Fri Feb 16, 2018 8:06 pm
This may have been stated earlier in the thread but it bears repeating:

In mcarpino's solution, make sure you have NO trailing spaces in the expressions entered into the KMyMoney Google online quote form. Unfortunately I did have a trailing space in the price or date line and kept getting errors. Wasted more than a bit of time figuring that out.

Thanks again for the fix mcarpino. ;D

ipwizard wrote:Btw: they includes me .


ipwizard: Thanks for your and everyone else's work. I'm very happy with 4.8.1 so far. :) Online quote capability will continue to change, maybe frequently, as websites change. I spent a lot of time messing with the choices provided but did not get them to work. The documentation pushes yahoo, but that is already obsolete. Finally tracked this post down. Given this situation, is there a way to:

  • Remove obsolete choices from future releases?
  • Add new working choices in future releases?
  • Provide a list of new or alternate choices like mcarpino's solution in a standard location between releases?

Any insight would be appreciated.
mcarpino
Registered Member
Posts
28
Karma
0

Re: KMyMoney & no stock quotes

Fri Feb 16, 2018 10:09 pm
This isn't my fix. I don't remember who actually originally shared this solution. I just passed it along so that is the only credit I can take. Someone much smarter than me shared it and I literally copied their work. I don't and won't take any credit for coming up with the solution nor am I trying to take anything away from the original author. Their solution is awesome and I am extremely grateful for their work. If I knew who came up with it I would be sharing their name and giving them credit and I am sorry I don't know who it is.

 
Reply to topic

Bookmarks



Who is online

Registered users: alvinwong, Baidu [Spider], Bing [Bot], claydoh, Google [Bot], ls2018, Majestic-12 [Bot], paulus3005, Sogou [Bot], vishalrao, Yahoo [Bot]