search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
137 stars 17 forks source link

Problems with scraping Yahoo and FT. Each is different. #102

Open jbourvic opened 2 months ago

jbourvic commented 2 months ago

LO 24.2.12; Win 10; Fin. Ext. v. 3.5.0 (USA)

Finding Yahoo site unreliable and FT, too.

I have one sheet with about 400 entries. Yahoo will peter out scraping prices about 1/3rd the way through the list, with everything after being #N/A during trading day or after hours. If I change search to FT, some prices are very high (I think it is returning values in pence). E.g., MFL shows N/A for Yahoo and 257.00 for FT. a MUNI Bond CEF pricing at 257 isn't right.

I am not Python smart> I am using =GETREALTIME(A272,21,"FT") [where A272 contains MFL) to get the price. I know many people have complained about Yahoo, but what can I do about FT printing weird?

Appreciate any insight HY_INCOME.ods HY_INCOME.xlsx

Durhammer3111 commented 2 months ago

You sure you have the right ticker? I can't find "MFL" anywhere -- Yahoo!, FT, Barchart, etc.

jbourvic commented 2 months ago

Sorry, this is an old list of CEF stocks. MFL merged with MUI (CEFs do that a lot) so yes, it will show N/A. But even MUI shows N/A! That is not the problem. I run the spreadsheet and 2/3rds show up as N/A. Is there something wrong with what I did? Or is Yahoo just being fussy. If I select most of the N/As and replace "YAHOO" to "FT", it will return results. More than half of the CEF world did not just become obsolete.

20240428 14:07 CDT (US) Just tried to get stock NAME and Industry (codes 104 and 99) for some of the funds, and it returned Yahoo Finance and #N/A, respectively. I also did an in depth look into Blackrock funds. Found only a few had been closed. Most are active but show up as #N/A for stock price. I did not validate the entire list, but if you want me to cull the closed fund, I could do that but it will take some time.

Durhammer3111 commented 2 months ago

You might need to find the primary ticker exchange that FT uses. I suspect that for most "naked" tickers, FT tries as if you had appended ":NYQ" to it -- for example, for "DECK" I think FT tries "DECK:NYQ", which works, but the stock might trade on a different exchange. Can't remember the many others now, but could be for example "DECK:NYS", so would show "N/A" if not fully qualified.

⁣Get BlueMail for Android ​

On Apr 28, 2024, 12:14 PM, at 12:14 PM, jbourvic @.***> wrote:

Sorry, this is an old list of CEF stocks. MFL merged with MUI (CEFs do that a lot) so yes, it will show N/A. But even MUI shows N/A! That is not the problem. I run the spreadsheet and 2/3rds show up as N/A. Is there something wrong with what I did? Or is Yahoo just being fussy. If I select most of the N/As and replace "YAHOO" to "FT", it will return results.

-- Reply to this email directly or view it on GitHub: https://github.com/cmallwitz/Financials-Extension/issues/102#issuecomment-2081537536 You are receiving this because you commented.

Message ID: @.***>

jbourvic commented 1 week ago

Took my spreadsheet and tried it this past weekend on YAHOO. I was a mess. But, just tried it this morning at 11:30 am CDT, and it was perfect.

Guess YAHOO is the pits over the weekend. So I guess I will have to change my tactics. Thanks to all you gave guidance. And thank you to cmallwitz for the program.