Excel formula green up %

[gianlan]

do somebody have the Excel formula for the calculation of green up %? I mean green up share the profit in each field to 50%, i need the formula for sharing the profit for example 70% in one way and 30% in other.
Thank you

[Euler]

To green up you open a trade, close a trade and then you will have a profit. To spread this profit across the field simply lay the value of profit divided by the current lay price. If you want to spread more or less of this profit then vary the amount of the final lay bet.

[premmahindruji]

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.


Thanks

[Euler]

Did you find a solution to this?

[ShaunWhite]

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.


Thanks

Your answer is in Euler's posting above, but in your case you can close your trade using the following formula:
Closing Stake = ((OpeningOdds/ClosingOdds)*OriginalStake) and your green amount will be ClosingStake-OriginalStake

Situation 1
Lay ((1.27/1.28)*1000 = 992.18, Green = - 7.81

Situation 2
Lay ((1.27/1.26)*1000 = 1007.94, Green = 7.94

I'm happy to be corrected if this is not right