How to pull "market capitalization” data from Yahoo! Finance within Excel?
i get #value error... i get the same error when i try to get j1, j3 or r1.See attached error and formula
your formula was using numbervalue to convert text to a number, but market capitalization includes a B at the end of the number so it couldn't convert that to a number. Any data that is text just simply remove the numbervalue function and leave only the webservice function.
