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

Notification

Icon
Error

Options
Go to last post Go to first unread
gorachand  
#1 Posted : Tuesday, December 13, 2016 7:00:41 PM(UTC)
gorachand

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 2/19/2012(UTC)
Posts: 106

Thanks: 1 times
Was thanked: 1 time(s) in 1 post(s)
Hello, I coded an indicator so that it gives a binary wave output. In explorer in the filter I selected that indicator after pressing functions and set it equal to one. I unchecked load minimum records and put the load records to 3000. But when I run the exploration it gives a message formula not defined on exploration date. I am aware that these errors crop up when load minimum records is selected.But here that is not the case. Can anyone help? Regards, Dr.Chatterjee
MS Support  
#2 Posted : Tuesday, December 13, 2016 11:24:55 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
Hi, This can occur if the condition was never true within all the data tested. Certain formula functions can return a N/A value (such as ValueWhen() ). Load Minimum Records just makes it more likely to see the message since you are testing a smaller data amount. Loading more data gives you more opportunity for a signal to have occurred in the past, but it does not guarantee a signal. That is ultimately what this message means - It is not true today and has never been true in the entirety of the data sample. If it was true at least once in the history of the tested data, you would have a "Normal Filter Rejection" (or a 0 if the formula was in a non-Filter column). Without knowing your formula or what securities you are running the scan against it is hard to say for certain what is happening. Are you testing on a single security or multiple securities? If you plot your indicator in a chart of one of the rejected securities, do you see the indicator equal to 1 ever?
Users browsing this topic
Guest (Hidden)
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.