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


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.


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

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s