Two Plus Two Poker Forums Any excel wizards here?
 Register FAQ Search Today's Posts Mark Forums Read TwoPlusTwo.com

 02-01-2021, 05:12 PM #1 deegen stranger   Join Date: Jan 2015 Posts: 10 Any excel wizards here? 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
 02-06-2021, 01:26 PM #2 muttiah Carpal \'Tunnel     Join Date: Aug 2004 Posts: 24,312 Re: Any excel wizards here?
02-08-2021, 11:47 AM   #3
deegen
stranger

Join Date: Jan 2015
Posts: 10
Re: Any excel wizards here?

Quote:
 Originally Posted by muttiah
Thank you Sir! Exactly what I was looking for

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Links to Popular Forums     News, Views, Gossip and Books     Beginners Questions     Staking     Casino & Cardroom Poker     Poker Rooms     NL Strategy Forums     Poker Goals & Challenges     Las Vegas Lifestyle     Sporting Events     Other Other Topics Two Plus Two     About the Forums     Two Plus Two Magazine Forum Poker News & Discussion     News, Views, Gossip and Books     Poker Goals & Challenges     Poker Beats, Brags, and Variance     That's What She Said!     Legislation for Poker & Income Taxes for Poker Players     Twitch - Watch and Discuss Live Online Poker     Televised Poker Online Poker Rooms & Marketplaces     Online Poker Rooms         General Rooms Discussion         Global Poker         BetOnline.ag     Coaches & Schools         Seeking Coaching         General Coaching Discussion     Staking         Offering Stakes         Seeking Stakes         Selling Shares - Live         Selling Shares - Online         Staking Rails     Poker Software         General Software Discussion     General Marketplace     Transaction Feedback & Disputes General Poker Strategy     Beginners Questions     Books and Publications     Poker Tells/Behavior, hosted by: Zachary Elwood     Poker Theory     Psychology No Limit Hold'em Strategy     Medium-High Stakes PL/NL     Micro-Small Stakes PL/NL     Medium-High Stakes Full Ring     Micro-Small Stakes Full Ring     Heads Up NL     Live Low-stakes NL Limit Texas Hold'em Strategy     Mid-High Stakes Limit     Micro-Small Stakes Limit Tournament Poker Strategy     STT Strategy     Heads Up SNG and Spin and Gos     Mid-High Stakes MTT     Small Stakes MTT     MTT Community     Tournament Events Other Poker Strategy     High Stakes PL Omaha     Small Stakes PL Omaha     Omaha/8     Stud     Draw and Other Poker Live Poker     Casino & Cardroom Poker         Venues & Communities         Regional Communities     Venues & Communities     Tournament Events         WPT.com     Home Poker     Cash Strategy     Tournament Strategy General Gambling     Backgammon Forum hosted by Bill Robertie.     Probability     Sports Betting     Other Gambling Games 2+2 Communities     Other Other Topics         OOTV         Game of Thrones     The Lounge: Discussion+Review     Las Vegas Lifestyle     BBV4Life         omg omg omg     House of Blogs Sports and Games     Sporting Events         Single-Team Season Threads         Fantasy Sports     Fantasy Sports         Sporting Events     Wrestling     Golf     Chess and Other Board Games     Video Games         League of Legends         Hearthstone     Puzzles and Other Games Other Topics     Politics and Society     History     Business, Finance, and Investing     Science, Math, and Philosophy     Religion, God, and Theology     Travel     Health and Fitness     Laughs or Links!     Computer Technical Help     Programming

All times are GMT -4. The time now is 04:43 PM.

 Contact Us - Two Plus Two Publishing LLC - Privacy Statement - Top