i am trying to convert Daily Sessions sheet

..............

Put the following in front of the existing formulas: =IF([@Tournaments]="","",existing formula)
I have changed the %*MU and cost + fee formulas but I have to go.
You really don't have to worry about making a mistake because pressing the Ctrl and z keys will undo changes (note that you can also select undo from the quick access ribbon).

okay let me know about this mate I have a question? not sure if i ask or if require vba. okay
is it possible to make de posits via bankroll all transactions to choose from column c downdrop list to the sheet where I would want de posit to reflect? lets say either Tournaments, Cash, or Pokerstake? via formula even if i have to type like we do now and not produce what the vba code does.
instead of having 2 all transactions entries ?

i try many ways can't get it right not sure how.

=IF([@Tournaments]="","",[@markup]*[@[Buy-in]]) not sure thats correct since #value! show everywhere

latest file I update list sheet, with list of tournaments from GG different categories

Modification to formulas applied on the pokerstake sheet.
Tournaments sheet looks ok as is.

Applied to %*MU, cost+fee, cost player, comission, profit/loss.(column Q), Grosss Profit and $/Hr
I don't believe that a formula can do what you are suggesting in post #207.
You might be able to do the opposite, list starting roll and deposits from the Tournaments and PokerStake sheets to the Bankroll sheet, using Power Query.
However, using Power Query doesn't seem to be working too well as I notice that the Power Query produced list of tournaments and categories is again missing from the List sheet.

thanks mate,
can we set it up that way see not sure why is that happening. i don't think is me making something that takes it off.
can we continue with pokerstake, tournament and cash ? if you don't think we should give that a try about the deposits.


how can i fixed column c not to show green arrows

Put the Append1 table back on the List sheet, columns A:B, as described in a previous post.
Put a transaction table on the List sheet in columns D:G using the following code:

Please Login or Register  to view this content.

Removed the inconsistent formula error from column C on the Tournament sheet.

If you are talking about the balance column again, then I don't know how to make the formula match amounts from the website.
If you are talking about something else, then please clarify.

The formula should read the same in all profit/loss columns:

Formula:

Please Login or Register  to view this content.

thank you so much mate, will intput formula this is the latest file with random name pick list working by tora

The formula returns a #value! error because the gross profit column on the PokerStake sheet contains blanks.
To fix that change the formula in cell U7 and down on the PokerStake sheet from =IF([@Tournaments]="","",N([@[Prize 2]])-[@[cost+fee]]) to =IF([@Tournaments]="",0,N([@[Prize 2]])-[@[cost+fee]])

Okay ty i will make the change now.
after applied the formula in u7 it returns u an v column #value! is these 2 fomulas one for pokerstake and one for tournament sheet ?
=IF([@Tournaments]="","",N([@[Prize 2]])-[@[cost+fee]])

when i paste these formula =IF([@Tournaments]="","",N([@[Prize 2]])-[@[cost+fee]]) to =IF([@Tournaments]="",0,N([@[Prize 2]])-[@[cost+fee]]) <----- i get #value!kk.png


this seems to work tho =IF([@Tournaments]="","",N([@[Prize 2]])-[@[cost+fee]])
not sure if you double paste the formula
but still value on pokerstake results sheet

Here is the file with the formula applied.

nice, thank bunch
will update I just finished fixing ACR list of tournaments.

how can the Acr list be input friendly or compatible with GG poker list for when entering tourneys to give out the buy-in amt. in buy-in column



i will have all days of the week shortly

The ACR tournaments should actually be entered on the Tournaments and/or the PokerStake sheet.
Show us a file with the ACR tournaments placed on one or both of those sheets and we can work on finding a way to modify the buy-in formula.
The orange/white table on the List sheet is produced by Power Query from the tournaments and category columns on the Tournaments and the PokerStake sheets.

just finished inputting the whole week. it would be on both okay i input 1 on each sheeet pokerstake/tournaments
let me know if i need to modify the list for acr, i preety much use the same format as GG poker the amt. last or near last

something weird going on when i hit refresh on the list in white/orange it removes all acr tournaments
is the happening because i don't have them on the pokerstake/tournament "tounaments Column "?

I think thats was going on, wow not cool i spend lot of time creating all gg poker tournaments last night and just to finf out they are not on the list. anymore after a refresh took them out

Not weird. Expected. Power Query Produces the orange/white table from the lists of tournaments and categories that are on the Tournaments and PokerStake sheets.
Since none of the ACR tournaments are listed on either of those sheets then Power Query will not include them in the orange/white table.

Where is the file with the list of GG poker tournaments?

okay now i undertand, it wipe all my list of GG poker tournaments i had almost all sections on this picture
b.png
how can i work around that, i though by having in the list i could just input in tounaments column and refresh

Ok, I simply added all of the ACR tournaments to the PokerStake sheet and then refreshed the table on the List sheet.
So all ACR tournaments are listed on both sheets now.
Is there a file attached to any post in this thread that has the GG poker tournaments?

you mean all the ones from all the sections No, i have to redo it post#230 has only the actual game i have stake
will look if i have one but i don't think so


mate, jusst saw them they are on post#230 all in the blue table thanks god they still there and i was going to ask if i cand delete that?

Are the GG poker tournaments in columns I:J (blue/white table)?

