US Equity Announcements Guide
US Equity Announcements Guide
version 1.0 (Feb 2022)
We are here to help you do great things with our market and reference data. For questions, feedback, and other concerns, you may reach our team of experts using the following contact information:
algoseek customer support
support@algoseek.com
(+1) 646 583 1832
algoseek sales
sales@algoseek.com
(+1) 646 583 1832
DATA ORGANIZATION AND FILE FORMAT 4
algoseek Equity Announcements data is built from public resources that provide announces for symbol’s name changes and Delistings.
The US Equity Announcements dataset covers all announcements for future changes that can occur on all public US exchanges. algoseek doesn't include announcements outside the public market (OTC, Over-the-Counter).
Currently, the announcement data is available from 2022.
algoseek provides Equity Announcements data in a plain-text CSV file. The first row of CSV file is a fixed header and then rows of data corresponding to specific events. By default, data is organized into a single file with all history (see Table 1 for sample Equity Announcements data).
Table 1: Sample Equity Announcements Data
AnnounceDate | Effective Date | SecId | Ticker | EventType | OldTicker | NewTicker | Delisting Exchange |
20220104 | 20220113 | 1140988 | TGP | Delisting | NYSE | ||
20220104 | 20220125 | 37917 | HMG | Delisting | AMEX | ||
20220105 | 20220106 | 6762992 | VPCC.U | Delisting | NYSE | ||
20220105 | 20220106 | 6893025 | VPCC | Ticker Change | VPCC | DAVE | |
20220106 | 20220107 | 7159485 | JWACU | Delisting | NASDAQ | ||
20220106 | 20220107 | 866689 | SINO | Ticker Change | SINO | SGLY | |
20220107 | 20220110 | 7144299 | FXCOU | Delisting | NASDAQ | ||
20220107 | 20220110 | 78219 | WLTW | Ticker Change | WLTW | WTW |
Table 2 (below) provides the name, default value, brief description, and data type for each data field (column) in the Equity Announcements CSV file.
Table column “Missing” indicates a default behavior if the data field value is absent. The column value “Never” means that the data field value is always present.
Table 2: CSV File Fields Schema
Field | Type (Format) | Missing | Description |
AnnounceDate | string (yyyymmdd) | Never | Date in yyyymmdd format when the event was announced |
EffectiveDate | string (yyyymmdd) | Blank | Effective Date of the event in yyyymmdd format |
SecId | integer | Never | algoseek unique security identifier |
Ticker | string | Never | Symbol name |
EventType | string | Never | Type of event. See Table 3 below for a list of available events |
OldTicker | string | Blank | Old symbol name |
NewTicker | string | Blank | New symbol name |
DelistingExchange | string | Blank | Exchange from which symbol was delisted |
Table 3: Event Type Table
Event Type | Description |
Delisting | Symbol is delisted from a public exchange |
TickerChange | Symbol name is changed to a new symbol |
Note: The ‘EffectiveDate’ field represents the initial effective date that was published during the first announcement. Sometimes it can be blank when the event was announced already but the effective date is not predefined yet.