Welcome guest, is this your first visit? Create Account now to join.
  • Login:

Welcome to the Australia Sports Betting Forum.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Betfair
Results 1 to 6 of 6
  1. #1
    New Member
    Join Date
    Sep 2014
    Posts
    3

    Bet Type Sub Categories?

    First of all, this is a fantastic spreadsheet. Very impressive.

    I am trying to figure out the best way to track when I am betting underdogs/favorites/home/away teams. When you input the bets you really are not inputting that data anywhere that is tracked. ( I am speaking mostly of NFL and NCAA football btw)

    The best I have come up with is for Bet Type instead of just having "Spread" as a general type for betting a normal betting line I could put in more specific types such as:

    Spread - Home Favorite
    Spread - Home Dog
    Spread - Road Favorite
    Spread - Road Dog

    The problem with that is, I would like to see those stats combined as well in the analysis/statistical tools. I could repurpose the Tipster/Capper column to acheive this as well I guess, but I would like to use that as well for its intended purpose. I guess another field where you could use for custom purposes that still was taken into the calculations on the other tabs would be the best way (in addition to Sport/Type/Tipster/Bookmaker). Then I can just have "Spread" as the bet type, then in the other field you could specify other types of categories you might want to isolate.

    Let me know if that makes sense, and if I am missing something and there is already a way to do this.

    Thanks alot. Great work.

  2. #2
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi geremye,

    Thanks, I'm glad you like the spreadsheet

    What you've written makes perfect sense. I have previously resisted introducing another filter column because it would have pushed some of the formulas in the Performance Summary sheet over the character limit imposed by Excel. Now that we're shifting support to Excel 2007 onwards the effective limit is now 8192 characters, so I'm confident I can now achieve a new filter. This will likely feature in the next version of the spreadsheet.

    In the meantime, given that you bet primarily on the NFL and NCAAF, what you could do is maintain a separate spreadsheet for each sport. While this isn't ideal, particularly when it comes to the 'Available Funds' feature, it would free up the 'Sport / League' column to be used as a custom filter. Once a version of the spreadsheet becomes available that has the additional filter you could then combine the two sheets into one.

  3. #3
    New Member
    Join Date
    Sep 2014
    Posts
    3
    actually i do bet bball, soccer, mma, etc. just was using that for the examples.

    i can workaround it with splitting out the bet types for know. that would not be too difficult to migrate to a newversion when more fields are available.

    how often do you guys update it?

    thanks for the quick response.

  4. #4
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Updates are pretty sporadic, although the next one may be this month.

  5. #5
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi geremye,

    Version 2.16 of the advanced betting tracker has been released. It features a new field that can be used for the purpose of your choosing, such as tracking the home favourite, etc.
    http://www.aussportsbetting.com/tool...cel-worksheet/

  6. #6
    New Member
    Join Date
    Sep 2014
    Posts
    3
    awesome. you are the man

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •