Online Quotes not working ( Yahoo finance )

I installed the latest version of kmymoney today

( kmymoney5-mingw64-5.1.3-lp155.10.7-setup.exe )

And loaded my file.
And not able to fetch online quotes from Yahoo.

It was working fine before updating to latest version.

PLEASE HELP

Hi Ganesh, there is a long thread to do with this. Search for " Kmoney currency udpates not working"
A

Hi

Thanks for the reply

I looked at the thread, but unfortunately it did not resolve my issue

Any working Online quotes to update Indian Stock would be very helpful

Thank you in advance

Here are the few symbol of the Stock i use

Screenshot 2024-10-09 171105

@ipwizard Please Help

Not able to update Indian stocks using Yahoo finance

Online quotes for stocks is the reason i started using Kmymoney
PLEASE HELP

So sorry, Ganesh, but I do not have any other worthwhile ideas. Someone else here should be able to help. Post again if needed. A

If you can find a website which actually provides the necessary information, we can help with the settings to extract the date an price from the page.

Please remember that when Yahoo stock prices stop working, it is much more likely a change Yahoo made to their web site than a change made in KMyMoney. As I said above, if you can find a web site that provides the information, we can probably create a price source that will extract the data from that page - although that will only work until the source changes the page again. There is nothing KMyMoney can do about that.

I gave up replying on Yahoo and other sites for stock quotes because they seem to routinely muck with the interface and the integration to pull prices from them is fragile. I found a more stable solution was to build a spreadsheet of my holdings in a Google Sheet using GOOGLEFINANCE function to compile the prices on demand and export them into a CSV file than can be parsed by KMyMoney. GOOGLEFINACE coverage is not perfect but seems to cover at least some Indian stocks. Here is an example Google sheet setup:

Formulas:

Results:

Once you have you holdings in a Google Sheet, you can download them as a CSV file using “File->Download->Comma separated values” and end up with:

wgking@turing:/tmp$ cat 'Untitled spreadsheet - Sheet1.csv'
,,
Last trade,Ticker,Price
2024-10-11,NSE:TATAMOTORS,931.4
2024-10-11,NSE:ASIANPAINT,3042.95
2024-10-11,NSE:AXISBANK,1173.2
2024-10-11,NSE:BAJFINANCE,7300.1
2024-10-11,NSE:WIPRO,528.45
2024-10-11,NSE:INDHOTEL,707.25
2024-10-11,NSE:TATACHEM,1183.5
2024-10-11,NSE:CPSEETF,97.86
2024-10-13,USD->INR,84.0756
2024-10-13,INR->USD,0.01189406

Then you need to setup a custom price update template in KMM and a script to search the CSV for each holding. For this to work you must use the Google finance ticker as the ticker inside KMM so it can be matched.

My template and script are:

----KMM custom stock price configuration
[Online-Quote-Source-mycustomsource]
CSVURL=
DateFormatRegex=%y-%m-%d
DateRegex=(\\d{4}\\-\\d{2}\\-\\d{2})
IDBy=0
IDRegex=%1
PriceRegex=(\\d+\\.\\d+)
SkipStripping=true
URL=file:/home/wgking/get-stock-price.sh  %1

----MyCustomSource shell script (get-stock-price.sh)
#!/bin/bash
grep $1  "/tmp/asset-allocation - Google-extract.csv" -m 1

You will have to tweak it to your situation. If you are using windows a simple .BAT file with a “FIND” command should work as the script.

I do not know how well Google tracks Indian markets but if you play around on finance.google.com you should be able to find if it has what you need. If it doesn’t, the concept should also work with any financial website that lets you build a list of your holdings and lets you download them as a CSV file. I have found Google finance lacking in support for Canadian mutual funds and commodities like gold, so you may have to look elsewhere to get that data.

It is an extra step to open the Google sheet and download the CSV, but I have found it to be way more reliable than trying to use other public stock quote sites.

I hope this helps. Good luck!

Greg

2 Likes

THanks, Greg, for sharing all those data on how to set it up. A

Hello developers :wave:

Thank you all for your quick response and for finding a fix for this.

I just want let you know that I came to know that Moneydance app is also suffering with the same issue with these public finance website in retrieving the online quote using their Quote and currency exchange update extension.

But they have a third-party extension (signed and approved by Moneydance) in their app called Quote loader which is able to get the online quote and currency exchange from yahoo finance and other websites

I don’t know if this will help, just wanted to let you know

Once again, I’m very thankful for your quick responses and it has been very helpful :slight_smile:

Valid point, but guess what: they seem to suffer from the same problems.