July 8, 2021

Hello,

I need formula to calculate the maximum percentage of drop , I explained more in the EXCEL file

Thank you in advance for your response

November 8, 2013

The question and topic title clearly says:

I need formula to calculate the maximum percentage of drop

Looks like the question is in half, not the response 🙂

Use this formula in F1:

=MIN(IF(IFERROR(1-$A$2:$A$7/OFFSET($A$2:$A$7,-1,0),0)=MAX(IF($A$2:$A$7<OFFSET($A$2:$A$7,-1,0),IFERROR(1-$A$2:$A$7/OFFSET($A$2:$A$7,-1,0),0),0)),ROW($A$2:$A$7),""))

in G2:

=1-INDEX($A:$A,F1)/INDEX($A:$A,F1-1)

in G3:

=INDEX($A:$A,F1-1)-INDEX($A:$A,F1)

July 8, 2021

Thank you for your time

Qoutation : "In your example, 500 and 25% is based on range A3:A6, considering cells A3=2000 and A6=1500." Its TRUE

Explain for LOGIC : in the stock market we have 2000$ , in the 1st trade we loss 300$=1700$ and in the 2nd trade we earn 100$=1800$, and in the 3rd trade we loss again 300$=1500$ "how much is the maximum loss of main capital : it is 500$ = 2000-1500=500"

your right, the consicutive is not correct word in this situation but it is common in the stock market

keep in mind the help file that I uploaded in this post is just a hint and it is vice versa of the my question

my question is maximum % retrace and the help file is maximum $ retrace "vice versa"

Thank you for your kindness

July 8, 2021

Dear Sir,

In the last file that I uploaded the formula is true but it is for maximum drawdown "900$ - 30%" I use it

but I need another formula to calculate different result which mean is "relative drawdown"

in the last file :

maximum drawdown is : 900$ and 30% "percentage of maximum value"

**relative drawdown is : 40% and 800$ "I need formula to calculate this one" "value of maximum percent"**

I uploaded agin with a little changes

**Please look this file and how can I get to 40%**

I'm so sorry for the complexity

Thank you very much

1 Guest(s)