General Betting
There is currently 1 person viewing this thread.
08 Jan 10
03:24
Joined:
Date Joined:
27 May 06
With a calculator if your first bet is a win bet
Win price / lay price * original stake = green up stake
With a calculator if your first bet is a lay bet
Lay price / Win price * original stake = green up stake
In excel
For your first bet or lay
Enter your lay or win price In cell A1
Enter your stake in B1
Enter this formula into cell B2
=IF(A2="","",B1*(A1/A2))
To get the stake needed to green up
Enter the price you can get in cell A2
Cell B2 shows the stake needed to green up
In cell C2 enter this formula
=IF(A2="","",ABS(B1-B2))
That cell C2 tells you how much you will win whether it wins or loses.
Win price / lay price * original stake = green up stake
With a calculator if your first bet is a lay bet
Lay price / Win price * original stake = green up stake
In excel
For your first bet or lay
Enter your lay or win price In cell A1
Enter your stake in B1
Enter this formula into cell B2
=IF(A2="","",B1*(A1/A2))
To get the stake needed to green up
Enter the price you can get in cell A2
Cell B2 shows the stake needed to green up
In cell C2 enter this formula
=IF(A2="","",ABS(B1-B2))
That cell C2 tells you how much you will win whether it wins or loses.
sort by:
Show
per page
Replies: 14
|
By:
Nice one compound ;)
|
|
By:
Where is the commission?
|
|
By:
..and the same formula for 'redding up' ?
|
|
By:
kenilworth
Redding up is not in my vocabulary. I don't like the idea of a guaranteed loss. |
|
By:
If you have Excel, there is a simple example here which shows you greening / hedging / level profit.
http://www.geekstoy.com/Download/Hedge.xls |
|
By:
Thanks for this.
I take it that to give an accurate return/loss reflection there still needs to be a 1 deduction in excel. e.g. price in betfair is 3.5 but reflected in excel as 2.5? cheers |
|
By:
Compound Magic 08 Jan 09:57
kenilworth Redding up is not in my vocabulary. I don't like the idea of a guaranteed loss. Compound Magic, If the market is going against you and you red out, you simply re-enter the market a better position. Look at it as starting a trade with a handicap. If your knowledge and ability to trade is decent, you will make back the difference quickly or atleast reduce it. |
|
By:
don't forget (if laying 2nd) the good old add green and reds together and type in payout radio box
|
|
By:
betfair and any decent API does all of this ??
|
|
By:
SHAPESHIFTER
I don't normally trade at all, but occasionally a horse I have laid at say 5.00 and I think the right price should be 7.00 and it has drifted to 8.00 then it is worth greening up on for a risk free profit. If it shortens I still think the right price is 7.00, so I would more than likely lay it for more. I have been asked many times how to green up equally, hence my post. Cheers |
|
By:
ok
|
|
By:
How would I calculate this in a different way?
|
|
By:
Say for example, I had a back stake of $500 placed, and wanted to know what price I would need to get out at to get exactly $50 green both sides?
|
|
By:
where is compound magic these days.....................rusty go to arbcruncher.com....then into betting calculator....then into back/lay
|