Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Stream real-time data with Quotemedia’s MarketXLS Addons

Streaming data

The function used to stream the real-time data is =qm_stream_Value(“Last”, "Symbol”). Instead of the Last price, you can also put in a bid, ask, volume, or another value supported by the Quotemedia Quote service.

MarketXLS will only start streaming content to your cell with this function if the markets are open (i.e. the symbol is trading at the time).

To see the list of all streaming functions simply start typing in any Excel cell =qm_stream_Excel will then show you all the functions available like shown below…

=qm_stream typing in Excel

The cells will change their color by default depending on the arriving values.

=qm_stream typing in Excel