I would be interested in a formula that calculates the biggest downswing in excel, similar to sharkescopes "Required Bankroll".

Since I cant track the mtts I play on this site with a software, I track every buyin and cash in excel, where:

Col A = Count
Col B = Buy in
Col C = Cash
Col D= Bounties

and Col E = profit, where for example E7=E6-B7+C7+D7, and this column is used to print the profit graph.

This lets me easily calculate things such as count, profit, av stake, av profit, itm%, roi, etc.

If anyone knows how I would calculate the MAX downswing in Col E, would be highly appreciated! Also, since I am a winning player on this specific site the solution isn't just FirstRow-LastRow

Try this? https://tradingtuitions.com/how-to-c...n-excel-sheet/

Thank you Sir! Exactly what I was looking for