search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
151 stars 21 forks source link

FT processed one request but fails on others #78

Closed jbourvic closed 1 year ago

jbourvic commented 1 year ago

I was doing some research today and just quickly added some preferred stocks to my list. Yahoo was giving errors (site must be under maintenance) so I switched to FT. Well, FT handles preferred stocks completely differently (a BML-PG has to become BML PR G:NYQ for FT). I thought everything was going to be okay when I found that FT processed one request just fine but other requests produced errors (see attached).

I included the string of what was in the GETREALTIME cell to insure I didn't have the formula wrong.

BML PR G:NYQ | 02-14 | 0.343 | 02/13/23 | 20 |   | '=GETREALTIME(A34,21,"FT") |   | 19.84 -- | -- | -- | -- | -- | -- | -- | -- | -- BML PR H:NYQ | 02-14 | 0.3441 | 02/13/23 | 20 |   | '=GETREALTIME(A35,21,"FT") |   | '<' not supported between instances of 'float' and 'NoneType'

I hope this is readable. Is there a reason for the error? The FT site show the data just fine.

cmallwitz commented 1 year ago

Thanks for the report! I have the feeling the extension is having a problem to recover after there was an error on an earlier request. I will take a look at this. In the meantime it might help to close all of LibreOffice/Calc completely and check if the data is OK afterwards (this would reset any internal state)

cmallwitz commented 1 year ago

I have published a new version that hopefully addresses some shortcomings. Please close LibreCalc completely and use either a blank/new spreatsheet or the attached examples.ods to see if the extension is working in general or there is a problem with you spreadsheet itself.

Closing as duplicate of https://github.com/cmallwitz/Financials-Extension/issues/80 (not a FT/Yahoo specific underlying problem)