Getting number of days since event

Best Answers

• Options

  markd mod

  January 2015 edited January 2015 Answer ✓

  You have to do it the other way around. As Gord noted, the scan engine only returns symbols. It doesn't return numbers. So you have to select the number, then see how many symbols fit that criteria.
  
  So for instance:
  
  and [20 days ago close = max(251, close)]
  
  This would get stocks that made their highest close in the last year twenty days ago. Substitute high for close if that's what you want.
  
  Note: (251 market days in a year, except for unusual circumstances that close the exchange)
  
  So, if you wanted to do every day, that would be 251 scans. Alternatively, you could scan for highest weekly high - only 52 scans.
  
  Another alternative - scan for a range of dates:
  
  and [20 days ago max(10, high) = max(251, high)]
  
  This would pick up stocks that made their highest high for most recent 251 days between 20 and 30 days ago.
  
  

  0
• Options

  gord admin

  February 2015 edited February 2015 Answer ✓

  If you can use the "high" instead of the "close", then I have another solution for you.
  
  The aroon indicator oscillates between 100 and 0. Aroon is 100 when a new high is set for the period, then it decreases each day a new high is not set. To keep it simple lets use Aroon (100) ie looking for new highs during the last 100 days.
  
  If a new high is set today Aroon 100 will be 100, if a new high is set the next day Aroon will still be 100, if a new high is not set then Aroon will decrease by 1 for each day a new high is not set. It will reach 0 if now new highs are set for 100 days.
  
  So lets put this in a scan of our list using the "rank by" feature. Note "Rank by [ Aroon(100) ] " will give us an output of 100 for stocks that hit a new high today. So to invert it I will just subtract the value from 100. That will give us an output of 0 days ago for stocks that hit a new high today and 100 for stocks that have not had a new 100 day high in the last 100 days or more.
  
  [favorites list is 55] // = 12 Comd
  rank by [Aroon Up(100) - 100]
  
  http://stockcharts.com/articles/mailbag/2014/06/ranking-a-group-of-stocks-by-percent-change.html
  
  
  
  
  hope this gives you some other ideas.
  cheers Gord
  

  1 aroon.png 53.4K

  0