I've had problems with this on and off. I've got an If formula triggering Take SP All 20 seconds after my bet is placed - about 90 seconds before the scheduled off time - and it's now working fine.
Trickle
Take sp all
Hi,
Sorry to dig up an old thread, but just wondering whether there was a conclusion to this?
Please see my new thread:
viewtopic.php?f=19&t=11858
Thanks.
Sorry to dig up an old thread, but just wondering whether there was a conclusion to this?
Please see my new thread:
viewtopic.php?f=19&t=11858
Thanks.
-
- Posts: 7
- Joined: Sun Jun 19, 2016 11:14 am
Hi all to fix this problem in the global command box write if cell c5 is greater then 0 in the true col type "TAKE_SP_ALL" in the false just put "" so what happens is your bets will be placed if they are not matched they will be placed at sp price
-
- Posts: 7
- Joined: Sun Jun 19, 2016 11:14 am
There's a log to show you what happens and you can use this just to take sp regardless.
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Monna Valley at 400. Entirely unmatched when it initially reached the market. Ref: 10000
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Paladin at 400. Entirely unmatched when it initially reached the market. Ref: 10001
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Ertidaad at 400. Entirely unmatched when it initially reached the market. Ref: 10002
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Bennelong at 400. Entirely unmatched when it initially reached the market. Ref: 10003
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Glorious Dancer at 400. Entirely unmatched when it initially reached the market. Ref: 10004
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Storm Runner at 400. Entirely unmatched when it initially reached the market. Ref: 10005
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10000 from 'Cancel' to 'Take SP'
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10001 from 'Cancel' to 'Take SP'
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10002 from 'Cancel' to 'Take SP'
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10003 from 'Cancel' to 'Take SP'
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10004 from 'Cancel' to 'Take SP'
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10005 from 'Cancel' to 'Take SP'
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Monna Valley at 400. Entirely unmatched when it initially reached the market. Ref: 10000
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Paladin at 400. Entirely unmatched when it initially reached the market. Ref: 10001
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Ertidaad at 400. Entirely unmatched when it initially reached the market. Ref: 10002
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Bennelong at 400. Entirely unmatched when it initially reached the market. Ref: 10003
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Glorious Dancer at 400. Entirely unmatched when it initially reached the market. Ref: 10004
23/06/2016 03:19:59: [Excel] : $ 5.00 Back bet placed on Storm Runner at 400. Entirely unmatched when it initially reached the market. Ref: 10005
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10000 from 'Cancel' to 'Take SP'
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10001 from 'Cancel' to 'Take SP'
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10002 from 'Cancel' to 'Take SP'
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10003 from 'Cancel' to 'Take SP'
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10004 from 'Cancel' to 'Take SP'
23/06/2016 03:20:00: [Excel] : Modify bet persistence 10005 from 'Cancel' to 'Take SP'