> For the complete documentation index, see [llms.txt](https://jpx.gitbook.io/j-quants-pro/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jpx.gitbook.io/j-quants-pro/api-reference/corporate_action/delisting.md).

# Delisting(/corporate\_action/delisting)

### Overview

Currently, data is not distributed via API (available through SFTP and Snowflake). You can obtain information about delisting dates and other details for listed companies.

### Attention

{% hint style="info" %}

* Securities that are not listed on the Tokyo Stock Exchange (securities listed only on local exchanges) are not included in the data.
  {% endhint %}

## Obtain Delisting Data

### Data Item

<table><thead><tr><th width="214">Variables</th><th width="188">Description</th><th width="100">Data type</th><th>Remark</th></tr></thead><tbody><tr><td>AnnouncementDate</td><td>Announcement Date (YYYY-MM-DD)</td><td>String</td><td>YYYY-MM-DD</td></tr><tr><td>AnnouncementTime</td><td>Announcement Time (HH:MI)</td><td>String</td><td>HH:MI</td></tr><tr><td>ReferenceNumber</td><td>Reference Number</td><td>String</td><td><p>A unique number to identify the delisting announcement</p><p>※See <a href="/pages/fdR8WW5JhlejyNRDcbKY#reference">About Reference Number</a></p></td></tr><tr><td>StatusCode</td><td>Update Type (Code)</td><td>String</td><td>1: New, 3: Deletion</td></tr><tr><td>Code</td><td>Issue Code</td><td>String</td><td></td></tr><tr><td>MarketCode</td><td>Exchange Code for Delisting</td><td>String</td><td>01: TSE, 02: OSE, 03: NSE, 06: FSE, 08: SSE, 11: JSDA GS, etc.</td></tr><tr><td>DelistingDate</td><td>Delisting Date</td><td>String</td><td>- for undetermined dates, empty string for unset values</td></tr><tr><td>CAReferenceNumber</td><td>CA Reference Number</td><td>String</td><td><p>Reference number of the delisting announcement being corrected or deleted. For new entries, set the same value as the reference number</p><p>※See <a href="/pages/fdR8WW5JhlejyNRDcbKY#reference">About Reference Number</a></p></td></tr></tbody></table>