Use QuoteMedia on Mac or Excel for the web
The Microsoft 365 add-in manages QuoteMedia for you. After you sign in, MarketXLS checks your subscription, obtains a streaming session, and opens the connection automatically.
You don't enter a QuoteMedia username, password, data center, or professional-mode setting in this add-in.
Start QuoteMedia
- Open Excel and select MarketXLS (Web).
- Open the MarketXLS task pane.
- Sign in to your MarketXLS account.
- Wait for the task pane to finish checking the account and opening the stream.
- Confirm that the task pane shows Streaming: On.
The task pane can show these states:
| State | Meaning |
|---|---|
| Login Required | The add-in doesn't have a signed-in MarketXLS user. |
| Streaming: Off | A QuoteMedia session isn't open yet. Check the subscription or wait for the connection. |
| Streaming: Paused | The connection exists, but the add-in isn't applying new ticks to formulas. |
| Streaming: On | The connection is open and new ticks can update streaming formulas. |
Test a streaming formula
- In a blank workbook, enter
=mxls.QM_Stream_Last("MSFT"). - Press Enter.
- Keep Streaming: On.
- During an active market session, wait for the next QuoteMedia value.
Microsoft 365 custom functions use the mxls. namespace. Add it before the Windows streaming function name: =QM_Stream_Last("MSFT") becomes =mxls.QM_Stream_Last("MSFT").
The legacy alias =mxls.Stream_last("MSFT") also works. Use the mxls.QM_Stream_* family for new formulas, and use the platform equivalence table when you move a workbook.
Pause or resume the stream
Use either control:
- On the MarketXLS (Web) ribbon, select Toggle Streaming.
- In the task pane, select Streaming: On to pause or Streaming: Paused to resume.
Pausing keeps the session available but stops new values from being applied. It isn't the same as refreshing a workbook. Read Turn real-time streaming on or off.
Run the built-in diagnostic
If you're signed in but the stream is off or reports an error, select Why? in the task pane. MarketXLS tests the account, subscription, backend connection, session, and stream, then copies a diagnostic report to the clipboard.
Paste that report into a support request. Don't add your password. The report can include your account email and technical session status, so review it before you share it outside MarketXLS support.