Real-Time Data Feed
Test and validate your real-time data subscription to ensure streaming functions are working correctly.
Validating Your Real-Time Data
To validate your Real-Time data feed is working, type in one of the streaming functions in Excel:
=qm_stream_last(symbol)Alternative Formula
You can also try other streaming functions like
=qm_stream_bid(symbol) or =qm_stream_ask(symbol) to test different data points.What to Expect
Once you input the function:
- Data should start streaming automatically
- The cell will update in real-time as market data changes
- You should see live price updates during market hours
Setup Complete!
Now you are ready to use MarketXLS! In the next section, explore all the functions available to power your investment research.