Analyze CDS basis arbitrage opportunities with Sourcetable AI. Calculate bond-CDS spreads, identify mispricings, and execute profitable credit arbitrage trades automatically.
Andrew Grosser
February 24, 2026 • 18 min read
March 2020: COVID liquidity crisis hits. Ford Motor Credit 5-year CDS spreads to 650bps while Ford bonds trade at T+580bps, a negative basis of -70bps. CDS basis arbitrage represents one of the most sophisticated credit trading strategies available to institutional investors and hedge funds. This strategy exploits the pricing difference between a corporate bond and its corresponding credit default swap (CDS), capturing profit when these two instruments that reference the same credit risk trade at different implied spreads.
The basis—defined as the difference between a bond's asset swap spread and its CDS spread—should theoretically converge to zero in efficient markets. When the basis widens significantly positive or negative, arbitrage opportunities emerge. A positive basis (bond spread wider than CDS) suggests buying the bond and buying CDS protection. A negative basis (CDS wider than bond) indicates selling the bond short and selling CDS protection sign up free.
Excel has long been the default tool for fixed income arbitrage, but it falls short when analyzing multi-dimensional credit strategies. Building a comprehensive basis trading model requires linking bond pricing sheets, swap curve data, CDS quote feeds, and funding cost calculations. Each component needs its own complex formula set, and keeping everything synchronized across workbooks becomes a full-time job.
Consider a typical basis trade setup: You're analyzing Ford Motor Credit bonds trading at a z-spread of 285 basis points while 5-year Ford CDS quotes at 245 basis points—a positive basis of 40 basis points. To evaluate this opportunity, you need to calculate the asset swap spread, adjust for funding costs (currently around SOFR + 15 bps for repo financing), account for accrued interest, estimate transaction costs, and project P&L under various spread scenarios.
In Excel, this requires building interconnected formulas: YIELD functions for bond pricing, interpolation formulas for swap curves, basis point conversion calculations, and scenario analysis tables. When you monitor 50+ issuers simultaneously, the spreadsheet becomes a fragile maze of cell references that breaks when data updates. Version control nightmares emerge when multiple traders modify the same workbook.
Sourcetable eliminates this complexity through conversational AI that understands credit market terminology. Upload your bond positions and CDS quotes as CSV files or connect directly to Bloomberg data feeds. Then simply ask: 'Show me all investment grade issuers with positive basis over 30 bps' or 'Calculate expected return on a basis package trade for GM bonds.' The AI instantly processes your data, applies proper credit calculations, and presents results in clear tables and charts.
The platform automatically handles technical details that consume hours in Excel: day count conventions (30/360 vs Actual/360), settlement date adjustments, accrued interest calculations, and present value discounting. When CDS quotes update, Sourcetable recalculates all basis values in real-time without manual formula updates. You focus on trade decisions while AI manages the computational heavy lifting.
Sourcetable's AI also catches errors that slip through Excel models. Ask 'Does this basis calculation look correct for XYZ Corp?' and the system validates your methodology against standard market conventions, flagging potential issues like mismatched maturities or incorrect day count assumptions. This intelligent error-checking prevents costly trading mistakes that manual spreadsheet reviews often miss.
CDS basis arbitrage offers compelling risk-adjusted returns when executed with precision. The strategy provides market-neutral exposure to credit mispricing while hedging directional credit risk. Successful basis traders generate alpha by identifying temporary dislocations between cash and synthetic credit markets, capturing spreads that converge as market inefficiencies correct.
Sourcetable continuously tracks basis levels across your entire universe of credits, alerting you when opportunities exceed your threshold criteria. Instead of manually updating Excel files with morning bond prices and CDS quotes, connect your data sources once and ask 'Which basis trades moved more than 10 bps today?' The AI instantly scans hundreds of issuers, calculates current basis levels, and highlights the most significant moves.
For a credit portfolio containing 200 corporate issuers, Sourcetable can monitor basis levels continuously and generate alerts when specific conditions trigger—like when the basis for investment grade credits exceeds historical 90th percentile levels. This systematic surveillance catches opportunities that manual Excel reviews inevitably miss during volatile market periods when dozens of credits move simultaneously.
Understanding basis trade performance requires decomposing P&L into multiple components: spread tightening/widening, carry from bond coupon and CDS premium, funding costs, and mark-to-market changes. Excel models typically calculate these manually with complex formula chains that break when positions change.
Sourcetable automates this attribution analysis. Upload your position file showing you're long $10 million Ford 4.5% 2027 bonds at a price of 98.5 and short 5-year Ford CDS at 245 bps. Ask 'Show me daily P&L attribution for this basis package' and the AI breaks down performance: $1,370 carry from net coupon minus CDS premium, $8,200 gain from basis tightening by 8 bps, minus $150 in funding costs. Every component updates automatically as market prices change.
The platform also calculates key risk metrics instantly. Ask 'What's my DV01 on this basis trade?' and Sourcetable computes the net interest rate sensitivity, showing how a 1 basis point parallel shift in rates affects position value. For basis trades, the DV01 should be close to zero since bond and CDS durations largely offset, but residual mismatches create risk that Sourcetable quantifies precisely.
Effective basis trading relies on understanding historical patterns—knowing when current basis levels represent genuine opportunities versus new market regimes. Excel-based historical analysis requires maintaining extensive time series data and building statistical models to identify outliers.
With Sourcetable, upload historical basis data and ask 'Show me the distribution of AT&T basis over the past 2 years.' The AI generates histograms showing that AT&T basis typically trades between 15-35 bps with a median of 23 bps. When you spot current basis at 52 bps, you immediately recognize this as a 2.5 standard deviation event—a strong mean reversion signal suggesting the basis should compress.
The platform can also run correlation analysis across credits. Ask 'Which issuers have basis movements most correlated with General Motors?' to identify pairs where one credit's basis might predict another's. This reveals systematic patterns that inform portfolio construction, helping you diversify basis trades across uncorrelated opportunities rather than concentrating risk in credits that move together.
Basis trades perform well in stable markets but can experience significant mark-to-market volatility during credit events or liquidity crunches. Stress testing helps quantify tail risks before they materialize. Traditional Excel scenario analysis requires building separate calculation sheets for each stress scenario—rate shocks, spread widening, funding cost spikes.
Sourcetable makes stress testing conversational. For your portfolio of 15 basis trades, ask 'What happens to my P&L if CDS spreads widen 100 bps but bond spreads only widen 75 bps?' The AI instantly recalculates position values under this adverse scenario, showing you'd face a $340,000 loss from basis widening. Follow up with 'Now add a funding cost increase of 50 bps' to layer additional stress factors.
You can also test positive scenarios. Ask 'Calculate my profit if all basis positions compress by 50% over 3 months' to quantify upside potential. Sourcetable handles the time decay calculations, adjusting for carry accrual and funding costs over the projection period. This comprehensive scenario framework helps you size positions appropriately for your risk tolerance.
The most valuable benefit Sourcetable provides is accelerating the trade idea generation process. Instead of spending mornings manually comparing bond spreads to CDS quotes in Excel, ask the AI to surface opportunities based on your criteria.
Query 'Find all BBB-rated issuers with positive basis above 40 bps and bond liquidity over $500 million outstanding' and Sourcetable instantly filters your universe, returning a ranked list of candidates. The results show current basis levels, historical percentile rankings, bond prices, CDS quotes, and outstanding amounts—everything needed to evaluate opportunities on a single screen.
You can refine searches iteratively. If the initial results include too many financial issuers, add 'excluding banks and insurance companies' to your query. Want to focus on shorter maturities? Specify 'only bonds maturing in 2-5 years.' The conversational interface lets you explore the opportunity set naturally, like discussing ideas with a research analyst who has instant access to complete market data.
Executing basis arbitrage analysis in Sourcetable follows a streamlined workflow that eliminates the tedious data preparation and formula building required in Excel. The platform handles technical complexities automatically while giving you complete control over analysis parameters and trading assumptions.
Begin by uploading your market data. Sourcetable accepts CSV files, Excel workbooks, or direct connections to Bloomberg Terminal, Refinitiv, or other market data providers. Your bond data should include: issuer name, CUSIP/ISIN, coupon rate, maturity date, current price, and yield. CDS data needs: reference entity, tenor (typically 5 years), quoted spread in basis points, and quote timestamp.
For example, upload a file showing: 'Ford Motor Credit, 4.125% bonds due 2027, priced at 97.25, yield 4.89%' alongside 'Ford Motor Credit 5Y CDS quoted at 245 bps.' Sourcetable's AI recognizes the data structure automatically—no need to format columns in specific layouts or write import macros like Excel requires.
You'll also need swap curve data for calculating asset swap spreads. Upload current SOFR swap rates across maturities (1Y, 2Y, 3Y, 5Y, 7Y, 10Y) and Sourcetable interpolates intermediate points automatically. The platform handles different day count conventions (30/360 for corporate bonds, Actual/360 for swaps) without manual adjustment.
Once data is loaded, ask Sourcetable to calculate basis levels: 'Calculate the CDS basis for all issuers in my dataset.' The AI computes asset swap spreads for each bond—the spread over the swap curve that equates the bond's cash flows to par value. This involves discounting all future coupon payments and principal repayment using swap rates plus the spread.
For the Ford example, Sourcetable calculates the bond's asset swap spread at approximately 285 bps (the spread over the 5-year SOFR swap rate that prices the bond at 97.25). With CDS at 245 bps, the basis equals 285 - 245 = 40 bps positive. The AI presents results in a sortable table showing all issuers ranked by basis width.
Behind the scenes, Sourcetable applies sophisticated financial mathematics—Newton-Raphson iteration for spread solving, cubic spline interpolation for swap curves, and precise accrued interest calculations. In Excel, building these calculations requires advanced financial modeling skills. Sourcetable delivers professional-grade accuracy through simple natural language requests.
Raw basis numbers don't tell the complete story. Profitable basis trades must overcome funding costs and transaction expenses. For a positive basis trade (long bond, long CDS protection), you finance the bond purchase through repo markets. If repo costs SOFR + 15 bps and the bond pays 4.125% coupon, your net carry depends on this funding rate.
Tell Sourcetable your funding assumptions: 'Apply repo funding at SOFR plus 15 basis points' or 'Use prime brokerage financing at SOFR plus 25 bps.' The AI recalculates net basis after funding costs, showing which opportunities remain attractive after accounting for financing expenses. For the Ford trade, if SOFR is 5.30%, your all-in funding cost is 5.45%. With a 4.125% coupon, you're paying 1.325% annually to hold the bond, but collecting 40 bps of basis—the economics need careful evaluation.
Transaction costs also matter. Bond bid-offer spreads might be 10-20 bps for liquid investment grade credits, wider for high yield. CDS bid-offer spreads typically run 3-5 bps for liquid names. Ask Sourcetable to 'Subtract 15 bps transaction costs from all basis trades' to see net opportunity after trading frictions. This realistic adjustment filters out marginal trades that look attractive on paper but don't clear the hurdle after implementation costs.
After entering trades, Sourcetable becomes your position monitoring dashboard. Upload daily bond prices and CDS quotes, and the platform automatically updates position values and P&L. Create a query: 'Show me daily P&L for all basis trades with attribution to spread changes, carry, and funding costs.'
The AI generates a detailed P&L report. For your Ford basis package (long $10 million bonds, short 5Y CDS on $10 million notional), today's P&L might show: +$8,200 from basis tightening (basis compressed from 40 bps to 32 bps), +$1,370 carry (bond coupon minus CDS premium for one day), -$150 funding cost, = +$9,420 total daily P&L. Each component updates automatically as market data refreshes.
You can also track cumulative performance. Ask 'What's my inception-to-date P&L on the Ford basis trade?' and Sourcetable sums all daily P&L since trade entry, breaking down total returns into realized gains (from closed positions) and unrealized mark-to-market. This comprehensive tracking eliminates the error-prone manual P&L reconciliation that consumes hours in Excel-based workflows.
Sourcetable transforms raw analysis into presentation-ready reports instantly. Ask 'Create a chart showing basis evolution for my top 5 positions over the past month' and the AI generates a line graph tracking how each trade's basis has moved. This visualization immediately reveals which positions are converging as expected versus those experiencing adverse basis widening.
For portfolio reviews, request 'Generate a summary table of all basis trades showing current basis, entry basis, P&L, and DV01.' Sourcetable produces a formatted table ready to share with portfolio managers or risk committees. Export to PDF or PowerPoint with one click—no copying and pasting charts from Excel or reformatting tables.
The platform also creates distribution charts for opportunity screening. Ask 'Show me a histogram of current basis levels across all investment grade issuers' to visualize the entire basis landscape. Outliers become immediately obvious, highlighting potential trades that warrant deeper investigation. This visual approach to opportunity identification is vastly more efficient than scanning rows of numbers in Excel spreadsheets.
CDS basis arbitrage opportunities arise in various market conditions and across different credit sectors. Understanding when and how to deploy this strategy maximizes risk-adjusted returns while managing the unique challenges each scenario presents.
During periods of market stress—credit events, liquidity crunches, or systemic shocks—basis levels often blow out to extreme levels as cash and synthetic markets temporarily disconnect. In March 2020, investment grade basis levels widened to 80-120 bps as corporate bond markets seized up while CDS markets remained functional. Hedge funds that identified these dislocations and executed basis packages captured significant profits as markets normalized.
Sourcetable helps traders identify these crisis opportunities systematically. During volatile periods when hundreds of credits are moving, ask 'Which investment grade issuers have basis levels above 2 standard deviations from historical average?' The AI instantly screens your universe and highlights the most extreme dislocations. For example, it might flag that Boeing's basis widened from a typical 25 bps to 95 bps—a clear mean reversion opportunity if you believe the dislocation is temporary rather than reflecting fundamental credit deterioration.
The platform also helps size positions appropriately during crisis periods. Ask 'Calculate maximum position size for Boeing basis trade with 2% portfolio risk limit assuming basis could widen another 30 bps.' Sourcetable computes the DV01 and basis point value, determining you can safely hold $15 million notional while staying within risk parameters. This disciplined approach prevents over-sizing trades during volatile periods when tempting opportunities can also generate outsized losses.
Negative basis situations—where CDS spreads trade wider than bond spreads—occur frequently in high yield markets. This happens when CDS protection buyers pay up for hedging convenience or when bond prices reflect technical supply-demand factors. A typical scenario: a high yield issuer's bonds trade at an asset swap spread of 450 bps while 5-year CDS quotes at 520 bps, creating a negative basis of -70 bps.
The negative basis trade involves selling CDS protection (receiving 520 bps premium) while shorting the bond (paying 450 bps). The net 70 bps spread provides attractive income if the basis converges. However, this trade requires careful risk management since you're exposed to credit deterioration (short CDS protection) and may face bond borrow costs and squeeze risk on the short position.
Sourcetable helps evaluate negative basis opportunities with proper risk adjustments. Upload your high yield universe and ask 'Find negative basis trades wider than 50 bps where bonds have borrow availability.' The AI filters for opportunities that are actually executable—many negative basis trades look attractive until you discover the bonds are impossible to borrow or borrow costs exceed the basis profit.
For a specific trade, query 'Calculate break-even for negative basis trade on XYZ Corp assuming 25 bps bond borrow cost.' Sourcetable adjusts the net spread to account for borrow expenses, showing whether sufficient edge remains. It also calculates credit risk exposure—if the issuer defaults, your short CDS position loses money. Ask 'What's my loss if XYZ defaults with 40% recovery?' to quantify tail risk before committing capital.
Sophisticated traders execute basis strategies using credit indices like CDX Investment Grade or iTraxx Europe rather than single-name CDS. Index basis arbitrage involves buying or selling a basket of bonds while taking the opposite position in the credit index. This approach diversifies idiosyncratic credit risk while capturing systematic basis mispricings across the credit market.
A typical index basis trade: the CDX IG index trades at 65 bps while a basket of constituent bonds trades at an average asset swap spread of 85 bps—a 20 bp positive basis. You buy $50 million of the bond basket (weighted by index composition) and buy $50 million notional of CDX IG protection. This creates a diversified basis package with reduced single-name risk.
Sourcetable streamlines index basis analysis by handling the complex basket calculations. Upload the CDX IG constituent list with current bond prices and ask 'Calculate the average asset swap spread for CDX IG constituents weighted by index composition.' The AI computes the weighted average spread, compares it to the index level, and shows the current basis. You can also ask 'Which CDX IG constituents have the widest individual basis?' to identify names contributing most to the index basis dislocation.
For portfolio construction, query 'Build an optimal bond basket to replicate CDX IG exposure with maximum liquidity.' Sourcetable selects the most liquid bonds from index constituents, ensuring your basis package can be adjusted or unwound efficiently. The platform also tracks tracking error—ask 'What's the DV01 mismatch between my bond basket and CDX IG position?' to ensure your hedge ratio remains balanced as spreads move.
Corporate events like mergers, acquisitions, restructurings, or rating changes create temporary basis dislocations as markets digest new information at different speeds. CDS contracts have specific definitions around succession events and credit events that may cause CDS and bonds to price differently during transition periods.
Consider an acquisition scenario: Company A announces it will acquire Company B in a cash deal. Company B's bonds rally on the news (spreads tighten) as credit quality improves with the stronger parent. However, CDS contracts may face uncertainty about whether the acquisition triggers a succession event that terminates contracts. This technical uncertainty can keep CDS spreads wider than bond spreads, creating a positive basis opportunity.
Sourcetable helps traders monitor event-driven basis opportunities across corporate actions. Create a watchlist of companies with pending M&A activity and ask 'Show me basis levels for all issuers with announced acquisitions.' The AI tracks how basis evolves through deal stages—announcement, regulatory approval, closing—highlighting when dislocations create trading opportunities.
For a specific situation, upload deal terms and ask 'Calculate expected basis convergence if the XYZ acquisition closes with standard succession language.' Sourcetable models the scenario, estimating P&L if basis normalizes post-closing. You can also stress test deal break scenarios: 'What happens to my basis trade if the acquisition fails and Company B's credit deteriorates?' This comprehensive scenario analysis ensures you understand both upside potential and downside risks before entering event-driven basis trades.
If your question is not covered here, you can contact our team.
Contact Us