ODCS v3.2.0Draft · 0.1.0licensed-dataoptionsreferenceusevent

OCC Information Memos

Normalised feed extracted from OCC Information Memos: option symbol changes, strike adjustments, multiplier and deliverable changes from corporate events (special dividends, reverse splits, demergers, FLEX consolidations). One row per memo that contains such information.

14 columns in delivery order · file or table name occ_info_memos. Types are ODCS logical types; the format line shows how values are written.

Schema columns with type, key role and description
ColumnTypeKeyDescription
MemoIdstringnumeric id, e.g. 58470Key 1 · RequiredUnique memo identifier assigned by OCC

Missing values: Never · Source: vendor guide and sample

PublishDatedateyyyymmddDate the memo was published; also the date the daily file is aggregated by

Missing values: Blank · Source: vendor guide and sample

EffectiveDatedateyyyymmddDate the memo's subject is expected to become effective; blank for anticipated adjustments

Missing values: Blank · Source: vendor guide and sample

SymbolChangeDatestring';'-separated yyyymmdd listDates on which each listed symbol change takes effect

Missing values: Blank · Source: vendor guide and sample

OldSymbolstring';'-separated listSymbols before the event takes effect

Missing values: Blank · Source: vendor guide and sample

NewSymbolstring';'-separated listSymbols after the event takes effect; equals OldSymbol when the symbol is unchanged

Missing values: Blank · Source: vendor guide and sample

SymbolAssetTypestring · enum (2)';'-separated listAsset type of each changing symbol

Missing values: Blank · Source: vendor guide and sample

2 allowed values
O
Equity options
F
Futures
SymbolChangeDetailstringfree text, may contain commasParsed description of affected symbols; 'Symbol XYZ remains unchanged' pattern when no change is described

Missing values: Blank · Source: vendor guide and sample

StrikeDivisorintegeri64Factor used to rescale option strikes in corporate events such as splits

Missing values: Blank · Source: vendor guide and sample

StrikeAdjustmentnumberUSD amount to subtract from the previous strike (e.g. special dividend)

Unit: USD · Missing values: Blank · Source: vendor guide and sample

MultiplierDetailstringfree text, may contain commasShares per contract with extra wording parsed from the memo

Missing values: Blank · Source: vendor guide and sample

Multiplierintegeri64Number of shares the contract represents per the memo (100 typical)

Unit: shares · Missing values: Blank · Source: vendor guide and sample

Deliverablesstring';'-separated SYMBOL:amount pairsAssets delivered per contract: symbol or ISO currency with share count or cash amount

Missing values: Blank · Source: vendor guide and sample

UnderSymbolCUSIPstring';'-separated SYMBOL:CUSIP pairsUnderlying symbols with CUSIPs for the new deliverables

Missing values: Blank · Source: vendor guide and sample

Contracts follow the Open Data Contract Standard (Bitol, LF AI & Data).

Vendor names are trademarks of their owners.