logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
calisto77  
#1 Posted : Thursday, May 16, 2019 11:58:30 PM(UTC)
calisto77

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/14/2019(UTC)
Posts: 27

Was thanked: 1 time(s) in 1 post(s)

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

MS Support  
#2 Posted : Friday, May 17, 2019 3:40:23 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Originally Posted by: calisto77 Go to Quoted Post

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.

calisto77  
#3 Posted : Friday, May 17, 2019 10:39:03 PM(UTC)
calisto77

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/14/2019(UTC)
Posts: 27

Was thanked: 1 time(s) in 1 post(s)

thanks, i'll check that & get back

calisto77  
#4 Posted : Monday, May 20, 2019 7:27:24 AM(UTC)
calisto77

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/14/2019(UTC)
Posts: 27

Was thanked: 1 time(s) in 1 post(s)

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

calisto77  
#5 Posted : Monday, May 20, 2019 7:30:14 AM(UTC)
calisto77

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/14/2019(UTC)
Posts: 27

Was thanked: 1 time(s) in 1 post(s)

the formula didn't come out correctly

it should be separately

ColA   Stoch

ColB  Macd

MS Support  
#6 Posted : Monday, May 20, 2019 3:23:29 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Originally Posted by: calisto77 Go to Quoted Post

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.

calisto77  
#7 Posted : Monday, May 20, 2019 10:31:18 PM(UTC)
calisto77

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/14/2019(UTC)
Posts: 27

Was thanked: 1 time(s) in 1 post(s)
Originally Posted by: calisto77 Go to Quoted Post

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

MS Support  
#8 Posted : Tuesday, May 21, 2019 8:23:23 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Originally Posted by: calisto77 Go to Quoted Post
Originally Posted by: calisto77 Go to Quoted Post

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.

calisto77  
#9 Posted : Sunday, June 16, 2019 11:22:12 AM(UTC)
calisto77

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/14/2019(UTC)
Posts: 27

Was thanked: 1 time(s) in 1 post(s)

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 

MS Support  
#10 Posted : Tuesday, June 18, 2019 2:07:00 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Originally Posted by: calisto77 Go to Quoted Post

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.

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.