Analyze convertible bonds and option-adjusted spreads with Sourcetable AI. Calculate relative value, credit spreads, and arbitrage opportunities automatically—no complex formulas required.
Andrew Grosser
February 24, 2026 • 17 min read
November 2021: Tesla's 2025 0.0% convertible bonds trade at 145 cents on the dollar with conversion premium at 22%. Investment-grade credit spreads are 85bps. Convertible option-adjusted spread (OAS) analysis represents one of the most sophisticated fixed-income arbitrage strategies available to institutional investors and hedge funds. When you're evaluating a convertible bond trading at $1,050 with an embedded call option and conversion rights, determining whether it's fairly priced requires analyzing multiple dimensions: the credit spread over treasuries, the value of the embedded equity option, and the issuer's call provisions. Traditional analysis involves building complex Excel models with binomial trees, yield curve calculations, and Monte Carlo simulations that can take hours to construct and validate.
The option-adjusted spread strips out the value of embedded options to reveal the true credit spread investors earn for taking on issuer default risk. For a convertible bond yielding 4.5% when comparable straight bonds yield 3.2%, the difference isn't pure alpha—you need to subtract the value of the conversion option and any call provisions. If the embedded options are worth 80 basis points, your actual OAS might only be 50 basis points, fundamentally changing your risk-reward assessment sign up free.
Sourcetable transforms this analysis from a multi-hour spreadsheet project into a conversation with AI. Upload your convertible bond data—prices, yields, conversion ratios, call schedules, and volatility inputs—and simply ask questions like 'What's the option-adjusted spread for these convertibles?' or 'Show me which bonds offer the best relative value.' The AI understands fixed-income terminology, automatically applies the correct valuation models, and generates comprehensive analysis with visualizations. Start analyzing convertible spreads today at app.sourcetable.com/signup.
This strategy appeals to quantitative analysts, fixed-income portfolio managers, and convertible arbitrage hedge funds seeking to identify mispricings in the convertible market. When a convertible bond's OAS widens to 200 basis points while comparable credits trade at 120 basis points, you've potentially found an arbitrage opportunity—assuming you've correctly valued the embedded options. The challenge has always been performing this analysis quickly and accurately across dozens or hundreds of securities. Sourcetable's AI handles the computational complexity while you focus on investment decisions.
Excel-based convertible bond analysis requires building valuation models from scratch—implementing binomial option pricing trees, linking yield curve data, calculating effective durations, and stress-testing assumptions across multiple scenarios. A typical model might contain 20+ interconnected worksheets with thousands of formulas. One error in your volatility surface interpolation or call schedule logic can produce materially wrong OAS calculations. Debugging these models consumes valuable time that should be spent on investment analysis.
Sourcetable's AI understands the structure of convertible bond analysis without requiring you to build the infrastructure. When you upload a dataset containing convertible prices, treasury yields, equity volatilities, and credit spreads, the AI recognizes the data types and knows which calculations to perform. Ask 'Calculate the OAS for each convertible assuming 30% equity volatility' and the system applies option pricing models, adjusts for call provisions, and returns results instantly. No VBA macros, no array formulas, no debugging circular references.
The platform handles the mathematical complexity behind convertible valuation. When analyzing a convertible with a conversion price of $45, current stock price of $52, and a soft call provision at 130% of par, Sourcetable's AI accounts for all these features in the OAS calculation. It understands that the in-the-money conversion option reduces the effective credit spread, and that the call provision creates negative convexity that must be valued. Traditional Excel requires you to code this logic manually; Sourcetable applies it automatically based on your data structure.
Real-time scenario analysis becomes effortless with natural language queries. Instead of manually changing input cells and copying results to a summary table, ask 'Show me how OAS changes if equity volatility increases by 5 percentage points' or 'What happens to spreads if treasury yields rise 50 basis points?' The AI instantly recalculates across your entire portfolio and presents results in tables and charts. This speed advantage proves critical when markets move and you need to reassess positions quickly.
Sourcetable also excels at comparative analysis across multiple securities. When evaluating 50 convertible bonds to identify the widest OAS relative to credit quality, Excel requires building comparison tables with careful cell referencing. In Sourcetable, ask 'Rank these convertibles by OAS adjusted for credit rating' and the AI performs the analysis, accounting for rating differences and presenting opportunities ranked by attractiveness. This capability transforms portfolio construction from a manual spreadsheet exercise into an interactive analytical conversation.
Convertible option-adjusted spread trading offers sophisticated investors the ability to capture relative value opportunities in the fixed-income market while managing embedded option risks. The strategy works best when you can quickly identify mispricings, calculate fair values across multiple scenarios, and monitor positions as market conditions change. Sourcetable provides institutional-quality analytics with unprecedented ease of use.
Sourcetable's AI understands complex fixed-income concepts including option-adjusted spreads, effective duration, convexity, and credit risk. When you upload convertible bond data with yields, conversion terms, and call provisions, the system recognizes the security structure and applies appropriate valuation models automatically. No need to manually code binomial trees or implement Black-Scholes adjustments—the AI handles the quantitative finance mathematics while you focus on identifying opportunities.
The platform calculates OAS by simulating interest rate paths, valuing the convertible under each scenario, and backing out the spread that equates model value to market price. For a convertible trading at $1,080 with a 3.5% coupon, conversion ratio of 20 shares, and call provision at 105, Sourcetable determines whether the 150 basis point spread over treasuries adequately compensates for credit risk after removing option value. This calculation would require hundreds of Excel formulas; Sourcetable delivers it through a simple question.
Identifying the most attractive convertibles requires comparing OAS across issuers while adjusting for credit quality, liquidity, and structural features. In Excel, this means building comparison tables, normalizing for different ratings, and manually sorting results. Sourcetable transforms this into natural language: 'Show me BB-rated convertibles with OAS above 200 basis points' or 'Which convertibles offer the widest spreads relative to their credit default swap levels?'
The AI automatically joins your convertible data with credit ratings, CDS spreads, and equity volatilities to perform comprehensive relative value analysis. When a BB+ rated convertible shows an OAS of 225 basis points while its CDS trades at 180 basis points, Sourcetable flags this as a potential opportunity. The 45 basis point difference might indicate the convertible is cheap, or it might reflect liquidity premium or call risk—but you've identified the opportunity in seconds rather than hours.
Convertible bonds exhibit complex sensitivity to multiple risk factors: interest rates, credit spreads, equity prices, and volatility. Understanding how your position performs under various scenarios is essential for risk management. Sourcetable enables instant stress testing through conversational queries: 'What happens to my portfolio OAS if rates rise 100 basis points and equity volatility increases to 40%?'
The AI recalculates valuations across all positions, accounting for how rising rates affect bond prices, how increased volatility changes option values, and how credit spreads might widen in stressed conditions. For a portfolio of 30 convertibles with $50 million notional, Excel-based scenario analysis might take 15 minutes to set up and calculate. Sourcetable delivers comprehensive results in seconds, enabling you to test multiple scenarios quickly and make informed risk management decisions.
Convertible arbitrage involves buying undervalued convertibles while hedging the equity and interest rate risks, capturing the credit spread and option mispricing. Identifying these opportunities requires comparing convertible OAS to straight bond yields, equity implied volatility to option-implied volatility, and monitoring these relationships continuously. Sourcetable automates this surveillance across your entire universe.
Ask 'Which convertibles have OAS at least 50 basis points wider than comparable straight bonds?' and the AI analyzes your dataset, matches convertibles to similar maturity straight debt, calculates the spread differential, and presents opportunities ranked by magnitude. When a convertible's OAS is 180 basis points while the issuer's straight 5-year bond yields 110 basis points over treasuries, you've potentially found a 70 basis point arbitrage after accounting for the embedded equity option value.
Understanding your portfolio's aggregate exposures to interest rates, credit, and equity helps manage risk and optimize hedging strategies. Sourcetable automatically generates visualizations showing OAS distribution, duration profiles, credit quality composition, and delta exposure across your convertible portfolio. Ask 'Show me my portfolio's effective duration by credit rating' and receive an instant chart breaking down interest rate sensitivity.
These visualizations update dynamically as market data changes or as you modify positions. When you're considering adding a new convertible with 4.2 years duration and 180 basis points OAS, instantly see how it affects your portfolio's overall risk profile. This real-time feedback enables more informed portfolio construction decisions than static Excel charts that require manual updating.
Analyzing convertible option-adjusted spreads in Sourcetable follows a straightforward workflow that replaces complex Excel modeling with natural language interaction. The platform handles the quantitative finance calculations while you focus on investment insights and decision-making. Here's how to implement convertible OAS analysis from data upload through portfolio optimization.
Start by uploading your convertible bond dataset containing essential information: CUSIP or identifier, current market price, coupon rate, maturity date, conversion ratio, conversion price, call schedule, and any put provisions. Include corresponding market data: treasury yield curve, credit spreads, underlying equity prices, and implied volatilities. Sourcetable accepts CSV files, Excel workbooks, or direct connections to financial data providers.
For example, your dataset might show: XYZ Corp convertible bond priced at $1,120, 2.5% coupon, maturing in 5 years, conversion ratio of 25 shares (conversion price $40), callable at 103 after year 2, with the underlying stock trading at $48 and implied volatility of 35%. The AI recognizes this structure and understands that this is an in-the-money convertible with significant equity sensitivity and call risk.
Once data is loaded, simply ask 'Calculate the option-adjusted spread for each convertible bond.' Sourcetable's AI applies option pricing models to value the embedded conversion option and call provisions, then determines the credit spread that equates the model value to the observed market price. The calculation accounts for the probability of conversion, the likelihood of the issuer calling the bond, and the time value of these embedded options.
For the XYZ Corp example, the AI might determine that the embedded equity option is worth $180 per bond and the call provision reduces value by $30, resulting in a straight bond equivalent value of $970. Comparing this to the $1,120 market price and the treasury yield curve, the system calculates an OAS of 165 basis points. This represents the pure credit spread after stripping out option values—your compensation for default risk.
With OAS calculated for your universe of convertibles, identify relative value opportunities by comparing spreads across issuers with similar credit profiles. Ask 'Show me BB-rated convertibles ranked by OAS' or 'Which convertibles have OAS wider than their CDS spreads?' The AI sorts and filters your dataset, highlighting securities that appear cheap or expensive relative to credit fundamentals.
Sourcetable might reveal that while most BB-rated convertibles trade at 140-170 basis points OAS, one issuer shows 210 basis points. This outlier warrants investigation—is the wider spread justified by company-specific risks, or does it represent a mispricing? The platform enables you to drill into individual securities, examine their characteristics, and compare them to peers, all through conversational queries rather than complex Excel filtering and sorting.
Test how your convertible positions perform under different market conditions by asking scenario-based questions. 'What happens to OAS if interest rates increase 50 basis points?' or 'How do values change if equity volatility drops to 25%?' The AI recalculates all valuations under the new assumptions, showing you how spreads and prices adjust across your portfolio.
This capability proves essential for risk management. If rising rates cause your convertible portfolio's average OAS to compress from 160 to 145 basis points (as bond prices fall and spreads tighten), you can quantify the mark-to-market impact and assess whether current positions remain attractive. Traditional Excel scenario analysis requires manually changing input cells and recording results; Sourcetable automates this entire process through natural language commands.
Continuously monitor your convertible portfolio by setting up queries that flag opportunities or risks. Ask 'Alert me when any convertible's OAS exceeds 200 basis points' or 'Show me convertibles where the spread to straight bonds widens beyond 60 basis points.' Sourcetable tracks these conditions and highlights securities meeting your criteria.
For convertible arbitrage strategies, identify situations where the convertible appears mispriced relative to the underlying equity and credit. When a convertible's implied volatility (backed out from its market price) is 28% while equity options trade at 35% implied volatility, you might buy the convertible and sell equity options to capture the 7 percentage point volatility differential. Sourcetable helps identify these arbitrage opportunities by comparing implied parameters across instruments.
Create comprehensive portfolio reports by requesting specific analyses and visualizations. 'Create a chart showing OAS distribution by credit rating' or 'Generate a table of my top 10 positions ranked by spread per unit of duration.' The AI produces publication-ready charts, tables, and summaries that you can share with portfolio managers, risk committees, or investors.
These reports update automatically as market data changes, ensuring you always have current information. When presenting portfolio positioning to stakeholders, you can demonstrate not just what you own, but why—showing that your convertible selections offer attractive OAS relative to credit quality, favorable risk-reward profiles, and diversification benefits. This level of analysis would require hours of Excel work; Sourcetable delivers it in minutes through conversational AI.
Convertible option-adjusted spread analysis serves multiple investment strategies and organizational roles. From hedge fund portfolio managers executing convertible arbitrage to corporate treasury teams evaluating financing options, understanding the true credit spread embedded in convertible securities drives better decisions. These use cases demonstrate how Sourcetable enables sophisticated analysis across different applications.
A convertible arbitrage hedge fund manages $800 million across 60 convertible bond positions, each hedged with short equity positions and interest rate swaps. The fund's edge comes from identifying convertibles trading at wide OAS relative to credit fundamentals, buying them, and hedging away equity and rate risk to isolate the credit spread. Portfolio managers need to continuously monitor OAS across all positions, comparing them to CDS spreads and straight bond yields to ensure each position remains attractive.
Using Sourcetable, the team uploads daily pricing data for all convertibles, underlying equities, and reference credit instruments. They ask 'Which positions have OAS that compressed more than 20 basis points this week?' to identify securities that have richened and might warrant profit-taking. When they discover a technology company convertible showing 195 basis points OAS while its 5-year CDS trades at 140 basis points, they investigate whether the 55 basis point differential is justified. If the convertible appears cheap due to temporary illiquidity rather than fundamental credit deterioration, they increase the position size.
The fund also uses Sourcetable for risk management, asking 'What's my portfolio's aggregate credit spread duration?' to understand sensitivity to credit spread widening. When analysis shows 4.8 years of spread duration with average OAS of 168 basis points, they can calculate that a 25 basis point widening across the portfolio would generate approximately $9.6 million in mark-to-market gains (4.8 × 0.25% × $800M). This real-time risk visibility enables dynamic position sizing and hedging decisions that would be impractical with manual Excel calculations.
A multi-asset investment manager allocates $200 million to convertible bonds within a balanced portfolio, seeking securities that offer equity upside participation with downside protection. The manager wants convertibles with attractive OAS to compensate for credit risk, but also values the embedded equity option for participation in stock appreciation. The challenge is balancing these objectives while maintaining appropriate credit quality and diversification.
The portfolio manager uses Sourcetable to screen a universe of 300 convertibles, asking 'Show me investment-grade convertibles with OAS above 100 basis points and delta between 40% and 70%.' This query identifies bonds offering meaningful credit spreads while retaining moderate equity sensitivity—the 'balanced' convertibles that fit the portfolio mandate. The AI returns 18 securities meeting these criteria, ranked by a composite score combining OAS, credit quality, and equity upside potential.
When evaluating a specific convertible—a BBB-rated healthcare company bond with 3.0% coupon, 4 years to maturity, priced at $1,090, with conversion into stock at $55 (current stock price $62)—the manager asks 'What's the OAS and what's my downside if the stock falls 20%?' Sourcetable calculates 125 basis points OAS and shows that a 20% equity decline would result in the convertible trading around $980, representing 10% downside from current price. This asymmetric profile—meaningful credit spread plus limited downside relative to equity—makes the bond attractive for the balanced portfolio.
A technology company's treasury team evaluates financing options for a $500 million capital raise. They're comparing straight debt at 4.5% versus issuing a convertible bond at 2.5% with conversion premium of 30% above the current $75 stock price. The CFO wants to understand the true cost of the convertible financing after accounting for the value of the conversion option the company is granting to investors.
The treasury team uses Sourcetable to model the convertible structure, inputting proposed terms: 2.5% coupon, 5-year maturity, conversion price $97.50, callable after 3 years at 102. They ask 'What option-adjusted spread would investors require for this convertible given our BBB+ rating and 32% equity volatility?' The AI analyzes comparable convertibles from similar credits and market conditions, determining that investors would likely require 140 basis points OAS.
Adding this 140 basis point OAS to the 2.5% coupon, plus the value of the call option the company retains, produces an all-in cost of approximately 4.1%—cheaper than the 4.5% straight debt alternative. However, the analysis also reveals that if the stock appreciates significantly, dilution from conversion could be substantial. Sourcetable helps the team model scenarios: 'What happens if our stock reaches $120 in three years?' showing that early conversion would result in issuing shares at an effective $97.50 when they're worth $120—a 19% dilution cost. These insights enable the CFO to make an informed decision balancing financing cost against dilution risk.
A credit research analyst covering the consumer retail sector monitors 25 companies, several of which have convertible bonds outstanding. Understanding whether these convertibles trade at appropriate OAS relative to credit fundamentals helps the analyst identify companies where the market perceives greater or lesser credit risk than the analyst's internal rating suggests. When a convertible's OAS widens significantly, it might signal deteriorating credit conditions before the company's straight debt shows stress.
The analyst uses Sourcetable to track OAS trends across the coverage universe, asking 'Show me the 3-month trend in OAS for all retail convertibles.' When one retailer's convertible OAS widens from 175 to 240 basis points while its straight bond spread only widens from 160 to 180 basis points, this divergence warrants investigation. The analyst queries 'What's changed in the convertible's structure or equity sensitivity?' and discovers that the underlying stock has fallen 25%, reducing the conversion option value and making the bond trade more like straight debt—hence the OAS widening.
This analysis informs the analyst's credit opinion. If OAS is widening primarily due to equity price decline rather than fundamental credit deterioration, the convertible might represent a buying opportunity for investors. Conversely, if OAS widening accompanies deteriorating financial metrics—declining EBITDA, rising leverage, weakening liquidity—it confirms credit concerns and might prompt a rating downgrade recommendation. Sourcetable enables the analyst to perform this multi-dimensional analysis across the entire coverage universe efficiently, identifying credit trends that might be missed when analyzing securities in isolation.
If your question is not covered here, you can contact our team.
Contact Us