I am trying to build a chart based on a simple scan of Moving averages of the whole market. I mean that I want to run my scan of 7000 tickers and find out how many stocks have a certain MA over another MA then take that result and chart it showing past results.
Is there anyway to do this simply or am I going to have to program each day manually to get past results?
It seems to me that I can do it the hard way such as .....
(Mov(C, 1, E)> Mov(C, 2, E)) then run a scan
(Ref(Mov(C, 1, E), -1)> (Ref(Mov(C, 2, E)), -1)
(Ref(Mov(C, 1, E), -2)> (Ref(Mov(C, 2, E)), -2)
(Ref(Mov(C, 1, E), -3)> (Ref(Mov(C, 2, E)), -3)
etc
etc
and have it count the number of hits of each scan result to give a chart point. I don't know how to get it to count the results without copying each scan result and then exporting into excel so I can get a clean count, then import it back into MetaStock so I can chart it.
It seems I should be able to do this and tell it to run this going back a year or two without having to do 365 inputs, export, import etc etc. Am I missing something?
I am now running MetaStock 8.
TIA and Good Luck,
Lee |
