UROP Proceedings 2021-22

School of Business and Management Department of Finance 180 Department of Finance Trade Shows and Supply Chain Formation Supervisor: BISETTI Emilio / FINA Student: CHEN Jinghui / FINA XU Suixin / QFIN YUAN, Wai Man / FINA ZHANG, Jiayi / MAEC Course: UROP1100, Spring UROP1100, Fall UROP2100, Spring UROP1100, Spring UROP1100, Spring Our research focuses on the field of corporate finance in the United States. We mainly use a large amount of retail data to determine the competitive relationship among companies by matching their products and giving a score based on the product matrix. In order to access the appropriate data, we have done some basic data cleaning jobs, using Python to match firm names from different databases and do manually matching. We also use inner functions in Excel to sort the company information into categories. The above methods can be utilized for broader company scope and longer time horizon. Measuring Product Market Competition Supervisor: BISETTI Emilio / FINA Student: CHEN, Jinghui / FINA HE Jinwen / COGBM HU Yumeng / SBM HUANG Jiawei / IEEM LEUNG Suet Ying / FINA LO Kim Wa / RMBI PHAM Thanh Hai Binh / IPO XU Suixin / QFIN YUAN Wai Man / FINA Course: UROP2100, Summer UROP1000, Summer UROP1000, Summer UROP1000, Summer UROP1100, Summer UROP1000, Summer UROP1000, Summer UROP3100, Summer UROP2100, Summer The project aims to construct a firm-level competition measure based on product information from detailed scanner data. We obtain product bar codes and sales revenue from Nielsen and link back to the public firms in the Compustat database. Following the literature on Text-based Network Industry Classifications (TNIC), our research makes use of category division and market shares to build up the product category matrix of each company and prepare the data to calculate similarity scores between the two companies.