repository·master·Indexed 19 days ago
https://github.com/kabucom/kabusapiA portal and API interface for kabuステーション used for interacting with financial trading services. Includes an Excel Add-in providing custom functions for retrieving real-time prices, market data, server status, and managing orders via RTD and WebSocket connections.
If you need to interact with the kabuステーションAPI developers, you can submit issues via GitHub using specific templates for different purposes:
To receive real-time data pushes in Excel, you must follow a two-step process:
test_StartWebSocket() to initiate the background connection to the server.test_RegistMarketData(symbol) to tell the server which symbols you want to receive updates for.test_GetWebSocketData() in a cell to display the most recent message received from the WebSocket stream.Note: test_StartWebSocket is a macro-type function and should be triggered once to start the background process.
// Step 1: Run this once (e.g., via a button or macro)
=test_StartWebSocket()
// Step 2: Register a symbol for updates
=test_RegistMarketData("165060019@2")
// Step 3: Use this in a cell to see the latest data
=test_GetWebSocketData()The Excel Add-in provides several custom functions that can be used directly within Excel spreadsheet cells to interact with the Kabu API. These functions allow for retrieving real-time prices, market data, checking server status, and managing orders.
| Function Name | Description | Argument(s) |
|---|---|---|
test_GetRTDPrice | Get real-time price of the symbol (via RTD) | symbol (string) |
test_GetStatus | Get Server Status | None |
test_GetMarketData | Get Market Data (4-price values, etc.) | symbol (string, format: 銘柄コード@市場コード) |
test_PutSendOrder | Execute a Send Order request | None |
test_RegistMarketData | Register a symbol for PUSH (WebSocket) delivery | symbol (string, format: 銘柄コード@市場コード) |
test_StartWebSocket | Start the WebSocket connection for real-time data | None |
test_GetWebSocketData | Retrieve the latest message received via WebSocket | None |
For functions requiring a symbol (like test_GetMarketData or test_RegistMarketData), use the format 銘柄コード@市場コード (e.g., 8411@1 or 5401@1).
Use the test_GetMarketData function to fetch market data (such as 4-price values) for a specific symbol. The symbol must follow the format 銘柄コード@市場コード.
=test_GetMarketData("5401@1")Use the test_GetRTDPrice function to retrieve real-time price information for a specific symbol using Excel's Real-Time Data (RTD) service. If no symbol is provided, it defaults to 8411@1.
=test_GetRTDPrice("8411@1")