Use the following expression:

pow((1+(series/100)), YearLength())-1

The expression “1+ (series / 100)” will be raised to the power of “yearlength()”. After which 1 will be subtracted from the result.

Skip to content
# How do I annualize a monthly P/P series with a formula?

### Contents

### Related material

Use the following expression:

pow((1+(series/100)), YearLength())-1

The expression “1+ (series / 100)” will be raised to the power of “yearlength()”. After which 1 will be subtracted from the result.

Tags: formula

- Data
- Analysis
- Calculations
- How do I calculate a Z-Score / How do I standardize a series?
- How do I annualize a monthly P/P series with a formula?
- How do I rebase a series?
- How do I aggregate a series?
- How do I calculate the median value for a series?
- How do I splice two series together?
- How do I calculate a spread, or subtract one series from another?
- How do I calculate a moving average / rolling mean?
- How do I calculate percentage change over period (Y/Y, Q/Q, P/P, M/M)?
- How do I “disaggregate” a series?
- How do I calculate a rolling sum?
- How do I lag or lead a series?
- How do I calculate / draw Bollinger lines?
- How do I replace all missing values in a time series with a 0?
- How do I retrieve as output the coefficients / beta from a Regression model?
- How do I calculate the percentile value of an observation in a series?
- How do I change a series from a ratio to a percentage?
- How do I calculate R2 coefficient using a formula?
- How do I calculate the parameters for a linear regression?
- How do I add a trend line?
- How do I add a trend channel / trend band?
- How do I determine the percentile value of a series using formula language?
- How do I define custom functions formula?
- How do I reverse or invert a series?
- How do I calculate the sum several series?
- How do I calculate the rolling correlation between two series?

- Chart elements
- Chart style
- Frequency & currency conversion
- Axis format
- Formula language
- Logical conditions
- Extending series
- Fill range
- Graph layout
- Text elements
- Annotations
- Bloomberg Connector
- General topics
- MS Office
- Excel
- Application