Trading 'green-up' calc

[Dannyh1]

Hi,

There a plenty of online tools that give can can give 'green-up' results.

I am looking for formula I can use in excel for bulk analysis.

In betting exchanges you can Back a result at one price & then Lay at another price as the market moves (or vice versa)

An example would be back at 48.00 for £100

The price then falls to 42.00

I would to know what how much I need to Lay at to get equal profit no matter what the outcome.

The result in this case should be £114.28 (giving guarenteed profit of £14.28)

Can anyone please advise.

Many Thanks.

 

[asking]

The formula is ~

Back price * stake / Lay price

48*100/42 = 114.2857143

If it was, Back price was 50, stake was 200.00 and lay price was 43
50*200/43 = 232.5581395

Cheers

 

[Dannyh1]

Great thanks