yes mate yes i just saw them too. thank you wow is that i get busy looking for the whole shedule and download every table some times i mis track

I think is missing the zodiac will look into the shedule tomorrow for the missing one

let me know once i can delete the blue table

these file has the zodiac

Ok, give me some time to see if I can get them listed on the PokerStake sheet.

Look it over and if it looks like all the tournaments are listed on both the PokerStake and List sheets then you can delete the blue/white table.
I'll look into buy-ins on Wednesday, won't be around my computer tomorrow.

mate, this is the latest file i update list
added partypoker all tounament list and some of 888poker, pokerstars

Let me know where they were added.
As stated in post #227 you need to add them to either Tournaments or PokerStake sheet and then refresh the orange/white table on the List sheet.
Otherwise, if they were added directly to the orange/white table, then when that table is refreshed those entries will disappear.

beginning with which row?

Assuming that the new tournaments should be added to the PokerStake sheet.

The records only need to be placed in one sheet in order for Power Query to add those records to the orange/white table when refreshed.
That said if the same tournament is placed in both sheets, Power Query will still only list it once when the orange/white table is refreshed.

This clears up a lot of the value errors, however having different and sometimes conflicting formats for the tournaments makes it difficult to come up with a formula that covers all cases:

Formula:

Please Login or Register  to view this content.

Note that some tournaments such as "#7: King of the Jungle Bounty 6-Max [Stage 1]" in row 1070 do not have dollar amounts listed.
I'll look at this a bit more, however I feel that you are going to have to make some manual entries in the buy-in column.

just have a question now since the list is on the orange and white table i can delete the tournaments from pokerstake sheet?

I still see lots of correction in buy-in column how can it be fixed i am doing a bit ot staking and i can enter the tournaments? nor sure what to do

You can delete the ones that are not relevant to that sheet.
Remember that when the orange/white sheet is refreshed, it will only show tournaments that are on either the Tournaments or PokerStake sheet.
So, if you delete a tournament from PokerStake, and it is not on the Tournaments sheet, then when the orange/white sheet is refreshed that tournament will no longer be included.
Note that as it is evident that this thread is going to continue it would be a good idea to remove the [Solved] tag using the thread tools menu at the top of the page.

wow thst kinda sucks how would i know which are relevant to each sheet
have a question what if it was the opposite we have the whole list on list of tournaments and it just search when i type in tournament column in either tournaments or pokerstake and adds the category would that work?

"I still see lots of correction in buy-in column how can it be fixed i am doing a bit ot staking and i can enter the tournaments? nor sure what to do"
From post #248 "you are going to have to make some manual entries in the buy-in column."
"how would i know which are relevant to each sheet"
If you don't know onto which sheet the tournament should go, then I would guess it isn't needed on either sheet, but that really goes beyond the scope of being an Excel question.

ohh i khow which goes in witch sheet i would have to cherry pick tho and go thru the whole list to know
its only to things where im selling actions which is the tournaments and where im buying a share which is the pokerstake


the big downside here is that most of the tournaments in pokerstake are only there so we could have them on the list and i didn't have to fix while staking
but is not tournaments i have stake so i think i will have to delete which the list of all games enter are going to delete when i do refresh

"have a question what if it was the opposite we have the whole list on list of tournaments and it just search when i type in tournament column in either tournaments or pokerstake and adds the category would that work?"
Type the tournament into the tournament column in either the tournament or pokerstake sheet.
Refresh the orange/white table
Type the category into the category column of the orange/white table.
The formula in the category on the tournaments and/or pokerstake sheets will then automatically include it on that sheet.

Question: "how would i know which are relevant to each sheet"
Answer: "i would have to cherry pick tho and go thru the whole list to know
its only to things where im selling actions which is the tournaments and where im buying a share which is the pokerstake"

It might, give it a try and if it doesn't fix everything then upload the file.

The formulas are already there no changes needed.
Delete any rows from the pokerstake sheet that don't need to be there and add any tournaments to the Tournament sheet that do need to be there.
Then refresh the orange/white table.
At the very worst you can revert back to the file in post #248.

I am almost through with the file from post #266, for some reason the player column was formatted as date instead of general which caused the overflow error.

You will need to fill in the blank cells B76:B99 on the List sheet.

thank you mate, yeah ill do it right now ty

i survive for another round. this is the most up to date. file
with the adjustment balance both match so far

on column D now is showing oct all the way down not only the day, how can i have only day to much oct after the oct is fixed i will mark thread as solved would like to work on bank roll since i don't have the buyins or cashes or profit i know i am loosing deposit is 170 my balance is 128 for now tomorrow is either win or loose everything saturday and sunday is the bigest gtd

Most of the cells in column D are formatted: d
Cells D7 and D86 are formatted: d-mmm
You will have to individually format those cells which should display the month.
If you are making a deposit to PokerStake then put it on the PokerStake sheet.
If you are making a deposit to Tournaments then put it on the Tournaments sheet.

That would require the formula in the Date column to return a text string rather than a numerical value, which I don't think would be helpful overall.

oh okay i will have to do manually every time then which i wouldn't want.
not running good today mate, will do entries and upload file all players out almost when i check this morning making zeroo $ will upload so you can see how it has when
latest file all entries

Go ahead and start the new thread tonight, I'll work on it as time allows.