Forums

General Betting

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.

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
sort by:
Show
per page
Replies: 14
By:
nightshift man
When: 08 Jan 10 05:21
Nice one compound ;)
By:
Optimizer
When: 08 Jan 10 07:26
Where is the commission?
By:
kenilworth
When: 08 Jan 10 08:20
..and the same formula for 'redding up' ?
By:
Compound Magic
When: 08 Jan 10 08:58
kenilworth
Redding up is not in my vocabulary. I don't like the idea of a guaranteed loss.
By:
The Geeks Toy
When: 13 Jan 10 10:37
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:
Bet of the Decade
When: 13 Jan 10 10:48
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:
SHAPESHIFTER
When: 13 Jan 10 11:14
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:
Reyes
When: 13 Jan 10 11:30
don't forget (if laying 2nd) the good old add green and reds together and type in payout radio box
By:
page-413
When: 13 Jan 10 11:59
betfair and any decent API does all of this ??
By:
Compound Magic
When: 13 Jan 10 12:29
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:
page-413
When: 13 Jan 10 12:59
ok
By:
Rusty23
When: 05 Jun 16 12:27
How would I calculate this in a different way?
By:
Rusty23
When: 05 Jun 16 12:28
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:
freddiewilliams
When: 05 Jun 16 17:24
where is compound magic these days.....................rusty go to arbcruncher.com....then into betting calculator....then into back/lay
sort by:
Show
per page

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
‹ back to topics
www.betfair.com