Hello everyone,

I am looking to create a macro ( if possible) that will be able to get me all of the stock info data from yahoo finance.
Yahoo is nice enough to provide : http://finance.yahoo.com/d/quotes.cs...OOG+MSFT&f=nab

So that the info for selected companies (in this case AAPL, GOOG and MSFT) can easily be obtained.

My problem is that I want all of the companies and the URL obviously cannot be that long.


Would it be possible to have something like : http://finance.yahoo.com/d/quotes.csv?s="Excel Cell"=nab
where I would have column A of all of the stock symbols, and then run a for loop which would insert each different symbol into the URL, and thus compile each stock info into the cell beside the respect symbol.


In other words, say I have:

Column A
AAPL (Cell 1,1)
GOOG (Cell 1,2)
MSFT (Cell 1,3)

and the macro would then execute
http://finance.yahoo.com/d/quotes.csv?s="Cell 1,1"=nab
http://finance.yahoo.com/d/quotes.csv?s="Cell 1,2"=nab
http://finance.yahoo.com/d/quotes.csv?s="Cell 1,3"=nab

and put them all into the same excel file.

Would this possible? As each link would open its own CSV file

Thank you for the help,
Regards,
Denis