Excel - analysing data
Budget: £10 – £20 GBP
We have a spreadsheet with nearly 300,000 rows of horse racing data.
We want to analyse this data by race class, 1,2,3,4,5,6,7,NA
For example, X amount of races, X amount of winners x amount of losers X amount of profit/loss
We also want to analyse data by odds
For example, betting on every horse under odds of X, would return X profit/loss.
and betting on every horse between the odds of X and X would return a profit/loss of X
This is just a start, we will progress to more calculations.
There are more future requirements, so knowledge of how we could look at future calcuations and the best platform to do these on, would be good.
We want to analyse this data by race class, 1,2,3,4,5,6,7,NA
For example, X amount of races, X amount of winners x amount of losers X amount of profit/loss
We also want to analyse data by odds
For example, betting on every horse under odds of X, would return X profit/loss.
and betting on every horse between the odds of X and X would return a profit/loss of X
This is just a start, we will progress to more calculations.
There are more future requirements, so knowledge of how we could look at future calcuations and the best platform to do these on, would be good.