SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : Metastock 6.0 for Window
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: MICHEL GUIBERT who wrote (2446)11/20/1998 7:47:00 PM
From: Paul Beattie  Read Replies (1) of 4056
 
Michel,
how can I make sure there is transactions for the last 5 days before the exploration date
The following formula will return a "1" on the 5th consecutive day that data exists for a symbol(and for all days after that):
sum(c>0,5)=5 .
On days 1 through 4 it will return "N/A". I don't understand why you don't just use the exploration formula, and then filter based on what you're looking for. If there is not enough days with data (ie. less than however many days you need), the filter will simply be NA, and the stock won't be your selected list.

Paul
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News