Need help with Poker stats to calculate results

Hi, Need help getting a few stats to show results In bankroll sheet, from tournament inputs
1. Todays Buyins column U5 in bankroll
2. Tournaments F19 " "
2. Satellites column F35 " "
3. Sit n Go column J35 " "
4. Finishes place columns AE:AH rows 49 in bankroll sheet.

Cell U5: =SUMPRODUCT((tbl_Tournaments[Buy-in])*(INT(tbl_Tournaments[Start])=TODAY()))
Cell F19: =COUNT(tbl_Tournaments[Start])
Cell F35: =SUMPRODUCT(--(ISNUMBER(SEARCH("satellite",tbl_Tournaments[Tournaments]))))
Cell J35: don't see any tournaments that contain the terms sit n go or freezeout
Cell AE49: =COUNTIFS($N53:$N134,"<="&RIGHT(AE48,LEN(AE48)-SEARCH("-",AE48))+0)-SUM($F49:AD49)
Let us know if you have any questions.

Thank you, mate, will see the changes. ty
Mate forgot to mention the Jackpot would be the Sit & Go in tournaments
Why is #REF! showing in MTT ITM% in tournaments and Satellites?

Cell J35: =SUMPRODUCT(--(ISNUMBER(SEARCH("jackpot",tbl_Tournaments[Tournaments]))))
What does ITM% mean?

ITM% means the times a player makes it to the Money in tournaments
Mate, can you see why in Tournaments column R shows 1 win when Rank is higher than 1, Only that one thing not sure I would need to create post for that,

ITM%: =SUMPRODUCT((ISNUMBER(SEARCH("jackpot",tbl_Tournaments[Tournaments])))*(tbl_Tournaments[Prize]<>""))/SUMPRODUCT(--(ISNUMBER(SEARCH("jackpot",tbl_Tournaments[Tournaments]))))
Because the formula in R2 read =IF(Tournaments!L866=1,1,"") instead of =IF(Tournaments!L2=1,1,"") as it should. (fixed)

Thank you, mate will see changes, I see is fixed now disregard
Rebuys show two different numbers for x9 column in bankroll and Ah25
for tournaments MTT ITM% can i paste the same formula
=SUMPRODUCT((ISNUMBER(SEARCH("satellite",tbl_Tournaments[Tournaments])))*(tbl_Tournaments[Prize]<>""))/SUMPRODUCT(--(ISNUMBER(SEARCH("satellite",tbl_Tournaments[Tournaments]))))

and change the name where it saids "satellite" ? or that would not work?

Cell X9 is counting all Rebuys which includes those made in 2022 while cell AH25 is the sum of AH13:AH24 which count only Rebuys in 2023.
MTT ITM%: =SUMPRODUCT(--(tbl_Tournaments[Prize]<>""))/SUMPRODUCT(--(tbl_Tournaments[Tournaments]<>""))
R5: =SUMPRODUCT((tbl_Tournaments[Buy-in + Rake*Rebuy])*(INT(tbl_Tournaments[Start])=TODAY()))

Happy morning mate nice many things working smoothtly mate, but there is a few other things. Column F45 site and All Games would have to give me the same for all rebuys from all sites instead it shows 34, can we adjust that with rebuys in Profit by Buy-ins colum J11
thank you mate. I forgot to mention when working on the transaction the Total Deposit & Balances for each site column J2
and FT column AE some some showing 1/1/1900 I know is format but not sure if it will continued when generating results when choosing different site or game by stake.

Mate, after entering a big win prize in tournament sheet it won't show in Tourney Profit by Site column J19

Mate, can we do the next changes in this workbook? I update workbook. I move Cash table to Cash Stats and added Yearly Stats
please make changes to this one.

I think that issues in post #11 are fixed.
Looks as if some sections got moved because the formulas didn't match the section headings.
We need an example of post #12.

Mate, here is the example I input in tournament 10k prize that won't show in Turney profit by site here the updated workbook
can # of games be adjusted to column M4 in total deposit & balances

question mate, can the Graph be updated to the same as this one in the picture?

graph.png

here is a link to the graph in the picture if you like to see how it funcions, maybe you need to do a player search kika5150

https://www.sharkscope.com/#Player-S...lass:SCHEDULED

I feel like the following may do what you are asking, but there is not way to test as all of the sites listed in the transactions section are for ACR and all of the sites listed on the Tournaments sheet are WPN (which is not even shown in the Total Deposits & Balances section).

Formula:

Please Login or Register  to view this content.

Thank you mate, I will work on that right away, and input some of the other sites, will download I been working on the Cash session put everything together similiar to the Bankroll, once I finished the inputs I will upload
question mate, why the word Casino? in the formula? not sure is adjusting the balance when doing a deposit and then inputing a tournament buying
i see why casino from all transaction

Mate, Here is the updated workbook, with all Sites inputs and the cash stats revised similiar to the Bankroll. I also copy the formula in post #17 which I don't see the results I want. Please take a glance at the Cash Games, I have a workbook that would help get the stats. I will upload as well so, you can see the way it funcions, I modify a bit the cash games to be similiar to the bankroll. Please lets work out of this workbook mate.
Mate, here is the link of the workbook, which I want the Cash Games in our workbook to function just like this one in the link. If make copy and download the stats for some reason don't work, its best to view in google sheets as you can see all stats working. In column N8 please input the number 20 so you can see how it does the calculations and gives me a Yes in I have to leave the table. here is the link


