Author Topic: [TR] A POM trigger  (Read 3568 times)

Tags:
  • All members
  • Posts: 231
  • Gender: Male
[TR] A POM trigger
« on: 24 Jun 2016, 00:43 »
Could I request a trigger please.

POM changes rapidly and widely for each race.

I want to calculate and record the POM (back_volume/lay_volume) for each runner at x mins before the off. This figure is to be recorded onto each race's spreadsheet (which I have created through Excel settings at the start of each day).

I then want to bet according to certain parameters (eg POM less than z, bet to be placed at y mins before the off if minimum starters >=10, and minimum price for favourite is $2.50 etc (all variables and not limited to these)).

I think I understand most of the issues, but recording and remembering the POM has beaten me.

I hope I have made my requirements clear, but I'm sure you will let me know if you need clarification.

Thanks in advance,

bobh

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: A POM trigger
« Reply #1 on: 27 Jun 2016, 10:57 »
hi
please complete the request.

mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 231
  • Gender: Male
Re: A POM trigger
« Reply #2 on: 27 Jun 2016, 22:37 »
Hi mcbee,

When I completed the request, it told me I had exceeded my quota.

I am baffled by this, as to my knowledge I have not made a trigger request for a long, long time, and in any case, I am a lifetime subscriber which, from my understanding, allows quite a few requests over a 12 month period.

Perhaps someone could look at this for me.

Regards,

bobh

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: A POM trigger
« Reply #3 on: 14 Jul 2016, 10:28 »
hi
i need to see the spread sheet.

mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 231
  • Gender: Male
Re: A POM trigger
« Reply #4 on: 15 Jul 2016, 05:21 »
G'day mcbee,

I don't know how to send you a copy of the spreadsheet!!

But anyway, this will help:

In Settings/Excel/ I tick the box "Create a sheet for each market"

In Custom Cells & Formulae I have the following:

S17:1      IF(back_volume/lay_volume=0,0,back_volume/lay_volume)

The puts POM for each runner in Column O in each race spreadsheet.

I hope this helps, and apologise if my lack of tech skills causes a problem.

bobh

  • All members
  • Posts: 231
  • Gender: Male
Re: A POM trigger
« Reply #5 on: 15 Jul 2016, 11:05 »
Sorry, my typo.

Should read S15:1

bobh


  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: A POM trigger
« Reply #6 on: 17 Jul 2016, 08:58 »
hi
can you tell me exactly what you are trying to do with the pom, please give an example of bets.

mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 231
  • Gender: Male
Re: A POM trigger
« Reply #7 on: 17 Jul 2016, 09:39 »
Hi again mcbee,

Thanks for trying to assist me.

Please refer to my initial request for what I am trying to achieve.

Nevertheless, as an example, I want to record POM for each runner at x mins before the off (let's say 0.2 mins). I need that saved into the race spreadsheet (because I want to keep them for statistics).

I then want to place a bet (or multiple bets) if the recorded POMs meet certain criteria (eg less than 3) at y mins before the off (let's say 0.1 mins).

The problems I have encountered in trying to design a trigger myself is that I don't know how to remember POM at 0.2 mins before the off, AND record it in the race spreadsheet.

What I have been doing (real money) is to stop monitoring at (say 0.1 mins), and triggering my bet(s) at (say between (0.1mins + 0.08333 mins) and 0.1 mins - 6 secs and 6.5 secs) so that the bet is hopefully placed just before monitoring is stopped.

One of the problems with this is that I then need to wait until the race has settled, and then start monitoring again so that the result is updated into my spreadsheet.

What I have found is that in the half second window I give the trigger to place the bet, the POM sometimes changes, and the recorded POM (in the spreadsheet) is different from the POM used to place the bet (that is difficult for me to explain).

If you can work out how to record and save the POM without having to stop monitoring, that would be perfect.

I know this may be unsolvable, but if anyone can solve it, I know you can.

Please keep asking questions if it remains confusing.

Regards,

bobh

   


  • All members
  • Posts: 231
  • Gender: Male
Re: A POM trigger
« Reply #8 on: 28 Jul 2016, 22:35 »
Has my request withered on the vine?

It's been a long time since anything has been communicated, and I'm just wondering.....................!

I am assuming it is a difficult problem, but would like an update if possible, please.

bobh

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: A POM trigger
« Reply #9 on: 04 Aug 2016, 07:46 »
Hello and apologies for your request taking so long to be processed.

I am attaching your triggers. I assume you want to place BACK bets on one or more selections, and that the bets are (among other parameters) based on the POM the selection had at the moment of recording it.

The file contains constants which you can use to adjust the time at which the POM is recorded, the time at which the bet is placed, the limits of the POM value, number of runners and the fav's price.

Please note that considering the fact that you will connect MF Pro to Excel, your refresh rate must be limited to 2 sec (no more often), otherwise we cannot guarantee the stability of the MF Pro + Excel combination.

The POM will be recorded into column O (each selection's POM on a new line).

I'd recommend you to turn ON the option "Don't create market sheet until it's 2 mins till the off".

Please make sure you have tested the triggers in Test Mode.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

  • All members
  • Posts: 231
  • Gender: Male
Re: [TR] A POM trigger
« Reply #10 on: 05 Aug 2016, 02:58 »
Thanks Oxa.

I will test it over the next few days and let everyone know how it performs.

I appears to be exactly what I requested, so thanks again. As usual, I complicate things more than necessary in my own feeble attempts at designing triggers.

I had wondered about the refresh rate, so will amend to your suggestion.

bobh

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: [TR] A POM trigger
« Reply #11 on: 05 Aug 2016, 11:20 »
Glad I could help, bobh! Any problems or questions, post here.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

  • All members
  • Posts: 231
  • Gender: Male
Re: [TR] A POM trigger
« Reply #12 on: 06 Aug 2016, 03:04 »
Just one correction, Oxa.

In the "remember POM trigger", the cell address for "write to excel" should be querymarket_id!O(sel_index*3+1) I think.

It's working a treat, but will my method make a profit?

Looking good so far.

Bobh

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: [TR] A POM trigger
« Reply #13 on: 06 Aug 2016, 07:52 »
In the "remember POM trigger", the cell address for "write to excel" should be querymarket_id!O(sel_index*3+1) I think.
I didn't realize you needed the figures to be arranged on the same lines as the selections' names. Glad you sorted it out on your own!
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

 

Please note, BetFair is seems to be currently OFFLINE