Market-Making Trading Strategy Analysis
Analyze market-making strategies with Sourcetable AI. Calculate bid-ask spreads, manage inventory risk, and optimize profitability using natural language—no complex formulas required.
Andrew Grosser
February 24, 2026 • 19 min read
Introduction
March 2020: Bid-ask spreads on SPDR ETFs blew out 10x as market makers pulled liquidity. Understanding how market makers price risk explains why spreads widen exactly when you need tight markets most. Market-making is a sophisticated trading strategy where you continuously quote both buy and sell prices for financial instruments, profiting from the bid-ask spread while providing liquidity to markets. Professional traders and institutions use market-making to generate consistent returns, but analyzing spreads, inventory positions, and risk exposures traditionally requires complex Excel models with hundreds of formulas.
The challenge? Traditional spreadsheet analysis means building intricate models to track real-time positions, calculate inventory risk, monitor P&L across multiple securities, and optimize quote placement. You're managing volatility adjustments, hedging requirements, adverse selection costs, and capital allocation—all while markets move in milliseconds. One miscalculation in your spread model or inventory valuation can turn profitable trades into losses sign up free.
Why Sourcetable for Market-Making Analysis
Market-making requires constant monitoring of positions, spreads, and risk metrics across potentially hundreds of instruments. Excel traders spend hours building models with VLOOKUP formulas for position tracking, nested IF statements for spread calculations, complex array formulas for Greeks aggregation, and pivot tables for P&L analysis. Every new instrument means copying formulas, adjusting references, and praying nothing breaks.
Sourcetable eliminates this complexity with AI that understands market-making terminology and calculations. Instead of writing =SUMIFS formulas to aggregate inventory by strike or building elaborate spreadsheets to calculate theoretical edge, you simply ask: 'What's my net delta exposure?' or 'Calculate average spread capture by symbol.' The AI instantly analyzes your data, performs calculations, and presents results in clear tables and charts.
The platform handles real-world market-making complexity automatically. Upload trade files with fills at different prices, position snapshots with multiple expirations, or quote data with changing spreads—Sourcetable's AI processes it all. Ask 'Show me inventory risk by expiration and strike' and get instant analysis. Request 'Calculate adverse selection costs for trades over $10,000' and see detailed breakdowns. Need to analyze spread compression during volatile periods? Just describe what you want in natural language.
Beyond calculations, Sourcetable provides visualization and scenario analysis that would take hours in Excel. The AI automatically generates P&L charts by time period, inventory heatmaps by strike and expiration, spread distribution histograms, and risk exposure graphs. Want to model the impact of widening spreads by 10% or analyze profitability under different volatility regimes? Describe your scenario and the AI builds the analysis instantly.
For teams, Sourcetable becomes your collaborative market-making hub. Share live dashboards with updated positions, create standardized risk reports that auto-refresh with new data, and ensure everyone analyzes trades using consistent methodologies. No more emailing spreadsheets with broken links or version control nightmares. Your entire market-making operation runs on one intelligent platform that scales from analyzing a single symbol to managing complex multi-asset portfolios.
Benefits of Market-Making Analysis with Sourcetable
Market-making generates consistent returns through spread capture while providing essential market liquidity. Professional traders use this strategy to profit from the natural bid-ask spread, earning the difference between where they buy and sell securities. Success requires precise analysis of spreads, inventory management, and risk control—areas where Sourcetable's AI capabilities deliver significant advantages over traditional spreadsheet approaches.
Instant Spread Analysis and Optimization
Calculating effective spreads across multiple trades and time periods is tedious in Excel. You need formulas to match buys with sells, adjust for partial fills, account for fee structures, and aggregate by symbol or strategy. Sourcetable's AI understands market-making mechanics and calculates spreads instantly. Upload your trade file and ask 'What's my average spread capture on AAPL options this week?' The AI analyzes all trades, matches positions, accounts for timing, and shows your realized spread—in seconds, not hours.
The platform handles complex spread scenarios automatically. Got trades with different lot sizes? Partial fills across multiple price levels? Options with varying strikes and expirations? Sourcetable processes it all. Ask 'Show spread capture by volatility regime' and the AI segments your trades by market conditions, calculating how your spreads perform in different environments. This insight helps you optimize quote placement and identify the most profitable trading conditions.
- Bid-Ask Spread Components: Total spread = inventory cost + adverse selection cost + order processing cost; in normal markets, adverse selection is 40-60% of total spread; during volatile markets, it rises to 70-80% as informed traders dominate order flow.
- Optimal Spread Formula: Avellaneda-Stoikov model: spread = gamma x sigma^2 x T + (2/gamma) x ln(1 + gamma/k); where gamma=risk aversion, sigma=volatility, T=time horizon, k=order arrival rate; higher volatility or risk aversion directly widens the optimal spread.
- Inventory Skewing: When long inventory accumulates, lower the bid and raise the ask to attract sellers; when short, reverse the skew; a 100-share long inventory position in a stock with $0.10 spread should cause bid to drop 1-2 cents to encourage customer selling.
- Fill Rate vs. Profitability: Tighter spreads increase fill rate but reduce per-trade profit; optimal spread balances both - SPY market makers quote $0.01 spread for high fill rates, making profits from volume (50M+ shares/day) rather than per-trade margin.
Real-Time Inventory Risk Management
Managing inventory exposure is critical for market-makers. Accumulating too much long or short inventory creates directional risk that can wipe out spread profits. Traditional Excel models require constant manual updates—copying position data, calculating net exposures, aggregating Greeks, and monitoring limits. Sourcetable transforms this process with natural language queries that deliver instant risk analysis.
Upload your current positions and ask 'What's my net delta exposure by expiration?' The AI instantly aggregates all positions, calculates Greeks, and shows your risk profile. Need to see inventory concentration? Ask 'Show me positions larger than 100 deltas' and get immediate results. The platform handles options positions automatically—calculating delta, gamma, theta, and vega across all strikes and expirations without requiring you to build Greeks calculators or maintain reference data.
For multi-asset market-makers, Sourcetable provides portfolio-level risk aggregation that's painful in Excel. Ask 'Calculate total portfolio delta across all symbols' or 'Show me gamma exposure by sector' and the AI analyzes your entire book. You can instantly identify concentration risks, hedge requirements, and capital allocation issues that might take hours to uncover manually. This real-time risk visibility helps you avoid costly inventory buildups and maintain balanced exposures.
- Inventory Limits: Market makers set maximum long and short inventory positions; a retail market maker with $1M capital might limit any single stock to plus/minus $100K position (10% of capital); exceeding limits triggers mandatory hedging or spread widening.
- Delta Hedging for Options Market Makers: Options MMs must delta-hedge their inventory continuously; a short 100 AAPL calls at delta 0.45 creates -45-share delta position requiring buying 45 shares of AAPL to hedge - each option trade triggers a stock trade.
- Inventory Mean-Reversion: Well-functioning market making maintains near-zero average inventory over time; if inventory persistently trends positive (accumulating long stock), market makers face adverse selection - sophisticated informed traders are buying from you consistently.
- Overnight Risk: Market makers who hold inventory overnight face gap risk; a $500K inventory in a single tech stock can gap 5-10% at open on earnings - many HFT market makers flatten positions completely before market close to avoid overnight exposure.
Automated P&L Attribution and Performance Analytics
Understanding what drives your market-making profits is essential for strategy refinement. Is your P&L coming from spread capture, favorable inventory marks, or volatility changes? Excel P&L attribution requires complex formulas tracking position changes, price movements, theta decay, and realized vs. unrealized gains. Sourcetable's AI handles this complexity automatically.
Ask 'Break down my P&L by source' and the AI analyzes your trades and positions to show spread income, mark-to-market changes, theta decay, and other components. Request 'Show daily P&L for the last month with trade count' and get instant visualization of your performance trends. The platform calculates key metrics like P&L per trade, return on capital, Sharpe ratio, and maximum drawdown—metrics that require extensive Excel modeling to compute accurately.
Performance analysis extends to strategy optimization. Ask 'Which symbols generate the highest risk-adjusted returns?' and Sourcetable analyzes your entire trading history to rank instruments by profitability, volatility, and efficiency. This data-driven insight helps you allocate capital to your most profitable market-making opportunities and identify underperforming symbols to drop from your trading universe.
Adverse Selection and Trade Quality Analysis
Market-makers face adverse selection risk—trading with informed counterparties who move prices against you. Analyzing trade quality requires examining post-trade price movements, fill rates, and whether you're consistently buying highs and selling lows. Building this analysis in Excel means complex time-series formulas, price data alignment, and statistical calculations that most traders avoid despite their importance.
Sourcetable makes adverse selection analysis accessible through natural language. Upload your trades with timestamps and ask 'Show me average price movement 5 minutes after my fills.' The AI analyzes post-trade price action to reveal whether you're experiencing adverse selection. Request 'Calculate adverse selection costs by trade size' and discover if larger trades face worse execution quality—critical insight for optimizing your quote sizes.
The platform helps you identify problematic trading patterns. Ask 'Show trades where price moved against me by more than 0.5% within 10 minutes' to spot potentially informed flow. Request 'Compare fill rates when I'm at the inside market vs. penny-wide' to optimize quote placement. These insights, difficult to extract from Excel, become instantly accessible with AI-powered analysis, helping you refine your market-making approach and avoid costly adverse selection.
- Toxicity Metrics: Volume-synchronized probability of informed trading (VPIN); high VPIN predicts adverse selection risk; when VPIN exceeds 0.7, market makers should widen spreads to compensate for the increased probability of trading against informed flow.
- Order Flow Toxicity: If 70% of fills are from a single client who consistently profits after trading with you, that client is toxic (informed); modern market makers classify client flow by toxicity and quote wider spreads to high-toxicity clients.
- Price Impact After Fill: If price consistently moves against the market maker within 5 seconds of each fill, the order flow has significant adverse selection content; measure 5-second price impact as a percentage of the spread to quantify toxicity.
- Information Leakage: When a large institutional order enters the market, front-running algorithmic traders detect the order flow and trade ahead; market makers detect unusual flow patterns 100-500ms before price moves, allowing them to widen spreads preemptively.
Scenario Analysis and Strategy Backtesting
Before deploying capital to new symbols or adjusting spread strategies, you need to understand potential outcomes. Excel scenario analysis requires building separate models for each situation—copying formulas, changing assumptions, tracking results. Sourcetable's AI handles scenarios through simple conversational requests that generate instant analysis.
Ask 'What would my P&L be if spreads widened by 20%?' and the AI recalculates your historical performance under that scenario. Request 'Model the impact of doubling my position sizes' to understand capital requirements and risk exposure. The platform processes your actual trading data to generate realistic projections, not theoretical models disconnected from your real performance.
Backtesting becomes equally accessible. Upload historical market data and ask 'Backtest a 0.05 wide market in SPY with 100 share clips.' Sourcetable simulates your strategy across the data, calculating fills, inventory management, and resulting P&L. You can test different spread widths, position limits, and hedging rules without writing a single line of code. This rapid strategy iteration helps you optimize your market-making approach before risking real capital.
How Market-Making Analysis Works in Sourcetable
Sourcetable combines spreadsheet familiarity with AI intelligence to make market-making analysis effortless. The platform understands trading terminology, financial calculations, and market-making mechanics, so you can analyze strategies through natural conversation instead of formula engineering. Here's how professional traders use Sourcetable to optimize their market-making operations.
Step 1: Upload Your Trading Data
Start by importing your market-making data into Sourcetable. Upload trade files from your broker, position snapshots from your risk system, or market data from your quote provider. The platform accepts CSV, Excel files, or direct database connections. Your data might include executed trades with prices, sizes, and timestamps; current positions with strikes, expirations, and quantities; or historical quotes showing bid-ask spreads over time.
Sourcetable automatically recognizes trading data structures—identifying symbol columns, price fields, quantity information, and timestamps. Unlike Excel where you manually format cells and create reference tables, the AI understands your data immediately. Got options trades with strikes and expirations? The platform recognizes option notation. Have trades across multiple accounts or strategies? Sourcetable maintains the structure without requiring complex VLOOKUP formulas.
- Start by importing your market-making data into Sourcetable.
- Sourcetable automatically recognizes trading data structures—identifying symbol .
Step 2: Ask Questions in Plain English
Once your data is loaded, analyze it by asking questions naturally. Type 'What's my total P&L this month?' or 'Show me inventory by expiration' in the AI chat. Sourcetable processes your question, identifies relevant data, performs calculations, and presents results—usually in under two seconds. No formulas to write, no pivot tables to configure, no macros to debug.
The AI handles complex market-making calculations automatically. Ask 'Calculate my average spread capture on TSLA' and it matches your buy and sell trades, computes the spread on each round trip, and calculates the average—accounting for partial fills, different lot sizes, and timing. Request 'Show net delta exposure by symbol' and the AI aggregates all your option positions, calculates deltas using appropriate models, and summarizes by underlying—calculations that would require dozens of Excel formulas.
Questions can be as simple or sophisticated as your analysis requires. Beginners might ask 'What symbols am I trading?' or 'Show my biggest positions.' Experienced market-makers can request 'Calculate adverse selection costs for trades larger than 500 shares where price moved more than 0.3% against me within 5 minutes' or 'Show correlation between spread width and volatility regime.' Sourcetable handles both with equal ease.
Step 3: Generate Instant Visualizations
Understanding market-making performance requires visual analysis—charts showing P&L trends, heatmaps revealing inventory concentration, distributions illustrating spread capture. Excel charting means selecting data ranges, choosing chart types, formatting axes, and adjusting legends. Sourcetable generates publication-ready visualizations through simple requests.
Ask 'Chart my daily P&L for the last quarter' and get an instant line graph with properly formatted dates and currency values. Request 'Show inventory heatmap by strike and expiration' and receive a color-coded visualization revealing concentration risks. The AI selects appropriate chart types for your data—time series for trends, bar charts for comparisons, scatter plots for correlations, heatmaps for multi-dimensional data.
Visualizations update automatically as you refine your analysis. Ask 'Now show only profitable trades' and the chart instantly filters. Request 'Add a trend line' or 'Break down by symbol' and the visualization adjusts immediately. This interactive exploration helps you discover patterns and insights that static Excel charts miss—like noticing that your spread capture deteriorates on Fridays or that certain symbols consistently underperform.
- Understanding market-making performance requires visual analysis—charts showing .
- "Chart my daily P&L for the last quarter"
- "Show inventory heatmap by strike and expiration"
- "Now show only profitable trades"
- "Break down by symbol"
Step 4: Perform Scenario Analysis and Optimization
Market-making strategy refinement requires testing different approaches—wider spreads, tighter position limits, different hedging thresholds. Excel scenario analysis means duplicating models, manually changing assumptions, and comparing results across multiple tabs. Sourcetable handles scenarios through conversational requests that generate instant comparisons.
Ask 'What would my P&L be if I used 0.10 wide markets instead of 0.05?' and Sourcetable recalculates your historical performance under that assumption. The AI adjusts spread capture, estimates fill rate changes based on your data patterns, and projects the net impact. Request 'Model the effect of limiting inventory to 50 deltas per symbol' and see how that constraint would have affected your positions and profitability.
Optimization becomes equally accessible. Ask 'What spread width maximizes risk-adjusted returns?' and Sourcetable analyzes your trading history across different spread regimes to identify the optimal balance between capture and fill rate. This data-driven optimization, nearly impossible in Excel without advanced modeling skills, becomes a simple conversation in Sourcetable.
Step 5: Create Automated Reports and Dashboards
Professional market-makers need consistent reporting—daily P&L summaries, risk reports for compliance, performance analytics for strategy review. Excel reporting means copying formulas, updating date ranges, and manually refreshing data. Sourcetable automates this process with templates that update automatically when new data arrives.
Create a market-making dashboard showing key metrics: current inventory positions, today's P&L, average spreads, top performing symbols, and risk exposures. As you add new trades or positions, the dashboard updates automatically—no manual refresh required. Share the dashboard with your team or risk managers, and everyone sees the same real-time information without email attachments or version confusion.
Build custom reports for specific needs. A morning risk report might show overnight position changes, current exposures, and hedge recommendations. An end-of-day performance report could detail P&L by symbol, spread capture statistics, and adverse selection metrics. Once created, these reports regenerate automatically with updated data, saving hours of manual Excel work each week.
Step 6: Collaborate and Share Insights
Market-making often involves teams—traders managing different symbols, risk managers monitoring exposures, analysts optimizing strategies. Excel collaboration means emailing spreadsheets, dealing with version conflicts, and hoping formulas don't break when someone opens the file. Sourcetable provides real-time collaboration where everyone works on the same data with live updates.
Share your market-making analysis with team members who can ask their own questions and create their own views—without affecting your work. A trader might analyze spread capture while a risk manager simultaneously examines inventory exposures, both working with the same underlying data. Changes appear instantly for all users, ensuring everyone has current information for decision-making.
The platform maintains audit trails showing who analyzed what and when—important for compliance and strategy review. You can see which questions were asked, what analysis was performed, and how conclusions were reached. This transparency, difficult to achieve in Excel, ensures your market-making operation maintains proper oversight and documentation.
Market-Making Use Cases
Market-making strategies vary widely based on asset class, market structure, and risk tolerance. Sourcetable adapts to different market-making approaches, providing specialized analysis for each trading style. Here's how different types of market-makers use the platform to optimize their operations and maximize risk-adjusted returns.
Options Market-Making and Volatility Trading
Options market-makers quote bid-ask spreads across multiple strikes and expirations, managing complex Greek exposures while capturing spread income. A typical options market-maker might quote 50+ different options on a single underlying, maintaining inventory across the entire surface. Traditional analysis requires sophisticated Excel models calculating theoretical values, implied volatilities, Greeks aggregation, and hedging requirements—models that take months to build and constant maintenance to keep functional.
Sourcetable transforms options market-making analysis through AI that understands options mechanics. Upload your position file showing 200 different SPY option contracts with varying strikes, expirations, and quantities. Ask 'What's my net delta exposure?' and the AI instantly aggregates all positions, calculates individual deltas, and shows your portfolio delta—positive or negative. Request 'Show gamma exposure by expiration' and see which expiration cycles create the most curvature risk.
The platform handles sophisticated options analysis that's painful in Excel. Ask 'Calculate my vega exposure to a 1% implied volatility increase across all positions' and Sourcetable computes the P&L impact instantly. Request 'Show positions where I'm short gamma with less than 7 days to expiration' to identify high-risk inventory requiring immediate attention. Need to analyze spread capture by moneyness? Ask 'Compare my average spread on ITM vs. OTM options' and get instant segmentation.
Volatility surface analysis becomes accessible without complex modeling. Upload historical implied volatility data and ask 'Show how my spread capture correlates with VIX levels.' Sourcetable analyzes your trading performance across different volatility regimes, revealing whether you're more profitable in high or low vol environments. This insight helps you adjust quote widths, position limits, and hedging frequency based on current market conditions.
Equity Market-Making and Statistical Arbitrage
Equity market-makers provide liquidity in stocks, capturing spreads while managing inventory risk and adverse selection. You might quote 20-30 stocks simultaneously, each with different spread widths, volatility profiles, and liquidity characteristics. Success requires analyzing which symbols generate the best risk-adjusted returns, how inventory accumulation affects performance, and where adverse selection erodes profits.
Sourcetable makes equity market-making analysis effortless. Upload your trade file showing 5,000 fills across 25 different stocks over the past month. Ask 'Calculate average spread capture by symbol' and instantly see which stocks generate the most profit per share. Request 'Show P&L per trade by symbol' to identify your most efficient markets. The AI handles all the matching logic—pairing buys with sells, accounting for partial fills, adjusting for fees—calculations that require complex Excel formulas with SUMIFS, INDEX-MATCH, and array functions.
Inventory management becomes transparent. Ask 'Show my average holding period by symbol' to understand how long you typically carry risk before offsetting. Request 'Calculate maximum inventory reached for each symbol' to assess whether your position limits are appropriate. Need to analyze the relationship between inventory and performance? Ask 'Show P&L when inventory exceeded 1,000 shares vs. below 500 shares' and discover whether large positions hurt your returns.
Adverse selection analysis reveals trading quality issues. Ask 'Calculate average price movement 2 minutes after my fills by trade size' and Sourcetable shows whether larger trades face worse execution. Request 'Show fills where price moved against me by more than 0.2% within 5 minutes' to identify potentially informed flow. This analysis, requiring complex time-series Excel formulas with timestamp matching, becomes a simple natural language query in Sourcetable.
Cryptocurrency Market-Making Across Exchanges
Crypto market-makers often operate across multiple exchanges simultaneously, exploiting spread opportunities while managing inventory across fragmented liquidity pools. You might quote BTC, ETH, and 20 altcoins on five different exchanges, each with different fee structures, maker-taker models, and withdrawal constraints. Analyzing this complex operation in Excel requires separate sheets for each exchange, manual consolidation of positions, and constant reconciliation—a nightmare of VLOOKUP formulas and copy-paste errors.
Sourcetable unifies multi-exchange analysis through AI that understands cross-platform trading. Upload trade files from Binance, Coinbase, Kraken, and other exchanges—each with different formats and column structures. Ask 'What's my total inventory across all exchanges?' and the AI automatically consolidates positions, handling different symbol naming conventions (BTC vs. BTCUSD vs. XBT) and denomination units. Request 'Show P&L by exchange' and see which platforms generate the best returns.
Fee analysis becomes critical in crypto market-making where maker-taker rebates significantly impact profitability. Ask 'Calculate net P&L after fees by exchange' and Sourcetable applies each platform's fee structure to your trades, showing true profitability. Request 'Compare spread capture vs. fee costs' to ensure you're capturing enough spread to cover transaction expenses. The platform handles complex fee calculations—tiered structures, maker rebates, volume discounts—that would require extensive Excel modeling.
Cross-exchange arbitrage opportunities appear through natural queries. Ask 'Show times when BTC spread on Binance exceeded Coinbase by more than 0.05%' to identify potential arbitrage. Request 'Calculate cost of rebalancing inventory between exchanges' to understand transfer fees and timing constraints. This multi-exchange perspective, nearly impossible to maintain in Excel, becomes standard operating procedure with Sourcetable's unified analysis platform.
Fixed Income and Bond Market-Making
Bond market-makers provide liquidity in corporate bonds, municipals, or government securities—instruments with varying maturities, credit qualities, and liquidity profiles. Unlike exchange-traded securities with continuous quotes, bonds often trade by appointment with wide spreads and irregular flow. Analysis requires tracking inventory by maturity and credit rating, calculating duration risk, monitoring spread movements, and assessing liquidity costs.
Sourcetable handles fixed income complexity through AI that understands bond characteristics. Upload your bond inventory showing 150 different CUSIPs with varying maturities, coupons, and credit ratings. Ask 'Calculate total duration exposure' and the AI computes duration for each bond, weights by position size, and aggregates to show portfolio-level interest rate risk. Request 'Show inventory by credit rating' to assess credit concentration risk.
Spread analysis reveals trading profitability across different bond types. Ask 'Compare average spread capture on investment grade vs. high yield bonds' and see which credit quality generates better risk-adjusted returns. Request 'Show spread capture by maturity bucket' to understand whether short-dated or long-dated bonds are more profitable. The AI handles bond-specific calculations—yield-to-maturity, spread-to-benchmark, duration-adjusted returns—without requiring you to build fixed income models in Excel.
Liquidity analysis helps optimize inventory management. Ask 'Show average time to exit positions by credit rating' to understand holding periods across different bond types. Request 'Calculate inventory turnover by maturity' to identify slow-moving positions tying up capital. This analysis helps you refine which bonds to quote actively and which to avoid due to liquidity constraints—strategic decisions that require data-driven insights Sourcetable makes instantly accessible.
Frequently Asked Questions
If your question is not covered here, you can contact our team.
Contact UsHow does a market maker determine the bid-ask spread and what factors affect its width?
What is the Kyle lambda and how do market makers use it to detect informed order flow?
How does inventory management affect market maker profitability and what are the risks of accumulated directional exposure?
How have electronic market making firms (Citadel, Virtu, Jane Street) changed competitive dynamics?
What is payment for order flow (PFOF) and how does it affect retail investor execution quality?
How do option market makers manage delta, gamma, and vega risk across large option portfolios?
What are the key regulatory requirements for becoming a registered market maker and what capital minimums apply?
