Help calculating bb/100

C

custo80

Visionary
Silver Level
Joined
Dec 17, 2007
Total posts
884
Chips
0
I'm trying to start measuring how many big blinds I make/lose per 100 hands I play. As I'm not the best at excel I need your help. Below is a scenario if you could answer but also show workings this will be really appreciated so I'll thank you in advance :)

I played 417 hands
Limit was .01 .02
I profited $1.09

How many big blinds have I won per 100 hands and how do you calculate it?

Better yet, how would I write this as a formula in excel, if anyone knows?

Thanks again
Custo
 
C

chispa73

Rock Star
Silver Level
Joined
Jan 8, 2008
Total posts
162
Chips
0
If I only Knew

If I knew the formula I could write it in excel. Let me look in the strategy articles and I'll get back to you.
 
Jagsti

Jagsti

I'm sweet enough!
Silver Level
Joined
Feb 18, 2007
Total posts
5,478
Chips
0
I'm trying to start measuring how many big blinds I make/lose per 100 hands I play. As I'm not the best at excel I need your help. Below is a scenario if you could answer but also show workings this will be really appreciated so I'll thank you in advance :)

I played 417 hands
Limit was .01 .02
I profited $1.09

How many big blinds have I won per 100 hands and how do you calculate it?

Better yet, how would I write this as a formula in excel, if anyone knows?

Thanks again
Custo

So you have won $1.09 and your bb is 0.02 (2c), so total bb's won = 1.09/0.02 = 54.5bb's

So total bb/100 =

54.5/(417/100) = 54.5/4.17

= 13.069

=13.07bb/100

Spreadsheet may be something like this (winnings/bb)/(no of hands/100)

(1.09/0.02)/(417/100) I think
 
C

custo80

Visionary
Silver Level
Joined
Dec 17, 2007
Total posts
884
Chips
0
Jagsti, you are an absolute legend, =(1.09/0.02)/(417/100) was the exact formula. Thank you very much
 
C

chispa73

Rock Star
Silver Level
Joined
Jan 8, 2008
Total posts
162
Chips
0
If I only Knew

If I knew the formula I could write it in excel. Let me look in the strategy articles and I'll get back to you.
 
Jagsti

Jagsti

I'm sweet enough!
Silver Level
Joined
Feb 18, 2007
Total posts
5,478
Chips
0
Custo just realised this is limit so it's slightly different as the formula above is for BB/100 (big bet)

To get bb/100 you have to change the 0.02BB to 0.01bb, as the blinds are 0.05 and 0.1 I think.
 
C

chispa73

Rock Star
Silver Level
Joined
Jan 8, 2008
Total posts
162
Chips
0
Ok found it. The formula is (Total Amount Won)/(Total Hands Played/100).

In excel say a1 would be Total Amount Won and a2 would be total hands played, you would write the following formula in a3.... "=A1/(A2/100)" without the quotation marks.
 
C

chispa73

Rock Star
Silver Level
Joined
Jan 8, 2008
Total posts
162
Chips
0
Jaqsti was right it would be =(a1/.01)/(a2/100)
 
Jagsti

Jagsti

I'm sweet enough!
Silver Level
Joined
Feb 18, 2007
Total posts
5,478
Chips
0
Custo ignore my last post if the blinds are 0.01/0.02, Im rambling :)
 
BelgoSuisse

BelgoSuisse

Legend
Silver Level
Joined
Nov 26, 2007
Total posts
9,218
Chips
0
At 0.01/0.02 would that not be a large investment for little return?

if you plan on staying at 0.01/0.02, yes.

But for the amount of hands OP was considering, the trial versions work. And PT still has a beta version that you can download and i guess that that beta requires no license.

Furthermore, if you ever plan to move up, then it's a great investment because it will improve your game much faster.
 
ajrobin

ajrobin

Visionary
Silver Level
Joined
Jan 29, 2008
Total posts
653
Chips
0
Get PT3 over HEM if you dont want to pay anything as with PT3 you get a 60 day trial period where you can import as many hands as your heart desires, whereas HEM restricts you to 5k hands trial.
 
BelgoSuisse

BelgoSuisse

Legend
Silver Level
Joined
Nov 26, 2007
Total posts
9,218
Chips
0
Get PT3 over HEM if you dont want to pay anything as with PT3 you get a 60 day trial period where you can import as many hands as your heart desires, whereas HEM restricts you to 5k hands trial.

but if you ever want to buy one, HEM is way better at the moment.
 
C

custo80

Visionary
Silver Level
Joined
Dec 17, 2007
Total posts
884
Chips
0
Custo just realised this is limit so it's slightly different as the formula above is for BB/100 (big bet)

To get bb/100 you have to change the 0.02BB to 0.01bb, as the blinds are 0.05 and 0.1 I think.

Don't worry Jagsti I did ignore the rambling :) It has bought up a new question for me though.

I understand that bb/100 measure big blinds won per hundred hands.
You've said, and I've heard it before about BB/100 which measures big bets per hundred hands. If this is the most obv. question then I apologize in advance but what is a big bet? Bearing in mind I'm on .01/.02.

Thanks again
 
zachvac

zachvac

Legend
Silver Level
Joined
Sep 14, 2007
Total posts
7,832
Chips
0
Don't worry Jagsti I did ignore the rambling :) It has bought up a new question for me though.

I understand that bb/100 measure big blinds won per hundred hands.
You've said, and I've heard it before about BB/100 which measures big bets per hundred hands. If this is the most obv. question then I apologize in advance but what is a big bet? Bearing in mind I'm on .01/.02.

Thanks again

Basically it's from limit, but some people use it for NL too, basically a big bet is double the big blind. So if you find out big blinds won/lost per 100 hands, just divide it by 2 to get your big bets won/lost per 100.
 
P

ph_il

...
Silver Level
Joined
Feb 5, 2005
Total posts
10,128
Awards
1
Chips
25
When figuring out bb/100 would the number of tables you play (if you MT) be a factor?
Or does it not matter if you MT because we are figuring out BB/100 for the (total profits/BB)/(hands/100)?
 
zachvac

zachvac

Legend
Silver Level
Joined
Sep 14, 2007
Total posts
7,832
Chips
0
When figuring out bb/100 would the number of tables you play (if you MT) be a factor?
No
Or does it not matter if you MT because we are figuring out BB/100 for the (total profits/BB)/(hands/100)?

This. $/hour (and thus BB/hour, or whatever other unit per time) is impacted, but winrate per number of hands is static whether you play a million hands a second or if it takes you an hour to play one hand.
 
P

ph_il

...
Silver Level
Joined
Feb 5, 2005
Total posts
10,128
Awards
1
Chips
25
Geez, you're fast. And thanks for clearing that up.
 
JimmyBrizzy

JimmyBrizzy

Visionary
Silver Level
Joined
Nov 14, 2007
Total posts
916
Awards
1
Chips
1
PT shows big bet/100, not big blind/100, correct?
 
Top