Market cap option in Stocks data type not working

%3CLINGO-SUB%20id%3D%22lingo-sub-1673840%22%20slang%3D%22en-US%22%3EMarket%20cap%20option%20in%20Stocks%20data%20type%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1673840%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2C%20I%20am%20using%20Microsoft%20365%20Excel%20to%20track%20stock%20info%20like%20price%2C%2052-wk%20high%2C%2052-wk%20low%2C%20market%20cap%20and%20shares%20outstanding%20then%20using%20this%20data%20to%20introduce%20it%20in%20some%20formulas.%20But%20very%20recently%20the%20data%20for%20the%20Market%20Cap%20stop%20appearing%20and%20only%20showing%20%23FIELD!%20instead.%20Does%20anybody%20know%20if%20the%20option%20was%20discontinued%20from%20Excel%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1673840%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1681578%22%20slang%3D%22en-US%22%3ERe%3A%20Market%20cap%20option%20in%20Stocks%20data%20type%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1681578%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20experiencing%20the%20same%20problem.%26nbsp%3B%20Can%20this%20please%20be%20fixed%20as%20this%20field%20was%20very%20useful.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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? 

1 Reply
Highlighted

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