none
Using Yahoo Finance to download stock quotes into MS Excel

    Question

  • Im trying to set up an Excel spreadsheet that will download semi-real time stock prices.

    Yahoo has a html web address which will download a quotes.csv file (prices delayed by about 15 min).

    http://finance.yahoo.com/d/quotes.csv?s= [SYMBOLS separated by "+" ] &f= [tags]

    In the excel spreadsheet i have command button. when i click the command button i would like the stock data to be downloaded and inserted into excel.

    The stock symbols will be typed into a cell on the spreadsheet by the user.

    The tags will be constant and written into the code.

    Any suggestions as to the best way to go about this?

     

    (reposted in response to VB forum reply)

    Saturday, June 13, 2009 3:16 AM

All replies