Home / Community / Forum / Support Area / Poker News /

How to figure out ROI%

Old
Default
How to figure out ROI% - Tue Mar 01, 2011, 09:05 PM
(#1)
Drew300's Avatar
Since: Nov 2010
Posts: 199
BronzeStar
Hey all I started to keep track of my results on a xcel spreadsheet.. Was wondering if anyone has a basic spreadsheet they would like to share? Or what is the easiest way to figure out ROI% over a course of many games?

Thanks Drew 300..


Just an example.. does something like this look right??

Date Pokerstars Game Game # Entry Fee Place Total win Win/Loss Total Invested Total Profit ROI$
February-28-11 $10.48 50/50 1 $10.48 1 $36.45 $25.97 $10.48 $25.97 247.81%
February-28-11 $10.48 50/50 2 $10.48 3 $19.35 $8.87 $20.96 $34.84 166.22%
February-28-11 $10.48 50/50 3 $10.48 4 $16.58 $6.10 $31.44 $40.94 130.22%
February-28-11 $10.48 50/50 4 $10.48 9 $0.00 -$10.48 $41.92 $30.46 72.66%
March-01-11 $10.48 50/50 5 $10.48 8 $0.00 -$10.48 $52.40 $19.98 38.13%
March-01-11 $10.48 50/50 6 $10.48 3 $21.72 $11.24 $62.88 $31.22 49.65%
March-01-11 $10.48 50/50 7 $10.48 2 $22.03 $11.55 $73.36 $42.77 58.30%
March-01-11 $10.48 50/50 8 $10.48 1 $32.27 $21.79 $83.84 $64.56 77.00%
 
Old
Default
Tue Mar 01, 2011, 10:50 PM
(#2)
Moxie Pip's Avatar
Since: Aug 2010
Posts: 3,853
I know I should'nt................

http://www.feltpoker.com/poker-strat...oi-calculation


Tic,tic,tic,tic................
 
Old
Default
Tue Mar 01, 2011, 11:17 PM
(#3)
Mmmm Fish's Avatar
Since: Oct 2010
Posts: 705
BronzeStar
One column for entry fee. (A)
One cell for total fees (AA) - Formula is sum of A
One column for payout. (B)
One cell for total payouts (BB) - Formula is sum of B
One column for profit (C) - Forumla is B-A
One cell for total profit (CC) - Formula is sum of C
One column for ROI - Formula is C/A
One cell for total ROI - Do not sum column - Formula is CC/AA
 

Getting PokerStars is easy: download and install the PokerStars game software, create your free player account, and validate your email address. Clicking on the download poker button will lead to the installation of compatible poker software on your PC of 51.7 MB, which will enable you to register and play poker on the PokerStars platform. To uninstall PokerStars use the Windows uninstaller: click Start > Control Panel and then select Add or Remove programs > Select PokerStars and click Uninstall or Remove.

Copyright (c) PokerSchoolOnline.com. All rights reserved, Rational Group, Douglas Bay Complex, King Edward Road, Onchan, Isle of Man, IM3 1DZ. You can email us on support@pokerschoolonline.com