Not logged in - Login
< back

Corporate Actions File FAQ

Corporate Action File FAQs

General

Please reference the following page: Corporate Actions File

Ex-dates can be missing if the corporate action event was cancelled, 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: Dividend for Societe Generale (event ID 1510382) was created on 17th Jan 2019; no dates have been announced for 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)

Takeovers/Mergers

Takeovers are usually Friendly or Hostile. The type of takeover can be found under 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 holding 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”.

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.

Compulsory Acquisition date is when the company have 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