macro getting price history online

VBN macro

Hello all,

In excel tab "data" I click "from web" I add the url: http://www.nasdaq.com/symbol/f/historical

(when I go to the website normally in the website there is a feature that lets me get data from 1, 5, 10, etc years back.)

It would be real easy if the 10 year price history was sourced in the url somehow but the option to change the dates to 10 years back doesnt change the url. So I cannot retieve all the data, just the data thats on the initial page (which is like daily data from the previous 3 months.)

Basically my goal is to write a macro that can pull the full 10 years of a stock out of nasdaq.

Any solution to this is appreciated.

Best,

Chris

Google has a historical feature that allows the entire date range to be downloaded as one CSV file. Here's a file file showing that in use. Set the Nasdaq code you want, and the date range, it presents it all for you automatically.
(source)

The attached workbook will allow you to select the startdate, enddate and the price you want reported (OPEN/HIGH/LOW/CLOSE).

If the first day of the month is a holiday or not reported from Nasdaq history, you will get the last date prior to that day with data.

I do not suppress errors in this version, to me N/A means "Not available" and is the correct result for a ticker that did not trade at all in the period noted.