I can do the basics as far as setting formulas is concerned, but because final calculations involve a random
walk variation,it's not straight maths.
I think it will involve vba and a simple reference database.
Can anyone point me in the right direction?
I do expect to have to pay for this and have tried looking
online,but they seem to treat you as a deep pockets contract customer or some basic it certified technician thinks they can help.
thanks alan
automate calculations /not automated trading
afraid not.
works on predictive football scores,
but runs more against goal difference and scores.
as an example 1 run type would work as follows -
score lines 0-1,1-0,3-0,0-0
0-1 to 1-0 = 2-0
2-0 to 3-0 = 1-0
1-0 to 0-0 = 0-1(invert)
second section run type is more of a meld (same example)
0-1 to 1-0 = 1-1
1-1 to 3-1 = 2-0
2-0 to 0-0 = 2-0
I think it would need some kind of database giving
0-0 to 9-9 reference values and some kind of building block program which would allow me to simply insert the particular column values that I want to use.
sorry if the expression 'random' is confusing but I've shown this to a maths guy and he described it as looking like a variation on random walk.
Just in case you think I'm completely off my head.
the score outcome for this comes under the category
It's Not Gonna Happen.
thanks alan
works on predictive football scores,
but runs more against goal difference and scores.
as an example 1 run type would work as follows -
score lines 0-1,1-0,3-0,0-0
0-1 to 1-0 = 2-0
2-0 to 3-0 = 1-0
1-0 to 0-0 = 0-1(invert)
second section run type is more of a meld (same example)
0-1 to 1-0 = 1-1
1-1 to 3-1 = 2-0
2-0 to 0-0 = 2-0
I think it would need some kind of database giving
0-0 to 9-9 reference values and some kind of building block program which would allow me to simply insert the particular column values that I want to use.
sorry if the expression 'random' is confusing but I've shown this to a maths guy and he described it as looking like a variation on random walk.
Just in case you think I'm completely off my head.
the score outcome for this comes under the category
It's Not Gonna Happen.
thanks alan
Hi Mobile,
I have to admit I can't work out what you are trying to do but as far as the simple database part of it is concerned Vlookup (or match/index if it's more complex) should do.
I have a suspicion that most of you results could also be calcutated with nested if/and/or statements or a combination of the 2
If you've already tried that then apologies I havn't understood what you are trying to do.
I have to admit I can't work out what you are trying to do but as far as the simple database part of it is concerned Vlookup (or match/index if it's more complex) should do.
I have a suspicion that most of you results could also be calcutated with nested if/and/or statements or a combination of the 2
If you've already tried that then apologies I havn't understood what you are trying to do.