Under the Yahoo system, each attribute has a short string Tag Code.All we need to do is to concatenate the string codes for each attribute we want and add the resulting string to the URL.We then need to figure out what to do with the CSV file that comes back.
Whenever you add or change one of these attributes in the first row of the Active Range, the range will automatically update as well.
In this post, you can learn how to use excel macros to fetch live stock quotes from Yahoo! It is also going to be a crash course in VBA for the express purpose of learning how the Active Range method works so that you can use it yourself.
Click here to download the excel stock quotes macro workbook.
In this post we will learn about how to get stock quotes for specified symbols using macros.
One method that has worked well for my clients can be implemented with just a few lines of VBA code. An Active Range is an area on a worksheet that you define by simply entering the range address in a configuration sheet.
Once enabled, that range becomes live in the sense that if you add or change a stock symbol in the first column of the range, the range will automatically (and almost instantly) update.You can specify any of 84 information attributes to include as columns in the Active Range.It will be much easier to follow this tutorial if you refer to the workbook.The stock information for the Active Range will come from Yahoo Finance.A number of years ago, Yahoo created a useful interface to their stock data that allows anyone at anytime to enter a URL into a web browser and receive a CSV file containing current data on the stocks specified in the URL. But it gets a little more complicated when you get down to specifying which attributes you want to retrieve [information here].Remember there are 84 discreet attributes available.