The function to use to stream the real-time data is =qm_stream_Value(“Last”, "Symbol”). Instead of the Last price you can also put in bid, ask, volume or another value supported by Quotemedia Quote service.
To make it easier for you, we have also created some extra functions which only take one argument which is the symbol. So, instead of using =qm_stream_value(“last”,”symbol”), you can also use =qm_stream_last(“symbol”).
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.
Category: Quotemedia Stream Real-Time Functions
**This category of functions results in values changing by themselves without you having to Refresh the data. A connection is made in the background to the servers and whenever the new data points arrive its shown in the cell**
The prefix for functions in this category is =qm_stream_
The main function in this category is =qm_stream_value(“What do you want to stream”, “For which symbol you want to stream”). For example, to stream the last price of a stock type =qm_stream_value(“last”, "symbol”)
Just like in =qm_value function we have pre-packaged if you like some of the commonly streamed values as extra functions that take only one argument which is the symbol.
For example… =qm_stream_value(“last”,”symbol”) is same as =qm_stream_last(“symbol”)