Log book manual
Below you’ll find a detailed manual for the log book, and how to get the most of it.
If you want to get started fast, look at the quick guide on how to log your bets first.
Remember to use the Confirm placed bet button in the Betting Browser when you’ve placed your bets.
By doing this, logging is just a matter of pressing Ctrl+V in the log book.
Excel 2007 or newer.
Use tab to add new rows
The Log book is built up with tables. To create new rows in tables (when adding another bet, a new deposit/withdrawal etc), select the bottom right cell in the table and press the “tab” button [↹ ] on your keyboard. You have to press tab in order to create a new row, otherwise the information will not be logged properly.
Don’t delete cells with formulas
Do not delete the content of any cells containing a formula. Most of these cells have a grey heading text. These cells are automatically calculated and if you delete the formulas the log book will not work properly.
Don’t want to see a certain column?
If you don’t want to see a certain column in the Log book, just hide it. This is helpful if you always use the Confirm placed bet button and paste the bet information (which you should), rather than entering it manually. Hide columns by right-clicking the column and select Hide.
First things to do
If you DON’T have accounts with any bookmaker
- Go to the DepWith tab
- Enter your total bankroll amount in the table in the middle.
If you DO have accounts with bookmakers
- Go to the DepWith tab
- Enter your total bankroll amount (including the total balance of your bookmaker accounts) in the table in the middle.
- Enter every bookmaker balance as a deposit in the table to the left.
Logging your bets
After you have placed a bet, you should log it immediately afterwards. Make this into your standard procedure after your bet. It only takes a few seconds when getting used to it.
Video on how to log your bet
Use the Confirm placed bet button
In the Betting Browser, after you have placed your bet, click the “Confirm placed bet” button (bottom right corner). A verification form will show:
Here you can modify the odds and your stake, if they changed during bet placement. The image above is for Value betting, but the same applies for Sure betting and Matched betting.
When you click “Ok” the bet information is copied to your clipboard. You can then switch to the Excel log book and paste the bet information into a new table row.
Entering the bet into the log book
Just place the cursor on the first column (Date), on the first blank row (create a new row by pressing tab on your keyboard):
…and press Ctrl+V:
Grade your bets
When the match has been played, grade your bet(s) in the Outcome cell:
- Win: Select this outcome when you have won the bet at the bookmaker.
- Half Win: Select this outcome when you win half your stake, and get the other half of your stake refunded to your bookmaker account. This could happen with for instance quarter handicaps (AH(0.25))
- Half Lose: Select this outcome when you lose half your stake and get the other half of your stake refunded (also used in quarter handicaps).
- Lose: Select this outcome when you have lost the bet at the bookmaker.
- Void: Select this outcome when a bet gets cancelled and the stake is refunded to your bookmaker account.
The Log Bets tab is the tab that you will use the most. Here you will be entering all your bets, and also the outcome of your bets. Use the Log Bets tab to log every bet you place.
The following columns exist in all versions of the log book (Sure betting, Value betting and Matched betting).
- Date: The date of the bet YYMMDD <– must be in this format
- Sport: The sport
- Bookmaker (1-3): The bookmaker(s) used
- Comm % (1-3): The commission percentage. Only fill this if: the bookmaker is an exchange (enter your commission percentage), or if the Bookmaker has a tax on your bets
- Participants: The participants in the match
- Odds (1-3): The odds of the bet
- Stake (1-3): The stake of the bet
- Bet on: What you bet on
- Outcome (1-3): The result of your bet (If you win, lose, void etcetera)
- Comments: Individual comments if necessary
The following columns are only used when sure betting or matched betting.
- Is Lay (1-3): Flags a certain bet as a lay-bet. Enter as “yes” only if the bet at the bookmaker is a lay-bet. Otherwise, leave the cell empty.
- TS: Total Stake. The combined stakes of all bets.
- AR: Actual Result. The result of all graded bets combined.
- A%: Actual percent. The result in percent of all graded bets combined.
The following columns are only used when value betting.
- Percentage: The percentage of the value bet (on the time of bet placement).
Here you’ll see key account figures like total Profit/Loss, bankroll size and growth, where your money is (on which bookmakers and if they are in-play or not) etcetera. Everything on this tab is automatically calculated.
Log all your deposits and withdrawals to and from bookmakers, and also to and from your bankroll. You will also make bookmaker account adjustments on this tab (for example cent adjustments when the account balance differs with a few cents), and also manual bookmaker bonus adjustments.
- Use the table to the left to make transactions within your bankroll.
- Use the table in the middle to make transactions to or from your total bankroll.
- Use the table to the right to make account/bonus adjustments.
Use this tab to enter new bookmakers and sports (if needed, most are already in there) into the log book.
A chart of your running result. If value betting, you’ll also see the Expected Value.
Monthly results of your betting progress.