cd /news/ai-tools/microsoft-excel-adds-federated-finan… · home topics ai-tools article
[ARTICLE · art-39402] src=letsdatascience.com ↗ pub= topic=ai-tools verified=true sentiment=↑ positive

Microsoft Excel Adds Federated Financial Connectors and Copilot Skills

Microsoft Excel has added federated financial connectors for LSEG and Moody's data, enabling Copilot to query live market data via the Model Context Protocol. The update allows users to access real-time foreign exchange rates, equities, and credit ratings directly within spreadsheets while preserving governance controls.

read2 min views1 publishedJun 25, 2026
Microsoft Excel Adds Federated Financial Connectors and Copilot Skills
Image: Letsdatascience (auto-discovered)

What happened

Per a Microsoft Excel blog post on the Microsoft Tech Community (May 28, 2026), Copilot in Excel can now connect to institutional data from LSEG and Moody's using federated connectors. The post states these connectors are built on the emerging industry standard Model Context Protocol and that Copilot will query the source systems at the moment a request is made, returning the latest available data. The blog also documents an in-app flow: open the Sources menu, connect to the provider with credentials, turn the source toggle on, and have Copilot request confirmation before incorporating provider data into the workbook.

Technical details

Per the Microsoft Excel blog, the LSEG connector exposes market data including foreign exchange rates, equities, and pricing via a standardized, AI-ready interface while preserving governance and entitlements. The post describes the connectors as "federated" because they retrieve context from the provider at runtime rather than copying static snapshots into the service. The blog emphasizes use cases such as updating hedging models or checking current credit ratings where query-time freshness matters.

Industry context

Editorial analysis: The move aligns with a broader industry pattern toward runtime data integration for AI assistants, where standardized protocols such as Model Context Protocol aim to make external, institutional datasets available to models without breaking existing enterprise controls. Companies and practitioners integrating third-party market data into analytic workflows often balance the benefits of fresher inputs against governance, entitlement checks, and audit logging requirements.

Practical implications

Editorial analysis: For data teams, embedding federated connectors into spreadsheets shifts some data validation and lineage work upstream, which can simplify analyst workflows but also requires revisiting access controls and data provenance processes. Observability and reproducibility of workbook-driven analyses become more important when results depend on live, external queries.

What to watch

Editorial analysis: Observers should look for additional provider integrations beyond LSEG and Moody's, vendor support for Model Context Protocol across platforms, and product-level details on entitlements, logging, and repeatable extraction for testing and audit scenarios.

Scoring Rationale #

Notable product update extending MCP-based federated data connectors to LSEG and Moody's in Excel Copilot, improving analyst workflows for enterprise finance users. Impact is real but specialized to the M365 Copilot and institutional finance segment; broader AI/ML practitioners are adjacent, not primary, beneficiaries.

Practice interview problems based on real data

1,625 SQL & Python problems across 15 industry datasets — the exact type of data you work with.

Try 250 free problems

── more in #ai-tools 4 stories · sorted by recency
── more on @microsoft 3 stories trending now
sponsored brought to you by zahid.host 4,200+ EU-deployed projects
reading about agents? ship yours in a single git push.

Run your AI side-project on zahid.host

EU-based hosting, git-push deploys, automatic HTTPS, no cold starts. Free tier with a custom domain — perfect for shipping the agent you just read about.

$git push zahid main
Live at https://your-agent.zahid.host
Get free account → Pricing
from €0/mo · no card required
LIVE [news/microsoft-excel-adds…] indexed:0 read:2min 2026-06-25 ·