1. #1
    tbiala
    tbiala's Avatar Become A Pro!
    Join Date: 05-06-09
    Posts: 14

    Trackin bets in excel

    I came across this site in through a google search trying to find a excel spreadsheet to use to calculate bets. i am not that great with excel but decent. i was looking for something i could track all my online wagers with and beable to sort and see how each type of bet is doing for me, ie: 1st half bets, moneylines, parlays etc. anyoen use something like this that wouldnt mind sharing?

    If not i will work on one and try and post it to the site for your use.
    thanks

  2. #2
    twister
    twister's Avatar Become A Pro!
    Join Date: 09-09-08
    Posts: 405

    I track my bets in Excel, it is the PERFECT tool to track bets.

    I recommend you have the following headers:

    - Date
    - Road Team
    - Home Team
    - Bet type
    - Road Odds
    - Home Odds
    - Road Score
    - Home Score
    - Totals Line
    - Over Odds
    - Under Odds
    - Amount Wagered (if you use differing amounts)
    - Amount won/lost
    - Any other types of information you think is pertinent (like starting pitcher etc)

    I do not personally use all of those headers as I don't need them, but if I were doing what you were doing (betting on things other than totals/ML etc) I would have it set out as above.

    Then to track how a certain type of play is doing, you can use the "filter" button in Excel to show on screen on "1H", or "ML" or "RRL" or "TOTAL" etc etc.

    Just make sure you enter the same word/abbreviation for the style of bet you are entering into excel.

Top