I am trying to convert portion of pokerstake file to nearly same as pokertake platform

Hi, would like help converting file to be as close to the same as pokerstake platform for keeping records of stake to be exact when input in file
4-22-24 pokerstake
in book1 is a sample of 30 games when i donwnload from pokerstake platform that i convert to query
I then copy paste the games from query table to file 4-22-24 pokertake file.
i notice a few errors in rows 23, 24 due to having the same time where i made a deposit from 12.52 and during the same time i stake a player which duplicates the deposit.
in column M and N i would like to have that combine like it shows in this picture from the pokerstake site. showing the negative amts. and the positive, as shown in picture.
please feel free to ask any question.

For deposits paste the following into cell H7 and copy down:

Formula:

Please Login or Register  to view this content.

thank you mate. will copy and paste now.
nice that clear the duplicate. tydup.png
would i be able to enter all deposits and withdrawals from pokerstake sheet, then have them reflect on stake bankroll? or how is that going to work.
the reason i ask is because the csv file i donload i download as all results which includes deposit, withdrawals and stake amt. and winnings. everything

Again, we don't get notifications when you edit a post.
On 4/23/2024 at 3:50 PM we got the following message: "thank you mate. will copy and paste now."
Apparently the post was edited 23 minutes later. A better idea would be to wait the extra 23 minutes and make the whole post, so that you are not waiting 2 days for a response.
As to the question.
The date, transaction and amount columns can be filled using formulas like:

Formula:

Please Login or Register  to view this content.

Assuming that only site from which these transactions come is poker stake use the following to fill the Site column: =IF([@Date]="","","Poker Stake")

I was thinking if we can work a bit on book1 to clean a bit the file after i convert to query.
as you can see the games come with [ ] [ Monday Saver $50 [Hyper] ] that returned #N/A in file
and maybe have the - + combine in one column for when i paste to file

I am a bit confuse i been trying to figure out the entries for deposits and withdrawals and not sure how to do it, since both places have formulas for amt.
D column in pokerstake bankroll and pokerstake sheet in colunn H
i thought it would be all done from pokerstake sheet to reflect on stake bankroll sheet all transactions?

Do you mean that #N/A is returned in the category column of the 4-22-24 pokerstake (west 123).xlsb file?
If so, what do you want returned in the category column?
If not where is the #N/A being returned and what do you want there?
To combine the percentage and value columns in Book 1 put the following into another column (such as column K): =(LEFT([@percentage],1)&[@value])+0

In category column would like the game from list sheet
for row 8 hyper
row 9 speed racer
row 10 speed racer and so on
thank you, will apply the formula in book1 with the following formula. brb
after putting formula in K column the #'s change a bit from 4-22-24 pokerstake file
-156.72
133.94
18.23
13.43
from file
$157.72
$131.94
$15.23
$10.43

There isn't any consistency in for row 8 hyper, row 9 speed racer and row 10 speed racer.
hyper comes from inside the inner square brackets while speed racer is only part of what is inside the out square brackets.
Put the tournaments in the table on the List sheet, remove the duplicates and then fill in the categories.
As for the amounts I get the ones listed under "from file" in post #9.

thank you in this file I put 100 Games 4-25-24 pokerstake, to show for Example of how things work from deposits withdrawals, and canceled withdrawals. shows all deposit except the one for 100 for row 53 Apr 24 16:52
Book100 I put formula in column K and copy paste all in file 4-25-24 pokerstake
In file
wow Fantastic mate thank you. just saw this in stake bankroll sheet all transactions.png
note:
deposit in row 53 for $100 Apr 24 16:52 is not showing, and cell G79 i had to type word withdrawal from deposit that was showing.
in book100 rows 73, 74, 75 shows a bit different than in stake bankroll
I had withdrawal 157.72 then i canceled and withdrawal only -100 leaving 57.72 I re-stake then deposit $25 4/22/2024 20:20

Don't know how the formulas in A8:B8 and D8 on the stake bankroll sheet got messed up, however if that happens in the future select cells A6:D6 and double click the fill handle to reset them.
Perhaps modifying the formula in the category column on the poker stake sheet will work better: =IF([@Tournaments]="",[@Status],INDEX(Append1[Category],MATCH([@Tournaments],Append1[Tournaments],0)))

As stated in post #11: "Put the tournaments in the table on the List sheet, remove the duplicates and then fill in the categories."
I have copied the tournaments to the Append1 table and removed the duplicates. All you have to do is fill in the categories.
If you really want my opinion, I don't understand why you don't just use the data in book100 and set up a simple pivot table to display the information needed to decide who to stake.

