Data & Specs
Which endpoint provides specific data such as average volume or dividend yield?
Please refer to the data specs & endpoint list for a full list of data and endpoints. If you cannot find what you need, please contact us via the inquiry form.
How do I retrieve data when it exceeds the single-response limit?
If pagination_key is included in the response, it indicates more data exists. Specify the previous response's pagination_key value as a query parameter in your next request to retrieve the next batch. Repeat until pagination_key is empty or absent to retrieve all records.
API response format (column names) has changed from before.
V2 API has changed the response structure and column names. See V1→V2 migration guide for details.
- Response structure: Returned as an array under the data key. pagination_key is also included when paginating
- Column names: Shortened forms are used for OHLC prices etc. Examples: Open → O, High → H, Low → L, Close → C, Volume → Vo, TurnoverValue → Va, AdjustmentFactor → AdjFactor
Data is missing or incorrect for a specific stock.
Thank you for reporting the issue. Please provide the following information via the inquiry form. Data fix status is also updated regularly at the data fix information page.
- Stock code
- Endpoint (e.g., /v2/equities/bars/daily)
- Issue description (e.g., missing data on a specific date, abnormal values)
- Date or period when the issue was observed
How can I check that the OHLC values match the official values published by TSE?
You can check the values for the relevant date in the Daily Stock Price Table published by the Tokyo Stock Exchange. Note that reconciliation at the level of individual execution times and execution prices is outside the scope of the J-Quants API.
Can I check the coverage for the issues I need before subscribing?
Please see APIs and Data Storage Period by Subscription for API availability and data storage periods by plan. For an individual issue, the history covered is the part that falls within the data storage period and on or after that issue's listing date. In addition, depending on each API's recording conditions (whether the issue was designated as a daily publication issue, whether a short position of 0.5% or more was reported, etc.), there may be periods for which no record exists. For the coverage of an individual issue, please check by actually calling the API on your subscribed plan.
Are adjusted stock prices retroactively updated for past data?
For stocks that have had splits or consolidations, adjusted prices are recalculated retroactively back to the oldest available data. There is no limit on how far back adjustments reach. The available data period varies by plan. See Data specs by plan for details.
The free plan does not provide data for the last 12 weeks. What happens to the stock price if a stock split occurs during this period?
When a stock split occurs, historical stock prices are adjusted retroactively from the effective date. Therefore, if a stock split occurs between 12 weeks ago and the present, stock prices prior to 12 weeks ago will also be adjusted for the split. See the data specs by plan and adjusted price spec for details.
How do I calculate market capitalization?
The Valuation Indicators API response includes market capitalization (MktCap, in millions of yen), so no calculation is needed. It is computed as the closing price (or the base price on days when no trade is executed) multiplied by the share count excluding treasury shares. Market capitalization in the Daily Stock Prices (OHLC) API uses a share count that includes treasury shares, so the two values may not match. See Valuation Indicators for details.
Can I retrieve data for delisted stocks?
Yes. Data for the period during which a delisted stock was listed remains available, and can be retrieved by specifying a date or period within its listing period. In the equities master (/v2/equities/master), specify a `date` on which the stock was still listed; if you specify a `code` with a date after delisting, the response will be empty. Note that listing/delisting dates and a list of delisted stocks are not provided. See the equities master API spec and Daily OHLC for details.
Are values in the financial info API (fins/summary) cumulative or quarterly?
Sales / OP (operating profit) / OdP (ordinary profit) / NP (net profit) are cumulative values from the start of the fiscal period (not quarterly standalone values). For example, CurPerType=3Q is the 9-month cumulative (1Q+2Q+3Q). This applies to all accounting standards. Note: OdP is blank for IFRS and US GAAP. See Financial Info API spec for details.
Which endpoint provides the total number of issued shares?
End-of-period issued shares are available from the financial info API (/v2/fins/summary). Subtract TrShFY (treasury shares) from ShOutFY (total issued shares incl. treasury) to get shares excluding treasury stock. The equities master endpoint does not have a total issued shares field. See Financial Info API spec for details.
Account item names in fins/details change every year. How do I map old and new names?
Keys in /v2/fins/details use the 'verbose label (English)' from the EDINET XBRL taxonomy, which may change with revisions. For Japanese GAAP, API keys correspond to Column E 'verbose label (English)' of each sheet in the 'Account Item List'; for IFRS, they correspond to Column D 'verbose label (English)' of each sheet in the 'IFRS Taxonomy Element List'. For details on each list, see the EDINET taxonomy pages.
Which indices are available in the index OHLC endpoint?
The list of available indices is in the index code list. Note that data coverage periods vary by index.
Is data from regional exchanges and PTS available? Are there any future distribution plans?
Only data for stocks listed on the Tokyo Stock Exchange is distributed. There are no plans to distribute data from regional exchanges or PTS. Note that Cash Dividend Data (/v2/fins/dividend) also includes dividend notifications for issues listed only on regional exchanges.
Is futures data available in the minute/tick data endpoints?
J-Quants API currently does not provide minute-bar data for futures. The minute/tick add-on only covers equity (cash equity) data. See Minute-bar data spec for details.
Is minute-bar data updated in real time?
Minute-bar data is updated on a daily basis. Real-time delivery is not available. See the data update schedule for details.
Does J-Quants API provide ISIN codes or FIGI codes?
J-Quants API does not include ISIN codes or FIGI codes. For details on available data items, please refer to the equities master API spec.
Is there a way to distinguish common shares from preferred shares?
The issue code (`Code`) consists of five characters, and the last (fifth) character is a reserve code assigned by share class. You can use this character to distinguish them: common shares have `0`. Also, when you specify a 4-character code in `code` on the J-Quants API, only common share data is returned for issuers that have both common and preferred shares listed. See the equities master API spec for details. For the list of currently listed preferred stocks, see Listed Issues (Preferred Stocks, etc.) on the JPX website.
Can you advise on calculation methods, such as whether a backtest or an indicator can be reproduced correctly?
Whether a particular backtest, ranking, or profit-and-loss calculation can be reconstructed from data for a given date range also depends on your own calculation conditions, so we do not assess or guarantee this. Please make your own judgment based on the published specifications.
Similarly, we do not define a recommended treatment for days with no trade in time-series calculations (such as carrying forward the previous business day's closing price, or treating the day as missing). Please decide according to your intended use.
Do you provide data on trading suspensions or corporate actions?
The personal J-Quants API does not provide information on trading suspensions, and it does not provide a dataset of corporate actions such as stock splits, reverse stock splits, or company name changes either.
However, in Stock Prices (OHLC), three types of corporate action — stock splits, reverse stock splits, and rights issues — are set in the ex-rights type (ExRT) on the ex-rights date. In addition, the only data adjusted retroactively for corporate actions is the adjusted fields of Stock Prices (OHLC); no other API is adjusted retroactively.
For the data available under each subscription, see APIs and Data Storage Period by Subscription.
Is there a push notification mechanism (such as a webhook) for dataset updates and corrections?
No. We do not provide an API or webhook that notifies you when a data update is complete, nor version numbers or ETags for the data. The update timing of each dataset is described in Update Timing of Provided Data, so please retrieve data periodically on your side with that in mind. Corrections are announced on the Data Correction History and Known issues page; if you need to reliably incorporate corrections, we recommend periodically re-fetching the data you need.
What happens if I specify a date outside the range covered by my plan?
If you explicitly specify a date outside the available range, HTTP 400 is returned with a message showing the range covered by your subscription. If you omit `from` and `to`, they are automatically adjusted to fall within the range covered by your plan.
Can I check the actual update times of past business days?
We do not publish a record of the actual update times for each past business day. For the approximate update timing, see Update Timing of Provided Data.
Is the update timing the same for the API and the CSV (bulk files)?
For some data, the update timing differs between the API and the CSV (bulk files). For example, Financial Statement Data (BS/PL/CF) is updated daily for CSV and near real-time for the API. Please check the table in Update Timing of Provided Data for how each dataset is handled.
Can I perform point-in-time analysis using only the information that was actually available at each point in time?
For data recorded per disclosure or report, a correction is added as a separate record and the pre-correction record is also retained. Items such as the disclosure number and disclosure date let you identify which disclosure a value is based on. See the "Data correction policy" section on each dataset page.
How are data corrections reflected?
For datasets in which a correction is added as a separate record (Financial Data, Financial Statement Data, Cash Dividend Data, Earnings Announcement Dates, Timely Disclosure, and EDINET-related data), how corrections are reflected is described in the "Data correction policy" section of each specification page. For the history of data additions and overwrites made because our data was missing or contained an error, see Data Correction History and Known issues.
Is there any difference in coverage between the CSV files (bulk download) and the API?
For Stock Prices (OHLC), the adjusted fields are not included in the CSV files.
Apart from that, the CSV files are created from the same data as the API, so the data items are the same as the API.
How are the CSV files split? Are per-issue files available?
Files are provided per data type (endpoint) and per month or per day. They are not split by issue, so if you only need specific issues, please extract them after downloading.
Japanese text is garbled when I open a CSV file in Excel.
Files are encoded in UTF-8 (without BOM). Japanese text may appear garbled if you open a file directly in Excel. In Excel, select the **Data** tab > **From Text/CSV** and set the file origin to UTF-8 when importing.
Are there limits on the number of records, data volume, or downloads for bulk files?
There are no limits on the number of records, the data volume, or the number of downloads. Note, however, that calls to the List of Downloadable Files API (`/v2/bulk/list`) and the Get File Download URL API (`/v2/bulk/get`) are subject to the rate limits.
Is there a preliminary/final distinction for the OHLC data (stocks and indices)?
Stock Prices (OHLC), Indices (OHLC) and TOPIX (OHLC) are each updated once a day. There is no distinction between preliminary and final values; the data is final once delivered.
When is the current day's data added for minute bars and ticks?
Is Financial Data available immediately after a disclosure?
Disclosures are reflected sequentially as they are released, but some delay may occur. Delays may be longer during periods when disclosures are concentrated, such as quarterly earnings season. Except on the Premium plan, even if you poll the Financial Data API at short intervals after detecting a disclosure, the data for that disclosure is not returned until the daily reflection timing (around 18:00 / around 24:30), so please keep this in mind. See Update Timing of Provided Data.
Is the Timely Disclosure index updated at the same time as TDnet?
It is not updated at the same time as the TDnet Timely Disclosure network service, and there is a time lag between disclosure and reflection. During time slots when earnings announcements are concentrated (around 15:00 and 15:30, for example) or depending on the operational status of the delivery infrastructure, a larger delay than usual (up to about one hour) may occur. The same applies during trading hours; there is no difference by time of day. Real-time delivery at second-level precision is not guaranteed.
Do the CSV files (bulk download) include adjusted prices?
Adjusted prices for stock splits/reverse splits (`AdjO` / `AdjH` / `AdjL` / `AdjC` / `AdjVo`) are not provided in CSV files. The Stock Prices (OHLC) CSV files contain the unadjusted OHLC prices and volume plus the adjustment factor (`AdjFactor`) and the ex-rights type (`ExRT`), so please refer to How to calculate adjusted prices and calculate them yourself.
Can I retrieve the trading unit (lot size) or its change history?
J-Quants API does not provide data on trading units or their change history.