Getting Market Data (real-time stock quotes) into Excel 2007

Discussion in 'Data Sets and Feeds' started by monty21, Apr 22, 2009.

  1. Been using XLQ with Excel since years. Quite happy. Developer releases constant updates.
     
    #11     Apr 23, 2009
  2. I’ve put together a macro enabled Excel file that can get U.S. stock quotes from Yahoo Finance with custom-built formulas.

    Excel Stock Quotes

    I also made a YouTube video for this tool.

    Excel Stock Quotes Video

    For example, you can get the stock quote for Microsoft by entering =StockQuote("MSFT") within the file.

    It also comes with other custom-built formulas such as StockChange, StockDaysLow, StockDaysHigh, StockYearLow, StockYearHigh, and StockVolume.

    You can refresh the quotes and price changes throughout the trading hours of the day by pressing F9, which is the shortcut key for recalculation. There's also a button in the file that can automatically refresh the quotes every minute at the first second of each minute.
     
    #12     Nov 12, 2014
  3. jjw

    jjw ET Sponsor

    R | Trader Pro™ has a mechanism to stream real-time market data into Microsoft Office Excel. R | Trader Pro™ also enables you to get real-time US equity market data from EDGX - for free.
     
    #13     Nov 15, 2014