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.
Christmas Gift List – Set your budget and track gifts using Excel
Steven, one of our readers from England sent me a Christmas gift tracker worksheet. I found it pretty cool, so made some minor changes to it and sharing it with you all so that you can have great time shopping for the holidays.
The workbook is full of lessons on conditional formatting, cell formatting, using formulas. Go ahead and download it today.