Excel Betting Tracker v2.14 Released (Standard and Advanced versions)

11 Responses to "Excel Betting Tracker v2.14 Released (Standard and Advanced versions)"

1. 

   E.C. Gupton December 23, 2013 at 3:24 PM · Edit

   Hi,
   I just downloaded v2.14 standard and noticed on the available funds tab that it goes from line 16 to 205. This causes some of the agencies to be missing.

   Thanks.

   Reply
   1. 

      admin December 23, 2013 at 4:03 PM · Edit

      Hi, thanks for pointing that out. Rows 17-204 were accidentally left hidden for the dollar and GBP versions. This issue has now been fixed and the files have been updated.

      Reply
2. 

   E.C. Gupton December 24, 2013 at 12:21 AM · Edit

   Awesome! Thanks for such a quick response and a very helpful spreadsheet. Happy Holidays.

   Reply
3. 

   Mark April 14, 2014 at 12:23 PM · Edit

   Love yoru work guys this is fantastic! I have been inputting some futures bets (pending) and some are highlighted in yellow while others aren’t. Is there any reason for this or have I made an error somewhere? cheers

   Reply
   1. 

      admin April 14, 2014 at 1:22 PM · Edit

      Hi Mark, I’m glad you like the spreadsheet! The highlighting issue is a quirk of Excel. If you close the spreadsheet and then open it again the pending bets should all be yellow.

      Reply
4. 

   Dimitris April 21, 2014 at 4:26 AM · Edit

   Nice work, thanks for this spreadsheet!

   I am only a beginner and I have two questions:

   1) Would adding more optional columns in BETS sheet mess with the formulas?

   2) Any chance to see the following implemented in the future versions:
   opening line – tipster’s line – currently available line – wager line – closing line (I don’t always wager the best line because I may not have funds available at the right book; more importantly I can’t track my tipsters 24/7 so I’m often several hours later and would like to keep track how not reacting quickly affects my bottom line).

   Reply
   1. 

      admin April 21, 2014 at 3:40 PM · Edit

      Hi Dimitris,
      1) Adding more optional columns shouldn’t mess up any formulas. If you ever accidentally do mess something up, you can always start again with a fresh copy of the spreadsheet.
      2) I can’t make any guarantees because we receive so many requests, but yes, that is a possible feature for a future version at some point.

      Reply
      1. 

         Dimitris April 22, 2014 at 8:25 PM · Edit

         Hello! One more question… Since I usually place wagers ‘american style’ so my risk amount is always different on a ‘1 unit wager’ when I’m betting the favorite (risk could be 1.50 if the line is -150 / 1.667 or could be 1.10 if the line is -110 / 1.909)… is there a way to tell the spreadsheet to automatically calculate my win/loss amount accordingly?
         I want to be able to just input 6.00 in the ‘Stake column’ on a -110 bet and, instead of W 5.4 or L 6.0, see W 6.0 or L 6.6.

         Does this make sense?

         Reply
         1. 

            admin April 23, 2014 at 10:50 AM · Edit

            Yes, you can change the sheet to work in this fashion. The easiest way would be to create a new column next to Stake called ‘To Win’, or whatever you want to call it. You would input 6.00 into the To Win column and have the Stake column automatically calculate the equivalent stake for you. For example if you input 6.00 for To Win with -110 odds, the stake would be calculated as -stake * odds / 100 (i.e. -6*-110/100 = 6.60). You could use an IF statement to make the stake column calculate the appropriate stake based on odds like +150 as well.

            Reply
5. 

   flo February 1, 2017 at 8:44 PM · Edit

   It is written “The password to unlock each worksheet is *****
   ” But it works just for the 1st worksheep not for all… Please !!!!!!!!

   Reply
   1. 

      admin February 1, 2017 at 9:48 PM · Edit

      Hi flo, which spreadsheet version and which currency are you using?

      Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.