net install http://researchata.com/stata/203/fetchyahooquotes.pkg, force * * Please find 3 SPAC-IPOs that were completed in 2020. * Please find 3 traditional IPOs that were completed in 2020. * * * Example SPAC-IPO: DKNG (be careful with the SPAC-IPO date) * https://finance.yahoo.com/news/draft-kings-completes-merger-diamond-eagle-now-public-company-dkng-222039095.html * ================================================================== local ticker = "DKNG" fetchyahooquotes `ticker', freq(d) chg(ln) start(24apr2020) gen days = date-date[1] * Performance at 10 days summ ln_`ticker' if days<=10 gen _10_days=r(sum) * Performance at 30 days summ ln_`ticker' if (days<=30) gen _30_days=r(sum) * Performance at 90 days summ ln_`ticker' if (days<=90) gen _90_days=r(sum) collapse (firstnm) _* gen symbol = "`ticker'" gen IPO_type = "SPAC" capture: append using temp.dta save temp.dta, replace * ================================================================== * Example Traditional-IPO: ABNB * ================================================================== local ticker = "ABNB" fetchyahooquotes `ticker', freq(d) chg(ln) gen days = date-date[1] * Performance at 10 days summ ln_`ticker' if days<=10 gen _10_days=r(sum) * Performance at 30 days summ ln_`ticker' if (days<=30) gen _30_days=r(sum) * Performance at 90 days summ ln_`ticker' if (days<=90) gen _90_days=r(sum) collapse (firstnm) _* gen symbol = "`ticker'" gen IPO_type = "Traditional" capture: append using temp.dta save temp.dta, replace * ==================================================================