Problems with scraping Yahoo and FT. Each is different.

[jbourvic]

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