Stream real-time data with Quotemedia’s MarketXLS Addons
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…
The cells will change their color by default depending on the arriving values.