Trading Sheet Metrics Automation

I maintain a Google Sheet that logs three full years of trades; every entry, exit, R factor and P/L % is already in place. What I now need is a layer of performance analytics that recalculates dynamically while I filter the sheet by any date window I choose.

The first additions are a Sharpe ratio, period returns, and a live draw-down column that references the existing P/L % field. The draw-down must track the running equity peak and show the percentage decline from each new high—updating the moment fresh data is entered.

I also want the standard deviation of my R-factor distribution displayed the same way my P/L distribution is, and all of these statistics have to respond instantly when I set a custom date range via start/end cells or a simple picker.

Using native Google Sheets functions (QUERY, FILTER, ARRAYFORMULA, etc.) or a lightweight Apps Script is fine as long as everything remains in-sheet and transparent. Inline comments or brief documentation explaining the formulas or script blocks will be part of the hand-off.

Deliverables
• Updated Google Sheet (or copy) containing:
 – Sharpe ratio calculation tied to date filter
 – Return metrics for any selected period
 – Live draw-down metric driven by running equity high
 – Standard deviation of R factors, date-aware
• Clear cell or script comments for future auditing

Acceptance criteria
– All stats adjust correctly in real time when a different date range is applied
– Sharpe ratio and returns match manual spot checks
– Draw-down resets only when a new peak occurs
– No external add-ons or offline tools required