Type IndexEvent
Type category Entity
Description Index events, Country events and Stock event details (including corporate actions) impacting the Index Constituents.
Fields
Name Type Filters Description
key id string(500)* = Unique identifier
acquirerName string(1000) Name of the acquiring company in a merger/acquisition (M&A), as of the EFFECTIVE DATE. Provided on a best effort basis.
actionGroup string(1000) Index, country/region or stock event action group. Please refer to section SDE Action Groups within this chapter for further information.
actionType string(1000) Index, country/region or stock event action type, including index holidays and rebalancing dates. Please refer to section SDE Action Types within this chapter for further information.
announcedDate date The date the event was first announced and appears in the file.
announcementId long(-9223372036854775807,9223372036854775806) Unique corporate actions identifier. (Not applicable for all event types, refer to SDE Action Types section for additional details)
audCreatedDate dateTime Timestamp of the record created in DataBase
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the data is calculated.
cashAmount decimal Cash consideration for mergers/acquisitions (M&A).
closeOfBusinessDate date The previous business day, taking into account holidays.
comments string(1000) Descriptive commentary associated with the event
currentAlternateClassificationCode string(1000) Constituents current alternate classification code. This field is reserved for alternate, product-specific classification schemes associated with the constituent.
currentAwf decimal The current Additional Weight Factor (AWF) of the stock as required for certain methodologies. For methodologies not using AWF, the value will be 1.
currentBloombergTicker string(1000) Constituents current Bloomberg Ticker, provided on a best effort basis.
currentCapRange string(1000) Indicates constituent stocks current capitalization range. Available for index families with breakdown by a market cap bracket. For example, a stock that is classified as having a capitalization of over $25 billion will have the code RO25B.
currentCompanyName string(1000) The current name of the constituent.
currentCountryOfDomicile string(2) ISO country/region code that is associated with the constituents current country/region of domicile.
currentCountryOfListing string(2) ISO country/region code that is associated with the constituents current country/region of exchange.
currentCurrencyCode string(3) The current ISO currency code in which the closing price of the stock is stated.
currentCusip string(1000) Constituents current CUSIP identifier, provided on a best effort basis.
currentDjiIndustryCode string(1000) Constituents current Dow Jones Indexes' proprietary industry classification code.
currentGicsCode string(1000) Constituents current Global Industry Classification Standard code
currentGvKey string(1000) Constituents current Compustat permanent company identifier, provided on a best effort basis.
currentIndexShares decimal The constituents current index shares. Index shares represents the total number of shares determined and used by the index calculation methodology (i.e. SHARES OUSTANDING * IWF * AWF).
currentIsin string(1000) Constituents current ISIN identifier, provided on a best effort basis.
currentIwf decimal The current Investible Weight Factor (IWF) of the stock. A value of 1 = 100% Free Float.
currentMic string(1000) Constituents current Market Identification Code, representing the ISO code of the exchange the constituent is traded on.
currentPrice decimal Latest available price prior to the EFFECTIVE DATE adjusted for all corporate actions.
currentRegion string(1000) Constituents current region. Available for the Global BMI family and indicates if the stock is considered part of a developed or emerging market. Currently not being used in files
currentRic string(1000) Constituents current Reuters Instrument Code, provided on a best effort basis.
currentSedol string(1000) Constituents current SEDOL, provided on a best effort basis.
currentSharesOutstanding decimal{26,0} The constituents current number of shares outstanding.
currentShariah string(1000) Current status regarding Shariah compliance.
currentSize string(1000) Constituents current size. Indicates if the stock is classified as a large, mid or small cap stock within the methodology of the index. A stock may be classified as large in one index family, and mid in another. Value is left blank for indices not providing size breakdown.
currentStockAttributes string(1000) Currently not populated. Will be used for future enhancement to changes in stock attributes.
currentTaxRate decimal Current tax rate.
currentTicker string(1000) Constituents current stock ticker, associated with the exchange the constituent is traded on. Provided on a best effort basis.
dividend decimal Dividend amount as reported, as of the EFFECTIVE DATE. Dividend amount will be translated to stock currency if dividend currency differs from stock currency. If the action type is Dividend Adjustment (primarily applicable for Japanese and Korean companies), the dividend amount will be the difference between the confirmed dividend and any amount recognized on the original ex-date.
dividendCurrency string(3) The ISO currency code for the currency the dividend is paid in.
effectiveDate date Indicative of when the corporate actions data is applicable. Also known as the ex-date.
fileDate date Date on which the file is distributed
frankingRate decimal Franking rate for Australian dividends.
fxRate decimal Foreign exchange rate as of the EFFECTIVE DATE.
growth decimal The growth weight factor associated with the stock, as of the EFFECTIVE DATE.
indexCode string(1000) Defines the index code that this stock is related to.
indexCurrency string(3) The ISO currency code for the currency in which the index level data is being reported in.
indexKey string(1000) Defines the index key that this stock is related to. See chapter Index Keys for more information.
indexName string(1000) Defines the index name that this stock is related to.
indexSharesPostEvents decimal The constituents final index shares post all events with the same effective date.
indexSharesPriorEvents decimal The constituents index shares as of close of business the day prior to the effective date.
issuanceFee decimal Dividend issuance fee.
lastUpdatedDate date The date when the last change was made to this record. For adds/drops this states the last update date of all compositions of an index.
netDividend decimal Net dividend amount, as of the EFFECTIVE DATE (after subtracting taxes and franking). Tax and franking rates used are as of ex-date. Dividend amount will be translated to stock currency if dividend currency differs from stock currency. If the action type is Dividend Adjustment (primarily applicable for Japanese and Korean companies), the net dividend amount will be the after tax amount of the difference between the confirmed dividend and any amount recognized on the original ex-date
newAlternateClassificationCode string(1000) Constituents new alternate classification code as of the EFFECTIVE DATE. This field is reserved for alternate, product-specific classification schemes associated with the constituent.
newAwf decimal The new Additional Weight Factor (AWF) of the stock as required for certain methodologies, as of the EFFECTIVE DATE. For methodologies not using AWF, the value will be 1.
newBloombergTicker string(1000) Constituents new Bloomberg Ticker as of the EFFECTIVE DATE, provided on a best effort basis.
newCapRange string(1000) Indicates constituent stocks new capitalization range as of the EFFECTIVE DATE. Available for index families with breakdown by a market cap bracket. For example, a stock that is classified as having a capitalization of over $25 billion will have the code RO25B.
newCompanyName string(1000) The new name of the constituent as of the EFFECTIVE DATE.
newCountryOfDomicile string(2) ISO country/region code that is associated with the constituents new country/region of domicile as of the EFFECTIVE DATE.
newCountryOfListing string(2) ISO country/region code that is associated with the constituents new country/region of exchange as of the EFFECTIVE DATE.
newCurrencyCode string(3) The new ISO currency code in which the closing price of the stock is stated as of the EFFECTIVE DATE.
newCusip string(1000) Constituents CUSIP identifier as of the EFFECTIVE DATE, provided on a best effort basis.
newDjiIndustryCode string(1000) Constituents new Dow Jones Indexes' proprietary industry classification code, as of the EFFECTIVE DATE.
newGicsCode string(1000) Constituents new Global Industry Classification Standard code, as of the EFFECTIVE DATE.
newGvKey string(1000) Constituents new Compustat permanent company identifier as of the EFFECTIVE DATE, provided on a best effort basis.
newIndexProfile string(1000) The new index name, new index code or new index key.
newIndexShares decimal The constituents new index shares as of the EFFECTIVE DATE. Index shares represents the total number of shares determined and used by the index calculation methodology adjusted for corporate actions (i.e. SHARES OUSTANDING * IWF * AWF).
newIsin string(1000) Constituents new ISIN identifier as of the EFFECTIVE DATE, provided on a best effort basis.
newIwf decimal The new Investible Weight Factor (IWF) of the stock as of the EFFECTIVE DATE. A value of 1 = 100% Free Float.
newMic string(1000) Constituents new Market Identification Code, representing the ISO code of the exchange the constituent is traded on, as of the EFFECTIVE DATE.
newPrice decimal Closing price adjusted for corporate actions as of the EFFECTIVE DATE.
newRegion string(1000) Constituents new region as of the EFFECTIVE DATE. Available for the Global BMI family and indicates if the stock is considered part of a developed or emerging market. Currently not being used in files
newRic string(1000) Constituents new Reuters Instrument Code as of the EFFECTIVE DATE, provided on a best effort basis.
newSedol string(1000) Constituents new SEDOL identifier as of the EFFECTIVE DATE, provided on a best effort basis.
newSharesOutstanding decimal{26,0} The constituents new number of shares outstanding as of the EFFECTIVE DATE.
newShariah string(1000) New status regarding Shariah compliance as of the EFFECTIVE DATE.
newSize string(1000) Constituents new size as of the EFFECTIVE DATE. Indicates if the stock is classified as a large, mid or small cap stock within the methodology of the index. A stock may be classified as large in one index family, and mid in another. Value is left blank for indices not providing size breakdown.
newStockAttributes string(1000) Currently not populated. Will be used for future enhancement to changes in stock attributes.
newTaxRate decimal New tax rate as of the EFFECTIVE DATE.
newTicker string(1000) Constituents new stock ticker, associated with the exchange the constituent is traded on, as of the EFFECTIVE DATE. Provided on a best effort basis.
priceAdjustment decimal Amount of price adjustment.
ratioHeld decimal For stock splits or rights offerings, this represents the ratio of the shares held. For example, in a 3-for-1 stock split, the ratio held would be 1. For a 0.1-for-1 rights offering, the ratio held would be 1.
ratioReceived decimal For stock splits or rights offerings, this represents the ratio of the shares received. For example, in a 3-for-1 stock split, the ratio received would be 3. For a 0.1-for- 1 rights offering, the ratio received would be 0.1.
referenceDate date The date of the next index rebalance or stock replacement. If the action type is Dividend Adjustment (primarily applicable for Japanese and Korean companies), the REFERENCE DATE will show the original ex-date of the dividend.
replacementStockKey long(0,9223372036854775806) When a constituent stock is dropped from an index, it is sometimes replaced by another stock constituent at a predefined weight, depending on the index methodology. In such instances, this field represents the STOCK KEY of the replacement stock constituent which will be added to the index at that predefined weight.
sequenceNo long(0,9223372036854775806) Sequence number for multiple actions on a single stock on the same date.
spinTargetIsIndexCo string(1000) Field used to identify if the M&A target stock is also a current index constituent.
spinTargetMic string(1000) The Market Identification Code representing the ISO Code of the exchange the M&A target company is trading on, as of the EFFECTIVE DATE.
spinTargetName string(1000) Name of the M&A target company, as of the EFFECTIVE DATE. Provided on a best effort basis.
spinTargetStockKey long(0,9223372036854775806) S&P Dow Jones Indices Stock Key of the M&A target company, as of the EFFECTIVE DATE. A stock key is a unique S&P Dow Jones Indices identifier assigned to every stock. This key will be persistent regardless of profile changes to the stock.
spinTargetTicker string(1000) Stock ticker associated with the exchange the M&A target company is traded on, as of the EFFECTIVE DATE. Provided on a best effort basis.
status string(1000) States whether the entry is finalized, estimate, pending or cancelled.
stockKey long(0,9223372036854775806) Unique S&P Dow Jones Indices identifier. This key will be persistent regardless of other identifier changes.
subscriptionPrice decimal Subscription price for rights offerings.
value decimal The value weight factor associated with the stock, as of the EFFECTIVE DATE.
96 rows of 96 total
API Open API Specification