Market cap option in Stocks data type not working

Question

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?&nbsp;

bludgee · Answer

I am experiencing the same problem.&nbsp; Can this please be fixed as this field was very useful.

bludgee · Answer

&nbsp;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)&nbsp;Hope this helps&nbsp;RosalioB&nbsp;