Take sp all

Discussion regarding the spreadsheet functionality of Bet Angel.
Trickle
Posts: 14
Joined: Sun Feb 05, 2012 9:10 am

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
User avatar
Euler
Posts: 26445
Joined: Wed Nov 10, 2010 1:39 pm

We had a couple of queries in support around Take SP but it turned out they were trying to SP a market that didn't habe SP on it.

Not aware of any issues with take SP. Only works in full API mode so be careful about that as well.
moolion
Posts: 6
Joined: Sat Apr 30, 2016 11:18 pm

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.
harrietflem
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
harrietflem
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'
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”