Andy - Thats different. For eg: I want to find the original IPO date of tickers in SPY500 like JNJ / AAPL / MSFT etc. How do I get that information ?
Well Google search wont work if I need to have it as a part of my automation especially considering that I have a large amount of tickers to go through.
Here is another source. https://site.warrington.ufl.edu/ritter/ipo-data/ Founding dates for IPOs from 1975-2018 (updated March 2019) https://site.warrington.ufl.edu/ritter/files/2019/05/FoundingDates.pdf has link https://site.warrington.ufl.edu/ritter/files/2019/05/age19752019.xlsx
Here is a crude way I was able to get them. I downloaded the historical daily data from Yahoo finance and used the data from it instead https://query1.finance.yahoo.com/v7...&interval=1d&events=history&crumb=UcCf48U0ShC Note the crumb is something that will change after a while