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

thecalip · Aug 30, 2006

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

Thanks

Bob111 · Aug 30, 2006

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

also-you can try web querry in excel

thecalip · Aug 30, 2006

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.

j_medved · Aug 30, 2006

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

syrre · Aug 30, 2006

X_Trader work great with Excel.

Bob111 · Aug 30, 2006

Quote from thecalip:

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.

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.

originalskunk · Aug 30, 2006

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

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

thecalip · Aug 31, 2006

Quote from Bob111:

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.

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

Thanks again.