PDA

View Full Version : Coinflips. Can create report by SQL?



alexoxol
04-02-2010, 11:16 AM
Hello.
I created SQL query from HM DB, it shows our coinflip's luck in tournaments. But I've never created custom reports in HM. Can someone create report by my SQL?


SELECT date(ph.handtimestamp) as date,
ph.numberofplayers as players,
cast(hc.holecardstring as char(3)) as cards,
gt.smallblind/100+gt.bigblind/100+(gt.ante/100*ph.numberofplayers) as M,
CASE
WHEN gt.smallblind/100+gt.bigblind/100+(gt.ante/100*ph.numberofplayers) between 0 and 150 THEN 'M = (0-150)'
WHEN gt.smallblind/100+gt.bigblind/100+(gt.ante/100*ph.numberofplayers) between 151 and 700 THEN 'M = (151-700)'
WHEN gt.smallblind/100+gt.bigblind/100+(gt.ante/100*ph.numberofplayers) between 701 and 2000 THEN 'M = (701-2000)'
WHEN gt.smallblind/100+gt.bigblind/100+(gt.ante/100*ph.numberofplayers) between 2001 and 5000 THEN 'M = (2001-5000)'
WHEN gt.smallblind/100+gt.bigblind/100+(gt.ante/100*ph.numberofplayers) >= 5001 THEN 'M = (5001+)'
ELSE NULL
END as Tourn_level,
allin.equitypct/10 as equity,
CASE
WHEN (((ph.netamountwon/100.00)/(gt.smallblind/100.00+gt.bigblind/100.00+(gt.ante/100.00*ph.numberofplayers)))-((allin.sklanskybucks/100.00)/(gt.smallblind/100.00+gt.bigblind/100.00+(gt.ante/100.00*ph.numberofplayers)))) > 0 THEN 1
ELSE 0
END as Won,
CASE
WHEN (((ph.netamountwon/100.00)/(gt.smallblind/100.00+gt.bigblind/100.00+(gt.ante/100.00*ph.numberofplayers)))-((allin.sklanskybucks/100.00)/(gt.smallblind/100.00+gt.bigblind/100.00+(gt.ante/100.00*ph.numberofplayers)))) < 0 THEN 1
ELSE 0
END as Lost
FROM playerhandstourneykeycolumns_hero ph left join allinsituations_hero allin on ph.playerhand_id = allin.playerhand_id left join holecards hc
on ph.holecardvalue_id = hc.holecard_id left join gametypes gt on ph.gametype_id = gt.gametype_id left join pokerhands_hero pokh on ph.pokerhand_id = pokh.pokerhand_id
where allin.equitypct/10 between 43 and 57 and ph.streetwentallin = 1 and pokh.numberofplayerssawflop = 2 and (allin.equitypct/10) > -100
and (((ph.netamountwon/100.00)/(gt.smallblind/100.00+gt.bigblind/100.00+(gt.ante/100.00*ph.numberofplayers)))-((allin.sklanskybucks/100.00)/(gt.smallblind/100.00+gt.bigblind/100.00+(gt.ante/100.00*ph.numberofplayers)))) not between -0.5 and 0.5
order by ph.handtimestamp

Columns:
date, players at the table, your cards, M digit, M range, Won (1 if won coinflip, 0 otherwise), Lost (1 if lost coinflip, 0 otherwise). WHERE clause includes just situations where you went allin on preflop with only one opponent, had from 43 to 57 percent on win and result is not like sklanskybucks (because it is split pot situations).
Maybe someone need this script.

fozzy71
04-02-2010, 11:46 AM
I have forwarded this thread to the developer and tech-team for a reply.

The Minder
04-02-2010, 10:10 PM
OP... don't loose track of this requirement. This type of report is vital to all tourney players so they can analyze their decisions.

If we could ever get a report writer done for HM, issues like this would go away... fast.

Good work Sir.

Rvg72
04-03-2010, 02:45 PM
I'll build this report for you and document how it was done which should help a little until we do have a real report builder tool.

Thanks,
Roy

alexoxol
04-03-2010, 03:10 PM
I'll build this report for you and document how it was done which should help a little until we do have a real report builder tool.

Thanks,
Roy

Thanks a lot.

alexoxol
04-13-2010, 03:32 PM
I'll build this report for you and document how it was done which should help a little until we do have a real report builder tool.

Thanks,
Roy

any news, Rvg? ;)

mckrogh
04-21-2010, 05:09 AM
bump

The Minder
05-03-2010, 01:31 AM
can we get some input from RVG on this?... should we wait? can we get an ETD?

fozzy71
05-03-2010, 11:34 AM
I have emailed Roy a reminder.

The Minder
05-15-2010, 09:29 PM
Perhaps we could email Roy asking him to read his emails?

The Minder
06-08-2010, 08:14 PM
I'd bump this, but would hate to step on anyone's toes.

signuptoday
07-14-2010, 12:38 PM
update?

The Minder
07-28-2010, 04:24 AM
I think this request can officially be laid to rest. Ain't gonna happen.