So I've been messing around with Excel and the WEBSERVICE formula. Basically, I want a sheet that will auto update after I put a ticker symbol column A. I can get most financial information to update but I can't quite figure out how to get sector info.
(For those interested, by formula looks like this:
=NUMBERVALUE(WEBSERVICE("http://ift.tt/2r1l4HS;))
And here is a good blog post that breaks down data-http://ift.tt/PyXAHU
Does anybody know the sector info?
Submitted June 06, 2017 at 09:00AM by royjones http://ift.tt/2r1HMzJ
