Equity bucket descriptions

Download sample file: Equity_Bucket_Description.csv This file provides a description of Equity buckets, including canonical values for Sector. It is used to populate the market cap, economy, and sector fields of the equity(underlying) description during the ETL. When the SBM sensitivity files (Curvature, Delta, or Vega) omit the market cap, economy, and/or sector fields, they can be filled from this Equity Bucket Descriptions file. To take advantage of this, the bucket description file must be loaded before (or at the same time as) the Curvature, Delta, or Vega file. This Equity Bucket Descriptions file type is identified using the pattern: **/Equity_Bucket_Description*.csv (as specified by equity.bucket-description.file-pattern). A sample file is Equity_Bucket_Description. This file is loaded using the EQUITY_BUCKET_DESCRIPTION topic. See the Topic Aliases table for an understanding of the topic aliases associated with each topic.


Field	Key	Null	FieldType	Description	Example
Bucket	Y	N	String	Bucket number (e.g. 1 - 13)
Market Cap Category	N	N	String	Market Cap for the bucket	Large, Small, Other
Economy Category	N	N	String	Economy for the Bucket	Advanced, Emerging, Other
Sector Category	N	N	String	Sector for the Bucket
AsOfDate	Y	N	Date ‘YYYY-MM-DD’	Timestamp (at close of business) for the data.