I have an issue I am trying to solve, I have had a look on the web and asked questions in a couple of other forums but I haven't got anywhere fast...
The Background
I have a football betting system I have been using to varying success the last couple of seasons, the example below is for the English league.
I have collected a large range of data from the English league, I have a separate model that builds the data set in the 'Results tab. It contains data from a number of different factors.
To determine whether a bet makes a cut I use a %weighting factor. Weight tab.
Probabilty Score = Sum of all criteria(Factor*Weighting). The result of this is given in Results tab Column CE.
Hopefully this is making sense so far....
The solution I am looking for is to take away the trial and error side of finding the highest profit. Currently I try different weights of % to come up with different Profit scores (Example in the Weight tab).
I am looking for a solution to automate this - the weighting factors need to be multiples of 5 or 10. I need a solution that randomly outputs multiples of 10 and then the P/L is recorded. Then change the weighting factors and do it again etc etc...
I realise with the number of weightings the number of scenarios will be massive - but even if I can get an idea of where the highest profit margin (if any) is it would be a bonus.
Hopefully this makes some sense and someone may have done something similar?
Thanks,
IF
Not sure how to upload a file and don't think turning it to HTML would work.
File is located here if possible...
http://www.excelforum.com/attachmen...-weighing-up-different-factors-exampleik.xlsx
The Background
I have a football betting system I have been using to varying success the last couple of seasons, the example below is for the English league.
I have collected a large range of data from the English league, I have a separate model that builds the data set in the 'Results tab. It contains data from a number of different factors.
To determine whether a bet makes a cut I use a %weighting factor. Weight tab.
Probabilty Score = Sum of all criteria(Factor*Weighting). The result of this is given in Results tab Column CE.
Hopefully this is making sense so far....
The solution I am looking for is to take away the trial and error side of finding the highest profit. Currently I try different weights of % to come up with different Profit scores (Example in the Weight tab).
I am looking for a solution to automate this - the weighting factors need to be multiples of 5 or 10. I need a solution that randomly outputs multiples of 10 and then the P/L is recorded. Then change the weighting factors and do it again etc etc...
I realise with the number of weightings the number of scenarios will be massive - but even if I can get an idea of where the highest profit margin (if any) is it would be a bonus.
Hopefully this makes some sense and someone may have done something similar?
Thanks,
IF
Not sure how to upload a file and don't think turning it to HTML would work.
File is located here if possible...
http://www.excelforum.com/attachmen...-weighing-up-different-factors-exampleik.xlsx
Last edited:
