The TalkingPoker.com Forum  

Go Back   The TalkingPoker.com Forum > All Things Poker > General Poker Discussion
Register Blogs Arcade HH Converter Calendar

Closed Thread
 
Thread Tools Display Modes
  #26  
Old 07-26-07, 10:53 PM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

You know you're really starting to piss me off now. I've basically just been ignoring your blather about this because that's the way I roll generally, but I've been stewing over this (and your other idiot comment). You don't find this useful - fine - shut the fuck up. I've poured hours (too many probably) into this to try and help figure this out (not the sql stuff, but the poker stuff - I've had to figure the sql stuff out, but I'm doing it for the poker...) because some of us are curious to see how this works.

If you have something constructive to say, great. You want to help get us better information, great. You want to keep on trying to invalidate the work we're doing - not great.
  #27  
Old 07-26-07, 11:07 PM
Talking Poker's Avatar
Talking Poker Talking Poker is offline
Adminimus Maximus
 
Join Date: Oct 2004
Location: Florida Coast
Posts: 27,480
Talking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep Points
Default

+Rep * {Infinity}
__________________

Got RakeBack?
27% at Full Tilt | 33% at Cake Poker | 30% at Carbon Poker
  #28  
Old 07-26-07, 11:24 PM
Wes Wes is offline
Forum Addict
 

Join Date: Apr 2007
Posts: 1,879
Blog Entries: 23
Wes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep Points
Default

Really easy, although you wouldn't have the l33tness because you don't know have to know how to do sql queries.
  #29  
Old 07-26-07, 11:25 PM
Talking Poker's Avatar
Talking Poker Talking Poker is offline
Adminimus Maximus
 
Join Date: Oct 2004
Location: Florida Coast
Posts: 27,480
Talking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep Points
Default

I updated the SQL in the first posts with "x.real_player_id" instead of "x.player_id."

So here are my personal results with raising donk bets. I'm using my Troll Pie ID only, so these should only be hands from 1/2 NL - 5/10 NL (all 6 max) games on Full Tilt since last October or so.

I raised 362 donk bets.
Donk has folded 189 times.

So, that's 52% of the time that I've taken down the pot right there.

I know one person will find this useless, but I think this is awesome, since in my head, I was guessing this number (for me, obviously) to be slightly over 50%.

For the stupid among you, please be aware that I do not think I have proved always raising a donk bet to be profitable or anything else like that. But I have proved that for me, when I have choosen to raise a donk bet, it has indeed been +EV... at least as far as the bet itself is concerned and ignoring the rest of the hand (where I am almost certain I have won a lot more money that I have lost).

I'd be interested in seeing more people's numbers, especially the people who speculated what their results were in the other thread.
__________________

Got RakeBack?
27% at Full Tilt | 33% at Cake Poker | 30% at Carbon Poker
  #30  
Old 07-26-07, 11:37 PM
Wes Wes is offline
Forum Addict
 

Join Date: Apr 2007
Posts: 1,879
Blog Entries: 23
Wes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep Points
Default

OK, you proved two people wrong in their assumption of just general donk betting and how often a person folds doing it. Now, can we please expand upon this into some more thorough analysis that will help people more?

Can you filter your actual winnings when you do this play? It might be a little more useful for deciding if just auto raising donk bets is a better way to approaching the hand than say evaulating what the donk bet means and acting accordingly.

And then, when you are done with that, filter on how you are doing when you raise a donk bet from a person with a vpip over/under 30 and the profitably of that play.
  #31  
Old 07-27-07, 12:00 AM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

to find the level you want try this

select * from game_level

that will give you all the levels you have in the DB and their game_level_id

then use

select x.game_id from game_players x join game_players y on x.game_id = y.game_id and y.fbet = 1 and y.praise != 1 and y.ffold = 1 join game z on x.game_id = z.game_id and z.game_level_id = game_level_id here where x.raised_first_pf = 1 and x.fraise = 1 and x.fcheck != 1 and x.real_player_id = player_id here

to those who actually appreciate my work - you're very welcome. This is such a fascinating topic. There's a lot of good stuff in there.

Here's a question:

how often is a limp - re-raise AA?

To be fair I'm not talking about pure limps, but people that call the current bet, get raised at some point behind them, and then re-reraise pre-flop.

Any guesses?
  #32  
Old 07-27-07, 01:16 AM
Talking Poker's Avatar
Talking Poker Talking Poker is offline
Adminimus Maximus
 
