Originally Posted by: calisto77

I set up a basic scan  Macd() <0 AND Macd()>Ref(Macd(),-1)

(off the top of my head - think it's right)

Macd under 0 & higher than last bar ( rising)

but the scan results  show some Macd over 0   etc  inconsistant I also have a filter  for each Col=1 and a $ volume min

how can I tighten up the code  to have the results as asked?

should I make the Macd into 2 separate Col's ?

advice appreciated

The =1 should be optional (meaning you can just write ColA AND ColB AND ColC) but it would help to see the actual Filter formula in its entirety. Based on your initial formula you should not be seeing any instrument with a MACD above 0, which leads me to believe there must be something slightly off in the Filter, perhaps a Boolean issue/issue with parentheses.

I just ran this formula and it passed about 10% ( ~ 200 !! )

with a weekly chart inc Macd & Stoc

result included a mixture of Stoc >50,  Macd above 0,  chart with 200MA, chart with no indicators  etc 

a real bag of tricks not no accuracy

Stoch(34,3) < 30 MACD() <0 AND MACD() >= Ref(MACD(),-1)

filter ==   colB AND colC =1 AND (C*V)>=50000  ( min $50000 volume)

I'd be interested in your thoughts to sharpen it up

thanks

Originally Posted by: calisto77

the formula didn't come out correctly

it should be separately

ColA   Stoch

ColB  Macd

Hi again,

What are the exact formulas within Column B and Column C? It is hard to say where the formula might be failing, but also are you comparing MACD being > 0 in a chart or in an exploration column? If you are comparing MACD in the chart, you could have different Load records which could affect the value of MACD between your exploration and what you see in the chart.

Originally Posted by: calisto77

Originally Posted by: calisto77

I just ran this formula and it passed about 10% ( ~ 200 !! )

with a weekly chart inc Macd & Stoc

result included a mixture of Stoc >50,  Macd above 0,  chart with 200MA, chart with no indicators  etc 

a real bag of tricks not no accuracy

Stoch(34,3) < 30 MACD() <0 AND MACD() >= Ref(MACD(),-1)

filter ==   colB AND colC =1 AND (C*V)>=50000  ( min $50000 volume)

I'd be interested in your thoughts to sharpen it up

thanks

as I said, the code  above didn't come through properly

ColB =  Stoch(34,3) < 30

ColC = MACD() <0 AND MACD() >= Ref(MACD(),-1)

filter =  as above

Seems like that those formulas should be fine. You can include the value of MACD in your report, i.e. specify MACD() in one of the additional columns. Is this where you are seeing the discrepancy, or when you open the chart?

MACD is an exponential calculation, so if you have the Explorer "Options" set to Load Minimum Records, it can give a different value than what you would see in a chart loading for example 500 records.

Originally Posted by: calisto77

I added  a Macd()  as suggested & all results show as < 0 whereas a few of the charts show > 0 which threw me off

re default template

I deleted all smart chart I could find and changed the default template to weekly and 1500 records

but I still get mainly Daily charts in Reports

where can I look for any more  smart charts to eliminate them 

Hi,

This will depend in part of which version of MetaStock you are using and the type of data, but generally speaking you would look for an MSSMART subfolder within each data folder.