i am seeking help to do the following. i wish to download historical stock data for a group of stock symbols from a website such as yahoo. i know that i can run a "Get external data>Web query" and using an URL such as http://table.finance.yahoo.com…s=qqq&y=0&g=d&ignore=.csv
...BUT i want to get each symbol (such as QQQ,IBM etc) from a series of cells in my spreadsheet and as such i need a way of adding its symbol in the appropriate place in the URL before URL is sent. for example if i could create the URL in excel using CONCATENATE and executing the result......suggestions please.
I would suggest you download the data using VBA. Just read the symbol in each cell and use the Workbook.Open method to open the data file. I've included a file as an example.