适用周期: 月线
公式代码:
#按月份统计
m:=STATS_BY(MONTH(TS()))
#上涨占比，按降序
up_ratio=↓STATS_RATIO(RC()>0)
#平均涨幅
rc_avg=STATS_AVG(RC())
#上涨占比输出为百分比表示
up_percent:=PERCENT(up_ratio,2)
#平均涨幅输出为百分比表示
rc_percent:=PERCENT(rc_avg,2)结果示例:
| m | up_percent | rc_percent |
|---|---|---|
| 2 | 66.91% | 5.77% |
| 11 | 59.14% | 4.54% |
| 7 | 51.35% | 2.45% |
| 5 | 51.27% | 3.53% |
| 3 | 50.04% | 3.06% |
| 10 | 48.55% | 2.71% |
| 6 | 47.12% | 0.34% |
| 9 | 46.07% | 2.17% |
| 8 | 45.2% | 0.97% |
| 12 | 39.37% | -0.18% |
| 1 | 37.22% | -3.58% |
| 4 | 37% | -1.38% |