Averages v100

Build: 2026-05-18 10:30 — improved CSV/chart filenames with ticker + selected years

Upload a CSV with at least date, open, and close columns.

averageXp = (current open / average close from previous Xp rows) - 1
Xp = 5, 21, or 63. Example: -0.05 means open is 5% below the previous average.

Status: page loaded. Choose a CSV file, then tap Load CSV / Show Years.

Diagnostics: script initialized.

Select Years

All years are selected by default. Output includes only selected years. Calculations can use earlier rows, including up to 63 prior rows before the selected year.

Combined Average Chart

average5average21average63

Separate Average Charts

average5

average21

average63

Lowest 100 average5 — Ordered by Date

These are the 100 lowest average5 rows from the selected output years, then sorted by date so you can inspect them chronologically.

Date	average5	average21	average63

Calculation Audit — First 100 Output Rows

Date	Open	Close	AvgPrev5	average5	AvgPrev21	average21	AvgPrev63	average63