Hi,
I am looking for a macro or a process by which I can get the historical Stock Price.
from the below site..
http://finance.yahoo.com/q/hp?s=AAPL+Historical+Prices


I want to specify the following Input criteria

1) STock Ticker
2) Start Date
3) End Date
4) Data type (Daily, Weekly, Monthy)
5) Also ability to specify whick column the User wants to select (Open, High, Low, ENd etc).

Thanks,

Any macro or a sample sheet will help


Thanks,