Questions can comments can be submitted through the Contact Form. Updates and new regarding the spreadsheet are posted on our Facebook page and Twitter account. Wednesday, 24 November Australia Sports Betting offers an Excel betting tracker spreadsheet that is free to download. There are seven worksheets as described below: Introduction — provides an introduction to the spreadsheet along with input instructions Settings — contains the worksheet settings for betting agencies, sports categories, bet types, tippers, etc.
Deposits — input sheet for deposits and withdrawals Bets — data entry sheet for your betting activity Available Funds — lists your credit levels for each bookmaker Performance Summary — interactive worksheet that summarises your betting performance. The standard and advanced versions enable you to track how frequently you beat the closing odds, while the advanced version also enables you to track tipper performance separately from your own.
Provides detailed performance insights to help you track your betting performance. This enables you to measure how frequently you beat the closing odds. Advanced Version — does everything the Standard version can, plus it enables you to enter separate tipper odds and lines.
This is designed for when odds have shifted from the time a tip was published to the time you placed your wager based on that tip. Download — Excel and Onwards. If your PC struggles with the calculations involved in the advanced spreadsheet it is recommended that you switch Excel from automatic to manual calculations.
Learn more. Alternatively, you can use v2. Share this:. Betting Tracker basic v2. Betting Tracker Standard v2. Betting Tracker Advanced v2. Staking Plan Calculator and Betting Tracker v1. It provides stake recommendations and calculates your hypothetical profit had you strictly followed each of the four staking plans: level stakes, percentage stakes, square root stakes and the Kelly Criterion.
Learn more about the staking plan calculator. Betting Tracker Standard v1. Updated basic , standard and advanced versions with the following updates: Support for cashing out, including cashing out a percentage of your bet. The Performance Summary calculates the profit difference between whether you had cashed out or not. Updated basic , standard and advanced versions with the following updates: New Basic version of the spreadsheet created, which corresponds to the previous Standard version.
The new Standard version features closing odds and lines, but not separate tipper odds and lines. This provides an additional filter by which you can analyse your betting data in the Performance Summary and Tipper Analysis worksheets. You can use this field any way you want.
Pick attribute — you could filter your wager data based on the home favourite, home underdog, road favourite, etc. Tip rating — if you subscribe to tippers who publish tip ratings you could enter them here. The number of bookmakers, sports, bet types and tippers supported has been increased from to Detailed Bets worksheet instructions added to the Intro worksheet.
New Tipper Analysis worksheet added to compare your betting performance to that of your tippers. This sheet ties directly into the three new columns discussed above. Instructions remain in the Win bet result column for all rows. Various background tweaks to reduce the number of hidden columns. New version with the following updates Tweaked Sports drop down menu validation in Bets worksheet. Punters who subscribe to tipping services can now track performance for each service separately.
Changes to the Settings worksheet instructions. New version with the following updates. This is only supported by Excel and onwards. Still, you will obviously want to see how much money you have made or lost. This is what most people tend to look at. It is a measure of how profitable you are relative to how much you are risking. While at the end of the day, the money in your pocket is what matters, this metric focuses more on results rather than process and is a measure of efficiency.
If you have a model, does it consistently value the Dallas Cowboys differently than the market? Thus making many of your bets on the Cowboys? Bankroll will track our running total of how much money you have in your accounts across all sportsbooks. You can also see this trended over time to help you see any changes in your betting strategy and how that has affected your bankroll.
It is very useful to see, at a glance, where your money lies. Maybe you should shift some to DraftKings. Having these metrics available is important, but insights really come from slicing the data by different dimensions.
Tracking your performance by league or team can give you clues into where your strengths or weaknesses are. Do you watch every second of every New York Knicks game? Think you have an edge on Knicks games? You can find out using the spreadsheet.
Same goes for leagues. Looking at performance by bet type can also shed some light on your process, especially if it is model driven. Want to see your performance over the last 14 days? Or how about the last 12 weeks? Both are possible here.
The sports betting tracker is also available on Google Sheets. While the features are the same as the Excel file, Google Sheets has some notable benefits:.
0コメント