Sep 16 2020 08:30 AM
Good morning, I am using Microsoft 365 Excel to track stock info like price, 52-wk high, 52-wk low, market cap and shares outstanding then using this data to introduce it in some formulas. But very recently the data for the Market Cap stop appearing and only showing #FIELD! instead. Does anybody know if the option was discontinued from Excel?
Sep 17 2020 06:08 PM
I am experiencing the same problem. Can this please be fixed as this field was very useful.
Sep 22 2020 09:12 PM
I am still waiting for the "Market Cap" field to be brought back, but in the meantime, you can just add a column of "Shares outstanding" and times this by "Price" to get the Market Cap (or something close to it)
Hope this helps
Oct 04 2020 03:17 AM
The same here, I hope they fix it soon!!
Mar 25 2021 12:05 PM
I had the same problem and here's my solution: You need to click on the ticker and define it as a "stock" data-type.
see video for more details:
https://www.loom.com/share/95f16972efc945b7a2d43dc160d84239
Aug 26 2021 06:19 PM