Hi,

Would like to build a backtestable screen looking for moving average prices. Specifically,  to find when a growing 50 moving average is higher thaa a 200-day moving average ("bulish cross"). How can I build this screen?


Attach file (image (.gif, or .jpg), screen (.und) or report (.rpd))
jclifton
at 05/14/19 10:58 PM : RE: moving avgs

Norman
at 05/28/19 7:50 PM : RE: moving avgs

jclifton
at 05/14/19 9:39 PM : RE: moving avgs

Thomas
at 02/07/12 8:53 PM : RE: moving avgs

J Schaefer
at 03/12/12 5:08 PM : RE: moving avgs


Okay, I figured it out pbanados,

Go to File>Open Database>DBDP-Historical Daily Prices

Press OK

Open Calculation Expression (Screen>Screen by Calculation Expression)

Using the Calculation Expression screen create the following:

[C] MovingMean50(i6) > MovingMean200(i6)

[C] MovingMean50(i6[Recent-1D]) < MovingMean200(i6[Recent-1D])

That should do it. Press OK to insert the into the screener.

Unfortunately, this is not back-testable because we are using Historical Daily Prices.  If you want it back-testable I understand you need to use DBCMHIST - Weekly Historical data.  Your moving means then would be for 10 weeks and 40 weeks.  However, this probably won't give you the exact day when the moving averages cross.


Attach file (image (.gif, or .jpg), screen (.und) or report (.rpd))

For questions or more information or to Order Today, call 1-800-767-3771, ext. 9392 or 1-312-630-9890, ext. 9392
You can also e-mail our Sales Support at: kevinm@zacks.com
Copyright 2012
Zacks Investment Research
111 N. Canal St., Suite 1101, Chicago, IL 60606
(800) 767-3771 ext. 9392