Back & Lay the Biggest Pre-Off Movers - Guardian Automation Bot

roadie
Posts: 1
Joined: Fri Feb 10, 2023 12:36 pm

Hi Dallas,

I am trying to automate my Excel worksheet, i.e. by automatically bringing the exchange data to my worksheet - and then returning the calculated bets, (if any), to the exchange.

Bet Angel support suggested I place a 'help wanted' post in the Excel part of the forum.
Perhaps I am being dim, but I can't seem able to post such a request.

Any assistance you can give would be greatly appreciated.

Christopher
User avatar
Dallas
Posts: 22713
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

roadie wrote:
Fri Feb 10, 2023 12:52 pm
Hi Dallas,

I am trying to automate my Excel worksheet, i.e. by automatically bringing the exchange data to my worksheet - and then returning the calculated bets, (if any), to the exchange.

Bet Angel support suggested I place a 'help wanted' post in the Excel part of the forum.
Perhaps I am being dim, but I can't seem able to post such a request.

Any assistance you can give would be greatly appreciated.

Christopher
This post shows how to create a new topic
viewtopic.php?f=17&t=16838

and here is the Excel section
viewforum.php?f=19
iggypop37
Posts: 98
Joined: Fri Jul 20, 2018 11:05 pm

Thank you Dallas, this is a simple but excellent concept I can't believe I spotted on the forum before now !
User avatar
Dallas
Posts: 22713
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

iggypop37 wrote:
Mon May 01, 2023 10:26 pm
Thank you Dallas, this is a simple but excellent concept I can't believe I spotted on the forum before now !
:) No problem
dav1520
Posts: 17
Joined: Thu Aug 24, 2023 2:09 pm

Hi Dallas,

I'm looking to automate setting a lay for EVERY horse if the price drifts 15% between 00.05.00 and the start of the race.

If the horse continues to drift a further 10% I would look to green up.

Is this possible?
User avatar
Dallas
Posts: 22713
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

dav1520 wrote:
Thu Aug 24, 2023 4:55 pm
Hi Dallas,

I'm looking to automate setting a lay for EVERY horse if the price drifts 15% between 00.05.00 and the start of the race.

If the horse continues to drift a further 10% I would look to green up.

Is this possible?
Yes, just use a Set/Modify Stored Value rule armed once at 5mins and applied to Every selection
on the Stored value tab store the lay book% of a selection minus whatever percentage you want it to move
Then add another stored value and store the book% of a selection again this time minus whatever percentage you want to green up at

Then add a 'Place lay bet' rule applied to every selection and add a 'Stored value condition to test
the selections
lay price is
less than the
stored value named
(whatever you called it above)

Finally add a 'close trade on selection with greening' rule and add a 'Stored value condition to test
the selections
lay price is
less than the
stored value named
(whatever you called the second stored value that you created above)

and that will do ot
User avatar
Dallas
Posts: 22713
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

Dallas wrote:
Thu Aug 24, 2023 5:31 pm
dav1520 wrote:
Thu Aug 24, 2023 4:55 pm
Hi Dallas,

I'm looking to automate setting a lay for EVERY horse if the price drifts 15% between 00.05.00 and the start of the race.

If the horse continues to drift a further 10% I would look to green up.

Is this possible?
Yes, just use a Set/Modify Stored Value rule armed once at 5mins and applied to Every selection
on the Stored value tab store the lay book% of a selection minus whatever percentage you want it to move
Then add another stored value and store the book% of a selection again this time minus whatever percentage you want to green up at

Then add a 'Place lay bet' rule applied to every selection and add a 'Stored value condition to test
the selections
lay price is
less than the
stored value named
(whatever you called it above)

Finally add a 'close trade on selection with greening' rule and add a 'Stored value condition to test
the selections
lay price is
less than the
stored value named
(whatever you called the second stored value that you created above)

and that will do ot
There is an example along those lines here which uses BSP rather than the current price at a fixed time, but the principal of storing the price then triggering a bet when it drifts is the same as described in last post
viewtopic.php?f=52&t=17936
dav1520
Posts: 17
Joined: Thu Aug 24, 2023 2:09 pm

Thank you!

Can you clarify this line please?

'Then add another stored value and store the book% of a selection again this time minus whatever percentage you want to green up at'
User avatar
Dallas
Posts: 22713
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

dav1520 wrote:
Thu Aug 24, 2023 6:09 pm
Thank you!

Can you clarify this line please?

'Then add another stored value and store the book% of a selection again this time minus whatever percentage you want to green up at'
Click the 'Add' button in the bottom left corner and store another value (on the same rule) to use as your green up price
SV.jpg
You do not have the required permissions to view the files attached to this post.
dav1520
Posts: 17
Joined: Thu Aug 24, 2023 2:09 pm

Do I still need this rule if I complete the above?

Finally add a 'close trade on selection with greening' rule and add a 'Stored value condition to test
the selections
lay price is
less than the
stored value named
(whatever you called the second stored value that you created above)
User avatar
Dallas
Posts: 22713
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

dav1520 wrote:
Thu Aug 24, 2023 6:45 pm
Do I still need this rule if I complete the above?

Finally add a 'close trade on selection with greening' rule and add a 'Stored value condition to test
the selections
lay price is
less than the
stored value named
(whatever you called the second stored value that you created above)
Yes, that is the rule to place the green up bet on each selection
The stored value on the first rule is just to store the price it needs to trigger at of after
dav1520
Posts: 17
Joined: Thu Aug 24, 2023 2:09 pm

Hi, can advise where I am going wrong here. I get 6 immediate lays each time, some x2 on one horse rather than the whole market.

There is then no action beyond these lays in some races. In others I get multiples of 6, so 12 or 18 lays
Screenshot 2023-08-24 232018.png
Screenshot 2023-08-24 232102.png
Screenshot 2023-08-24 232129.png
You do not have the required permissions to view the files attached to this post.
dav1520
Posts: 17
Joined: Thu Aug 24, 2023 2:09 pm

Screenshot 2023-08-24 232149.png
Screenshot 2023-08-24 232211.png
Screenshot 2023-08-24 234225.png
You do not have the required permissions to view the files attached to this post.
dav1520
Posts: 17
Joined: Thu Aug 24, 2023 2:09 pm

Screenshot 2023-08-24 234247.png
Screenshot 2023-08-24 234302.png
Screenshot 2023-08-24 234332.png
You do not have the required permissions to view the files attached to this post.
dav1520
Posts: 17
Joined: Thu Aug 24, 2023 2:09 pm

Screenshot 2023-08-24 234402.png
Screenshot 2023-08-24 234413.png
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Bet Angel Automation - Horse racing - Pre off”