I am making a spreadsheet for my MMA bets. What formula can I use to plug in what I would make if I were to win?
For example, Say I bet $100 on a -220 favorite. What formula should I use?
Thanks!
=x220/100
lol
On the right side of Excel there should be like a help thingy you can ask and should get the fomula from that. You can also find a pre-made one Im sure from microsoft.com thats free to download.
I see your cry for help and I raise you one intervention
100/2.2
not exactly what i was lookng for lol
Pi.
A1 B1 C1 D1
|???|???|=if(B1<0,100/-B1,B1/100)|=A1*C1|
A1=bet amount
B1=betting odds
D1=win amount
I track all of mine in a spreadsheet, so here is a screenshot of how mine is set up:
So here are the formulas:
A3: favored fighter
B3: closing line
C3: =SUM((-B3/(100+-B3))) - the line translated to a win %
D3: =SUM(100/-B3) - the payout per dollar
E3: my line
F3: =SUM((-E3/(100+-E3))) - that line translated to a win %
G3: =SUM(100/-E3) - the payout per dollar
H3: my wager
I3: =SUM(G3*H3) - the amount won if successful
J3: underdog fighter
K3: closing line
L3: =SUM(100/(100+K3) - the line translated to a win %
M3: =SUM(K3/100)
N3: my line
O3: =SUM(100/(100+N3)) - that line translated to a win %
P3: =SUM(N3/100) - the payout per dollar
Q3: my wager
R3: = SUM(P3*Q3) - the amount won if successful
S3: total amount won or lost entered manually; this would've been wagering $50 for a profit of $39.55.
A few notes - some people might joke about the amount wagered. This was before I started actually gambling and was based on wagering no more than 10% of my starting bankroll of $500 on any event. I'm a conservative guy. Most people that brag about wagering $100 on a fight are probably one of a few things: 1. lying; 2. not serious about gambling; 3. lying.
Also, I did learn a lot just placing fake bets and tracking how they did. I would recommend it strongly.
Just let me know if you have any questions on setting it up or any other questions.
aarondramp - I track all of mine in a spreadsheet, so here is a screenshot of how mine is set up:
<img alt="" width="640" height="117" src="http://a.yfrog.com/img339/6030/ufc110o.jpg" />
So here are the formulas:
A3: favored fighter
B3: closing line
C3: =SUM((-B3/(100+-B3))) - the line translated to a win %
D3: =SUM(100/-B3) - the payout per dollar
E3: my line
F3: =SUM((-E3/(100+-E3))) - that line translated to a win %
G3: =SUM(100/-E3) - the payout per dollar
H3: my wager
I3: =SUM(G3*H3) - the amount won if successful
J3: underdog fighter
K3: closing line
L3: =SUM(100/(100+K3) - the line translated to a win %
M3: =SUM(K3/100)
N3: my line
O3: =SUM(100/(100+N3)) - that line translated to a win %
P3: =SUM(N3/100) - the payout per dollar
Q3: my wager
R3: = SUM(P3*Q3) - the amount won if successful
S3: total amount won or lost entered manually; this would've been wagering $50 for a profit of $39.55.
A few notes - some people might joke about the amount wagered. This was before I started actually gambling and was based on wagering no more than 10% of my starting bankroll of $500 on any event. I'm a conservative guy. Most people that brag about wagering $100 on a fight are probably one of a few things: 1. lying; 2. not serious about gambling; 3. lying.
Also, I did learn a lot just placing fake bets and tracking how they did. I would recommend it strongly.
Just let me know if you have any questions on setting it up or any other questions.
Interesting. I just finished mine and t has a different format with some different information (such as an area for pecentage gain/loss) but yours is easier to read
aarondramp - I track all of mine in a spreadsheet, so here is a screenshot of how mine is set up:That's awesome Aaron.. thanks for the info
So here are the formulas:
A3: favored fighter
B3: closing line
C3: =SUM((-B3/(100+-B3))) - the line translated to a win %
D3: =SUM(100/-B3) - the payout per dollar
E3: my line
F3: =SUM((-E3/(100+-E3))) - that line translated to a win %
G3: =SUM(100/-E3) - the payout per dollar
H3: my wager
I3: =SUM(G3*H3) - the amount won if successful
J3: underdog fighter
K3: closing line
L3: =SUM(100/(100+K3) - the line translated to a win %
M3: =SUM(K3/100)
N3: my line
O3: =SUM(100/(100+N3)) - that line translated to a win %
P3: =SUM(N3/100) - the payout per dollar
Q3: my wager
R3: = SUM(P3*Q3) - the amount won if successful
S3: total amount won or lost entered manually; this would've been wagering $50 for a profit of $39.55.
A few notes - some people might joke about the amount wagered. This was before I started actually gambling and was based on wagering no more than 10% of my starting bankroll of $500 on any event. I'm a conservative guy. Most people that brag about wagering $100 on a fight are probably one of a few things: 1. lying; 2. not serious about gambling; 3. lying.
Also, I did learn a lot just placing fake bets and tracking how they did. I would recommend it strongly.
Just let me know if you have any questions on setting it up or any other questions.
aarondramp - I track all of mine in a spreadsheet, so here is a screenshot of how mine is set up:Thanks for posting this dude, I have been doing the fake bet thing the last few months and my spreadsheet will definteley benefit from adding some of those formulas to it. Thanks again.
So here are the formulas:
A3: favored fighter
B3: closing line
C3: =SUM((-B3/(100+-B3))) - the line translated to a win %
D3: =SUM(100/-B3) - the payout per dollar
E3: my line
F3: =SUM((-E3/(100+-E3))) - that line translated to a win %
G3: =SUM(100/-E3) - the payout per dollar
H3: my wager
I3: =SUM(G3*H3) - the amount won if successful
J3: underdog fighter
K3: closing line
L3: =SUM(100/(100+K3) - the line translated to a win %
M3: =SUM(K3/100)
N3: my line
O3: =SUM(100/(100+N3)) - that line translated to a win %
P3: =SUM(N3/100) - the payout per dollar
Q3: my wager
R3: = SUM(P3*Q3) - the amount won if successful
S3: total amount won or lost entered manually; this would've been wagering $50 for a profit of $39.55.
A few notes - some people might joke about the amount wagered. This was before I started actually gambling and was based on wagering no more than 10% of my starting bankroll of $500 on any event. I'm a conservative guy. Most people that brag about wagering $100 on a fight are probably one of a few things: 1. lying; 2. not serious about gambling; 3. lying.
Also, I did learn a lot just placing fake bets and tracking how they did. I would recommend it strongly.
Just let me know if you have any questions on setting it up or any other questions.
ttt