Greening up

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
premmahindruji
Posts: 2
Joined: Wed Mar 29, 2017 5:05 am

Even I am looking for Greening Up.

After some post on this forum, I could get the profit on one side. But how to get the profit on both side is what I am looking at. Say e.g.
In Cricket match (ODI) between Australia v Sri Lanka; presently Sri Lanka are favourite at 1.27 and I backed Sri Lanka at 1.27 for £1,000
My current position is SRI +£270 and AUS -£1000
Using the greening up formula ((Back Odds - 1) / (Sell Odds -1) * Back Amount
At this moment the Sell Odds is 1.28, using the above formula I get the Sell Amount as £1013.89 and when I lay that amount at 1.28, the total on SRI is -£13.89(Negative) and AUS is +£13.89(Positive)
Again if I take the Sell Odds at 1.26 the total on SRI is £13.51 (Positive) and AUS is -£13.51(Negative)

My question is what formula should be used to make profit (Positive) on both side i.e SRI or AUS irrespective of which teams WINS.
User avatar
CLOWNSHOES
Posts: 173
Joined: Sun Dec 28, 2014 8:04 pm

how have you managed to overthink this so much :lol: :?
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

premmahindruji wrote:
Fri Apr 14, 2017 2:49 pm

Using the greening up formula ((Back Odds - 1) / (Sell Odds -1) * Back Amount

My question is what formula should be used to make profit (Positive) on both side i.e SRI or AUS irrespective of which teams WINS.
Your greening up formula is wrong, think of it as a balanced equation, you don't take the stake off the odds just use the decimal odds

back odds * back stakes = lay odds * lay stakes

So you backed £1000 at 1.27 and you can now lay at 1.28

1000 * 1.27 = 1.28 * lay stakes

lay stakes = 1000 * 1.27 /1.28 = £992.19

So your book would now show -£7.81 on both teams , you won't have a profit by backing at 1.27 and laying at 1.28 , if you lay at 1.26 you'd lay £1007.94 and a profit of almost £8 on both teams.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”