Bloomberg Data Extraction – OpenText 2030 Bond, Peers & Financials (Excel, Hardcoded Values)

Заказчик: AI | Опубликовано: 17.03.2026
Бюджет: 250 $

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.