Hi,
I couldn't figure out how to upload or attach the spreadsheet file.
However, just copy & paste what I have pasted below into excel and it
will work and will properly format properly (I tried it - no issues).
Take note that there are no formulas. I essentially transcribed the
results using another program that I know is correct. I hope this
helps. I have included two examples below.
Thanks.
Example 1A
Odds Wager Return If Win Profit Pct Profit
Side 1 110 $543.48 $1,141.31 $141.31 14.13%
Side 2 150 $456.52 $1,141.30 $141.30 14.13%
Total $1,000.00
Example 1B
Odds Wager Return If Win Profit Pct Profit
Side 1 -120 $576.93 $1,057.69 $57.69 5.77%
Side 2 150 $423.07 $1,057.67 $67.67 5.77%
Total $1,000.00
Example 2A
Odds Wager Return If Win Profit Pct Profit
Side 1 110 $684.00 $1,436.40 $296.40 26.00%
Side 2 150 $456.00 $1,140.00 $0.00 0.00% BREAKEVEN
Total $1,140.00
Example 2B
Odds Wager Return If Win Profit Pct Profit
Side 1 -120 $636.00 $1,165.98 $105.98 10.00%
Side 2 150 $424.00 $1,060.00 $0.00 0.00% BREAKEVEN
Total $1,060.00
On May 17, 9:03 am, DILIPandey <dilipan...@gmail.com> wrote:
> Hi Qcan,
>
> For the better understanding of the group, can you transfer the
> details in an excel spreadsheet and send the same as an attachment.
>
> Thanks,
> DILIPandey
>
> On May 15, 10:45 pm, qcan <comeonove...@gmail.com> wrote:
>
>
>
> > Hi,
>
> > I am looking for a couple of formulas that can be used to calculate an
> > arbitrage in sports wagering.
>
> > Example 1.
>
> > An even split based on a 1000 dollar total wager divded between both
> > sides.
>
> > - Side 1 odds = +110
> > - Side 2 odds = +150
>
> > I know that one would have to wager $ 543.48 on side 1, in order to
> > get a return $ 1141.31
> > I also know that a wager of $ 456.52 on side two in order to get a
> > retrun of $ 1141.30
>
> > In other words a 14.13 % profit would be generated evenly no matter
> > which side won.
>
> > Example 2.
>
> > The same as example 1 except I want to maximize side 1 while breaking
> > even on side 2. To clarify - this would mean that all the profit would
> > go to side 1 should side 1 win. If side 2 wins - I would break even.
>
> > Using 1000 dollars again (actually 1140 dollars so that it's even),
> > with the same odds as the first exmaple - I know that
>
> > - $ 684.00 would have to be wagered on side 1 and $ 456.00 would have
> > to be wagered on side 2.
>
> > If side 1 wins - I would get back a total of $1436.40 (meaning a $
> > 296.40 profit)
> > If side 2 wins - I would get back exactly the total money wagered on
> > both sides (1140 dollars) and break even.
>
> > I have no idea how to express these two examples into a formula.
> > Further, the formula(s) might be different when the favorite is
> > actually below -100.
>
> > I hope I made some sense. I will try and clarify should there be any
> > questions.
>
> > Anyone ?
>
> > Thanks !!- Hide quoted text -
>
> - Show quoted text -
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
