Within 1% to Moving average

Viewing 7 posts - 1 through 7 (of 7 total)

Author

Posts
11/22/2016 at 3:36 PM #16956 quote

Hockeytrader
Participant

Junior

Hi friends. I wanna make a screener for stock thats within 1% from a moving average. I just can’t make myself clear about how to 1% code should be.

11/22/2016 at 5:28 PM #16960 quote
Nicolas
Keymaster

Legend
It should look like this:
```
percent = abs(close-average[20])/close*100

return percent 
```
price-percent-from-moving-average.png
11/27/2016 at 1:10 PM #17306 quote

Hockeytrader
Participant

Junior

It says return can only be used in trading systems. Can you help me build the screener?

11/27/2016 at 2:03 PM #17313 quote

GraHal
Participant

Master

Hi Hock Replace Return with Screener (Nicolas was just testing us! :)) Cheers GraHal

12/04/2016 at 10:00 PM #17788 quote

Hockeytrader
Participant

Junior

Thanks! But i can’t make it work. Can you help me do the screener?

12/05/2016 at 9:21 AM #17794 quote
Nicolas
Keymaster

Legend
Yes, please find below the screener of your request:
```
percent = abs(close-average[20])/close*100>=1

screener [percent] 
```
It will detect and sort out all shares with Close more or equal to 1% from the moving average 20 periods.
12/05/2016 at 11:47 AM #17814 quote
GraHal
Participant

Master
I nearly always want to see the ‘value’ on a Screener, so if you add / amend as below then you can see what the percentage from MA is.
```
percent = abs(close-average[20])/close*100>=1

screener [percent]  (abs(close-average[20])/close*100 as "percent from MA")
```
Nicolas thanked this post
Author

Posts