Hour Weekday Heatmap Export

"Which hour is best" and "which hour is calm" are two different questions that a single average-return-by-hour table quietly conflates: a quiet grinding hour and a wild whipsaw hour can average out to the same mean return while behaving nothing alike to trade. This script walks historical bars on the chosen symbol and timeframe, buckets each bar by its weekday and hour (server time), and reports two grids instead of one - mean close-minus-open return, and mean high-minus-low range, both converted to pips - so the two questions stay visible side by side rather than being collapsed into one number. Both grids are written into the same CSV, one after another with a blank row between, columns ordered Monday through Sunday for a trader-friendly sheet even though the underlying MQL4 weekday numbering starts at Sunday. Pasting either grid into a spreadsheet and applying a colour scale across the 24x7 block turns it into a heatmap with no further transformation needed. Notes and limitations Hour and weekday are read from the bar's OPEN time in the broker's SERVER time - not GMT, and not the timezone of whoever is reading the export. Cells with zero bars observed are left blank in the CSV rather than shown as a misleading 0.00. Only whole bars fully inside the lookback window are counted - a bar whose open time falls before the cutoff simply stops the walk, it is not partially counted. Mean range (high-low) is not the same as volatility in the statistical sense; it is a simple average of each bar's own high-low spread, which can be dominated by a handful of unusually wide bars in a small sample. Widen InpLookbackDays for a steadier picture on lower timeframes.

Script · MT4 · v1.0 · Free

Tags: Alerts · MT4 Script · MQL4 Source Code

MQL4 & MQL5 scripts · PolyMaria