You can calculate Drawdown with the Drawdown formula. There are ways of constructing it differently to fit your desired output – please see examples below.


Drawdown - as a number or percentage

Our formula Drawdown() the outcome is in percentage. Here we change it into a number.

Drawdown - count Drawdown's length

See how to calculate length of a simple drawdown and length of drawdown from certain value to local peak.

Drawdown - maximum drawdown each year

Calculate maximum value for each year including current one.

Drawdown - show values only when recession

See drawdowns, but only when there is a recession.