Provides Japanese stock daily time-series data as CSV files intended for saving to a specified Google Drive folder, with the destination folder ID supplied to the assistant.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@J-Quants Timeseries MCP キオクシアの株価時系列データを取得してGoogle Driveに保存してください"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
This is a personal MCP server that fetches daily Japanese stock bars from the J-Quants API V2 and returns a CSV that ChatGPT can save to the "Timeseries Data" folder in Google Drive.
Search listed stocks by ticker code or company name
Fetch all pages of /v2/equities/bars/daily
Convert unadjusted and adjusted OHLCV plus limit-up/limit-down flags into a CSV
Read the destination folder ID from Render secret settings and include it in the tool result
When a ticker is ambiguous, return candidates instead of guessing
Related MCP server: Enhanced MCP Stock Query System
Name | Description |
| J-Quants V2 API key. Required. |
| ID of the destination Drive folder. Required. |
| Secret path for the MCP URL. At least 32 characters. Required. |
| HTTP listening port. Set automatically by Render. |
| Public host name set automatically by Render. |
Do not write the API key, Drive folder ID, or access token into source, conversations, or logs.
python -m venv .venv
.venv/bin/pip install -r requirements.txt
PYTHONPATH=. .venv/bin/python -m unittest discover -s tests -vIn Windows PowerShell, replace the Python from the virtual environment with .venv\\Scripts\\python.exe.
JQUANTS_API_KEY=... GOOGLE_DRIVE_FOLDER_ID=... MCP_ACCESS_TOKEN=32文字以上の秘密文字列 python server.pyThe connection URL has the following format.
https://<Renderのホスト名>/mcp/<MCP_ACCESS_TOKEN>Treat this entire URL as secret information. This is lightweight protection for personal use, not a robust method that replaces OAuth authentication. If it leaks, regenerate MCP_ACCESS_TOKEN.
In the web version of ChatGPT, enable Developer mode under "Settings" → "Security and login".
In the Plugins addition screen, register the MCP URL above.
In the conversation, select the J-Quants app and Google Drive from Developer mode.
Ask: "Get Kioxia's timeseries data."
The tool returns the CSV body, the file name, and the destination folder ID read from the secret settings. ChatGPT uploads that CSV to the specified Google Drive folder.
With the Free plan, the stock prices you can retrieve are limited to the past two years excluding the most recent 12 weeks. Check the actual returned first_date and last_date.
This server cannot be deployed
Search Japanese subsidies and public company data using J-Grants, gBizINFO, and EDINET.
Search Japanese companies, departments and hiring signals; export CSV/XLSX with authentication.
Fetch current stock prices and key data for symbols across global markets. Look up companies like…
Provide access to Chinese stock market data including historical prices, real-time data, news, and…