Dataset for: Determinants of IPO Underpricing in the UK: An Empirical Analysis from 2014 to 2024

Description This repository contains 2 files related to the construction and cleaning of a comprehensive dataset on UK IPOs from Jan 2014 to Nov 2024. The dataset has been used in regression analyses for my bachelor’s research, and all steps, from initial data collection to final adjustments, are documented and provided for transparency and reproducibility. The repository includes the following files: 1. Excel Dataset FileThis single Excel file comprises multiple sheets, each detailing a different aspect of the data preparation and analysis. Important sheets include: Regression_Final: Contains all 616 IPOs after cleaning and adjustments, with the variables (highlighted in yellow) that were used in the final regression analyses. Rough: Provides the initial matching of 616 IPOs sourced from the London Stock Exchange (LSE), Bloomberg (BB), and Refinitiv (RF). In this sheet, rows with dates and issuer names marked in red indicate deletions (e.g., SPACs, funds, duplicates), while blue-highlighted cells denote manual overrides such as stock splits, currency adjustments, or listing date corrections. Variable Breakdown, Backing Data, and Originals: Additional sheets break down the key variables, include supporting data (e.g., FTSE price and volatility, currency data), and provide the original downloaded tables for reference and verification. 2. Data Collection Documentation:This supplementary document details the methodology used for data collection, cleaning, and manual adjustments. It explains the procedures, criteria, and any assumptions made during the process, ensuring that the dataset is reproducible and transparent for future research.