Who has an Excel spreadsheet to track your bets and $?

Search

Rx Senior
Joined
Dec 7, 2004
Messages
18,351
Tokens
if someone creates one with pivot tables, you are the man.

then can do chronologically, view individual sports, $ value, etc.
 

Woah, woah, Daddy's wrong, Mommy's right.
Joined
Feb 25, 2006
Messages
7,977
Tokens

I was going to explain how to do it since I don't want to post my own. Here, use this.

http://www.filefactory.com/file/6a9302/

It has pull down tabs where you can sort by date, by sport, by book where you placed the wager.

The current bankroll row shows where you are if you have segregated bankrolls and how much a unit would be based on current bankroll and percentage of current bankroll. The row that shows Balance shows your balance per book (it has formula to calculate with deposits and withdrawals) and per sport. I highlight each play to correspond to the book at which it was made (use the same colors as the book's column).

Have fun, would be interested if anyone has thoughts or comments.
 

Rx Senior
Joined
Dec 7, 2004
Messages
18,351
Tokens
what do you mean with pivot tables?

Basically, they are tables where you can select certain parameters and only view those....so for instance, if you list the date as one of your data fields, you can view all bets on certain dates only (maybe sunday nfl)

I'm an accountant and I don't remember how to make them (haven't done one since college)
 

Forum statistics

Threads
1,108,089
Messages
13,448,418
Members
99,391
Latest member
tinhy047
The RX is the sports betting industry's leading information portal for bonuses, picks, and sportsbook reviews. Find the best deals offered by a sportsbook in your state and browse our free picks section.FacebookTwitterInstagramContact Usforum@therx.com