All articles with 'daniel ferry' Tag

Get Stock Quotes using Excel Macros [and a Crash Course in VBA]

Published on Jun 2, 2010 in Learn Excel, VBA Macros
Get Stock Quotes using Excel Macros [and a Crash Course in VBA]

Have you ever wanted to fetch live stock quotes from excel? In this post we will learn about how to get stock quotes for specified symbols using macros. We use Yahoo! Finance API to fetch the stock quotes and other information related to a company using excel macros. Along the way, we will also learn various interesting things about Excel VBA. Think of this post as a crash course in VBA.

This is a guest post by Daniel Ferry.

Continue »

An Excel Hero indeed [blog recommendation]

Published on May 24, 2010 in Learn Excel
An Excel Hero indeed [blog recommendation]

Today, I want to introduce an excel hero to you. He may not be wearing red cape or carrying latest ninja weaponry with him. But he is a hero. He can arm twist toughest sets of data to create beautiful (almost art like) charts or animations. He can a complex vba model and make it […]

Continue »