Brief explanation how to use this file:
First sheet – Settings. The biggest part of the job is done. Just add bookmakers and currency you are using. I have accounts in euros and pounds hence it is important for me to have a final summary in one currency which automatically will be applied in the end. In column X you can see exchange rate which you can update if needed but keep in mind that if you update currency exchange rate all information will be updated too. If you are using just one currency no need to do anything.
Sports/leagues/Market Type/Period/Tipsters/Win Options/Dates/Bet type – are added, just add more leagues/tipsters and you are set.
Some explanations:
HW – half win/half void for Asian handicap
HL – half lost/half void for Asian handicap
(+) – positive Asian handicap
(-) – negative Asian handicap
Hwin – Home team wins
Awin – Away team wins
Column Y – 5% Betfair commission (change number if needed)
Second sheet – Bets. Obviously, you need to add your bets here. Looks like a lot of columns but it will take you 10 sec to record your bet as most of the columns have drop-down boxes.
Why the first line have 3 different colors?
Orange – add your information manually.
Blue – use the drop-down menu and choose what you need.
Green – automatic calculations, do not touch!
Once you will be adding new bets – in green columns you need to drag formula’s down to create new calculated cells. When you will be adding your own bets instead of mine – do not delete formulas in green columns!
I don’t think you need more explanation here. Y/N – obviously means Yes or No. In the comments column, you can add your personal comments if needed.
Third sheet – Performance. If you have a bit of Excel knowledge you can see that this is basic Pivot tables. Click and drag anywhere you want and you can analyze your bets in hundreds of different scenarios: by bet type, by sport, by a tipster, by period – you name it. If you are not sure how to do it ask Google or me.
The main point of this file – to find your weak points and get rid of them. Find your strong points and use them!