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

[makloda]

Been using XLQ with Excel since years. Quite happy. Developer releases constant updates.

 

[Excel Clout]

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.

 

[jjw]

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.