Bet Tracker Excel xls Spreadsheet
The Spreadsheets Direct Bet Tracker will allow you to easily keep track of your online betting for upto four accounts with a summary of your betting and graph representations of Profit/Loss & Account balances. Enter an Account Name to appear on the Financial Analysis graphs. Select the odds format you want to enter bets in from fractions, decimals, American, Hong Kong, Indonesian or Malaysian and the Odds column with change to match.
The Deposit (+) / Withdrawal (-) column allows you to enter/remove money from your account. The Account column gives a running total of your funds from deposits/withdrawals and bet winnings/losings. The Date column is used to in show your data in the graphs on the Financial Analysis sheet. The Time, Venue/Race & Bet columns are optional columns to allow you to keep track of your bets. In the Type column you can choose if you are placing a bet or a lay. Enter the Odds from the dropdown and a Stake. For an E/W bet select the fraction from the dropdown that the place will pay of the main bet odd. In the Result column select W (win), P (place) or L (lose) and the Profit/Loss column will automatically calculate your winnings. The Rule 4 column lets you enter a percentage deduction if there is a late NR. e.g. 5p in the £ equals 5%.
Each Account sheet will allow upto 5000 lines to entered. To clear the entered data click the Clear Data button on each sheet. The Bet Summary sheet will show you the total number of bets placed, wins, win %, total amount bet & total winnings. On the Financial Analysis sheet select a Start Month & Account from the dropdowns and the graphs will update to match.