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

Notification

Icon
Error

Options
Go to last post Go to first unread
Guest  
#1 Posted : Sunday, November 8, 2015 9:45:30 AM(UTC)
Guest

Rank: Member

Groups: Guests
Joined: 5/6/2007(UTC)
Posts: 25

My formula is like this

IsUndefined(Mov(C,200,S))

it results in nothing.

Everything with less than 200 period of data is just regarded as error, in fact those rejected are the result I am looking for.

Please can anyone help me.

Thank you.

 

 

MS Support  
#2 Posted : Monday, November 9, 2015 4:30:31 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 91 times
Was thanked: 155 time(s) in 150 post(s)
You will probably have to provide some additional detail on what version of MetaStock, what symbol and interval you are attempting to use it on (or are you using it within the Explorer, etc)? The formula above works just fine for me, returning a value of 1 for the 1st 200 bars of data in my chart and switching to 0 every data point thereafter.
Guest  
#3 Posted : Tuesday, November 10, 2015 6:44:41 AM(UTC)
Guest

Rank: Member

Groups: Guests
Joined: 5/6/2007(UTC)
Posts: 25

i am using the Metastock 10.1

I tried the above formula in the explorer and it could not give me the result.

My aim is to distinguish the stock with less than 200 days of data.

Thank you.

 

MS Support  
#4 Posted : Tuesday, November 10, 2015 3:35:20 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 91 times
Was thanked: 155 time(s) in 150 post(s)

The isundefined function is designed to analyze the condition of an indicator over a data point. If a security does not have a particular data point, then there is nothing for this function to analyze. You would want to use the Cumulative function instead to count up the total bars available in the Explorer. You would also want to ensure your Load Records is set to a high enough number to accomodate this setting.


Cum(1) >= 200

The above formula would ensure that the security has to have at least 200 records available. You could include this in the Filter portion of an exploration if you want to reject securities with less than 200 data points.

Edited by user Tuesday, November 10, 2015 3:35:52 PM(UTC)  | Reason: Not specified

Guest  
#5 Posted : Tuesday, November 10, 2015 6:32:15 PM(UTC)
Guest

Rank: Member

Groups: Guests
Joined: 5/6/2007(UTC)
Posts: 25

Thank you very much for your help. I have solved my problem.
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.