• All Files

 

Securities File Layout

Header Record

Column	Type	Version	Comments
Line Discriminator	Character	Any (If header is enabled)	Value will be "H"
File Type	Alphanumeric		Transactions
File Type Abbreviation	Alphanumeric		SEC
Run Date	Alphanumeric		Date format is configurable
Run Time	Alphanumeric		HH:MM:DD in 24 hour format System Clock Time
As of Date	Alphanumeric		Data On Record As-Of Date (date format is configurable)
Version	Numeric		Version of the file layout used.

 

Security Record

Column	Type	Version	Column Header	Comments
Line Discriminator	Character	Any (If header is enabled)	C	Value will be "D" for data
Internal Asset ID	Alphanumeric	1.0	InternalAssetID	Internal unique identifier for all asset types
Asset Type	Alphanumeric	1.0	AssetType	For more information, see Asset Types
Security ID	Alphanumeric	1.0	SecurityID	US Security - CUSIP Foreign security - ISIN Only for applicable securities
Symbol	Alphanumeric	1.0	Symbol	The ticker symbol of the security
BBG Ticker	Alphanumeric	1.2	BBGTicker	Bloomberg ticker
BBG Ticker and Exchange Code	Alphanumeric	1.2	BBGTickerAnd ExchangeCode	Bloomberg ticker + exchange code
Bloomberg Global ID	Alphanumeric	1.4	BloombergGlobalID	Bloomberg Global ID
Description	Alphanumeric	1.0	SecurityDescription	Description of the security
Underlying Symbol	Alphanumeric	1.2	UnderlyingSymbol
Multiplier	Alphanumeric	1.0	Multiplier
Expiration Date	Alphanumeric	1.0	ExpirationDate
Option Type	Alphanumeric	1.0	OptionType
Option Strike	Alphanumeric	1.0	OptionStrike
Maturity Date	Alphanumeric	1.0	MaturityDate
Issue Date	Alphanumeric	1.0	IssueDate