Replication code for "From Good to Bad Concentration?"
By Matias Covarrubias, German Gutierrez & Thomas Philippon
Last modified: 06/10/2019
*************
(open this window wide to improve readability)

To generate replication results, simply run 0_DoFile.do from the main directory. 
This file will execute all required code from beginning to end. 

The folders have the following structure:

"Data" contains all the do-files and data sources.
	"Raw_data" contains the sources and the do-files to work with them.
	 Upon execution of the main do_files new final_data will be created.

	"Mappings" contains inter databases mappings.

	"Temp" is empty. Upon execution of the main do-files temp data will be stored.



The raw files for Cumpustat_NA and Compustat_Global are not available beforehand since they are proprietary. They will be downloaded automatically from WRDS upon execution of 0_doFile.do, so long 
as the user has a WRDS account and has set-up an ODBC connection. For instructions to set this up, see 
https://www.stata.com/blog/wrds/Stata_WRDS.pdf. 
Data from FRED will be downloaded using Freduse. The remaining data are 
included in the Raw_data folder. 

"Figures and "Tables" contains the figures and tables that come out from the code. They are formatted just as they appear in the paper. The list of Figures and tables, with the sub-folder in which they are located is:


Section		Figure/Table		Do File			Sub-Folder (In Figures or Tables)
Introduction	Figure 1. Panel A and B	1a_Intro_ProfCons.do	1_Intro
		Figure 1. Panel C and D	1b_Intro_QNIK.do	1_Intro
		Figure 2. Panel B	1c_Global_Concentration.do	2_Global
		Figure 2. Panel A and C	1d_Global_Profits_LS.do	2_Global
Section 2	Figure 3.		2a_China_Conc.do	6_China
		Figure 4.		2b_China_Inv.do		6_China
		Figure 5.		2c_China_Mu.do		6_China
		Figure 6.		2d_DLE.do		8_DLE
		Figure 16.		2d_DLE.do		8_DLE
		Figure 17.		2d_DLE.do		8_DLE
		Figure 18.		2d_DLE.do		8_DLE
Section 3	Figure 7.		3a_leaderTurnover.do	4_Leaders
		Figure 8.		3a_leaderTurnover.do	4_Leaders
		Figure 19.		3a_leaderTurnover.do	4_Leaders
		Figure 20.		3a_leaderTurnover.do	4_Leaders
		Figure 21.		3a_leaderTurnover.do	4_Leaders
		Table 2.		3b_KLEMS_PricesTFPconc.do	3_PricesTFP
		Figure 9.		3b_KLEMS_PricesTFPconc.do	3_PricesTFP
		Figure 22.		3b_KLEMS_PricesTFPconc.do	3_PricesTFP
		Table 3.		3c_DETAILED_PricesTFPconc.do	3_PricesTFP
		Figure 23.		3c_DETAILED_PricesTFPconc.do	3_PricesTFP
		Table 8.		3c_DETAILED_PricesTFPconc.do	3_PricesTFP
		Figure 10.		3d_QNIK_gap.do		5_QNIK
		Figure 24.		3d_QNIK_gap.do		5_QNIK
		Table 5.		3e_QNIK_LeadLag.do	5_QNIK
		Figure 25.		3e_QNIK_LeadLag.do	5_QNIK
		Table 6.		2b_China_Inv.do		6_China
		Figure 11.		2b_China_Inv.do		6_China
Section 4:  	Figure 12.		4_PCA.do		7_PCA
		Figure 13.		4_PCA.do		7_PCA
		Figure 14.		4_PCA.do		7_PCA
		Figure 15.		4_PCA.do		7_PCA
		Figure 26.		4_PCA.do		7_PCA

For questions or issues, please email ggutierr@stern.nyu.edu and mc5851@nyu.edu


Thank you for your interest!