Taiwan Stock Exchange (TWSE) API for Openclaw

This integration relies on the public, open-data API provided by the Taiwan Stock Exchange, which requires no registration. To query the endpoints using tools managed under Openclaw Skills, you can interact with the endpoints directly.

To fetch daily OHLC data and extract data for a specific stock code (e.g., TSMC - 2330) using curl and Python, run the following commands:

curl -s https://openapi.twse.com.tw/v1/exchangeReport/STOCK_DAY_ALL | \
python3 -c "import json,sys; print([r for r in json.load(sys.stdin) if r['Code']=='2330'])"

For a direct programmatic implementation in Python, use the following snippet:

import json, urllib.request

BASE_URL = 'https://openapi.twse.com.tw/v1'

def fetch_twse_data(endpoint):
    with urllib.request.urlopen(f'{BASE_URL}{endpoint}') as response:
        return json.load(response)

# Fetch daily stock valuations
market_data = fetch_twse_data('/exchangeReport/BWIBBU_ALL')
target_stock = next(item for item in market_data if item['Code'] == '2330')
print(target_stock)

Endpoint Categories and Schema Mapping

Endpoints are grouped into distinct categories. Field names vary between English keys and Traditional Chinese keys depending on the source dataset.

Data Normalization Guidelines

• Date Adjustments: Most datasets use the ROC calendar (e.g., 1150706 representing July 6, 2026). Convert this format by adding 1911 to the leading three digits to get the Gregorian year.
• Numeric Formatting: Numeric attributes are returned as string fields and may contain commas (e.g., "1,005,300") or dashes (e.g., "-") for blank fields. These must be sanitized before conversion to numeric data types.