Excel Trigger - Clearing & Resubmitting Unfilled Part Of

[dogform]

Hi,

Could anyone please advise me how to resubmit the unfilled part of a "Fill or Kill" bet automatically when using triggered betting in excel.

The scenario is as below:

1. The excel trigger fires in a fill or kill LAY to a £10 libaility using LAY-F5
2. Part of the bet is matched to a liability of £7 leaving £3 liability unmatched which is then killed.
3. The excel bet ref column now has a value from the part matched liability and the trigger becomes disabled.

What I hope to be able to achieve is to get the trigger to fire again with a LAY bet for the previously unmatched £3 liability and repeat this until the £10 liability is completely filled.

Is there a way of doing this using cell functions/formulae and trigger modifiers, or, do I need to use VBA to get the bet ref cell to clear subject to certain conditions ?

Any help most appreciated.

Thx & Rgds
dog

[thunderfoot]

Why not extend LAY-F5 to read LAY-F20?

[dogform]

Why not extend LAY-F5 to read LAY-F20?

Personal preference

[osknows]

I think you will need to use VBA to do this; logic would be

1. create a new column in excel for cumulative stake (or as variable in VBA)
2. Use VBA to write matched bet stake into new column 1. above and clear out triggers and bet refs (eg, bet placed = £7, clear refs and add £7+£0 = £7)
2. Adjust formula for your current stake column to minus value in cumulative stake 1. above (eg normal stake equals £10, cumulative stake equals £7, new stake £10-£7 = £3)
3. Only trigger when calculated stake >0
4. Reset cumulative stake column to zero on new market selection