If you send ME your email address I will send you a file of mine that does
this for you. All you do is input the symbol . Or, send me your file and
I'll take a look.
Symbol Name Basis
Shares Last Trade Value Profit
IBM INTL BUSINESS MAC $ 100.00 100.00 $
90.86 $ 9,086.00 $ 8,986.00
T AT&T INC. $ 100.00 100.00 $ 26.21 $
2,621.00 $ 2,521.00
MSFT MICROSOFT CP - $ 24.12
-
FE FIRSTENERGY CP - $ 52.74
-
cm-pd.to CANADIAN IMP BANK - $ 20.19
$ -
^GSPC S&P 500 INDEX,RTH - $ 963.20
-


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TEB2" wrote in message
...
If I paste the following code in the address bar in IE, I get a window
asking
me if I want to open or save a csv file which has the monthly highs for
the
stock for the time period specified:

http://ichart.finance.yahoo.com/table.csv?s=(insert stock
symbol)&a=12&b=01&c=2007&d=01&e=01&f=2009&g=m&igno re=.csv

Here's the issue. I have a list of 332 stock symbols in a spreadsheet. I
need the code that will insert the first stock symbol after "s=" in the
above
address, save the file to a specific folder and loop thru the list till
the
end.

I have to evaluate these stocks on a monthly basis to determine the
market-to-cost adjustment. This would be my final piece to fully automate
the process.

Thanks for your help!

Tom