search

cmallwitz / Financials-Extension

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

Yahoo codes problem #82

Closed HitVideo2 closed 1 year ago

HitVideo2 commented 1 year ago

It seems many of the Financials-Extension Codes are not working again for Yahoo data in LibreOffice version 7.4.4. on Windows 10.. I also removed LibreCalc and reinstalled LibreOffice version 7.3.7.2 and Financials-Extension version 3.0.7, 3.0.8, 3.1.0 in case Yahoo might have reversed their code (but same results). (Some codes still work for "FT", so only Yahoo seems affected). Surprised since similar problem Dec 2022 and fix to improve #N/A return.

i.e., GETREALTIME Codes: 11, 14, 16, 21, 24, 26, 27, 35, 67, 68, 69, 70, 71, 73 and GETHISTORIC code 90

Example calls: =GETREALTIME("AGNC",21,"YAHOO") =GETREALTIME("AGNC",11,"YAHOO")/100 =IF(ISNA(GETREALTIME("AGNC",70,"YAHOO")), 0, GETREALTIME("AGNC",70,"YAHOO")) =IF(ISNA(GETREALTIME("AGNC",72,"YAHOO")),"",GETREALTIME("AGNC",72,"YAHOO")) =IF(ISNA(GETREALTIME("AGNC",71,"YAHOO")), 0, GETREALTIME("AGNC",71,"YAHOO")) =IF(ISNA(GETREALTIME("AGNC",69,"YAHOO")), 0, GETREALTIME("AGNC",69,"YAHOO")) =IF(ISNA(GETREALTIME("AGNC",68,"YAHOO")), 0, GETREALTIME("AGNC",68,"YAHOO")) =IF(ISNA(GETREALTIME("AGNC",27,"YAHOO")), 0, (GETREALTIME("AGNC",27,"YAHOO")/1000000)) =GETREALTIME("AGNC",35,"YAHOO") =GETREALTIME("AGNC",26,"YAHOO") =GETREALTIME("AGNC",24,"YAHOO") =GETREALTIME("AGNC",14,"YAHOO") =GETREALTIME("AGNC",16,"YAHOO") =IF(ISNA(GETREALTIME("AGNC",67,"YAHOO")), 0, GETREALTIME("AGNC",67,"YAHOO")) =IF(ISNA(GETREALTIME("AGNC",73,"YAHOO")), 0, GETREALTIME("AGNC",73,"YAHOO"))

=IF(ISNA(GETHISTORIC("AGNC",90,"01-18-2023","YAHOO")), 0, GETHISTORIC("AGNC",90,"01-18-2023","YAHOO"))

HitVideo2 commented 1 year ago

Thank You, THANK YOU Financials-Extension ver 3.3.0 FIXED all the issues I had listed. Thanks you.

HitVideo2 commented 1 year ago

Thank You, THANK YOU Financials-Extension ver 3.3.0 FIXED all the issues I had listed. Thanks you.