download_wrds.download_data_wrds_trace_enhanced()
Download Enhanced TRACE data from WRDS.
Usage
download_wrds.download_data_wrds_trace_enhanced(
cusips, start_date=None, end_date=None, quiet=False
)Establishes a connection to the WRDS database to download the specified CUSIPs trade messages from the Trade Reporting and Compliance Engine (TRACE). The trade data is cleaned as suggested by Dick-Nielsen (2009, 2014).
Parameters
cusips: list of str-
A character vector specifying the 9-digit CUSIPs to download.
start_date: str = None-
A character string or date in ‘YYYY-MM-DD’ format specifying the start date for the data. If not provided, a subset of the dataset is returned.
end_date: str = None-
A character string or date in ‘YYYY-MM-DD’ format specifying the end date for the data. If not provided, a subset of the dataset is returned.
quiet: bool = False- If True, the messages about the WRDS connection and the download progress are suppressed. Defaults to False.
Returns
pl.DataFrame- A data frame containing the cleaned trade messages from TRACE for the selected CUSIPs over the time window specified. Output variables include identifying information (i.e., CUSIP, trade date/time) and trade-specific information (i.e., price/yield, volume, counterparty, and reporting side).
References
Dick-Nielsen, J. (2009). Liquidity biases in TRACE. Journal of Fixed Income, 19(2), 43-55. https://doi.org/10.3905/jfi.2009.19.2.043
Dick-Nielsen, J. (2014). How to clean enhanced TRACE data. Working Paper. https://doi.org/10.2139/ssrn.2337908
Examples
from tidyfinance import download_data_wrds_trace_enhanced
download_data_wrds_trace_enhanced(
['00101JAH9'], '2019-01-01', '2021-12-31'
)