GETREALTIME with "YAHOO" not working this morning

[kerpenbe]

I have been using the GETREALTIME(symbol, 21, "YAHOO") call using version 3.6.0 and it was working fine until this morning when it just stopped working and now returns "N/A." I am wondering if Yahoo has updated their format and we need another update on the financials-extension to handle it?

[techman2423]

i updated to 3.6.0 due to #NA's: and this version did work well for a few days...now back to #NA and GETREALTIME doesn't work.

[cafn]

I see that I am not alone. Mine stopped working a day ago. I get the same #NA response.

[schmani-db]

Mine did work fine also yesterday but stopped working today as well.

[techman2423]

...still down, nothing working...

[JohnDSR]

I noticed Yahoo pulls were not working over the weekend and still not working today. Bummer. Thank-you Yahoo!

[techman2423]

I removed 3.6.0 and rolled back to 3.5.0 and can get realtime 21 last price at least (=GETREALTIME(B2,21,"YAHOO"). 3.5.0 still gives #NA for other get realtime codes. 3.50 does provide get realtime code 11 the percentage change for the day, but it is out of whack - but thats easily solved with division.

[wp7777]

Same here: =GETREALTIME("^GSPC",21,"YAHOO") was fixed last week, so was very happy (SP500 code) but now it shows #N/A

[cyberlink1]

Let me ask, when you are getting the #N/A are the markets open?

I get #N/A from the pull if it is after hours or on a day the market is closed. If I switch to a GETHISTORIC 90 for the day, I get a proper response with the market close price.

I wish there was an easy way to check if the market is open/closed and adjust accordingly.

[wp7777]

Thanks for your reply - and great extension app - to be honest cannot recall about the timing and yes - that is a good hypothesis "GETHISTORIC" - I used an FT query instead to get my basic index data:

=GETREALTIME("COMP:NAS","LAST_PRICE","FT")

so my needs are met now - thanks to your efforts on this extension much appreciated

john

-- Sent with Tuta; enjoy secure & ad-free emails: https://tuta.com

May 16, 2024, 11:53 by @.***:

Let me ask, when you are getting the #N/A are the markets open?

I get #N/A from the pull if it is after hours or on a day the market is closed. If I switch to a GETHISTORIC 90 for the day, I get a proper response with the market close price.

— Reply to this email directly, > view it on GitHub https://github.com/cmallwitz/Financials-Extension/issues/105#issuecomment-2115025282> , or > unsubscribe https://github.com/notifications/unsubscribe-auth/BIP7CVZUEW6WAW2U4U75ZULZCSM33AVCNFSM6AAAAABHNIVUAWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMJVGAZDKMRYGI> . You are receiving this because you commented.> Message ID: > <cmallwitz/Financials-Extension/issues/105/2115025282> @> github> .> com>

[techman2423]

i went back to 3.6.0 to check on this...and it didn't work during open market hours and of course after hours as well.... no getrealtime codes worked. i've again switched back to 3.5.0...yes i'm getting #NA for some codes. as far as the using the get historic vs getrealtime....this is a bit tedious and my spreadsheets are quite complex and would have to build 2 different sheets for during market hours and after market hours. for now i'll keep checking my watchlist at Fidelity and using 3.5.0 to get last price which is what my main spreadsheet needs. Secondary spreadsheets track watchlist and price triggers. i had to split up spreadsheet tasks as they were taking too long to load with all the online queries running at startup and every time I hit CTRL-SHIFT-F9.

idk, thats how it's been for me. 3.6.0 worked for a bit then failed, good catch maybe during market hours etc, but didn't affect me.

[cyberlink1]

idk, thats how it's been for me. 3.6.0 worked for a bit then failed, good catch maybe during market hours etc, but didn't affect me.

wp7777's suggestion of using FT (Financial Times) inplace of YAHOO works very well.

As to the spread sheet, Im using conditionals to decide what to load in the cell.

=IFERROR(GETREALTIME(A3,21,"FT"),GETHISTORIC(A3,90,IF(WEEKDAY(TODAY())>1,TODAY(),IF(WEEKDAY(TODAY())=1,TODAY()-2,IF(WEEKDAY(TODAY())=7,TODAY()-1))),"FT"))

Cell A3 is the ticker for the stock

[cmallwitz]

I have created a new release version 3.6.1 - give it a try and let us know if it fixes the problem for you

BTW it seems this time around Yahoo didn't fiddle with the data structure but the consent/crumb handling...

[AD-mrr]

It works fine now. By the way, 3.6.1 is much faster than 3.5.0 at retrieving Yahoo data (5 times faster for me). Thanks a lot!

[techman2423]

3.6.1 IS WORKING!!! thanks a million

[cmallwitz]

Got some "working" responses with version 3.6.1 - closing this one for now

[wp7777]

Thanks for your efforts !

-- Sent with Tuta; enjoy secure & ad-free emails: https://tuta.com

May 17, 2024, 14:38 by @.***:

idk, thats how it's been for me. 3.6.0 worked for a bit then failed, good catch maybe during market hours etc, but didn't affect me.

wp7777's suggestion of using FT (Financial Times) inplace of YAHOO works very well.

As to the spread sheet, Im using conditionals to decide what to load in the cell.

=IFERROR(GETREALTIME(A3,21,"FT"),GETHISTORIC(A3,90,IF(WEEKDAY(TODAY())>1,TODAY(),IF(WEEKDAY(TODAY())=1,TODAY()-2,IF(WEEKDAY(TODAY())=7,TODAY()-1))),"FT"))

— Reply to this email directly, > view it on GitHub https://github.com/cmallwitz/Financials-Extension/issues/105#issuecomment-2117752987> , or > unsubscribe https://github.com/notifications/unsubscribe-auth/BIP7CV3DWXUMRVJ4IEWARPTZCYI45AVCNFSM6AAAAABHNIVUAWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMJXG42TEOJYG4> . You are receiving this because you commented.> Message ID: > <cmallwitz/Financials-Extension/issues/105/2117752987> @> github> .> com>