NEW: utility functions to easily calculate multi year growth rates for any fundamental item

Latest Release
1

Dear All,

Rather than creating specific growth rates for many factors we added some easy to use general functions.

First, the most generic one located under MISC->MATH

Gr%( a , b , years )

You can put anything for a & b. It calculates an annualized growth rate : 100 ( ( (a-b)/Abs(b) + 1 )^(1/years ) - 1 )

Example. To calculate annualized 3Y sales growth enter:

Gr%( Sales (0,ANN) , Sales (3,ANN) , 3 )

Next, for growth rates of fundamental items see:

Gr%Q (“fundItem”[,offset])
Gr%PYQ (“fundItem”[,offset])
Gr%TTM (“fundItem”[,offset])
Gr%A (“fundItem”[,offset])
Gr%3Y (“fundItem”)
Gr%5Y (“fundItem”)
Gr%10Y (“fundItem”)

These are utility functions specific for fundamental items. See the documentation for more in FUNDAMENTALS->RATIOS&STATS->GROWTH RATES. The first parameter is the name of the fundamental item. Only items that have a function like fundItem(offset,type[,NAHandling]) can be used inside the quotes.

For example to calculate the annualized 5Y growth rate for Book Value enter:

Gr%5Y(“BookVal”)

Hope this helps.

2

Nice.

3

Great enhancement, Marco. Specifically for Gr%10Y! Bravo!

4

Nice feature, but function composition remains a P123 weakness. Functions like;

FRank(“Gr%5Y(“Sales”)”,#All,#Desc)

still needs the usual workaround.

Is there any plan to improve function composition?

Walter

5

I’m getting errors trying to use these formulas:

Error generating graph: In ‘fcf’-> Error near ‘Gr%Q’: Invalid command ‘Gr%Q’

Gr%Q("FCF")
6

Please use Gr%PQ instead of Gr%Q

Documentation is wrong, sorry. It has been updated.

7

Hi Marco,

I find it very useful when you inlude the actual formula in the explanation, like you did in the first post. Thanks