Inception date of ETF or stock

General
1

Is there a function that returns the inception date of a stock or ETF?
Thank you

2

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?

1 Like
3

What are you trying to do? It would be trivial to add something if necessary to suit your needs.

4

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.

1 Like
5

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.