Just wondering whether you guys keep a record of all your bets/lays etc? I normally just keep a record of my number of bets, profit, ROI etc but have now decided to keep a record of all my bet details in order to keep TABs (no pun intended) on everything thats going on. For those who do keep an active record of the bets what do you use in order to do so? I myself set up a MS Excel Spreadsheet two days ago which calculates everything for me and also lists all my bets and their descriptions. Is their a better way, such as a website etc?

Attached is my current system which I have run for the past 3 days, it seems to do the job however i dont want to start this only to find something better in a few weeks so I'm just wondering if this is the way to go? Any advice?

Regards
Betsy

PS. Spreadsheet assumes Ljubicic will beat Roddick tonight, haha

Attached Files

Book1.xls (60.5 KB, 862 views)

No need to assume anymore, Ljubicic won in straight sets

I try an keep records of my bets but am too lazy. Ive started with a new account now and will do it. I really like the way you have set it out, so much so im going to steal the layout and design. Anyone else like to post theirs?

With a winning percentage that Betsy was showing,perhaps you should steal his tips as well,Andrew.

Haha, I've had a good run of late - considering I'm doing exams at the moment and not putting many hours into punting I'm happy with my results.

All tips can be found in the Gamblers Lounge at www.menstennisforums.com (Username is Breaker)

Updated Stats:

Attached Files

Betting Records.xls (63.0 KB, 758 views)

at the beginning of this year i bought a full year diary and every bet i make i write down everything. how much wagered, what i bet on and outcome and how much it payed. at the beginning of every month i noted my starting account balance with all accounts i have and at the end of every month i noted how much was in them and whether i made a profit or loss.

next year i will start with excel. i dint know how to use excel at the beginning of this year but my g/f tought me and it seems to be alot easier.

Betsy, question mate.

If i have a win loss column, is it possible to do a formula win/loss x 100 to give me a percentage?

How do I get a copy of the spreadsheet?
pdaniels450@hotmail.com


Mad Gambler

Im sure it can be done, but I only know the basics of Excel so I cant help you out mate. If you find out how this can be achieved give us a bell

Is this what you need, if not let me know....the numbers in blue contain all the formulas

Attached Files

Win %.xls (13.5 KB, 616 views)