Excel Stocks not outputting some data

[lach1234]

Hi,


I am trying to create a spreadsheet that tracks stocks. When using the excel stocks function and outputting data, the market cap for all 500 stocks is coming up as ####### and I am also getting a #FIELD ! error for certain P/E or EPS data. I've attached a screenshot with issues highlighted in yellow.


Please help!


Thanks


Photos:
https://ibb.co/Wgn8MtV
https://ibb.co/XD9y5rB
https://ibb.co/rkStypw

 

[alansidman]

Posting a picture does not really help as we cannot manipulate the data nor determine the formatting. You may wish to attempt to widen the column for the Market Cap as that is usually the issue with this type of scenario. As to the #Field look at this link https://support.office.com/en-us/article/-field-error-66b3a5db-1904-41aa-9913-51ded9dd15f2