Back Fav/3rd Fav & Countdown Trigger

[diddlydo]

Hello all, hope your all well.

I was hoping someone could help me out please.

*In Excel*

1. Countdown trigger: If i want at 10min before every race to back the FAV trigger, how can this be set?

2. Once the countdown trigger is hit, how can i set a command to BACK the FAV at that moment in time?

Sorry if im asking for too much, but big thanks!

[6thSense]

This can be done in Guardian advanced automation.

Set the rule trigger time relative to before event start time.

Add a rule to back and apply to runner in position 1 when sorted by price.

[diddlydo]

Thank you for your reply.

But i wanted to know the commands for EXCEL Automation.
Im sorry, i was tired when i wrote the question.

Hope someone can guide me in the right direction.
Thanks

[6thSense]

There is not a simple instruction that does this.

You would need to sort by price order and write the code to do this.

Happily, there is a sheet here that sorts into favourite order:

viewtopic.php?f=31&t=7397

You would also need to decide what to do when there are two favourites at the same price.

Then write a conditional flag that sets ten minutes before the race. This can trigger your bet instruction. Decide how you're going to apply to all races when some are only five mins apart. If you intend to leave this running on it's own you will also need to build in some kind of race delay detection. If you are using Guardian to monitor the races you will need to set the refresh rate accordingly.

Hopefully this is enough to get you started. A bit of trial and error and I think you could probably get there.

Good luck in developing this. Feel free to post the sheet up here when you complete it.

[Euler]

The order of favouritism is usually static unless there is a big market move so you wouldn't necessarily have to re-order the odds to achieve this. It just depends on how fickle the entry criteria.

[diddlydo]

Hello guys,

Really am thankful for the help.
I would need some guidance on how to set the time/countdown trigger i.e. at 1min to trigger a bet.

Iv got a few little questions, which would help me very much.

6thsense, are you able and allowed from here to message/email me? As it would be an even bigger help to have a quick chat with you to resolve all my little queries.

Thanks again

[LinusP]

Have a look at these videos:

http://www.betangel.tv/videos/excel-and-bet-angel

Once you can master IF commands you can do a lot! This a handy bit of code which converts the countdown timer to the number of seconds...

Code: Select all

=IF(ISERROR('Bet Angel'!F4/2),0,ROUND('Bet Angel'!F4/0.0000116,0))

You can then have a simple IF command to trigger the bet.

(Also if you don't want to learn, I have a spreadsheet that will do exactly what you want)

[diddlydo]

Big thanks to all you guys that helped.

Have a nice weekend.