Is there a function that returns the inception date of a stock or ETF?
Thank you
There is no function available to return the exact inception date but you could do this to return the number of years we have data for the stock or ETF:
@years:LoopSum("Eval(Close(CTR*251) != NA, 1, NA)", 25, 0, 1, 1, 1)
Another option would be to return the number of weeks. LoopSum is limited to 501 iterations so this can only go back about 9.6 years.
@Weeks:LoopSum("Eval(Close_W(CTR) != NA, 1, NA)", 501, 0, 1, 1, 1)
Or do 4 weeks to approximate the number of months:
@FourWks:LoopSum("Eval(Close_W(CTR) != NA, 1, NA)", 501, 0, 4, 1, 1)
Would that meet your needs?
What are you trying to do? It would be trivial to add something if necessary to suit your needs.
I have found #APeriods and #QPeriods extremely useful in finding how long a stock has been around and limiting my universe to older or younger companies.
These are some helpful suggestions. Thank you! I was just experimenting with ETF rotational stuff to learn the basics of the platform and wanted to have a universe of all of the ETFs while having a way to programmatically only trade ETFs that had significant history.