Using Excel to Track Your Poker Records

• 31.06.2025 3:29 pm
• headhunter
• 0 Comments

It is very important that any person who plays poker a lot to call it a passion, a hobby or even their main source of employment keep notes on their notes.

Lawful businesses have employed accountants who usually spend most of their time looking at the cash flow. To improve the growth of any company so that its income can go up as well, you ought to know your source of income and also what causes your losses. Your poker activities are no different.

There is no way you can study your game if you do not keep records on all the play. You must know where you get your cash as well as how much cash every area generates for you.

At some point, all the experts in poker become losing players. When the only amount you closely monitor is the overall total, you probably cannot find out if any particular limit is a cash pit for you.

Example, if you get $20 per hour by playing a $5/$10 game, but lose a whole hour playing $10/20, provided you played more hours of $5/$10, every month, you will find yourself at the top. From seeing the month in the dark, you will probably go on playing $10/$20, without having any idea how much cash you are using in doing so.

What to track

Remember if you record as well as monitor all the information, you will make more comprehensive reports using the same. You must make a decision on how -in depth you must go and are capable of going.

It does not matter whatever you may choose, other items are very important for all the individuals playing to track. For each session you need to ensure that you take a record on:

• Limit
• Date
• Total buy-in amount
• Hours spent at the table
• Total cash-out amount

The information above will enable you to monitor your income and your losses, hourly, rate, BB/hour ratio, annual trends and the buy-ins you go for in total.

When you want your record to have more information, you could keep track of:

• Particular players at the table
• The days of the week
• The mood
• The time of the day
• Variant
• Location

You could also record data such as this to help you understand:

• How particular opponents affect your result
• Which of the variants give you the most profits
• How your mood affects your results
• Where most of your money comes from
• What day you are likely to give your best shot

All these are essential pieces of information for an expert.

The first results will be of great help to you if you are a careless player.

How you could track it

The best method to track all the figures is to note them in black and white immediately. When you reach home, put the numbers in an excel spreadsheet. This enables you to get immediate results and reports, in addition to much deeper analysis.

If you are one of the people who have never used an excel before, there is no wasting time. Take online tutorials and figure how it works. When you have a little knowledge of it, you can begin to make your spreadsheet for the purpose of tracking statistics.

Here is an easy stats-tracking set-up:

You must fill the first five columns, but the last two can be filled by excel automatically. So as to do that, you have to include a formula in every field. Once you click on a particular field, and put an equal sign, excel will recognize you are making a formula.

Result: =SUM (E2-D2)

S/h: =PRODUCT (F2/B2)

If you add an extra row of data to the third row, you must highlight the particular column with the formula you intend use again. Copy it and the paste it to the new cell.

You can also use the Fill down function. Use the mouse to move down and highlight the cell with the formular, and if you want the formula in highlight all the cells, then hit CTRL-D or you can simply select the option "fill down' using the file menu.

Now you have a very easy spreadsheet. To create other formulas, you could make use of the build-in formula builders in excel. All is needed is to follow the orders, point and then click.

If you would like to develop higher, you can google and figure out how to go about any report. Example, here is a simple formula that you can use to calculate your BB/h.

=PRODUCT(_(F2/(RIGHT(C2,LEN(C2)-FIND("*",SUBSTITUTE (C2, "-","*",LEN(C2)-LEN(SUBSTITUTE(C2, "-" , "" )_)_)_)_)_)/B2)_)

Remember that in order for a formula to work properly; all the underscores must be gotten rid of.

This formula is a great way of doing this: Result/BB)/Hours). All the things that are at the center are used to get the big blind from the limit field. This formula would be a little easier if you had two fields.

No matter the method you use to take care of it, begin keeping the track of every single session that you play. If you already keep track of them, continue to do that so as to get more information from them. When the data as well as stats you make are used truthfully and reasonably, they will give you the methods to make the best use of your ROI.