search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
145 stars 19 forks source link

Missing FT stats #37

Closed R7914T closed 3 years ago

R7914T commented 3 years ago

I notice that the FT also shows shares outstanding and Free float. If you have time could you please add them into the extension's options.

cmallwitz commented 3 years ago

Unfortunately only if you are registered/signed in.

cmallwitz commented 3 years ago

Sorry - my fault was looking for something else. shares outstanding and free flat is something that could be done for yahoo/ft. I will take a look.

cmallwitz commented 3 years ago

I have publish a new version of the extension 3.0.5 with SHARES_OUT and FREE_FLOAT data points. Let me know if that works for you.

R7914T commented 3 years ago

Thank you very much for making the additional stats available.

I could not find a readme file setting out all the codes now available in your extension.

I keep the list of supported data points in the notebook "ZIM" but this time I had difficulty copying and pasting the list from github into Zim. It came out poorly formatted and hard to read quickly. Instead I first copied them into libreoffice Calc and then copied and pasted the block of entries in libreoffice into Zim. That caused each column to be straight.

I will start using the new stats and if there is a problem I will let you know.

Thank you again,

R7914T commented 3 years ago

Currently, my spreadsheet is not showing any values for the two new data points. I have tried both F9 and ctrl shift F9. Other data points are working.

I have updated the extension with version 3.0.5.

cmallwitz commented 3 years ago

Hmmm... Could you try the examples.ods spreadsheet from [https://github.com/cmallwitz/Financials-Extension/releases/tag/3.0.5] and see if you see data? Maybe you have switch between FT and Yahoo in the sheet first.

R7914T commented 3 years ago

The example spreadsheet is showing shares out and free float results, even though the function in your examples point to the field name instead of the code. I therefore dug further and found that the newly added cols in my spreadsheet were not showing the values because of something connected with the cell formats. I cleared direct formatting. The function results appeared and then could be formatted and still show the correct results. In other words sorry to have raised the query.

cmallwitz commented 3 years ago

No worries - better save than sorry. Closing this issue for now...