FXMacroData for Microsoft 365 Copilot
Build a Microsoft 365 Copilot agent that answers FX and macro questions with FXMacroData release calendars, indicators, FX rates, COT positioning, commodities, and market-session tools.
Brief markets in chat
Ask Microsoft 365 Copilot for pair briefings, release calendars, central-bank context, and current FX session timing.
Use read-only tools
The first agent package maps to read-only MCP tools, so the agent retrieves data without changing user or FXMacroData resources.
Extend later
The same package can evolve into Copilot Studio flows, Teams desk bots, Outlook meeting prep, and interactive MCP widgets.
First build: declarative agent plus MCP plugin
The repository includes a Microsoft 365 Copilot scaffold under extensions/microsoft-365-copilot/. It is designed for import and validation with Microsoft 365 Agents Toolkit.
Core files
declarative-agent.jsonfxmacrodata-mcp-plugin.jsonmcp-tools.jsondocs/test-prompts.md
Production endpoints
MCP: https://fxmacrodata.com/mcp API: https://fxmacrodata.com/api OpenAPI: https://fxmacrodata.com/api/openapi.json
Supported agent questions
Market briefings
Brief me on EUR/USD macro risks this week. Compare Fed and ECB policy pressure. Prepare a concise USD briefing for my morning meeting.
Data lookups
What are the next USD releases? Show latest COT positioning for JPY. Summarize gold price history for the last 6 months.
Tool map
| Intent | MCP tools | Typical prompt |
|---|---|---|
| Discover indicators | data_catalogue | What indicators are available for AUD? |
| Macro series | indicator_query | Show USD inflation since 2023. |
| Release risk | release_calendar | What EUR releases are due this week? |
| FX rates | forex, forex_visual_artifact | Get EUR/USD for the last 3 months. |
| Sessions | market_sessions | Which FX sessions are open now? |
| Positioning | cot_data, cot_visual_artifact | Show JPY COT positioning. |
| Commodities | commodities, commodities_visual_artifact | Summarize gold price history. |
Setup path
Create a declarative agent project
Use Microsoft 365 Agents Toolkit and create a new declarative agent project in your tenant.
Add the FXMacroData MCP action
Use the package files from extensions/microsoft-365-copilot/ and point the runtime at https://fxmacrodata.com/mcp.
Configure authentication
Use Microsoft tooling to store the FXMacroData API key in a plugin vault. Public tools can be tested without a key, but protected families need one.
Run the test prompts
Validate public flows, protected access, multi-tool briefings, unavailable indicators, and investment-advice guardrails.
Next Microsoft 365 builds
After the Copilot agent scaffold is validated in a Microsoft tenant, the next highest-value steps are a public Copilot demo page, Copilot Studio connector hardening, Excel workflow examples, and Work IQ meeting-prep research.