Join Date: Oct 2004
Location: Florida Coast
Posts: 27,480
Talking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep Points
Default

You have way more data that I do. By all means, go for it.
__________________

Got RakeBack?
27% at Full Tilt | 33% at Cake Poker | 30% at Carbon Poker
  #33  
Old 07-27-07, 01:19 AM
Talking Poker's Avatar
Talking Poker Talking Poker is offline
Adminimus Maximus
 
Join Date: Oct 2004
Location: Florida Coast
Posts: 27,480
Talking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep Points
Default

Stats are fun.

This is a tricky one though, especially with the broad definition (maybe this should be a new thread - but I guess there's not too much to discuss with this one). I think the number is pretty high... how about 42%?
__________________

Got RakeBack?
27% at Full Tilt | 33% at Cake Poker | 30% at Carbon Poker
  #34  
Old 07-27-07, 06:57 AM
lightfungus's Avatar
lightfungus lightfungus is offline
Back in business!
 

Join Date: Nov 2004
Posts: 2,259
lightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Pointslightfungus has between 750 and 999 Rep Points
Default

I'm doing a decent amount of SQL at work right now and would love to help out with this but I don't have the time right now. So I appreciate it de-coder. And work also blocks this site
__________________
I need 'em for my footsies.
  #35  
Old 07-27-07, 01:31 PM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

Keep in mind I'm not actually a sql guy - I'm just kindof flying by the seat of my pants and reading a lot of sql docs (I also asked a guy at work to point me in the right direction). If you have any suggestions as to how to do things better, or if you see any problems with it let me know.

There's more stuff in there too if we have any ideas for things we'd like to see (see above for 1 fun stat...).
  #36  
Old 07-27-07, 03:17 PM
Wes Wes is offline
Forum Addict
 

Join Date: Apr 2007
Posts: 1,879
Blog Entries: 23
Wes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep PointsWes has between 3000 and 3499 Rep Points
Default



Use it.
  #37  
Old 08-02-07, 10:57 AM
Reel Deal's Avatar
Reel Deal Reel Deal is offline
I'm on a boat
 

Join Date: May 2005
Location: NE Fla
Posts: 6,651
Blog Entries: 3
Reel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep Points
Default

Finally getting around to reading this after my Cali trip... thanks TP and de-coder, this is very interesting stuff.

And BL, you really, really need to learn how to deal with people w/o being a complete ass... trust me, it will help you later in life when you eventually crawl out from the bowels of your parent's basement.
__________________
GO GREEN!!! GO WHITE!!!
  #38  
Old 08-02-07, 12:44 PM
de-coder's Avatar
de-coder de-coder is offline
Talking Poker League Champion
 
Join Date: May 2006
Location: Toronto, On
Posts: 1,248
de-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Pointsde-coder has between 1000 and 1499 Rep Points
Default

No other guesses on this?

TP guessed 42% - anyone else?
  #39  
Old 08-02-07, 03:19 PM
Reel Deal's Avatar
Reel Deal Reel Deal is offline
I'm on a boat
 

Join Date: May 2005
Location: NE Fla
Posts: 6,651
Blog Entries: 3
Reel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep PointsReel Deal has between 3000 and 3499 Rep Points
Default

62%
__________________
GO GREEN!!! GO WHITE!!!
  #40  
Old 08-02-07, 03:45 PM
meanness meanness is offline
Shark
 

Join Date: Apr 2006
Posts: 937
meanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Pointsmeanness has between 750 and 999 Rep Points
Default

Good thread, thanks for the work.

I don't have any data, but I'm sure my 5% guess was strongly influenced by the way I was running at the time, and not truly representative of the general trend. Thanks to this thread, I've been experimenting a lot more with raising the donk bettor.

On a drawy board, I'm starting to find more success - not with the initial fold, at $100NL anyway - but if the turn blanks and I fire again, I'm winning the pot consistently.
  #41  
Old 08-02-07, 04:14 PM
Talking Poker's Avatar
Talking Poker Talking Poker is offline
Adminimus Maximus
 
Join Date: Oct 2004
Location: Florida Coast
Posts: 27,480
Talking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep PointsTalking Poker has between 3000 and 3499 Rep Points
Default

Exactly.

Nice to know that not everyone finds this thread useless.
__________________

Got RakeBack?
27% at Full Tilt | 33% at Cake Poker | 30% at Carbon Poker
Closed Thread


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 07:37 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2004-2008 TalkingPoker.com