Where can I source the nasdaq100 (or something close to NDX) historical earnings going back as far as possible, preferably prior to tech bubble. Just the total earnings is fine.
The data is available at SEC's edgar archive. You need to know the 10 digit CIK number e.g. AAPL 0000320193. This link will bring you to the AAPL 10-Q page. https://www.sec.gov/edgar/browse/?CIK=320193 Select either 10-K(annual) or 10-Q(quarter) Click on Filling of each report https://www.sec.gov/Archives/edgar/data/0000320193/000032019322000007/0000320193-22-000007-index.htm Click on interactive data https://www.sec.gov/cgi-bin/viewer?...sion_number=0000320193-22-000007&xbrl_type=v# Click Financial Statement and there are the data.
Since Jan 1995 there have been 411 stocks that have been a constituent of the Nasdaq-100 at some point in time.... there's a fair amount of research involved to look up each one.
Thanks, a wealth of knowledge this forum is. It's 'possible' using ycharts and SEC filings but involves a lot of manual compiling. All I'm trying to do is put together a similar data to Robert Schiller but for Nasdaq. Surprised someone hasn't already done and published this. For now I think the easiest way is to get onto QuantConnect and do it programatically