Forums

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Compound Magic
08 Jan 10 03:24
Joined:
Date Joined: 27 May 06
| Topic/replies: 760 | Blogger: Compound Magic's blog
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.
Pause Switch to Standard View Single selection green up formula
Show More
Loading...
Report nightshift man January 8, 2010 5:21 AM GMT
Nice one compound ;)
Report Optimizer January 8, 2010 7:26 AM GMT
Where is the commission?
Report kenilworth January 8, 2010 8:20 AM GMT
..and the same formula for 'redding up' ?
Report Compound Magic January 8, 2010 8:58 AM GMT
kenilworth
Redding up is not in my vocabulary. I don't like the idea of a guaranteed loss.
Report The Geeks Toy January 13, 2010 10:37 AM GMT
If you have Excel, there is a simple example here which shows you greening / hedging / level profit.

http://www.geekstoy.com/Download/Hedge.xls
Report Bet of the Decade January 13, 2010 10:48 AM GMT
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
Report SHAPESHIFTER January 13, 2010 11:14 AM GMT
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.
Report Reyes January 13, 2010 11:30 AM GMT
don't forget (if laying 2nd) the good old add green and reds together and type in payout radio box
Report page-413 January 13, 2010 11:59 AM GMT
betfair and any decent API does all of this ??
Report Compound Magic January 13, 2010 12:29 PM GMT
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
Report page-413 January 13, 2010 12:59 PM GMT
ok
Report Rusty23 June 5, 2016 12:27 PM BST
How would I calculate this in a different way?
Report Rusty23 June 5, 2016 12:28 PM BST
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?
Report freddiewilliams June 5, 2016 5:24 PM BST
where is compound magic these days.....................rusty go to arbcruncher.com....then into betting calculator....then into back/lay
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com