Kmymoney upgrade to 5.2, yet another Yahoo quote problem

Hello,
Earlier today, in my weekly Arch system update, Kmymoney was updated to 5.2. I am really liking the UI upgrades, with drag-able and re-sizeable column headers in the ledgers.

However, I am also seeing a few annoyances I will eventually need to deal with. The one I am dealing with now is that I can no longer fetch quotes using the “Yahoo Finance” quote source has been working for me before today.

This is its configuration:

Online quote settings generated with Alkimia 8.2.0-webengine-qtnetwork(I18N_ARGUMENT_MISSING)

URL: https://query1.finance.yahoo.com/v8/finance/chart/%1(I18N_ARGUMENT_MISSING)
Download mode: Default(I18N_ARGUMENT_MISSING)
Data format: HTML(I18N_ARGUMENT_MISSING)
Identifier: %1(I18N_ARGUMENT_MISSING)
Select by: Symbol(I18N_ARGUMENT_MISSING)
Price: "regularMarketPrice":((\d+|\d{1,3}(?:[,]\d{3})).\d+)(I18N_ARGUMENT_MISSING)
Price decimal separator: Legacy(I18N_ARGUMENT_MISSING)
Date: "regularMarketTime":([\d]+)(I18N_ARGUMENT_MISSING)
Date format: (I18N_ARGUMENT_MISSING)
Default identifier: (I18N_ARGUMENT_MISSING)
Remote source: not checked(I18N_ARGUMENT_MISSING)

When I try to retrieve a quote for symbol GOOG, this is the result:

(Debug) symbol=GOOG id=E000123...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/GOOG...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/GOOG...
Unable to parse symbol for GOOG
Price found: '174.43' (174.43)
Date found: '1750968001'
Date format found: '1750968001' -> ''
Received an invalid price for GOOG, unable to update.

When I enter that URL into a browser and look at the JSON returned, I can see that the price found is correct, and the date found is correct, but (I’m pretty sure) is a Unix time_t date stamp. Note that in my quote source configuration, the date format is empty. In the Kmymoney handbook doc on setting up online quotes, I can’t find instructions for how to indicate a time_t format date here.

Is the date the real problem here, or something else?

The only change I think you should try is
Date Format: %u

let me know if that works – and good to see you around again Section8 ! A

Thank-you, Athiest. Good to see you too. I tried that and a few other guesses, but it made no difference.

However, I just noticed the “install” button in the online quotes configuration dialog, which can download quote sources others have written. The Alphavantage.co quote source is actually working, for everything I’ve tested it on so far.

Now I just have the PITA of having to change the quote source in several dozen securities. As far as I know, I will have to go through that security edit wizard in every one of them, one at a time.

Until a couple of months ago, I was using a python script to get quotes from a service called Twelve Data, which I think is similar to Alpahvantage. I can still get stock quotes from Twelve Data, but most of my investment accounts are mutual funds, and Twelve Data stopped working for them, so I reverted back to Yahoo until today.

1 Like

The only other difference that I see is that for
“Price decimal separator” you use “Legacy” and I use “.” Surely that cannot be it…right?
On the Install option, it would be nice if we could use an alias. For example, in every security instead of saying “yahoo finance” or “alphavantage.co” we could stipulate “MyPreferred” and we could point that to whatever quote source is working at the time. The idea of changing the source for dozens of securities is daunting. :frowning:

Once I got it set up and working, I’ve forgotten the details, but what I did was to delete the original Yahoo Finance source, and then make a copy of the new working source installed as you found in comment #2 and called that new copy Yahoo Finance.

1 Like

That’s why you get paid the big bucks! :slight_smile:

What is your date format setting? Try to use %u as date format.

@Ipwizard - Thank-you, that actually works. I feel like an idiot now - I thought I tried that (and %U, which doesn’t work) yesterday, but I guess not.

I think, in that Online source configuration dialog, that I probably failed to click that “Accept” button after making a change. I have dim memories of being bitten by that in the past.

@ostroffjh - Thank-you for the quote management tips. I went through and gave all of my investments a generic quote source and have duplicated the working “Yahoo Finance” source and renamed it that. (I know that if I had a source named “Yahoo Finance” that had something else inside, that will really throw me for a loop the next time I have to look at these things. The one thing I really excel at is forgetting).