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.

Screenshot needed · M365-LOGIN-01

Capture the signed-out task pane with a blank or fictional email.

/images/docs/microsoft-365/taskpane-login.webp

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.

Screenshot needed · M365-STREAM-01

Capture the task pane with Streaming: On and the live status indicator.

/images/docs/microsoft-365/streaming-on.webp

Streaming: On means the session is open and live formulas can apply new ticks.

Screenshot needed · M365-STREAM-02

Capture the same task-pane area with Streaming: Paused.

/images/docs/microsoft-365/streaming-paused.webp

Streaming: Paused holds current values until you resume the stream.

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.

Screenshot needed · M365-STREAM-03

Capture a safe Streaming: Off or error state with Why? visible and personal data hidden.

/images/docs/microsoft-365/streaming-off-why.webp

When the session is off or reports an error, Why? creates a support-ready diagnostic.

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.