Bloomberg Data Extraction – OpenText 2030 Bond, Peers & Financials (Excel, Hardcoded Values)
Budget: $30 – $250 USD
Description:
I need a clean, institutional-grade Excel file with historical market data and financials for OpenText (OTEX) and a peer set of 11 software/tech issuers. No Bloomberg formulas (#N/A) – all data must be hardcoded (Paste Values). All dates must be Excel-standard dates.
1. Date Range & Frequency
Market Data: 1 March 2024 – 16 March 2026 (Daily)
Financials: Last 5 Fiscal Years (Annual) and Last 20 Quarters (Quarterly)
2. OpenText (OTEX) Bond & CDS Data
2.1 Primary Bond: OTEX 3 7/8 02/15/30 <Corp> (USD Senior Unsecured)
Fields (Daily): Date, Mid Price (PX_MID), Yield to Maturity (YLD_YTM_MID), G-Spread, Z-Spread, OAS, OAS Duration, Convexity, and Bid-Ask Spread (as % of price).
2.2 OpenText 5Y CDS: OPEN TEXT CORP 5Y USD SR <Corp> (or liquid parent entity).
Fields (Daily): Date, CDS Spread (PX_LAST). Document the exact ticker used in the Readme.
3. OpenText Equity Data
Note: I require data for both US and Canadian listings to ensure currency alignment in the model.
Primary (USD): OTEX US <Equity>
Secondary (CAD): OTEX CN <Equity>
Fields (Daily): Date, Closing Price (PX_LAST), 30-Day Implied Volatility (IVOL_30D), and Short Interest as % of Float.
4. Benchmarks & Peer Bonds
4.1 High Yield BB Index: LUACTRUU Index (Bloomberg US Corp HY BB OAS Index).
Fields (Daily): Date, OAS Spread, Yield to Worst.
4.2 Peer Bond Panel (USD Issues Only):
For each issuer, extract Date, Z-Spread, Yield to Maturity, OAS Duration, and Mid Price. Use these specific tickers:
Gen Digital Inc: GEN 6 3/4 09/30/30 <Corp>
Cloud Software Group (Citrix): CTXS 6 1/2 09/30/29 <Corp>
NCR Voyix Corp: VYX 5 1/8 04/15/29 <Corp>
Box, Inc: (Use closest liquid USD Senior bond, e.g., BOX 0 01/15/26 or liquid proxy; specify ISIN in Readme).
Teradata Corp: TDC 2 3/8 09/01/29 <Corp>
DXC Technology: DXC 1.8 09/15/30 <Corp>
Kyndryl Holdings: KD 2.05 10/15/28 <Corp> (Benchmark liquid)
Oracle Corp: ORCL 2.95 04/01/30 <Corp>
SAP SE: SAP 3.5 03/13/30 <Corp> (Must be the USD issue)
Broadcom Inc: AVGO 4 1/8 08/15/29 <Corp>
OpenText (Re-include): OTEX 3 7/8 02/15/30 <Corp>
5. Financials & Ratios (All 12 Issuers)
5.1 Full Statements: Income Statement, Balance Sheet, Cash Flow.
5.2 Key Ratios (LTM/Adjusted where available):
Net Debt / LTM Adjusted EBITDA
Total Debt / EBITDA
Free Cash Flow (FCF) / Total Debt
Interest Coverage (Adjusted EBITDA / Interest Expense)
EV / Adjusted EBITDA
Revenue Growth YoY (5 Years)
OpenText Only: Please include the Debt Maturity Schedule summary (DDIS <GO>) and Segment EBITDA breakdown (Cloud vs Content vs Network).
6. Format & Deliverables
Tab “OTEX_MARKET”: Bond (2.1), CDS (2.2), and US Equity (3).
Tab “OTEX_CN_EQUITY”: Canadian listing data.
Tab “INDEX”: BB HY Index data.
Tab “PEER_BONDS”: Consolidated panel of all 11 peers + OTEX.
Tab “FINANCIALS_ANNUAL” & “FINANCIALS_QUARTERLY”: Standardised data for all 12 issuers.
Tab “README”: Documentation of every ticker, ISIN, and Bloomberg field mnemonic used.
Requirement: All numbers must be hardcoded. No Bloomberg macros or formulas.
I need a clean, institutional-grade Excel file with historical market data and financials for OpenText (OTEX) and a peer set of 11 software/tech issuers. No Bloomberg formulas (#N/A) – all data must be hardcoded (Paste Values). All dates must be Excel-standard dates.
1. Date Range & Frequency
Market Data: 1 March 2024 – 16 March 2026 (Daily)
Financials: Last 5 Fiscal Years (Annual) and Last 20 Quarters (Quarterly)
2. OpenText (OTEX) Bond & CDS Data
2.1 Primary Bond: OTEX 3 7/8 02/15/30 <Corp> (USD Senior Unsecured)
Fields (Daily): Date, Mid Price (PX_MID), Yield to Maturity (YLD_YTM_MID), G-Spread, Z-Spread, OAS, OAS Duration, Convexity, and Bid-Ask Spread (as % of price).
2.2 OpenText 5Y CDS: OPEN TEXT CORP 5Y USD SR <Corp> (or liquid parent entity).
Fields (Daily): Date, CDS Spread (PX_LAST). Document the exact ticker used in the Readme.
3. OpenText Equity Data
Note: I require data for both US and Canadian listings to ensure currency alignment in the model.
Primary (USD): OTEX US <Equity>
Secondary (CAD): OTEX CN <Equity>
Fields (Daily): Date, Closing Price (PX_LAST), 30-Day Implied Volatility (IVOL_30D), and Short Interest as % of Float.
4. Benchmarks & Peer Bonds
4.1 High Yield BB Index: LUACTRUU Index (Bloomberg US Corp HY BB OAS Index).
Fields (Daily): Date, OAS Spread, Yield to Worst.
4.2 Peer Bond Panel (USD Issues Only):
For each issuer, extract Date, Z-Spread, Yield to Maturity, OAS Duration, and Mid Price. Use these specific tickers:
Gen Digital Inc: GEN 6 3/4 09/30/30 <Corp>
Cloud Software Group (Citrix): CTXS 6 1/2 09/30/29 <Corp>
NCR Voyix Corp: VYX 5 1/8 04/15/29 <Corp>
Box, Inc: (Use closest liquid USD Senior bond, e.g., BOX 0 01/15/26 or liquid proxy; specify ISIN in Readme).
Teradata Corp: TDC 2 3/8 09/01/29 <Corp>
DXC Technology: DXC 1.8 09/15/30 <Corp>
Kyndryl Holdings: KD 2.05 10/15/28 <Corp> (Benchmark liquid)
Oracle Corp: ORCL 2.95 04/01/30 <Corp>
SAP SE: SAP 3.5 03/13/30 <Corp> (Must be the USD issue)
Broadcom Inc: AVGO 4 1/8 08/15/29 <Corp>
OpenText (Re-include): OTEX 3 7/8 02/15/30 <Corp>
5. Financials & Ratios (All 12 Issuers)
5.1 Full Statements: Income Statement, Balance Sheet, Cash Flow.
5.2 Key Ratios (LTM/Adjusted where available):
Net Debt / LTM Adjusted EBITDA
Total Debt / EBITDA
Free Cash Flow (FCF) / Total Debt
Interest Coverage (Adjusted EBITDA / Interest Expense)
EV / Adjusted EBITDA
Revenue Growth YoY (5 Years)
OpenText Only: Please include the Debt Maturity Schedule summary (DDIS <GO>) and Segment EBITDA breakdown (Cloud vs Content vs Network).
6. Format & Deliverables
Tab “OTEX_MARKET”: Bond (2.1), CDS (2.2), and US Equity (3).
Tab “OTEX_CN_EQUITY”: Canadian listing data.
Tab “INDEX”: BB HY Index data.
Tab “PEER_BONDS”: Consolidated panel of all 11 peers + OTEX.
Tab “FINANCIALS_ANNUAL” & “FINANCIALS_QUARTERLY”: Standardised data for all 12 issuers.
Tab “README”: Documentation of every ticker, ISIN, and Bloomberg field mnemonic used.
Requirement: All numbers must be hardcoded. No Bloomberg macros or formulas.