https://docs.google.com/spreadsheets...sQg/edit#gid=0

here is the website as well http://blog.microrollers.com

I notice that I put the $20 in O8 so it already says yes, but if you input $5 dollars it would change and you will see how it functions

mate, I Revised and change all WPN to ACR in tournaments sheet

I was able to fixed some of the stats in tournament profit by site J19 in bankroll, I change the names, aim the markup on the heading, but I don't know whats up! with GG its not giving the results. I also format to text because 888 was giving some weird # on pivot table

I added some Deposits but GG its playing hard to get. not showing the deposit amt.

There was an extra space after GG in cell J5.
Balance column: =SUM(SUMIFS(tbl_AllTransacations[Amount],tbl_AllTransacations[Casino],J4),SUMIFS(tbl_Tournaments[Profit],tbl_Tournaments[Network],J4))
Note that 888 has been changed to 888Poker in the Info sheet list and in tbl_AllTransacations to make it consistent with the tbl_Tournaments.
For this thread I am going to stick to issues on the Bankroll sheet as that is the original question.

Happy morning mate, I really forgot about the space, Okay mate yes lets play by the rules once we done with that, I can close and open new thread. will see changes. Mate I update heading in tournament profit by site, GG is not showing results I check for space, I don't know this one

Column 44 All site and All games not displaying all games and rebuy ft and wins also not sure why some show 1/1/1900
can we get the stats for Satellites column J17 Profit by Buy-ins

Thank you mate, Total Deposits & Balances seem to work as per request.

Mate, I update workbook, a bit not affecting, Any formula. Can we do all changes here, please
I will upload. ty

Mate, I notice the deposits for GG, pokerstars, partypoker and 888poker don't reflect in the Tournament sheet.

Mainly because all of those deposits were made on May 11th and the data on the Tournaments sheet only runs through May 10th.
Question: Should all four deposits be totaled in one row for that date?

"is that not possible when draging down the rows ?"
Don't know what that means.
Here is the file with the Deposit column formula modified to match deposits to both network and date:

Formula:

Please Login or Register  to view this content.

I don't believe that pivot tables have the same search selections, like shown in the screenshot, as regular excel tables.
The Date Filters options may make searching for a specific date or range of dates easier.
If you select Date Filters and then select Custom Filter there is a calendar type search option.

okay. Thank you, mate let me try that. I know there was a time where I would see month but is not there not sure how that got trigger. but I will try the above now. Can you see the pivot with all the formated colors or not? not sure if is only on my end but I added the colors

Date would be under Start right? or Days2?

after searching for the week, not sure why is not in order starts with 8 then 7th day 9 and 10 but not in order

dd.png

start date only shows this format

start.png

I don't have an answer for this one.
Will ask the other contributors to take a look.

Don't know what needs fixing with Satellite section.
Issue with the Rebuy, FT and Wins formulas is that the all games playing section was changed, specifically merging columns AD:AE and AF:AG.
Rebuy, FT and Wins formulas seem to be working now.

happy morning,
Thank you mate, you think we can continued with cash. will close this one and start cash thread

the satellite, I was refering to is F25 mate, profit, played and rebuys

for buyins m45 only shows 23/82 for all, all and its over 900 tournaments
would be possible to search by date. but if is going to be a delay leave for last. would like to start the cash

This is the reply that I was about to send before the last two rows of post #32 were added.
G25 (=L32) and H25 (=L28) are very elementary.
I25 is: =SUMPRODUCT((ISNUMBER(SEARCH("satellite",tbl_Tournaments[Tournaments])))*(tbl_Tournaments[Rebuy]))

EDIT: M45: ="("&COUNTIFS(U53:U1001,">0")&" / "&COUNT(S53:S1001)&")"

mate, not sure if G25 is missing something



shows like this

77.png


disregard mate

What do you want to search by date? The pivot table, the all games playing section, tbl_Tournaments?
As to adding a row to tbl_Tournaments when a new transaction is added to tbl_AllTransacations, if that is possible, it would more than likely require VBA of which I know too little to help.

Do you want to search for a specific date or a range of dates?

I worked on something similar a while back and found that for for me it was easier to filter the source data.
In this case you would filter the Start column in tbl_Tournaments, which would in turn display only the filtered rows in the all games playing section.
Is that something you could work with?
Note that there may be other ways to filter using the 2021 version.

mate, thats fine lets give it a try see how that works. Excel version 2021 imm i will see if i can get that version

downloading 2021 office as well

Your profile says that you are using the 2021 version already, which is why I brought it up.

So far only the All All portion of the formulas has been changed.
Wanted to make sure this will work for you before changing the other parts of the formulas.
Note that the start and finish dates are displayed in cells G47 and J47.

okay, mate thank you, let me see the changes

how do i change it or how it works?

thats fine there i will move and center with all the dates but is fine there

is going to be searchable by dates?

You search for the dates using the sort/filter button in cell F1 on the Tournaments sheet.

okay thank you mate, let me try that

and then go to the Bankroll ? i don't like that set up mate. having to go to tournament

would be great if the same filter was in bankroll

mate I notice the Prize and profit have got a bit out of order under all games

555.png

If you don't like that setup then use the file that was attached to post #34, to move forward.
Will look into other ways to filter the all games playing section from the bankroll sheet some other time.

Here is the file from post #45 with the prize and profit columns corrected.