Rakeback for a different timeframe (cashgame)

[damncute]

Hi guys,

I am looking for a way to include different rakeback % for different times of the year. For example, from January to March I get 50% and 30% for the rest of the year. Is it possible to show this in one graph? I've been searching the whole morning, but couldn't find anything usefull.

Thanks in advance for any help!

Regards,
Chris

[kraada]

You could have your stat test for the date the hand was played and assign a different value of rake to that time frame, but it could be a bit complicated to work out. What site is this for?

[damncute]

It's for 888 (Pacific Network).

I've found this thread :

https://www.pokertracker.com/forums/vie ... hp?t=37445

But this is only for tournaments.

[kraada]

The same methods will work; the date played for a hand is cash_hand_player_statistics.date_played. You can see the different rake valuations in the amt_rake_* columns in the Configure -> Statistics -> $ -> Columns area.

[damncute]

Thanks kraada! I'll try it later and let you know how it worked.

Regards,
Chris

[damncute]

Okay, this is how it looks like after my adjustments:

sum(if[cash_hand_player_statistics.date_played >= 'January 01 2013'::timestamp AND cash_hand_player_statistics.date_played <= 'January 07 2014'::timestamp, amt_rb_ftp * .25 + amt_rb_888 * .29, if[cash_hand_player_statistics.date_played >= 'January 08 2013'::timestamp, amt_rb_ftp * .25 + amt_rb_888 * .18, 0]])

But I always get "The Statement is not valid SQL" (Summary Type = Sum). I guees it's just a small misstake somewhere in the formula? The stats "amt_rb_ftp" and "amt_rb_888" are custom stats I've made myself.

[kraada]

You can't use columns within other columns like that. You need to alter the amt_rb_888 and amt_rb_ftp values to be based on the timestamps.

[damncute]

Thanks again, kraada. Great!!

sum(if[cash_hand_summary.id_site=900 AND cash_hand_player_statistics.date_played <= 'January 07 2014'::timestamp,(((cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 0.38)), if[cash_hand_summary.id_site=900 AND cash_hand_player_statistics.date_played >= 'January 08 2014'::timestamp,(((cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 0.18)),0]])

Expression is fine now and I don't get any error. But, now it always takes the 18%, even for hands before 08 January. What did I miss here? Maybe something wrong with the timestamp?

[kraada]

It certainly looks like it should work from that definition. How are you testing the results on the older hands?

[damncute]

I just changed the date time filter from 08 January to 07 January and it uses the same % for both dates.