modifying lay fav sample sheet

[craigy]

Hi All
Can anyone suggest a way I can modify the lay fav sample sheet so my lay bet stays at the front of the line until matched instead of matching the best price available when it triggers. Once someone comes in with a better price I want cancel and jump back to the front of the line. I wish to do this as many times as it takes to get matched.(I am working with low liquidity markets)
Thanks for any help
Craigy

[craigy]

I think I may need to know the simplest way to use the UPDATE tigger.
Just not sure how to put it into a formula.

[GaryRussell]

Here is an example spreadsheet that uses UPDATE to keep at the front of the queue.

Put "1" in the enabled column to activate chasing and the maximum odds you will lay up to in the max odds column.

While testing this I noticed a potential pitfall with this method. For example if your stake is £2. The problem is when there is money below £2 in the queue. If say £1 is at the front of the queue BA won't display it. UPDATE puts you at the front of the queue so it's now £3 at the front. UPDATE will again put you at the front. Because only £1 is at the next best odds it won't be displayed so UPDATE will trigger again to reduce your offer. Your offer will join the £1 again so it will trigger another UPDATE to put you at the front. It can get stuck in this cycle. This could cause a large number of transactions so you may want to modify this example for your needs. It should however give you an idea of how UPDATE can be used.

[craigy]

Thanks Gary. This could be what Im looking.

[craigy]

A question for Gary or anyone who understands excel better than me.
If I want use this sheet for a back instead of a lay what do I do about changing the maximum odds col for a minimum odds col.