Author Topic: A template trigger using Excel (VBA-code)  (Read 5076 times)

Tags:
  • All members
  • Posts: 365
A template trigger using Excel (VBA-code)
« on: 13 Jul 2015, 18:52 »
The ability to use Excel provides very good functionality to solve calculations , but I think that the link between the software is a bit complicated.

I would like to see a template trigger that fetch data from different markets (maybe u/o 2.5 goals and match-odds markets) and make calculation in a VBA-script (maybe a sum of two odds from respectivly markets). The results from the calulation should place a back-bet at "next goal" market at selection 1 at a price corresponding to the value (the sum of two odds) from the VBA-script.

  • Guest
Re: A template trigger using Excel (VBA-code)
« Reply #1 on: 14 Jul 2015, 10:13 »
Hi Tupp,

Is writing such a trigger as you described difficult? I am a novice at Excel so can you explain what the difficulty is and perhaps a trigger can be written here.

Larp

  • Administrator
  • Posts: 8819
  • Gender: Female
*
Re: A template trigger using Excel (VBA-code)
« Reply #2 on: 14 Jul 2015, 10:39 »
Hi tupp,

Why does this sort of problem have to be solved through Excel? It is perfectly programmable with triggers alone.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

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

  • All members
  • Posts: 365
Re: A template trigger using Excel (VBA-code)
« Reply #3 on: 14 Jul 2015, 21:28 »
Hi Larp & Oxa,

I thought a template trigger of this kind would be a good start for everyone who needs a trigger to solve more complex mathmatics. For example by applying VBA-script will give you accsess to statistical distributions, numeric solving, Monte Carlo  and much more - there are almost no limit.

The "strategy" I was describing was just fictitious to give an example of how to effectivly linking the software (MFP, VBA-code). This would be a good starting plate  for peope who needs more mathematics and programing to solve there strategy.

  • All members
  • Posts: 365
Re: A template trigger using Excel (VBA-code)
« Reply #4 on: 19 Jul 2015, 14:18 »
Instead of using excel I suppose many times it's possible to make all the calulations by running millions of simulations (stand alone) and build the function with lots of partial derivites to create the function (polynom)

I use to have problems with polynoms with to high degree, when using 10-degrees I somtimes get "POW-error" - the solution to this is to create a piecewise function which reduce the plynom degree to maybe only 4 (with maintaining accuracy), but on the other hand need lots of triggers instead!

So my next trigger project could probably get reality without VBA-code inside the trigger, but it would have reduced the number of triggers and saved weeks of simulations.

 

Please note, BetFair is seems to be currently OFFLINE