Analyze loan sharking options strategies with Sourcetable AI. Calculate premiums, strike prices, and income scenarios automatically—no complex formulas required.
Andrew Grosser
February 24, 2026 • 17 min read
November 2023: XYZ stock is at $45. You sell a 30-delta put at $42 strike for $2.10 premium, collecting $210 per contract. If assigned, your effective cost basis is $39.90—an 11% discount. The loan sharking trading strategy is an aggressive options income technique where traders systematically sell out-of-the-money put options to collect premiums, similar to how traditional loan sharks collect interest payments. This strategy capitalizes on time decay and volatility premiums, generating consistent income when markets remain stable or rise. The name comes from the high-interest-rate nature of the premiums collected relative to the capital at risk.
Unlike conservative strategies like covered calls, loan sharking involves naked put selling or cash-secured puts on multiple positions simultaneously. Traders might collect 2-5% monthly premiums on stocks trading at $50-$100, targeting strikes 5-15% out of the money with 30-45 day expirations. The risk? If markets drop sharply, you're obligated to buy shares at the strike price, potentially facing significant losses if multiple positions get assigned simultaneously sign up free.
Loan sharking requires monitoring multiple dimensions simultaneously: premium income, margin utilization, delta exposure, assignment probability, and downside risk across 10-30 positions. In Excel, this means maintaining separate worksheets for position tracking, Greeks calculations, scenario analysis, and P&L reporting. Each market move requires manual updates to dozens of formulas, and one mistake in a cell reference can cascade through your entire risk model.
Sourcetable's AI understands options terminology and market mechanics. When you upload broker statements or options chains, the AI automatically recognizes strikes, expirations, premiums, and position sizes. Ask 'What's my aggregate delta across all short puts?' and get instant answers. Request 'Show me which positions have assignment risk if SPY drops 5%' and see visual scenario analysis in seconds. The AI handles all calculations behind the scenes while you focus on strategy decisions.
The real advantage shows when managing multiple expirations. Say you're running 15 positions with expirations spread across three weeks. In Excel, tracking which positions to roll, which to let expire, and which to close early requires constant manual calculation of time value remaining, annualized returns, and opportunity costs. Sourcetable's AI analyzes all positions simultaneously and answers questions like 'Which positions should I roll this week to maximize annualized return?' with specific recommendations based on current market prices.
Margin management becomes effortless. Loan sharking strategies consume significant buying power, and brokers calculate margin requirements using complex formulas that vary by position size and market volatility. Instead of manually calculating portfolio margin or reg-T requirements in Excel, ask Sourcetable 'How much buying power do I have for new positions?' or 'What happens to my margin if VIX increases 20%?' The AI factors in all positions and current market conditions to provide accurate answers instantly.
Sourcetable also excels at historical analysis. Upload six months of trade history and ask 'What was my average premium capture per position?' or 'How many positions were assigned versus expired worthless?' The AI analyzes patterns, calculates win rates, and identifies which strikes and expirations generated the best risk-adjusted returns. This intelligence helps refine your loan sharking approach based on actual performance data, not guesswork.
The loan sharking strategy offers compelling income potential when executed with proper risk management and analytical tools. Traders regularly collect 2-5% monthly premiums, which annualizes to 24-60% returns on capital at risk. However, realizing these returns requires sophisticated position management, risk monitoring, and quick decision-making when markets move. Sourcetable provides the analytical infrastructure to execute this strategy professionally.
The biggest danger in loan sharking is concentration risk—having too many correlated positions that all move against you simultaneously. When running 20 short puts across different stocks, you need to understand your aggregate exposure to market moves, sector risk, and volatility changes. Sourcetable's AI analyzes your entire portfolio in real-time and answers questions like 'What's my total loss if the market drops 10%?' or 'How much sector concentration do I have in tech stocks?' This visibility prevents the catastrophic losses that wipe out months of premium collection.
The AI also tracks position-level Greeks aggregated across your portfolio. Ask 'What's my total theta decay this week?' to see expected premium erosion, or 'Show me my delta exposure by expiration' to understand directional risk at different time horizons. In Excel, aggregating Greeks across multiple positions requires SUMIF formulas, manual updates, and constant verification. Sourcetable handles this automatically, updating calculations as market prices change throughout the day.
Loan sharking success depends on position sizing—collecting meaningful premiums without over-leveraging your account. If you have $50,000 in capital and sell 10 puts on a $75 stock with $70 strikes, you're controlling $70,000 in stock value with significant margin requirements. Sourcetable calculates exactly how much buying power each new position consumes and shows remaining capacity for additional trades.
Ask Sourcetable 'How many more contracts can I sell on XYZ without exceeding 80% margin utilization?' and get instant answers based on current positions and broker margin rules. The AI factors in portfolio margin benefits when you have offsetting positions, something that's extremely complex to calculate manually in Excel. This intelligent position sizing helps maximize premium income while maintaining safety buffers for market volatility.
The AI also identifies optimal position sizes based on historical volatility and your risk tolerance. Upload your trading rules—like 'never risk more than 5% of capital on a single position'—and Sourcetable recommends appropriate contract quantities for each new trade. This systematic approach prevents emotional decision-making and maintains consistent risk management across all positions.
Understanding your actual returns requires tracking premium collected, commissions paid, positions closed early, and assignments. In a typical month, you might open 15 new positions, close 8 early for profits, let 5 expire worthless, and get assigned on 2. Calculating net premium income and annualized returns manually in Excel requires detailed transaction tracking and complex formulas.
Sourcetable automatically categorizes all transactions and calculates key metrics. Ask 'What was my net premium income last month?' or 'What's my average return per position?' and see instant results. The AI distinguishes between realized gains from expired/closed positions and unrealized P&L on open positions, giving you accurate performance metrics without manual journal entries or reconciliation.
More importantly, Sourcetable calculates return on capital employed, not just absolute premium dollars. Collecting $500 premium on a position that ties up $10,000 in margin is a 5% return. Collecting $300 on a position using $5,000 margin is 6%—better risk-adjusted performance despite lower absolute dollars. The AI automatically calculates these efficiency metrics across all positions, helping you identify which strikes and expirations offer the best risk-reward ratios.
Every loan sharking trader needs to know their downside exposure before markets crash. What happens if the S&P 500 drops 15% overnight? Which positions get assigned? What's your total loss? How much margin calls would you face? In Excel, modeling these scenarios requires copying your entire spreadsheet, manually adjusting all stock prices, recalculating Greeks, and updating margin requirements—a process that takes hours and is prone to errors.
Sourcetable performs instant scenario analysis. Ask 'Show me my P&L if all stocks drop 20%' and see position-by-position impact with aggregate portfolio loss. Request 'What if implied volatility increases 50%?' to understand how vega risk affects your positions. The AI runs these scenarios in seconds, letting you test multiple market conditions before they happen. This stress testing helps you identify dangerous concentrations and adjust positions before taking catastrophic losses.
The AI also performs historical backtesting. Upload past market data and ask 'How would my current positions have performed during the March 2020 crash?' or 'What would my losses have been in the 2018 volatility spike?' This historical context helps calibrate position sizing and risk limits based on real market behavior, not theoretical assumptions.
Managing 15-30 positions requires visual tools to spot patterns and risks quickly. Sourcetable automatically generates dashboards showing premium income by week, positions by expiration date, margin utilization trends, and assignment risk heat maps. These visualizations update in real-time as you add positions or market prices change, giving you constant situational awareness.
Ask 'Show me a chart of my weekly theta decay' and see how time value erosion accelerates as positions approach expiration. Request 'Visualize my positions by strike price and days to expiration' and get a bubble chart showing your entire portfolio structure. These visual insights are nearly impossible to create in Excel without extensive charting expertise and manual data preparation. Sourcetable generates them instantly through natural language requests.
Sourcetable transforms loan sharking strategy management from a complex spreadsheet exercise into a conversational analysis experience. The platform combines spreadsheet functionality with AI intelligence that understands options terminology, market mechanics, and risk management principles. Here's how to implement and manage a loan sharking portfolio using Sourcetable's capabilities.
Start by uploading your broker statements, options positions, or trade history. Sourcetable accepts CSV files, Excel spreadsheets, or direct data imports from major brokers. The AI automatically recognizes options data structure—identifying ticker symbols, strike prices, expiration dates, position quantities, premiums collected, and current market values. You don't need to format data or create specific column headers; the AI understands standard broker formats and adapts to your data structure.
For ongoing management, connect your broker account through Sourcetable's integration features. This enables automatic daily updates of positions, prices, and account balances without manual exports. The AI maintains a complete transaction history, tracking every position opened, closed, assigned, or expired. This historical record becomes the foundation for performance analysis and strategy refinement.
Once data is loaded, start asking questions in plain English. Try 'What's my total premium income this month?' or 'Show me all positions expiring this week.' The AI analyzes your data and returns instant answers with supporting calculations. Unlike Excel where you need to know which cells to reference and which formulas to use, Sourcetable's AI understands your intent and performs the appropriate analysis automatically.
For position-specific analysis, ask 'What's the break-even point on my AAPL short puts?' or 'How much time value remains in my TSLA position?' The AI calculates exact figures based on current market prices and displays results in clear, formatted tables. You can drill deeper with follow-up questions like 'What happens if AAPL drops to $160?' to see scenario-specific outcomes for individual positions.
Loan sharking requires constant monitoring of portfolio Greeks—delta, gamma, theta, and vega—to understand how market changes affect your positions. Ask Sourcetable 'What's my total portfolio delta?' to see aggregate directional exposure. The AI calculates position-level Greeks and sums them across your entire portfolio, showing whether you're net long or short the market.
Request 'Show me theta decay by expiration cycle' to see how much premium you're collecting each day from positions expiring in different weeks. This helps prioritize which expirations to focus on for new positions. Ask 'What's my vega exposure?' to understand how volatility changes impact your portfolio—critical information when VIX spikes and implied volatility expands.
The AI also calculates probability of profit for each position using current implied volatility and time to expiration. Ask 'Which positions have less than 70% probability of profit?' to identify risky positions that might need adjustment or early closure. This quantitative approach removes guesswork from position management decisions.
Understanding margin utilization prevents over-leveraging and maintains capacity for new opportunities. Ask Sourcetable 'How much margin am I using?' to see current utilization as a percentage of total account value. The AI calculates margin requirements using standard broker rules, showing exactly how much buying power each position consumes.
Before opening new positions, ask 'Can I sell 5 more contracts on XYZ without exceeding 75% margin utilization?' The AI calculates margin impact of the new position and confirms whether you have sufficient capacity. This prevents the dangerous situation of being over-leveraged when markets move against you and margin calls force position liquidation at the worst possible time.
For portfolio margin accounts, the calculations become more complex as margin requirements decrease when you have offsetting positions. Sourcetable handles these portfolio margin calculations automatically, showing the actual margin benefit from diversified positions rather than simple position-by-position requirements.
Before markets crash, you need to know your downside exposure. Ask Sourcetable 'What's my loss if the market drops 10%?' and the AI calculates position-by-position impact assuming all underlying stocks decline proportionally. See which positions move into the money, which face assignment, and what your aggregate loss would be. This stress testing reveals whether your position sizing is appropriate for your risk tolerance.
Test multiple scenarios simultaneously: 'Compare my P&L under three scenarios: market up 5%, flat, and down 10%.' The AI generates a comparison table showing outcomes across all scenarios, helping you understand your risk-reward profile. You can also test volatility scenarios: 'What happens if VIX increases to 40?' to see how expanding implied volatility affects option values and unrealized P&L.
After running the strategy for several months, performance analysis reveals what's working and what needs adjustment. Ask Sourcetable 'What was my average return per position last quarter?' to calculate risk-adjusted performance. The AI analyzes all closed positions, calculates returns as a percentage of margin used, and shows average holding periods.
Request 'Which stocks generated the best premiums relative to risk?' to identify your most profitable underlyings. The AI compares premium collected against maximum loss potential and assignment frequency, revealing which stocks offer the best risk-reward for your loan sharking strategy. This intelligence helps you focus on the most profitable opportunities and avoid underperformers.
Ask 'How many positions were assigned versus expired worthless?' to understand your assignment rate. High assignment rates might indicate you're selling strikes too close to current prices, while very low rates might mean you're leaving premium on the table by selling strikes too far out of the money. Sourcetable's analysis helps you find the optimal balance for your risk tolerance and return objectives.
The loan sharking strategy adapts to different market conditions, account sizes, and risk tolerances. Here are specific scenarios where Sourcetable's analytical capabilities enable effective implementation and management of this aggressive income strategy.
A trader with $100,000 capital runs a weekly loan sharking strategy, selling 20-30 out-of-the-money puts each Monday on high-liquidity stocks like SPY, QQQ, AAPL, MSFT, and TSLA. Each position targets 0.5-1% premium with 5-7 days to expiration. By Friday, most positions expire worthless and the cycle repeats. The challenge is tracking 100+ positions per month, each with different strikes, expirations, and P&L outcomes.
Sourcetable transforms this high-frequency strategy from overwhelming to manageable. Upload Monday's new positions and ask 'What's my aggregate delta across all positions?' to ensure you're not over-exposed to market direction. On Wednesday, ask 'Which positions have lost more than 50% of their value?' to identify early close opportunities. Friday morning, request 'Show me positions expiring today with more than $0.10 remaining value' to decide which positions to close versus letting expire.
At month end, ask 'What was my total premium collected versus commissions paid?' to calculate net income. The AI tracks all 100+ transactions automatically, categorizes outcomes (expired worthless, closed early, assigned), and calculates win rate and average return per position. This performance data reveals which expiration cycles and strike selections generate the best risk-adjusted returns, allowing continuous strategy refinement.
An investor bullish on technology sells cash-secured puts exclusively on tech stocks, targeting 3-5% monthly premiums on companies like NVDA, AMD, GOOGL, META, and CRM. With 10-15 positions open simultaneously across different expirations, the critical risk is sector concentration—if tech sells off, all positions move against you at once. Managing this correlated risk requires sophisticated portfolio analysis beyond standard Excel capabilities.
Sourcetable provides the sector risk visibility needed for this strategy. Ask 'What's my total exposure if tech stocks drop 15%?' and the AI calculates aggregate loss across all positions, showing exactly how much capital is at risk from sector-specific moves. Request 'Show me correlation between my positions' to understand which stocks move together and where concentration risk is highest.
The AI also helps with position sizing. Before opening a new position on NVDA, ask 'How much of my portfolio is already exposed to NVDA through correlated positions?' Sourcetable analyzes historical correlations between NVDA and your existing positions in AMD, AVGO, and other semiconductors, showing the effective concentration. This prevents inadvertent over-exposure to single stocks or sub-sectors within your tech focus.
A sophisticated trader adjusts loan sharking position sizing based on market volatility. When VIX is below 15, they sell more contracts with strikes closer to current prices, collecting higher premiums with acceptable risk. When VIX exceeds 25, they reduce position count and move strikes further out of the money, prioritizing capital preservation over premium income. Managing this dynamic approach requires constant monitoring of volatility conditions and portfolio risk metrics.
Sourcetable enables this adaptive strategy through real-time analysis. Set up alerts: 'Notify me when VIX crosses above 25' to trigger position sizing adjustments. When volatility spikes, ask 'What's my current vega exposure?' to understand how much your portfolio benefits from expanding implied volatility. Request 'Show me which positions have the highest vega' to identify which options gained the most value from volatility expansion—prime candidates for early closure to lock in gains.
As volatility normalizes, ask 'Compare my current premium income rate to my 6-month average' to determine whether current market conditions still offer attractive premiums. The AI analyzes historical premium rates relative to volatility levels, helping you decide whether to increase position sizing as opportunities improve or stay conservative if risk-reward ratios remain unfavorable.
Some traders use loan sharking as a stock accumulation strategy, intentionally selling puts on stocks they want to own at lower prices. When assigned, they hold the stock and sell covered calls, creating a wheel strategy. A trader might sell puts on 5-8 stocks simultaneously, collecting premiums while waiting for attractive entry points. When assigned on 2-3 positions, they need to track cost basis, manage the newly acquired shares, and identify covered call opportunities.
Sourcetable simplifies this complex transition from short puts to long stock to covered calls. When assigned, upload the new stock positions and ask 'What's my adjusted cost basis including premiums collected?' The AI calculates your true entry price after factoring in all premiums received from the put sales. Request 'What covered call strikes offer 2% monthly returns?' to identify appropriate call options to sell against your new shares.
For ongoing management, ask 'Show me my wheel strategy performance by stock' to compare results across different underlyings. The AI tracks total premiums collected from both puts and calls, assignment frequency, and overall returns for each stock. This analysis reveals which stocks work best for the wheel strategy and which generate insufficient premium relative to the capital commitment and assignment risk.
If your question is not covered here, you can contact our team.
Contact Us