Source for Full-holdout metric auditSource: GP metric audit rowsFile: diagnostics/gp_metric_audit.sqlShapes the reviewed full-holdout metrics and benchmark interpretations into an audit table.
SELECT * FROM (VALUES (1, 'Displayed accuracy', '88.63%', 'Defined as 100 - sMAPE', 'Not a probability of a correct price or direction'), (2, 'Mean absolute error', 'BDT 32.27', 'Last-price MAE: BDT 31.81', 'Worse than the naive forecast'), (3, 'Skill vs last price', '-1.46%', 'Positive is better', 'No baseline-beating skill'), (4, 'Directional accuracy', '46.82%', '50% is a rough binary reference', 'No useful directional evidence in this run'), (5, 'R-squared', '-0.028', 'Zero is the holdout-mean reference', 'Explains no useful holdout variation'), (6, 'Q10-Q90 coverage', '4.52%', 'Nominal: 80%', 'Severely under-dispersed uncertainty'), (7, 'Price range', 'Predicted BDT 6.96', 'Actual BDT 157.00', 'Forecast path is genuinely flat at the full scale')) AS t(rank, metric, observed, benchmark, diagnosis) ORDER BY rank