thank you so much. i will fill categories. you think thats a better way? can you set up a good example of that with pivot table. i will input all games from 2024 to 4-25-24 file
i don't see the categorie to fill i will copy paste and delete duplicates
in this file i have all games i was trying to figure out all my deposits and withdrawals to to exact how much i have deposit and withdrawal 2024

Categories to fill are in cells B16:B30 on the List sheet of the 4-25-24 pokerstake file.
There is an example of a pivot table on the Pivot Table sheet of the Book100 file.

thank you mate, i think I redo and fill categories i will see file again i have put all games to date in post #16

okay after checking file Book100 games i it would work, having it that way can you set up the file with all games to current day so i can do lots of testing.after.png
after comparing file book100 to pokerstake
if we can have bookallgames set up to know breakdown of every deposit and withdrawals woudl be great not sure what i did in rows 4078:4095 a bit confusing for me about the amts.
please note:
that in bookall games i move the amt. from column I to G the Negatives i was trying to figure out how much i have deposit and how much i have withdrawal.
bookallgames i reversed to original so it won't be confusing me moving amt.

The formula that is supposed to be used to populate the Value3 column was missing from a lot of rows so I pasted it into cell K3 and copied down.
I put the withdrawal values back in column I and produced a pivot table to show the amounts deposited and withdrawn.

thank you mate, since my last post i been trying to know exact amts for all deposits and withdrawals not sure if this is correct this is what i have
D + 6233.14
W- 2921.45
L/P 3311.69 loosing would that be correct? will see file
can't beleive this we on the same page i was trying too figure that out but we both have different amts. wow
i use this file
can i delete columns not needed? like source.Name, my-shares, and percentage column from Bookallgames?

in sheet1 can we have pivot table for all players where i can see how much i have stake loss/profit amts bigest wins ?

Using a calculated item in the deposit/withdrawal pivot table yields the expected numbers: Act. Withdrawal=Withdrawal+'Withdrawal Canceled'
While the source.name and my-shares columns aren't needed, the percentage column is used in the calculation in the Combine percentage and value column.
Not sure what you expect in the for the other pivot table but set one up as a starting point.

Thank you mate.
okay will delete source & my-share leaving % column.
i want to figure out exact how much is a players been stake and if he is in profit or not as its using combine % sheet1 seems to show magnus lisberg -80.85 which seems correct will do more testing and see how that pivot table work in sheet1 will run to the bank and brb want to stake few other players for sunday 105 mystery brb thank you i will also deposit and giving us more of how it will work after i make deposit to pokarstake and do the entries which will be alot faster now
laterst file

Latest file with recent stake a lot faster to do to keep track please see downside i see is in the last row 4443 & 4442 is backward 4442 should be the last row like it shows in this picture.13.png

As this is an Excel table:
1. select cells A4443:J4443
2. move the cursor to the top of green selection box until you see a four headed arrow
3. press and hold the left mouse button
4. drag upward until the thick green line is between the rows for Pablo_Escobarr and DCB1316
5. release the left mouse button

Q: i was able to do that would that be an issue next time when i paste again the games. A: Seems as if the .csv file had the records out of order, so you'd have to ask whoever sent the .csv file.
Q: is there a way in pivot table to know how much i have stake so far just in that game. A: Yes, although I had to "Refresh All" for the pivot table to find the correct range on the Staking grom 01-01-2024 - 03-24 sheet.
As to guadis stats you'll need to show us a file that illustrates the issue.

thank you,
I get this 2 error when opening the file
after the errors table is gone, i can't continued to paste the stake games

I opened the file and got the "We found a problem with some..." message.
I selected yes and looked at the workbook.
For some reason Excel had converted the table on the Staking grom 01-01-2024 - 03-24 sheet into a range.
I converted the range to an Excel table and gave it the name: tbl_StakingGrom
I then changed the data source of the three pivot tables to tbl_StakingGrom.
Seems to be working.

thank you so much, your the best to have your support
I will see file and also enter all thes stakes from 4/26/24 and 4/27/24 ty
it seems of a bit of and issue. with the running balance not been in the last row. 61.13 should be row 4530 in this file as it shows in pokerstake61.13.png
instead its in row 4523
mate, have a question i am looking into guadis games in staaking grom it shows 48 games and on sheet 1 shows 20 games in this picture.
is that my actual games i have stake him for on 20?

