Fund Holdings with CMBS Exposure

# Overview

The "Fund Holdings with Exposure to CMBS" dataset offers a comprehensive view of Commercial Mortgage-Backed Securities (CMBS) bonds held by various funds, as reported in SEC.gov EDGAR NPORT-P filings. This dataset provides valuable insights into the investment strategies and risk exposures of funds within the CMBS sector, enabling investors, analysts, and regulatory bodies to make informed decisions.

# Scope and Scale

This dataset captures the current holdings of CMBS bonds for the reporting period, detailing each CMBS bond held by funds. It offers a snapshot of investment positions, reflecting market trends, fund performance, and risk management practices. The data encompasses a wide range of funds, providing a detailed and broad view of the market.

# Value Proposition

- **Investment Analysis**: Understand the investment strategies of funds holding CMBS bonds.
- **Market Trends**: Gain insights into market movements and trends within the CMBS sector.
- **Risk Management**: Evaluate the risk exposure and management practices of funds.
- **Regulatory Compliance**: Assist regulatory bodies in monitoring and assessing fund activities.

# Sample Tables and Schemas

Sample Table: **edgar_paid_fund_holdings_cmbs**

## Sample Fields

1. **edgar_cik**: The unique Central Index Key (CIK) assigned by the SEC to identify companies and individuals who have filed disclosures with the SEC. This CIK is of the CMBS deal that is the holding.
2. **deal_short_name**: A shortened name or identifier for the CMBS deal, providing a concise reference to the specific commercial mortgage-backed security holding.
3. **fund_cik**: The unique Central Index Key (CIK) assigned by the SEC to identify the filer of the NPORT-P, representing the fund holding the CMBS bonds.
4. **fund_id**: A unique identifier assigned to the fund holding the CMBS bonds, used for internal tracking and reference purposes.
5. **fund_lei**: The Legal Entity Identifier (LEI) of the fund, providing a globally recognized identifier for the legal entity holding the CMBS bonds.
6. **fund_name**: The name of the fund holding the CMBS bonds, as reported in the NPORT-P filing.
7. **filing_date**: Date when the fund's holdings data related to Commercial Mortgage-Backed Securities (CMBS) was officially filed, ensuring data timeliness and compliance with reporting requirements.
8. **reporting_period_end**: The end date of the reporting period for the current NPORT-P filing, indicating the period for which the CMBS holdings are reported.
9. **figi_search_url**: A URL constructed to lookup more information about the fund on OpenFIGI.com, providing additional details using the Financial Instrument Global Identifier (FIGI).
10. **lei_lookup_url**: A URL constructed to lookup more information about the fund on LEILookup.com, providing additional details using the Legal Entity Identifier (LEI).
11. **sec_filings_url**: A URL constructed to access more information about the fund's filings on SEC.gov, offering comprehensive details from the fund's submitted SEC filings.
12. **total_value**: The sum of the value of all holdings for a particular CMBS deal, representing the aggregate value of all bonds associated with that deal.

# Data Sources

This dataset is sourced from the NPORT-P filings available on SEC.gov EDGAR. These filings provide detailed information on the holdings of funds, ensuring accurate and up-to-date data.

# Access and Workflow

1. **Accessing Data**: Consumers can access the dataset via the Snowflake Marketplace by subscribing to the "Fund Holdings with Exposure to CMBS" listing.
2. **Using Data**: Upon subscription, users can query the dataset to retrieve detailed information on CMBS bond holdings, analyze investment strategies, and monitor market trends.
3. **Results**: Providers ensure that the dataset is updated regularly to reflect the latest filings, providing consumers with current and relevant data for their analysis.