Install MNI Markets
Install MNI Markets directly from Microsoft AppSource — no file download required.
Install from Microsoft AppSource
The easiest way — available directly inside Excel or from the AppSource marketplace. No file download required.
How to use MNI Markets
Stream real-time macroeconomic data directly into Excel cells using the task pane and built-in formulas.
1. Sign in
Click the MNI Markets button in the Home ribbon to open the task pane. Click Sign in with MNI Portal and authenticate with your MNI Markets account credentials.
2. Browse the data catalog
Once signed in, the task pane shows a searchable catalog of available data series grouped by economic release (e.g. US CPI, NFP, GDP). Click any release to expand it and see the individual series it contains.
Use the search bar at the top to filter by series name.
3. Insert data into cells
Select a cell in your spreadsheet, then click one of the insert buttons next to a series:
Live (actual)
Inserts =MNI(id) — streams the latest published value and updates the cell automatically when a new release arrives.
Forecast
Inserts =MNI_FCST(id) — returns the consensus forecast for the next release. Optionally filter by source (e.g. "MNI").
Prior
Inserts =MNI_PREV(id) — returns the previously published value for the series.
History
Expands a date picker — choose a start date and click Generate to write a historical table of values into the sheet.
4. Custom function reference
You can also type the formulas directly into any cell:
| Formula | Description | Updates live? |
|---|---|---|
=MNI(dataSeriesId) | Streams the latest actual value. Updates automatically when AlphaFlash publishes a new observation. | Yes |
=MNI_FCST(dataSeriesId, [source]) | Returns the forecast value. Optional source parameter filters by provider (e.g. "MNI"). | On reconnect |
=MNI_PREV(dataSeriesId) | Returns the prior period value for the series. | On reconnect |
The dataSeriesId is the AlphaFlash identifier shown below each series name in the catalog (e.g. US_CPI_YY). You can copy it from the task pane.
=MNI_FCST("US_CPI_YY","MNI") → MNI's forecast for next US CPI release
=MNI_PREV("US_CPI_YY") → previous period value
5. Generate a live release sheet
Click Generate live release sheet in the task pane to create a new sheet with all upcoming releases pre-populated. Each row updates automatically when a new observation arrives via the live data stream.
6. Refresh formulas manually
If any cells show stale or missing values after a reconnect, click Refresh formulas in the task pane to force a re-fetch of all current values.
7. Sign out
Click Logout in the top-right corner of the task pane. This immediately clears all stored tokens. Streaming functions will stop updating until you sign in again.
Contact support
Having trouble with the MNI Markets Excel Add-in? Our support team is here to help.
MNI Markets Support
Email us and include a brief description of the issue, your Excel version, and your operating system.
For account and subscription queries, contact your MNI account manager directly.
Before you write
These steps resolve most common issues:
- 1
Check your connection status
Look at the coloured dot in the top-right of the task pane. A red dot means the WebSocket is disconnected — click Refresh formulas to reconnect.
- 2
Sign out and sign back in
Click Logout, then Sign in with MNI Portal again. This refreshes your session token.
- 3
Reload the add-in
Close the task pane, close and reopen Excel, then reopen the MNI Markets task pane.