JPX List of TSE-listed Issues

Use in your agent

Load the JPX list of TSE-listed issues into pandas and Parquet. Checked against the provider's documentation on Nov 5, 2026.

Access

• No account or key; direct Excel download.
• English file data_e.xlsx and Japanese twin data_j.xlsx on the List of TSE-listed Issues page.

Request

curl -o data_e.xlsx 'https://www.jpx.co.jp/english/markets/statistics-equities/misc/tvdivq0000001vg2-att/data_e.xlsx'

Format

Excel (.xlsx, about 260 KB), one sheet, one row per issue: Effective Date, Local Code, Name (English), Section/Products, 33 Sector(Code), 33 Sector(name), 17 Sector(Code), 17 Sector(name), Size Code (New Index Series), Size (New Index Series). Non-stock rows use "-" in the sector and size columns.

Load into pandas and Parquet

Needs Python 3 with requests, pandas and pyarrow.

"""JPX List of TSE-listed Issues (monthly Excel, English) -> pandas -> Parquet. No key."""
import io
import requests
import pandas as pd

URL = "https://www.jpx.co.jp/english/markets/statistics-equities/misc/tvdivq0000001vg2-att/data_e.xlsx"
r = requests.get(URL, timeout=60)
r.raise_for_status()
df = pd.read_excel(io.BytesIO(r.content), dtype=str)
df.to_parquet("jpx_tse_listed_issues.parquet", index=False)
print(len(df), "issues; effective", df["Effective Date"].iloc[0], ";", df["Section/Products"].value_counts().index[0])

Run by us on 2026-11-05 (python 3.13 | pandas | pyarrow | requests (box probe)). Result: 4444 issues; effective 20261031 ; Prime Market (Domestic)

Limits

• One snapshot a month (as of the previous month-end), updated at about 9:00 a.m. JST on the 3rd business day; only the latest file is posted.
• No download limit stated.

Quirks

• Read all columns as text: sector and size columns mix numbers and "-".
• Reference data only, no prices; for prices see the J-Quants API (separate terms).

Terms and attribution

• JPX website terms prohibit collecting data or secondary use of site information for commercial purposes without JPX permission or a paid contract.
• The list is an outline for information, not a solicitation for investment; JPX does not assure its completeness.

Sources

• https://www.jpx.co.jp/english/markets/statistics-equities/misc/01.html: “Updated at approximately 9:00 a.m. on the 3rd business day of each month”
• https://www.jpx.co.jp/english/term-of-use/index.html: “The collection of data or secondary use of information from this website for commercial purposes is strictly prohibited, unless JPX has granted prior permission or authorized such use under a paid contract.”