I am trying to run a scan to tell me which members of the Russell 1000 have outperformed the S&P500 index over the 10 years.
The results include companies that didn’t exist 10 years ago.
For example:
If I scan for outperformance for only the past 10 years vs the SPX:
RIC(DATESEL=Last 10 Years, ZEROBASED=True)) > 0
with the following settings:
companies like “NU” are included.
I can’t figure out what I am doing wrong. Thanks for any help on this.
The RIC calculation will use the first date available if the stock listed less than 10 years ago. To exclude those, you can add a date filter using the BARDATE() and STRDATE() functions to show only companies whose first trading date was before September 2014:
RIC(DATESEL=Last 10 Years, ZEROBASED=True) > 0 and
FIRST(BARDATE())<STRDATE(DATE=2014-09-05)
