What's the easiest way to get last price of a list of stock to a txt of xls file?

What is the easiest way to get the last price ofa list of stock into Excel or Text file?


Thanks

 

http://www.gummy-stuff.org/Yahoo-data.htm

also-you can try web querry in excel

 

thanks. but I have a big list, and it will take a long time for me to use this method. is there a script or simple program that will do the trick?

thanks.

 

the Yahoo URL lets you query multiple symbols at the same time, so it would be very fast. For example:
http://finance.yahoo.com/d/quotes.csv?f=sd1t1l1cvbahgc4&e=.csv&s=DELL,IBM,INTC

 

X_Trader work great with Excel.

 

try it, before saying it will take long time. as far as far i remember, yahoo alow you to get data for 200 symbols in one shoot. and it only take second or two. maybe even less than that. update of portfolio with 6000 stocks in it should take few seconds with good intenet.

 

There may be something in the files section of this Yahoo group

http://groups.yahoo.com/group/xltraders/

 

Yes, I did that over while I was free at work.

Thanks again.