Responding to post #29: there are 20 different event names associated with Guadis.
Note that some like [ Bounty Hunters Deepstack Turbo $8.55 ] are repeated multiple times.
The pivot table is going to combine the event names for seller name Guadis.

Here is the pivot table with dates.

thank you will look now.
as the day is over for me and not a very good day when i though it was going to be a good day is it possible to know how much i stake in a particular tournament and how much loss/profit i don't want this to repeat i know i stake way to many guys in this tournament. i will upload file with all games in a few minutes as i im done for the day
I am looking at guadis so is the amts. going to be combine for th same name of tournament ?
i don't undertand this pokerstake show one way and file shows different here is an example of both 33.png try searching by Apr 27, 2024 07:45

Over the past couple of days I have only worked on three other requests. At the present time I am working through the requests for the morning of April 25th. When I get caught up I'll come back to this again. Please do not add any other questions to what was edited in on 4/28/2024 until I or one of the other contributors has responded.

Not sure that I understand, however the time in the file is 10:45 AM.
If the issue is the difference between the times, and if pokerstack sent you the csv data then you would have to ask them.
If you want to find the date regardless of time do the following:
In the pivot table add the date field in the Rows area and then use date filter between 4/19/2024 and 4/28/2024.
If you just want to see the to the data on the 27th then change the between filter to 4/27/28 and 4/28/2024.

thank you mate.
yes i figure out that the issue is the time because of when i purchased the % it records the actual time thank ty i was able to find that out.
i would really like to know the best way to filter the data. i found erros on some players not sure if you can clear of the way by talking a bit. I just finished putting together a file which has All stake i mean all stakes from date 1 to 4/30/24 but i can't upload desposits shows over 20k in this file guadis dosen't show the amt. of 3.60 anywhere will upload
guadis don't show the 6.60 in cell J6 I don't think is minizing th 6.60 anywhere from daily hypersonic

I found the record in row 4490 of the Staking grom 01-01-2024 - 03-24 sheet.
I don't know what is expected in cell J6 on Sheet1 as the record shows a positive percentage and column J displays those percentages which are negative.

thank you, will look into that now.
J6 i think is suppose to be the amt. stake which is 6.60 and k6 51.71. - 6.60 i think this is how it shows in pokerstake

Then it would have to show on some column in row 4490 on the Staking grom 01-01-2024 - 03-24 sheet.
If J6 should show -6.60 then shouldn't J7 show -16.16?

so confused not sure why is not showing maybe i wasen't charge u mean? when i place the stake on him let me look into the pokerstake i mean i download from there as cvs file should of been there. looking into that now shows like this in pokerstake looking futher found it not sure what happen
i enter the missing games as it was 3 pages i had only 2 was missing 3rd part this is how it looks after
regarding your question on post#41 If J6 should show -6.60 then shouldn't J7 show -16.16?
i really don't know what should show in j7 very confuse of how this numbers work or where they should be.
j6 i though it would be -6.60 since i stake 6.60 for daily hypersonic $15 not sure about what should be in j7 i though would be the same -8.08 since thats how much it was stake its really really confusing for me i think it has to do because of all the times is there a way to simplify things and not be as confusing

I don't know pokerstake's accounting practices, however if you sort the dates ascending it may make a bit more sense.
The pivot table now makes it look like for the [ Daily Hypersonic $15 ] $6.60 was taken out of an account at 7:37 and then $51.71 was put into an account at 10:25.
Other than that I suggest asking pokerstake since they are the ones sending you the .csv file.

thank you so much. they don't send it to me i download from the pokerstake site. if you like please log in and see how that works.
let me explain how it kind of works, okay when i stake a games lets say for tomorrow it will record the actual time i buy the percentage. then when the game starts it put in the money as the player is winning if is bounty tounament money goes inthe account when the players KO's another player then i get my % of the bounty. and when my player i stake gets busted if his in the Money it would put in the money for its Performance Results in guadis was 51.71 when he busted out
please don't mind logging into the account
please also see this file with all games since the 1st date i started staking pivot shows different also would like to know how the deposits and withdrawals work see all here.
https://docs.google.com/spreadsheets...f=true&sd=true

The only instance of a deposit or withdrawal that I see is on Sheet1 cells B4:B5, and I don't know where those amounts came from.
Please explain what you want us to see in detail, including which sheet and which row(s).

in staking grom i in put all stake games from the day i started staking.
i suppose they come from all deposits in staking grom 01-2024 other than that i wouldn't know
is that not correct? i mean i don't know which amts ore correct now from results to deposits.
you have more expirence of how the accounting works thats why i was aking to log in to pokerstake account.