Discussion in 'Trading Software' started by thecalip, Aug 30, 2006.
What is the easiest way to get the last price ofa list of stock into Excel or Text file?
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?
the Yahoo URL lets you query multiple symbols at the same time, so it would be very fast. For example:
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
Yes, I did that over while I was free at work.
Separate names with a comma.