--- title: 'Create Your Excel Template for Sports Betting' source: 'https://youtube.com/watch?v=_ytrPmlSKH4' video_id: '_ytrPmlSKH4' date: 2026-08-04 duration_sec: 571 --- # Create Your Excel Template for Sports Betting > Source: [Create Your Excel Template for Sports Betting](https://youtube.com/watch?v=_ytrPmlSKH4) ## Summary This video provides a step-by-step tutorial on creating an Excel spreadsheet to track sports betting. It covers essential columns, formulas for calculating value (EV), profit/loss, and estimated vs. actual profits, emphasizing the importance of knowing real odds to avoid being among the 97% of losing bettors. ### Key Points - **Setting Up Basic Columns** [00:03] — Start with columns for date, match, and bet placed. These are simple data entry fields without formulas. - **Odds Columns** [00:15] — Add two odds columns: bookmaker's odds (the odds you bet on) and actual odds (the true probability). The actual odds are crucial; if you don't know them, you're likely among the 97% who lose money. - **Additional Columns** [00:29] — Include columns for EV (value), euros generated per bet, amount bet, result (win/loss), profit/loss, actual profit, and estimated profit. - **EV Formula** [02:39] — To calculate EV, use the formula: (bookmaker odds - actual odds) / actual odds. This shows the percentage of value in each bet. - **Euros Generated Formula** [03:23] — Multiply the amount bet by the EV cell to get the money generated per bet, regardless of win or loss. - **Result Dropdown** [04:25] — Use Excel's data validation to create a dropdown menu for 'win' or 'lost' results, making it easy to select outcomes. - **Profit/Loss Formula** [04:55] — Use an IF formula: if result is 'win', calculate (odds * bet) - bet; if not, show negative bet amount. This automates profit/loss calculation. - **Estimated and Actual Profit** [07:33] — Create running totals for estimated profit (sum of EV-based profits) and actual profit (sum of real results). Drag down to autocomplete. ### Conclusion By following this tutorial, you can build a comprehensive Excel tracker for sports betting, enabling you to monitor value and profitability. The key to success is knowing the real odds and using value bets to ensure long-term profits. ## Transcript track of your sports betting in 5 minutes. Let's start with the columns you need to make. First, the date, the match, and the bet we placed. Next, we need to add two columns of odds, one the bookmaker's odds and the other the actual odds. We also need to add a actual odds. We also need to add a column for EV, value or ROY, column for EV, value or ROY, another for the euros generated by each bet, and to finish up we will have to add the amount we bet, the result of whether we won or lost, the profit and loss account, and of course, the actual profit column and the estimated profit column. The first three columns simply need to be filled in with the date of the match, the match, and the bet we have placed. So far I don't think there's any doubt, right? There's no need to add formulas or anything, just information about your bets. In this case, it's the bets that Bet Investor sends. You can access them through the link in the description. It's software that sends value bets, and you can see the incredible profits it has made in both 2024 and 2025. So, if you're interested in value betting or how to make money with sports betting, I recommend watching the full course. Let's move on to the next column, which is the bookmaker's odds. Basically, the odds we bet on. But the fifth column is the actual quota. And this one is a bit more difficult, and many people don't know how to find it. Without a doubt, this is the most important aspect of sports betting, because if you don't know the real odds, you probably belong to the 97% of bettors who lose money. In the case of Bet Investor, it is stated when the bet is sent. And if your tipster or the bet is sent. And if your tipster or software doesn't tell you the real odds, I would honestly stop giving them money because it's not legitimate. And if you place your own bets without software or tipsters, this free course will include a video titled "How to know if you are a winner, where I explain how to find this real odds." Taking these two columns into account, we can now easily complete the rest of the Excel file by introducing some formulas. To by introducing some formulas. To create the EV column, or the value or the real, we just need to put equals, open parentheses, select the bookmaker's odds cell, the minus symbol, and select the minus symbol, and select the actual odds cell. We close the parentheses and divide with the bar. And finally, we select the cell for the actual quota again. This will allow us to see what percentage of V we are getting what percentage of V we are getting in each stink. Next comes the column showing in each stink. Next comes the column showing the dollars generated on each bet and the amount bet. You can turn it upside down from how you're seeing it, no problem. The amount wagered is simply the money you have bet, without formulas or anything, but for the dollars or euros generated we do need to put a small formula. All you have to do is type equals, select the cell with the amount you bet, and then an asterisk, which in Excel means multiplication. After the asterisk, multiplication. After the asterisk, we select the EV cell or the value or the ROY and by using this formula you will get the money you are generating in each of the bets you make, regardless of whether you win or regardless of whether you win or lose. If the actual odds are higher than the odds we bet on, we are losing money because we are not making value bets. As for the results column, you just need to click on insert and then on drop-down menu. A box with different information will open on the right . At first it will show option one and option two, so in our case we will put win and lost and whatever colors you want. When the game is over, you just have to choose whether it was a winner or a loser. And now, let's move on to the And now, let's move on to the difficult and most important columns. First, the result. Of course, you could do it manually, but it's much faster with a formula. As you can see, it's somewhat difficult, but don't really worry because it's very easy. The first thing that comes is an equals and then a yes. We open parentheses and select the result cell. We put an equals sign, open quotation marks, and We put an equals sign, open quotation marks, and put win. We close the quotation marks and add a semicolon. It seems very difficult, but all we're saying is that if the word "win" appears in the result cell, then you'll have to do what we tell you now. If you wrote "acierto" instead of "win" tell you now. If you wrote "acierto" instead of "win" , then you will have to write "acierto" in quotation marks in that formula . And now we'll tell you what you have to do if you've earned the stink. To do this, after the semicolon, we will have to put parentheses and select the box of the odds we have bet on. An asterisk to multiply and select the box we multiply and select the box we have bet on. We close parentheses. We put in a minus one and again select the box for what we have bet. Basically what we are doing is multiplying the €5 bet by the odds of 2.34, which comes out to a total of €11.7, but then we subtract the €5 we bet, since what we want to know is the profit, not the total of what we have been paid. And now, of course, we need to consider, what if it's lost? And instead of doing this hellish formula again, what we're going to do is put a semicolon, the minus sign, and then the cell for the amount wagered again. This means that if it's not a win or a correct bet or whatever you put in, it will automatically show the amount we bet, but in negative, since we lost it. It seems difficult, but don't worry, as soon as you start doing it by pausing the video you'll see that it's easy. The good thing about doing it with formulas is that, as you can see, you only have to do it once. Then, you simply have to put the mouse in the bottom right corner, click and drag down. And this way it auto-completes for all the stacks you want and you don't have to do any calculations. And that's how we get to the last two that's how we get to the last two columns, the famous estimated profit and the actual profit. To create these last two columns, we will initially need two rows to be able to do it correctly. Let's start with the estimated profit. In the first row, we will simply have to put equals and select the cell of the profit generated in that bet. And in the second row we will have to put an equals sign, select the cell above, equals sign, select the cell above, since we had already generated those €10.22 in the previous bet. We put the plus symbol and select the cell for the estimated profit of the second bet in this row. From there, we can do the same. We drag down and it will autocomplete perfectly. As you can see, the estimated profit always adds up regardless of whether the bet is won or lost. As you know, with value bets, our actual profits in the long run will equal the estimated profits. And now, let's get to the real benefits, which is what we all want. As before, we'll need two rows, and after that, we'll simply drag down and it will automatically fill in. The first one, simply an equals sign and we select the box for the result of that bet. And in the second one, the same, but adding the previous result, that is , an equals sign. We select the cell above, the plus symbol, and the cell with the result of setting this row. With this, you now have an Excel file with all the basics you need. If you want me to add any type of column or function, add any type of column or function, let me know in the comments. And remember to watch the entire free course if you want to be part of the winning 3%.