A template trigger using Excel (VBA-code)

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.

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

Hi tupp,

Why does this sort of problem have to be solved through Excel? It is perfectly programmable with triggers alone.

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.

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.