I feel like a stock broker but with FREE access to real-time quotes in #Excel using Yahoo. #analytics #bigdata

image

Boy, does it free great writing code again and quickly producing some insights that I didn’t have before.  What do I mean by that, hasn’t stock data always been available?  Yes, but it is more of a pain to copy and past in Excel.

I can type in a stock ticker into a cell and using Yahoo Finance, I can call their API and get a table set in return that I can throw into Excel and use for some analysis.

image

Once I get this working has my data harvesting tool, then I’m moving the data into one of the predictive analytics tools to see if we can predict some stock movements.

The possibilities are endless, email me if you have any questions.

Enjoy, Patrick


Read Original Post

Comments are closed.