Using Overrides Within Excel

Click to Download Workbook: Overrides

Many fields within Bloomberg can be modified. You can think of an override as a manipulation to a standard calculation. For instance, beta can be calculated in different ways. In most contexts, an OLS (Ordinary Least Squares) regression method is used to calculate a firms beta. Within this regression, the relative index used and length of time series data are two independent variables within the beta calculation.  Think of being able to change these variables within a Bloomberg function for a specific metric. This is exactly what we will do with beta.

The Field: 

BETA_RAW_OVERRIDABLE

The Overrides to the Calculation: 

BETA_OVERRIDE_START_DT
BETA_OVERRIDE_END_DT
BETA_OVERRIDE_REL_INDEX
BETA_OVERRIDE_PERIOD

We can check the overridable fields for a particular field by using the FLDS function within the Bloomberg terminal window.

Within the workbook, you will find a template for manipulating a beta calculation for a company. I did one for Apple Inc.  and compared it to a standard regression output within Excel. I also included a worksheet tab to do this for many companies within an index also. Enjoy and share!

About the author

programmingforfinance

Hi, I'm Frank. I have a passion for coding and extend it primarily within the realm of Finance.

View all posts

Leave a Reply

Your email address will not be published. Required fields are marked *