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 : Tuesday, October 13, 2020 11:06:38 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 used this simple Mo formula

Mo(C,14)>Ref(Mo(C,14),1) and got a near 100%  N/A

I added this Filter  with no effect

colA=1 AND Mov(V,30,S)*C>=50000

 I thought the simple Mo was correct --if so, why do I get N/A ??

thanks for your advice

MS Support  
#2 Posted : Wednesday, October 14, 2020 2:23:26 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 used this simple Mo formula

Mo(C,14)>Ref(Mo(C,14),1) and got a near 100%  N/A

I added this Filter  with no effect

colA=1 AND Mov(V,30,S)*C>=50000

 I thought the simple Mo was correct --if so, why do I get N/A ??

thanks for your advice

Hi,

If you are attempting to compare to a prior bar value, you will want to make sure and use a negative number with the REF function, i.e.:

Code:
Mo(C,14)>Ref(Mo(C,14),-1)

calisto77  
#3 Posted : Thursday, October 15, 2020 1:23:57 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)

thanks, such a simple but fundamental error

looked at that number of times before I asked  ( redfaced)

in the correct result, a few show

COLES GROUP FPO    Error in column A: Period value out of valid range in Mo() function.

out of valid range?   it's heavily traded

MS Support  
#4 Posted : Thursday, October 15, 2020 3:53:07 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

thanks, such a simple but fundamental error

looked at that number of times before I asked  ( redfaced)

in the correct result, a few show

COLES GROUP FPO    Error in column A: Period value out of valid range in Mo() function.

out of valid range?   it's heavily traded

I just ran a quick scan using Mo(C,14)>Ref(Mo(C,14),-1) and got Normal Filter Rejection on symbol COL.AX in the Rejects tab. This was using Load Minimum Records. However, you may want to try Loading X (i.e. 20) records if you are using Load Minimum to see if this helps.

Depending on which version of MetaStock you have changes how the Explorer works to some extent, but you want to make sure you are running from the most recent date. You may also want to open COL.AX as a chart and see how the data looks. Are you using Local data downloaded from a particular source? Based on the chart I looked at you are correct, this stock appears to trade pretty regularly.

Edited by user Thursday, October 15, 2020 3:53:38 PM(UTC)  | Reason: Not specified

calisto77  
#5 Posted : Friday, October 16, 2020 5:33:28 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)

data is from a regular local supplier

I'll check the date & records used too

thanks for your advice

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.