BullCharts Forum Homepage
Forum Home Forum Home > BullCharts > BullScan
  New Posts New Posts RSS Feed: Moving Average Scans
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Moving Average Scans

 Post Reply Post Reply
Author
Message / View First Unread Post
maximo View Drop Down
BullCharts Guru
BullCharts Guru
Avatar

Joined: 02 Sep 2006
Location: Australia
Posts: 232
Post Options Post Options   Quote maximo Quote  Post ReplyReply Direct Link To This Post Topic: Moving Average Scans
    Posted: 16 Aug 2008 at 7:24pm
I have noticed BKN and other stocks that have had a trading halt on just 1 day a few months back and they do not turn up in scan results concerning Moving Averages.
 
eg. Close above 200 MA.
  BKN does not appear in results.
 
Any stocks that have had a halt in the last 200 days are invalidated, so is there a work around for this?  Like some option to include these?
 
Back to Top
peter1 View Drop Down
Regular
Regular


Joined: 27 Aug 2008
Location: Sydney
Posts: 56
Post Options Post Options   Quote peter1 Quote  Post ReplyReply Direct Link To This Post Posted: 27 Aug 2008 at 9:49pm
Thanks for posting this maximo. I would like to see this problem fixed also.
 
I look for closes above 10d, 30d XMA as one of my main screening tools. I have often wondered how I could have missed seeing some charts.
Back to Top
maximo View Drop Down
BullCharts Guru
BullCharts Guru
Avatar

Joined: 02 Sep 2006
Location: Australia
Posts: 232
Post Options Post Options   Quote maximo Quote  Post ReplyReply Direct Link To This Post Posted: 31 Aug 2008 at 8:25pm

Hi Peter1,

Did some work on this and have found a couple of remedies, also made an
insufficient data checker indicator to display where the missing bars are, which
all look to be trading halts.   Load symbol XAO and you can insert the
security eg. QGC BKN in a lower pane to compare them.

{ Insufficient Data Checker Indicator }
[description="Flags Missing Data, compare to XAO"]

method := inputma("Method",S);

period:= input("Period",200,1);

symb := inputsymbol("Compare bars to", "QGC");

stock:=LoadSymbol(symb,C);

[target=price; color=aqua; width=2]

ma(C,period,method);

[color=Crimson]

[Name=" "; linestyle=Marker; marker=short]

if(stock=0,1,0);

[linestyle=Text; textalign=Above,Center]

if(stock=0,"MISSING",undefined);

High;


Now for the remedies..  You could just scan weekly that'l work eg. 41 weekly
appears to be equivalent to a 200day MA.  Hardly elegant, but it works.
Alternatively you can add this indicator which only calculates the Moving Average
on the last bar of the chart. Then select 'indicator signal' to use it in a scan,
that seems to get around it.

{ Moving Average Insufficient Data bypass surgery }

[description="Include scanning of stocks with insufficient data"]

method := inputma("Method",S);

period:= input("Time periods",200,1);

dataOk := isdefined(C) and C > 0; { does not work because no zero data to be found }

[Target=price; linestyle=points; color=blue]

if(barnumber=lastvalue(barnumber) AND C>ma(C,period,method),ma(C,period,method),undefined);

[linestyle=marker; marker=type2; name=x]

condition:=if(barnumber=lastvalue(barnumber) AND C>ma(C,period,method),1,0);

condition;



Edited by maximo - 03 Sep 2008 at 5:14am
Back to Top
maximo View Drop Down
BullCharts Guru
BullCharts Guru
Avatar

Joined: 02 Sep 2006
Location: Australia
Posts: 232
Post Options Post Options   Quote maximo Quote  Post ReplyReply Direct Link To This Post Posted: 31 Aug 2008 at 9:07pm

oo nope still not working on daily... must have been testing on weekly.. will find a way to do that soon.   I have in mind just to sum the data into a variable and divide by the period input to get a  simple MA result and use that as an indicator signal.   Should work in theory... as i suspect it's an internal dummy spit by the ma() function.

 
   


Edited by maximo - 03 Sep 2008 at 5:17am
Back to Top
peter1 View Drop Down
Regular
Regular


Joined: 27 Aug 2008
Location: Sydney
Posts: 56
Post Options Post Options   Quote peter1 Quote  Post ReplyReply Direct Link To This Post Posted: 07 Sep 2008 at 1:27pm
Thanks again. Trading halts, 0 volume days should not cause a problem.
It is a problem with the programming and we should not have to work around it. It should be a high priority item to be fixed as the scan for closes above an MA is a very common scan.
 
Back to Top
peter1 View Drop Down
Regular
Regular


Joined: 27 Aug 2008
Location: Sydney
Posts: 56
Post Options Post Options   Quote peter1 Quote  Post ReplyReply Direct Link To This Post Posted: 03 Jan 2009 at 7:15pm
Another one, this time TTS does not show up in close >200 daily sma scan.

It shows up in >200exponential ma scan but not simple ma scan.
It shows up in all <185d sma scans

Back to Top
maximo View Drop Down
BullCharts Guru
BullCharts Guru
Avatar

Joined: 02 Sep 2006
Location: Australia
Posts: 232
Post Options Post Options   Quote maximo Quote  Post ReplyReply Direct Link To This Post Posted: 04 Jan 2009 at 1:29pm
This could be fixed either with a software update or fixing the data.
 
ie. LNC showed up in above 200sma scans from 10/10/2008 because it was
    included as a zero volume day.   It did not trade that day but they chose
   to include that day in data,  which also works. 
 
 
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Bulletin Board Software by Web Wiz Forums® version 9.69
Copyright ©2001-2010 Web Wiz