Not logged in - Login

Corporate Actions File FAQ

Corporate Action File FAQs

Links

Corporate Actions File Spec (.txt Download Link)

Corporate Actions File Lookup Table (Excel Download Link)

Glossary of Terms (PDF Download Link)


General

Please reference the following page: Corporate Actions File
Ex-dates can be missing if the corporate action event was canceled, it was deleted by the source, or it has not been updated yet. Please email support@xignite.com if you believe that the data incorrectly missing.
This should never be found in the actual text feed file. If you import into Excel it will usually turn any numeric only numbers to scientific format. Please report if you see any of this in text files delivered via CloudFile.
For newly created corporate action events, there may not be any dates announced yet. Examples: The dividend for Societe Generale (event ID 1510382) was created on 17th Jan 2019; no dates have been announced for the dividend yet.
The frequency can be missing if it is a special or irregular dividend that is not paid out in regular intervals. (no frequency)
The file versions correspond to each of the 3 updates per day. Each version will have different data and will be compiled in the 'Final' version for each day.

Takeovers/Mergers

Takeovers are usually Friendly or Hostile. The type of takeover can be found under the field name “Field4Name”

Takeover (Also known as Amalgamation) (V/M) - Company A takes over the managerial control of Company B. Both companies may continue to exist. A Takeover may result in Compulsory Acquisition if the country’s trigger limit of minimum public shareholding is breached. Compulsory Acquisition turns the Takeover event from Voluntary to Mandatory

Merger (M) Coming together of two or more companies to form a new company. Shareholders of all the old companies have to exchange their holdings for shares of the new company. The original companies cease to exist. E.g. AOL Inc. & Time Warner Inc. merged to form AOL Time Warner Inc.

Mini takeover is highlighted under field name “Field5Name”.

The open date, close date, and compulsory acquisition date are the main dates for this event.

Open and Close dates are the start and end windows of the takeover.

The compulsory Acquisition date is when the company has taken over most of the second company which then triggers the Compulsory Acquisition by this date. Compulsory Acquisition turns the Takeover event from Voluntary to Mandatory

Rec date and ex-date can occur in TKOVR but are seldom populated


Action Flags (actflags)

We have I (insert), U (update), D (delete), and C (cancel).

  • Insert (I) - inserting new corporate action events
  • Update (U) - usually used when information is added to a corporate action. For example, adding a date that was not previously available. Updates are applied to previously inserted events; the actflag changes from I to U for the same event ID.
  • Delete (D) - usually used when the provider discovers that the information for the event is erroneous.
  • Cancellation (C) - used when the company cancels the corporate action

    • Each event ID is unique to each corporate action. In uncommon cases, you may see two event IDs for one corporate action, where one has the D (delete) action flag. This deleted event ID will not show in the next corporate actions file.

    Note that you can have more than one eventid on the same recdate so you may want to limit to only regular cash dividends in which case there should never be more than one.

      Corporate Actions List
    • Annual General Meeting
    • Announcement
    • Arrangement
    • Assimilation
    • Buy Back
    • Bankruptcy
    • Bonus Issue
    • Bonus Rights
    • Call
    • Capital Reduction
    • Company Meeting
    • Consolidation (a.k.a Reverse split)
    • Conversion (a.k.a Exchange of Security)
    • Certificate Exchange
    • Currency Redenomination
    • Distribution
    • Dividend
    • Demerger
    • Dividend Reinvestment Plan
    • Divestment
    • Entitlements
    • Franking
    • Financial Transaction Tax
    • Financial Year Change
    • International Code Change
    • Incorporation Change
    • Issuer Name Change
    • Lawsuit
    • Local Code Change (Symbol change)
    • Liquidation
    • Listing Status Change
    • Lot Change
    • Market Segment Change
    • Merger Sec
    • New Listing
    • Odd Lot Offer
    • Property Income Distribution
    • Purchase Offer
    • Primary Exchange Change
    • Preferential Offer
    • Parvalue Redenomination
    • Return of Capital
    • Preference Redemption
    • Rights
    • Security Description Change
    • Security Swap
    • Subdivision (Forward split)
    • Security Reclassification
    • Takeover


    Listing Status Changes

    L -Listed, S suspended D- Delisted and R - Resumed.

    Delisted will make the security inactive or suspended will make security inactive for a period.

    Yes, but a suspension can be a temporary suspension.

    If the status is immediately changed from suspension to delisted, the effective date of suspension is the date it is inactive. However, if the security is resumed and then delisted then the effective date of delisting is the inactive date.

    No, when it is resumed it means it is active security.

    There is no implication; both statuses mean that it is actively trading.