Connect J-Quants to Copilot Studio
Query J-Quants directly from Copilot Studio. Arlet links the two through one MCP connection and takes care of API keys.
This server connects your AI client to J-Quants API V2, the official market data API operated by JPX Market Innovation & Research (Japan Exchange Group). It provides pro-grade Japanese equities data collected directly from the exchange.
Key features:
- Look up listed companies (name, sector, market segment) by issue code or by company-name keyword.
- Fetch daily OHLC bars (open/high/low/close, volume, turnover, and split-adjusted figures) for any listed stock, over a date range.
- Fetch quarterly financial summaries built from TDnet earnings reports (kessan tanshin).
- Check upcoming earnings announcement dates and the trading calendar (market holidays).
Using the API requires a J-Quants account and an API key issued from the J-Quants dashboard. A free plan is available (data is delayed; paid plans unlock fresher data, longer history, and higher rate limits - the free plan allows 5 requests per minute). Set the key as JQUANTS_API_KEY in your Arlet environment variables.
How to connect J-Quants to Copilot Studio
- 1
In the Arlet dashboard, open Data tools, find J-Quants, set the API key issued by J-Quants and switch it on.
- 2
Sign in to Copilot Studio with your work account, create a new agent (or open an existing one), and in the Build tab choose Tools → + → Add → Model Context Protocol (MCP) in the right panel.
- 3
In the Add MCP server form, enter "Arlet" as the Server name, https://mcp.arlet.dev/mcp/ as the Server URL, choose OAuth 2.0 for Authentication and "Dynamic (detected)" for Configuration type, then click Add. No Client ID / Secret is needed.
- 4
On the Select a connection screen, choose Create new connection → Create, then sign in with Google on the Arlet authorization screen and click Allow. Click Add to attach the tool to the agent, then Publish to use it from Microsoft 365 Copilot.
Requires a Microsoft work account and a Copilot Studio license (or trial). MCP is available only for agents using generative orchestration and not in Copilot Studio in Teams.