How to record statistics and analyze your sessions
1) Purpose of accounting
Check discipline (stop losses/teik profits, time limits).
Understand the risk profile of slots (volatility in fact, length of "empty" series, cost of bonus).
Cut off unprofitable patterns (dogons, prolonged sessions).
Don't try to "predict" your backs - statistics are needed for management decisions, not fortune telling.
2) What to fix during the session (mandatory minimum)
Session Card:
- Date/time (start-finish), provider, slot, declared RTP/volatility (from the operator's game passport), bet, mode (mobile/desktop).
- Session budget, stop loss, break profit, spin/time limit.
- Total spins, auto-game (yes/no), change of rate (when and why).
- Top events: each bonus (back number, × size), major hits (≥20×), series of "empty" (length).
- Final: balance of the session, maximum drawdown (MDD), triggers achieved (which), state of emotions (tilt/calm).
3) Table template (copy to Google Sheets/Excel)
CSV header:
- ```
- date,provider,slot,rtp_declared,volatility,bet,session_budget,stop_loss,take_profit,spin_limit,time_limit_min,
- spins_total,autoplay,stake_changes,bonuses_count,bonus_spins_list,bonus_payouts_x_list,top_hits_x_list,
- dead_streaks_list,turnover,total_payout,balance_change,peak_balance,low_balance,mdd,trigger_hit,tilt_flag,notes
- ```
Explanations:
- 'turnover '=' bet × spins_total' (subject to actual rate changes).
- 'mdd '(max drawdown) =' peak _ balance − low_balance' during the session.
- '* _ list' store through ";" (example: '15: 82x; 240: 35x`).
4) Key metrics and formulas
Actual RTP (session): 'RTP _ real = total_payout/turnover'.
Session ROI: 'ROI = balance_change/turnover'.
Hit rate: 'hits/ spins_total'. (If you don't count all the hits, count ≥1× or ≥0. 2 × according to its own rule.)
Bonus frequency: 'bonuses _ count/ spins_total'.
Average bonus price (in backs): 'spins _ total/ bonuses_count' (if' bonuses _ count> 0 ').
Wed. bonus win (×): 'AVG (bonus_payouts_x_list)'.
Average major hit (×): 'AVG (top_hits_x_list)'.
MDD (Max Drawdown): 'max (peak_balance − Current Balance)' along the path.
Turnover per hour (for rate estimation): 'spins _ per _ hour × average rate'.
Normalization: Enter the column'x _ win = payout/ bet_at_spin' to compare sessions with different rates.
5) Rolling windows (for operational solutions)
HR100: hit rate for the last 100 spins.
BF200: frequency of bonuses for the last 200 spins.
RTP100: actual RTP on the last 100 spins (rough indicator of "protracted minus" for the foot).
Streak\_ max is the longest run of empty spins in the current session.
Rule: any of the predefined thresholds worked (drawdown, spin/time limit, BF200 "too long without bonus," Streak\_ max over the limit) - immediate exit.
6) Beer/slices for analysis after week/month
Make PivotTables by:
- Slots/providers/volatility: median 'RTP _ real', 'ROI', 'BF' (spin/bonus), 'MDD' and 'average session duration'.
- Time of day/days of the week: for self-control - where there is more tilt and violation of stops.
- Game mode (mobile/desktop), auto-game: does it affect discipline and MDD.
- Rate size: does MDD also increase the proportion of foot disorders with an increase.
Interpretation: keep the choice on disciplinary conclusions (for example, "I break my feet on mobile 2 times more often → play only with a PC"), and not on an attempt to "calculate happy hours."
7) Practical thresholds (landmarks)
Stop-loss from the session: low volatility 20-25%, average 30-40%, high 50-60%.
Take-profit: record + 40-60% of the session (at least part of the profit).
Spin limit: low 150-250, medium 250-400, high 400-800.
No bonus for too long: exit after ~ 1. 5× / 2× / 2–2. 5 × your "normal" distance (low/medium/high).
Empty series: stop if> 3 × of your average interval between hits.
Tilt markers: speed up clicks, raise the rate "to beat off," skip pauses - stop tap.
8) Mini-accounting roadmap
1. Before starting: fill in the goal card (rate, budget, stops, limits).
2. During the game: record numbers and bonus ×, major hits, empty series, bet changes.
3. After the session: close the turnover, total\_ payout, RTP\_ real, MDD fields, mark the triggers/tilt.
4. Once a week: Update beers, remove slots/modes where you systemically disrupt your feet or get extreme MDD.
9) Examples of formulas for Excel/Sheets
'turnover = SUMPRODUCT (SpinsRange, BetRange) 'or simply' bet * spins _ total'if bet is fixed.
`RTP_real = total_payout / turnover`
`ROI = balance_change / turnover`
`BF = bonuses_count / spins_total`
'MDD ': Calculate cumulative PnL over spins and use'MAX (rolling_peak - cumulative_pnl)'.
10) Discipline metrics
% of sessions closed as planned (= limit/trigger → stop reached) - target ≥90%.
Average session duration vs planned - growth = tilt risk.
The share of sessions with a change in the rate in the minus series - should tend to 0.
11) Typical accounting errors
"I write everything" → overload, throw tracking. Leave only what influences decisions.
No × normalization - compare sessions with different rates like apples with oranges.
Slot evaluation for 1-2 sessions - outliers. Keep the horizon at least 2-3 thousand spins per game for any conclusions.
Fitting thresholds "in situ." Thresholds are fixed before the start.
12) Ready-made template "Session Plan"
Slot/Provider/RTP Version : \_\_\_\_\_\_\_\\_
Rate and Budget : \_\\_\_\_\_\_\_\\_
Stop-loss: \_\_\_\_\_% | Take-profit: \_\_\_\_\_% |
---|---|
Limit :\_\_\\_\_\_ spin/\_\_\_\\_ _ minutes | |
"No bonus - I go out after" :\_\_\_\_\\_ spins | |
Empty series - stop :\_\_\_\_\\_ | |
Emotion triggers - stop: tilt/dogon/rush |
Result
Accounting is the minimum log + clear metrics + regular beers. Record only influencing decisions, read RTP\_ real/ROI, frequencies of hits and bonuses, MDD, monitor discipline. Use rolling windows for operational stops and once a week clean the pool of slots and scenarios where you systematically violate the plan. This reduces losses and removes tilt - the only reliable "boost" of the result at a distance.