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). 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(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.