casper43
casper43
Clicking on the date-format button in calc won't change anything. The date always displays the same (e.g. 2020-04-12). I also tried to make a reference in another cell to the...
Yes, this seems to work. I can't format the specific original cell as a date though. Maybe that's the reason why conditional formating doesn't work?
But not market cap. I get #NV with =GETREALTIME(Ticker;"MARKET_CAP";Source) .
Hi. Every source is from a secondary exchange. As FT doesn't seem to have the original (Hyundai is a South Korean car manufacturer) available. Not sure how to do FX...
Okay, my whole doc is refering tickers to a source cell currently. Have you found Yahoo more reliable than FT? Sent with [ProtonMail](https://protonmail.com/) Secure Email. ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ cmallwitz...
Thanks for your answer. That market cap isn't calculating the "current" market cap on the fly, makes your plugin not very usable however for calculating fundamentals. Sent with [ProtonMail](https://protonmail.com/) Secure...
I assume we need a reliable datasource for this. Google has it. The power of your plugin pretty much depends on reliable data. :) Sent with [ProtonMail](https://protonmail.com/) Secure Email. ‐‐‐‐‐‐‐...
If I add a row with no information in it at all, it's also present. At this point the text I enter in the cell has not become a symbol...
Yes. Basically what =GoogleFinance(Ticker, "shares") does in Googlespreadsheets.
That would get the total market capitalisation (Number of shares x LAST_PRICE) I Could calculate them. But sometimes there are numbers missing.