Data analysis/stats - Spreadsheet/correlation analysis

---

I'm looking for a dashboard, where i input ongoing back testing data, in various time-based increments (30S, 1M, 2M, etc), for both long and short trades, that would take a weekly 5-day PnL, and then compare that most recent period against the rolling previous 10d, 20d, 40d periods, with a red-yellow-green coded signal, based on predefined percentage. This could be done in excel or python. more interested in ease of data input and flexibility if I'd like to expand functionality over time (not in this assignment).

Keyword: Python

Exploratory Data Analysis Data Analysis Microsoft Excel Statistics