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