Error

 Previous Topic Next Topic
 calisto77 #1 Posted : Tuesday, October 13, 2020 11:06:38 PM(UTC) Rank: MemberGroups: Registered, Registered Users, SubscribersJoined: 5/14/2019(UTC)Posts: 27Was 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
 Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
 MS Support #2 Posted : Wednesday, October 14, 2020 2:23:26 PM(UTC) Rank: Advanced MemberGroups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)Posts: 1,746Thanks: 66 timesWas thanked: 146 time(s) in 142 post(s) Originally Posted by: calisto77 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) Rank: MemberGroups: Registered, Registered Users, SubscribersJoined: 5/14/2019(UTC)Posts: 27Was 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) Rank: Advanced MemberGroups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)Posts: 1,746Thanks: 66 timesWas thanked: 146 time(s) in 142 post(s) Originally Posted by: calisto77 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) Rank: MemberGroups: Registered, Registered Users, SubscribersJoined: 5/14/2019(UTC)Posts: 27Was 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.