scanman77
2 posts
msg #121031
- Ignore scanman77 |
7/17/2014 3:22:22 AM
hello to all
i'm looking for a filter that screen last x days average between a range
example last price is in +/- 5 % average price 7 days price
last price is is in +/- 10 % average price 30 days price
i write this but I'm not sure perform well
set{avg_chg,sum(day change,7) / 7}
avg_chg below 5
add column avg_chg
set{avg_chga,sum(day change,30) / 30}
avg_chga below 10
add column avg_chga
set{avg_chgb,sum(day change,120) / 120}
avg_chgb below 15
add column avg_chgb
|