Other Record Dates and Ex-dates(/corporate_action/other_events)

You can obtain information about other record dates and ex-dates.

Overview

Currently, this data is not available through the API (available via SFTP and Snowflake). You can obtain record dates, ex-dates, effective dates, subscription start dates, ratios, prices, etc. for stock splits, free stock warrant allocations, shareholder allocations of stock acquisition rights, physical distributions, company splits (limited to split-type divisions), and stock distributions.

Attention

• Data is not collected for stocks that are not listed on the Tokyo Stock Exchange (stocks listed only on regional exchanges).

Get Other Record Dates and Ex-dates Information

Data Item

Variables	Description	Data type	Remark
AnnouncementDate	Announcement Date (YYYY-MM-DD)	String	YYYY-MM-DD
AnnouncementTime	Announcement Time (HH:MI)	String	HH:MI
ReferenceNumber	Reference Number	String	A unique number to identify the other event announcement ※See About Reference Numbers
StatusCode	Update Type (Code)	String	1: New, 2: Correction, 3: Deletion
BoardMeetingDate	Board Meeting Date	String
EventCode	Event (Code)	String	1: Allotment of Stock, 2: Allotment of Subscription Rights, 3: Offering of Subscription Rights to Shareholders, 4: Non Cash Dividend, 5: Issuer's Request for General Shareholders Notification, 6: Company Split by Split-off, 7: Share Distribution for Splitting off Wholly Owned Subsidiary, 9: Other Events
Code	Stock Code	String
RecordDate	Record Date	String	Undetermined: -, Not set: Empty string
ExDate	Ex-date	String	Same as above
ActualRecordDate	Actual Record Date	String	Same as above
EffectiveDate	Effective Date	Number/String	Same as above
SubscriptionStartDate	Subscription Start Date	Number/String	Same as above
SubscriptionEndDate	Subscription End Date	Number/String	Same as above
AllotmentOldRatio	Ratio 1 (Old)	Number/String	Same as above
AllotmentNewRatio	Ratio 1 (New)	Number/String	Same as above
Price	Issue Price	Number/String	Same as above
CAReferenceNumber	CA Reference Number	String	Reference number of the other event announcement subject to correction/deletion. For new entries, set to the same value as the reference number ※See About Reference Numbers
ShareholderMeetingDate	Shareholders Meeting Date	String	Undetermined: -, Not set: Empty string
AllotIssueCode	Allotment Stock Code	String	Same as above
ExercisePrice	Exercise Price	Number/String	Same as above
ExerciseStartDate	Exercise Period Start Date	String	Same as above
ExerciseEndDate	Exercise End Date	String	Same as above
SharesUnderlyingSubscriptionWarrantCode	Underlying Stock Code for Stock Acquisition Rights	String	Same as above
OldWarrantTransferRatio	Ratio 2 (Old)	Number/String	Same as above
NewWarrantTransferRatio	Ratio 2 (New)	Number/String	Same as above
WarrantTransferPossibilityCode	Stock Acquisition Rights Transfer Possibility (Code)	String	1: Possible, 0: Not Possible, 9: Undetermined, Not set: Empty string
ForeignInvestorsSubscriptionRestrictionCode	Foreign Resident Stock Acquisition Rights Exercise Restriction (Code)	String	1: Yes, 0: No, 9: Undetermined, Not set: empty string
AllotIssueListingDate	Allotment Stock Listing Date	String	Undetermined: -, Not set: Empty string
AllotIssueLastTradingDate	Allotment Stock Last Trading Date	String	Same as above
AllotIssueDelistingDate	Allotment Stock Delisting Date	String	Same as above
SharesUnderlyingShareWarrantsListingDate	Underlying Stock Listing Date for Stock Acquisition Rights	String	Same as above
SharesUnderlyingShareWarrantsLastTradingDate	Underlying Stock Last Trading Date for Stock Acquisition Rights	String	Same as above
SharesUnderlyingShareWarrantsDelistingDate	Underlying Stock Delisting Date for Stock Acquisition Rights	String	Same as above
RightsOfferingCommitmentCode	Commitment Type Rights Issue Classification	String	1: Commitment Type, Non-commitment Type: Empty string
AcquisitionDate	Full Acquisition Date	String	Undetermined: -, Not set: Empty string
AcquisitionConsiderationPaymentDate	Acquisition Consideration Payment Date	String	Same as above
AllotIssueJapaneseName	Allotment Stock	String	Same as above Added after June 6, 2022
AllotIssueEnglishName	Allotment Stock English Name	String	Same as above Added after June 6, 2022