Scanner to find distance between price and moving average?

[YungTraderFromMontana]

Does anybody have code for a scan that can filter by a stocks distance from a MA? For Example .5% away from 200 SMA (simple moving average).

 

[mc01439]

Does anybody have code for a scan that can filter by a stocks distance from a MA? For Example .5% away from 200 SMA (simple moving average).

P is greater than .50 would be the scan.

#start code
# define the percent difference of close - 200SMA

def a = Average(close, 200);
def d = close - a;
plot p = (d / close) * 100;

#end code

This would be the results for the S&P 100.

Watchlist Scanner
Results
Symbol	Description	SMA Diff
TGT	TARGET CORP COM	23.18​
LMT	LOCKHEED MARTIN CORP COM	15.94​
NEE	NEXTERA ENERGY INC COM	14.97​
PG	PROCTER & GAMBLE CO COM	14.49​
SO	SOUTHERN CO. COM	14.45​
COST	COSTCO WHOLESALE CORP COM	14.38​
AAPL	APPLE INC COM	14.01​
T	AT&T INC COM	13.92​
HD	HOME DEPOT INC COM	13.73​
QCOM	QUALCOMM INC COM	13.62​
AIG	AMER INTL GRP INC COM	13.16​
TXN	TEXAS INSTRUMENTS INC COM	12.99​
WMT	WALMART INC COM	12.39​
SBUX	STARBUCKS CORP COM	12.11​
MSFT	MICROSOFT CORP COM	11.79​
MDT	MEDTRONIC PLC COM	11.77​
CHTR	CHARTER COMMUNICATIONS INC COM CL A	11.36​
AGN	ALLERGAN PLC. COM	11.26​
MA	MASTERCARD INCORPORATED COM CL A	11.23​
ALL	ALLSTATE CORP COM	10.89​
DHR	DANAHER CORP COM	10.25​
RTN	RAYTHEON CO COM	9.88​
MDLZ	MONDELEZ INTL INC COM CL A	9.81​
NKE	NIKE INC COM CL B	9.72​
UPS	UNITED PARCEL SERVICE INC COM CL B	9.42​
ACN	ACCENTURE PLC COM	9.01​
V	VISA INC COM CL A	8.9​
CMCSA	COMCAST CORP COM CL A	8.79​
KO	COCA-COLA CO COM	8.7​
PEP	PEPSICO INC COM	8.55​
CELG	CELGENE CORP COM	8.13​
GOOG	ALPHABET INC COM CL C	7.83​
JPM	JPMORGAN CHASE & CO. COM	7.71​
GOOGL	ALPHABET INC COM CL A	7.54​
MCD	MCDONALD'S CORPORATION COM	7.48​
DUK	DUKE ENERGY CORP COM	7.45​
BKNG	BOOKING HOLDINGS INC COM	7.4​
UTX	UNITED TECHNOLOGIES CORP COM	7.4​
LOW	LOWE'S COMPANIES INC COM	7.24​
USB	US BANCORP COM	7.24​
C	CITIGROUP INC COM	6.23​
GD	GENERAL DYNAMICS CORP COM	6.22​
BA	BOEING CO COM	5.65​
COF	CAPITAL ONE FINANCIAL CORP COM	5.46​
IBM	INTERNATIONAL BUS MACH CORP COM	5.44​
VZ	VERIZON COMMUNICATIONS COM	5.43​
CL	COLGATE-PALMOLIVE CO COM	5.3​
GS	GOLDMAN SACHS GROUP INC COM	5.01​
KMI	KINDER MORGAN INC COM	4.94​
ABT	ABBOTT LABORATORIES COM	4.72​
CVS	CVS HEALTH CORPORATION COM	4.36​
HON	HONEYWELL INTERNATIONAL INC COM	4.19​
AXP	AMERICAN EXPRESS CO COM	4.12​
AMGN	AMGEN INC COM	4.09​
MRK	MERCK & CO INC COM	4.04​
BMY	BRISTOL-MYERS SQUIBB CO COM	3.98​
DIS	WALT DISNEY COMPANY (THE) COM	3.7​
FB	FACEBOOK INC COM CL A	3.03​
BAC	BANK OF AMERICA CORPORATION COM	2.83​
WFC	WELLS FARGO & COMPANY COM	2.74​
INTC	INTEL CORP COM	2.64​
MET	METLIFE INC COM	2.62​
EXC	EXELON CORP COM	2.55​
BLK	BLACKROCK INC COM	2.43​
ORCL	ORACLE CORP COM	1.95​
BRK/B	BERKSHIRE HATHAWAY INC COM CL B	1.17​
PYPL	PAYPAL HOLDINGS INC COM	0.66​
CVX	CHEVRON CORPORATION COM	0.53​

 

[YungTraderFromMontana]

Thanks