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