Dear Excel-forum,
I am currently writing a working paper where I am doing some time series analysis on S&P indexes' average stock lifetime, and are having some difficulties creating scalable and effiecient workbooks.
What I need is a workbook that includes the lifetime of all stocks listed before a series of given dates (monthly) in order to calculate moving average lifetime, turnover rate and actual number of delistings per period.
I have attached a list of listings/delistings for S&P100 with their respective dates and durations. SP100.xlsx
Any help would be greatly appreciated. Many thanks in advance!
/vonborge
Bookmarks