Maths Excel Help Please

[pugs]

I am trying to write a trigger that will level profit/loss but i just can’t fathom out the maths.

IF(AND(-profit_loss>5, back_unmatched>=0), IF(lay_matched>0, -profit_loss/(r_ticks(lay_price,-1) -1), 2), 3)

The bet amount trigger above leave’s all profit/loss on all other selections, plus if I have laid 2 or more selections it needs to fire several times to remove excess liability. I have tried messing about with percentage calcs (lay price matched/lay price now) (lay amount/amount I need to lay) but I just keep hitting a brick wall. I need to insert my calculation in place of “-profit_loss” but is there a set formula for leveling profit/loss, and if so can anyone help. Please ignore the 2 and 3 at the end, I only put them there to fire fathom bets to cancel any unmatched.

Thanks for reading and any helpful advice.

[Captain Sensible]

Pugs have a look at the formula posted by Uncle Ernie at

http://gruss-software.co.uk/forum/viewt ... highlight=

it'll show you you how to balance the profit acroos selections. Basically you have to treat things in terms of a 100% book and work out the payout for the selections by using the max and min figures from profit and loss to set the book payout.

[pugs]

Captain many thanks, i would promote you to general but it sounds stupid

I haven’t actually got a clue how to use Excel so having the spreadsheet do the “max profit” calculation and insert it into my trigger is a no no, BUT that thread got my grey matter ticking over and i think i have stumbled across a formula for levelling profit that i can write directly into the trigger. So many thanks and good luck.