Step 1: Understanding Your Question

Before diving into the data, clearly define what you want to discover. Common analysis questions include:

• Trend Identification: "Has short interest in Tesla been increasing over the past year?"
• Event Analysis: "How did GameStop's borrowing spike during the January 2021 squeeze?"
• Comparative Research: "Which tech stocks show the highest relative borrowing activity?"
• Pattern Recognition: "Does borrowing typically increase before earnings announcements?"
• Correlation Study: "Is there an inverse relationship between loan balance and stock price for this security?"

Step 2: Selecting Your Date Range

The date range you choose should align with your analysis goals:

• Short-Term Event Analysis (1-30 days): Ideal for studying specific news events, earnings announcements, or sudden market movements. This timeframe reveals immediate market reactions and short-term borrowing patterns.
• Medium-Term Trend Analysis (1-6 months): Perfect for identifying developing trends, seasonal patterns, or the impact of ongoing corporate developments. This window captures tactical trading behaviors without overwhelming long-term noise.
• Long-Term Strategic Research (6 months - 5 years): Essential for understanding structural changes in a stock's borrowing dynamics, comparing across market cycles, or validating long-term investment theses. Note: The graph can display approximately 5 years (1,758 days) maximum, though tables will show all data.

Step 3: Choosing Your Securities

Stock selection is crucial for meaningful analysis:

• Single Stock Deep Dive: Select one ticker to thoroughly understand its unique borrowing patterns. This approach is best for stocks you're considering for investment or when researching a specific company's short interest dynamics.
• Sector Comparison: Choose 3-5 stocks within the same industry (e.g., major banks: JPM, BAC, WFC, C) to identify which companies face higher bearish sentiment or hedging activity relative to their peers.
• Portfolio Monitoring: Track all stocks you currently own or are watching to spot emerging bearish trends that might affect your holdings.
• Theme-Based Analysis: Group stocks by a common characteristic (high-growth tech, meme stocks, dividend aristocrats) to study how different market segments experience borrowing pressure.

Step 4: Interpreting the Visual Output

Once your data loads, you'll see two primary visualizations working together:

The Stock Loan Balance Chart (Primary Y-Axis, Left Side)

This shows the dollar value of shares borrowed over time. Key patterns to watch for:

• Steady Upward Slopes suggest accumulating short interest or persistent hedging needs
• Sharp Vertical Spikes often coincide with major news, earnings surprises, or institutional position changes
• Sudden Drop-Offs indicate short covering, possibly triggered by rising prices, positive news, or fear of a squeeze
• Flat Lines or Minimal Activity suggest stable sentiment with limited short interest or hedging

The Candlestick Price Chart (Secondary Y-Axis, Right Side)

This displays traditional OHLC (Open, High, Low, Close) price action. Look for:

• Inverse Correlations: Loan balance increasing while price decreases often confirms growing short interest betting on further decline
• Divergences: Price rising while loan balance stays high can signal an impending short squeeze
• Synchronized Movements: Both metrics changing together might indicate options market maker hedging rather than directional short selling
• Lag Patterns: Sometimes borrowing spikes precede price movements, potentially offering predictive value

Comparative Sector Analysis

Understanding relative borrowing pressure within an industry provides powerful insights into market sentiment and potential opportunities.

Event-Driven Analysis: Earnings Announcements

Earnings season creates predictable patterns in borrowing activity as traders position ahead of results and react to surprises.

Typical Pre-Earnings Pattern:

• 10-5 days before: Borrowing often increases as traders establish short positions anticipating disappointment
• 3-1 days before: Borrowing may plateau as positions are fully established
• Day of announcement: Minimal change in borrowing, though price can be extremely volatile
• 1-5 days after: Dramatic borrowing changes as shorts either cover (if results positive) or add (if negative)

Volatility Event Analysis

Major corporate events, regulatory announcements, or market-wide shocks create distinct borrowing signatures that can validate or contradict prevailing narratives.

Squeeze Potential Assessment

Identifying stocks with high squeeze potential requires analyzing both absolute borrowing levels and price action context.

Key Indicators of Squeeze Risk:

1. High Absolute Borrowing: Loan balance representing a significant percentage of the stock's market cap (compare dollar borrowing to total market capitalization)
2. Rising Price Despite High Borrowing: Shorts are underwater but haven't covered, increasing pressure to eventually buy
3. Sudden Volume Increases: Check Yahoo Finance data for volume spikes that might force shorts to cover
4. Borrowing Plateau at Elevated Levels: No new shorts entering but existing shorts not covering—creates unstable equilibrium
5. Positive Fundamental Catalyst: Earnings beat, product approval, or major contract can trigger covering cascade

OCC loan data is most powerful when combined with other market intelligence. Here's how to create a comprehensive analysis:

1. Short Interest Reports (FINRA)

FINRA publishes bi-monthly short interest data showing total shares sold short across all lending programs, not just OCC.

• Comparison Value: OCC data updates daily and shows trends in real-time, while FINRA data is comprehensive but published with a 2-week delay
• Validation Check: Rising OCC borrowing should generally align with increasing FINRA short interest
• Divergence Signals: If OCC borrowing decreases but FINRA short interest increases, this suggests short interest is shifting to other lending programs, possibly due to better rates or availability

2. Options Market Data

Options activity provides additional context for understanding borrowing patterns:

• Put/Call Ratio: High put buying combined with high borrowing confirms bearish sentiment; high borrowing with low put buying might suggest hedging rather than directional shorts
• Implied Volatility: Rising IV during borrowing increases suggests options traders also expect big moves
• Skew Analysis: Negative skew (expensive puts relative to calls) combined with high borrowing double-confirms bearish positioning

3. Institutional Holdings (13F Filings)

Quarterly 13F filings reveal what major institutions own. Cross-reference with borrowing data:

• Long/Short Analysis: Institutions might be simultaneously long the stock (13F) and short via borrowed shares (OCC) as part of pair trades or hedging strategies
• Ownership Concentration: If borrowing is high but institutional ownership is concentrated among a few holders, a squeeze could be more severe due to limited available shares
• Institutional Exits: Declining institutional ownership plus high borrowing suggests sophisticated money is rotating out or outright betting against the stock

4. Fundamental Analysis

Always ground technical borrowing analysis in fundamental reality:

• Justified Skepticism: High borrowing of a company with deteriorating fundamentals (declining revenue, margin compression, increasing debt) validates that shorts have legitimate concerns
• Disconnect Opportunities: High borrowing of a fundamentally strong company with improving metrics might represent a mispricing opportunity—either the shorts are wrong or they know something not yet public
• Valuation Context: Borrowing patterns mean different things for overvalued versus undervalued stocks

Pitfall #1: Confusing Correlation with Causation

The Problem: Just because borrowing increases before a price drop doesn't mean the borrowing caused the drop. Correlation does not equal causation.

The Solution: Look for multiple confirming indicators (volume, options activity, news flow) before concluding that borrowing changes are predictive rather than simply correlative.

Pitfall #2: Ignoring Hedging vs. Directional Shorts

The Problem: Not all borrowing represents bearish bets. Market makers hedge options positions by borrowing stock. Merger arbitrageurs borrow when playing spreads.

The Solution: Check options open interest and recent M&A announcements. Borrowing increases on large options expiry dates or after merger announcements may be hedging, not directional shorts.

Pitfall #3: Focusing Only on Absolute Levels

The Problem: A $100 million loan balance means very different things for a $500 million market cap stock versus a $50 billion market cap stock.

The Solution: Always contextualize borrowing relative to market cap, float, and historical norms for that specific security. What matters is the ratio, not the absolute number.

Pitfall #4: Overweighting Recent Data

The Problem: Recent sharp moves can distort your perception of what's "normal" for a stock's borrowing pattern.

The Solution: Always analyze at least 6-12 months of history to establish a baseline before evaluating whether current borrowing is truly unusual.

Pitfall #5: Treating OCC Data as Comprehensive

The Problem: OCC represents one lending program. Total market short interest includes many other sources.

The Solution: Use OCC data for trend analysis and relative comparisons, but combine with FINRA short interest reports for absolute short interest assessment.

Here's a repeatable process for conducting thorough stock loan analysis:

1. Define Your Question: Write down exactly what you're trying to learn or prove
2. Establish Historical Context: Pull 12+ months of data to understand normal borrowing ranges
3. Identify the Current Pattern: Is borrowing trending up, down, or stable recently?
4. Correlate with Price Action: Does the borrowing pattern make sense given price movements?
5. Check for Events: Were there earnings, news, or broader market events during periods of unusual borrowing?
6. Compare to Peers: Is this borrowing pattern unique to this stock or industry-wide?
7. Validate with External Data: Check FINRA short interest, options data, and news flow
8. Form a Hypothesis: Based on all data, what story does the borrowing pattern tell?
9. Monitor for Confirmation: Track whether future price action and borrowing changes support your hypothesis
10. Document and Learn: Keep records of your analyses to improve pattern recognition over time

Background

GameStop (GME) became the most famous short squeeze in history when retail traders coordinated through social media to drive the heavily-shorted stock from under $20 to nearly $87 in just weeks, forcing short sellers to lose billions and fundamentally changing market dynamics.

What the OCC Data Showed

Pre-Squeeze Period (October - December 2020):

• Stock Loan Balance ranged from $178M to $656M despite GME trading between $2.28 and $5.25
• Average of 103 million shares were loaned daily—a massive position relative to the stock's market cap
• Borrowing remained stubbornly elevated throughout the period, indicating shorts maintained conviction despite modest price strength

Early Squeeze Phase (January 4-12, 2021):

• Stock Loan Balance increased from $522M to $662M (27% increase) as price climbed from $4.31 to $4.99 (16% increase)
• Shorts were adding to positions even as the price rose, believing the rally was temporary
• This "doubling down" behavior would later prove catastrophic as it provided more fuel for the squeeze

Peak Squeeze Period (January 13-28, 2021):

• Stock Loan Balance exploded to $7.23 billion on January 27, the same day GME hit its peak of $86.88
• The borrowing in absolute dollar terms increased more than 10x from early January
• Number of shares loaned at peak was approximately 83 million—many shorts had already been forced to cover as the price rocketed
• The massive dollar value increase was driven by both new shorts entering and the dramatic price appreciation of existing positions

Post-Squeeze Period (February - March 2021):

• Stock Loan Balance exhibited extreme volatility, ranging from $17M to $1.1B
• Price remained elevated between $10 and $66, well above pre-squeeze levels
• Periodic spikes in borrowing coincided with mini-squeezes, showing continued short interest despite the January lesson

Key Lessons

1. Massive Pre-Existing Short Interest: GME had over 100 million shares loaned even before the squeeze began—this was the powder keg waiting for ignition.
2. Adding During Adverse Movement = Danger: When shorts increased positions by 27% during a rising price, they were multiplying their risk exponentially.
3. Absolute Dollar Amounts Can Mislead: The $7.2B peak was partly due to price increase, not just new short positions. Always consider both dollar amounts and share counts.
4. Social Coordination Changed Everything: Traditional models assumed shorts could cover gradually. Reddit's WallStreetBets removed that assumption, creating unprecedented buying pressure.
5. Post-Event Persistence: Shorts remained active months after the squeeze, providing fuel for subsequent rallies—showing conviction that fundamentals would eventually matter.

Background

Tesla (TSLA) spent years as one of the most heavily shorted stocks in the market, with bears citing valuation concerns, production challenges, and CEO controversies. The company's transformation from short target to market phenomenon is clearly visible in OCC loan data, showing one of history's most expensive short squeezes.

What the OCC Data Revealed

Peak Short Interest Period (Q4 2019):

• Stock Loan Balance ranged from $130M to $1.17B (split-adjusted prices)
• Stock traded between $15-29 per share (split-adjusted)
• Average daily loan balance of $480M represented significant short conviction
• Bears believed Tesla faced fundamental challenges including cash burn, production issues, and competition

Unexpected Decline in Borrowing (Q1 2020):

• By March 2020, Stock Loan Balance dropped to essentially zero despite stock rallying to $35
• This dramatic decline occurred as Tesla reported surprising Q3 2019 profitability
• Early covering suggested some shorts recognized improving fundamentals and exited positions
• However, COVID-19 crash in March 2020 brought temporary renewed short interest

COVID-19 Disruption (March-April 2020):

• Stock fell to $24 in March panic selling; borrowing spiked to $130M as bears re-entered
• By April, stock recovered to $52 and borrowing increased to $230M
• Some shorts saw COVID as validation of their thesis, expecting prolonged economic weakness to hurt Tesla

The Great Squeeze (May-December 2020):

• Stock surged from $47 in May to $235 by December—a 403% gain
• Paradoxically, Stock Loan Balance increased from $130M to $1.30B (892% increase)
• This counterintuitive pattern shows shorts kept fighting the rally, adding positions throughout
• The dollar value increase was driven by both new shorts entering at higher prices and price appreciation of existing loans
• By year-end, remaining shorts were either hedges for options positions or extremely convicted directional bears

Key Lessons

1. Fundamental Improvement Trumps Thesis: When Tesla demonstrated operational improvements and profitability, some smart shorts recognized the changed landscape and exited early. Those who stayed paid dearly.
2. Fighting the Trend is Expensive: The 892% increase in loan balance during a 403% stock price increase shows shorts kept adding to losing positions—a classic mistake.
3. Dollar Amounts vs. Market Cap: While loan balance increased 892%, this was largely due to price appreciation. As a percentage of market cap, short interest actually declined as Tesla's valuation soared.
4. Gradual vs. Sudden Squeezes: Unlike GME's explosive squeeze over weeks, TSLA's squeeze played out over 12+ months, giving shorts multiple opportunities to exit but also creating false comfort that led to stubbornness.
5. Multiple Waves: Shorts who exited in Q4 2019 avoided the pain. Those who re-entered during COVID crash learned that trying to time a bottom in a momentum stock is perilous.

Background

First Republic Bank (FRC) became one of the most visible casualties of the 2023 regional banking crisis. OCC loan data tells a compelling story about how sophisticated short sellers recognized fatal flaws even as government agencies attempted rescue operations.

What the OCC Data Showed

Pre-Crisis Baseline (January - March 9, 2023):

• Stock Loan Balance averaged just $30M with a range of $0.5M to $96M
• Stock traded in $96-147 range—seen as stable regional bank
• Low borrowing reflected market view that FRC was solid, well-managed institution
• This calm baseline makes the subsequent spike even more significant

SVB Failure Impact (March 10-15, 2023):

• March 9 (day before SVB failure): Loan Balance $15M, stock at $96
• March 10 (SVB failure announced): Stock dropped to $82, but loan balance actually declined to $13M
• March 13: Stock crashed to $31 (68% decline), loan balance dropped to just $4M
• Initially, the dramatic price decline meant there was LESS dollar value loaned, even as short interest in shares may have increased
• March 14-15: Stock attempted recovery to $32-40 range, borrowing remained minimal at $7-9M

Rescue Attempt Period (March 16-31, 2023):

• March 16: Major banks announced $30B deposit infusion to stabilize FRC
• Stock initially rallied but borrowing exploded to $98-644M range
• Stock traded $12-34—extreme volatility despite rescue attempt
• The surge in borrowing AFTER the rescue attempt signaled sophisticated traders didn't believe the fix would work
• This proved to be the critical warning signal: when borrowing increases after a rescue, the market doesn't buy it

Final Collapse (April - May 1, 2023):

• April 1: Stock Loan Balance at $668M with stock at $14.60
• Throughout April, borrowing remained elevated in $150-400M range as stock declined toward zero
• May 1: FDIC seized FRC; stock went to $3.51
• Final borrowing spike indicated shorts correctly predicted the terminal outcome despite government intervention attempts

Key Lessons

1. Initial Reaction vs. Informed Response: The March 10-15 period showed retail confusion (dramatic selling) while short sellers were relatively quiet. The real short interest explosion came AFTER the rescue was announced, showing smart money's skepticism.
2. Post-Rescue Borrowing = Red Flag: When loan balance surged from $15M to $644M AFTER major banks tried to save FRC, this was the critical signal that informed traders saw fatal flaws despite the rescue.
3. Speed Matters: Unlike gradual changes in tech stocks, financial crisis borrowing spikes happen in days. The window for protective action is brief.
4. Persistent Elevation = Ongoing Concerns: Borrowing stayed elevated from March 16 through May 1, correctly signaling the problem wasn't solved. This gave long-holders ample warning to exit.
5. Information Asymmetry: Sophisticated shorts clearly had better risk assessment than both retail investors and government agencies attempting rescue. Following this "smart money" signal would have protected against devastating losses.

Background

Sarepta Therapeutics (SRPT) awaited FDA approval for its Duchenne muscular dystrophy gene therapy. The binary nature of FDA decisions creates unique borrowing patterns as traders position for all-or-nothing outcomes. The May 15, 2023 approval triggered a 31% single-day gain and demonstrates how shorts position around known catalysts.

What the OCC Data Showed

Pre-Decision Period (February - May 14, 2023):

• Stock Loan Balance ranged from $0.7M to $36M with $19M average
• Stock traded in $118-156 range, consolidating before decision
• Borrowing of $19M on a stock trading around $120-140 represented moderate short interest
• Some shorts positioned based on belief drug wouldn't get approval or would face restrictive labeling

Final 4 Weeks Before Decision:

• Borrowing trended downward from $13M to just $0.7M
• This decline suggested risk-averse shorts were closing positions to avoid binary event exposure
• Smart shorts often exit before FDA decisions, binary earnings, or other all-or-nothing events
• Declining pre-event borrowing can be a subtle positive signal—skeptics are de-risking

FDA Decision Day (May 15, 2023):

• Day before (May 14): Loan Balance $5.2M, Price $120.20
• Decision day (May 15): FDA approved with favorable labeling
• Stock surged 30.8% to $157.19 in single day
• Loan Balance barely changed ($5.3M), confirming most shorts had already exited before decision
• The minimal remaining short interest meant limited forced covering—the rally was driven by fundamental revaluation, not squeeze mechanics

Post-Approval Period (May 16 - June 14, 2023):

• Borrowing ranged $5M-23M with $17M average—returning close to pre-approval levels
• Stock consolidated in $124-149 range after initial approval pop
• New shorts emerged based on valuation concerns ("sell the news") or commercial execution doubts
• The re-establishment of moderate short interest suggests market viewed approval as fairly priced in at new levels

Key Lessons

1. Pre-Event De-Risking: The decline from $13M to $0.7M in borrowing during the final month showed smart shorts reducing exposure before the binary event—often a bullish contrarian signal.
2. Risk Management Over Conviction: Even shorts who believed approval was unlikely chose to exit rather than risk the binary outcome. This shows disciplined risk management.
3. Minimal Squeeze Dynamics: With only $5M borrowed at decision time, the 31% gain was NOT a short squeeze—it was fundamental revaluation. Understanding whether a move is squeeze-driven vs. fundamental is critical.
4. Post-Catalyst New Baseline: The return to $17M average borrowing post-approval established a new baseline. Some shorts remained skeptical despite approval, positioning on valuation or execution concerns.
5. Binary Events Create Clarity: Unlike gradual fundamental changes, FDA decisions provide clean before/after periods that make it easier to interpret borrowing data and short behavior.

Background

The energy sector experienced extreme volatility from 2020-2022, moving from heavily shorted (COVID crash, oil price collapse, "peak oil" narrative) to favored (inflation hedge, geopolitical tensions, strong cash flows). This multi-year sector rotation is clearly visible in OCC data, showing how macro themes drive entire industries.

What the OCC Data Revealed Using ExxonMobil (XOM) as Example

COVID Collapse (March 2020):

• March 1: Stock Loan Balance $210M, Price $53.88
• March bottom: Stock crashed to $31.45, but borrowing declined to $120M
• March 31: Stock recovered to $38, borrowing dropped further to $60M
• Counter-intuitively, shorts covered during the crash rather than adding—suggesting even bears were shocked by oil going negative and reduced risk

Extended Bear Case (July 2020 - December 2021):

• Stock Loan Balance ranged $0-400M with $180M average over 18 months
• Stock traded in $31-66 range—choppy but generally recovering
• "Peak oil demand" thesis kept shorts engaged despite price recovery
• ESG concerns and renewable energy narrative reinforced bearish positioning
• Moderately elevated borrowing throughout this period reflected persistent skepticism about energy sector's future

Sentiment Inflection (Q1 2022):

• January 1: Stock Loan Balance $180M, Price $63.54
• March 31: Stock Loan Balance $130M (-29%), Price $82.59 (+30%)
• Russia-Ukraine conflict in February 2022 caused oil price spike and sector rally
• Inverse relationship between borrowing and price showed short covering was underway
• This marked the inflection point where energy shifted from unloved to defensive/inflation hedge

Full Rotation (Q2-Q4 2022):

• April 1: Stock Loan Balance $130M, Price $83
• December 31: Stock Loan Balance $290M, Price $110
• Year-end high: Price reached $114 with borrowing at $300M
• Paradoxically, borrowing INCREASED as stock rallied in late 2022
• This suggests new shorts entering at higher prices—possibly profit-taking shorts or those betting on economic slowdown reducing oil demand
• However, at $300M on a $110 stock, this was still relatively modest short interest compared to the 2020-2021 period

Key Lessons from Sector Analysis

1. Macro Themes Drive Sectors: Individual company fundamentals mattered less than sector-wide narratives: COVID/peak oil (bearish) → inflation/geopolitics (bullish).
2. Short Capitulation in Stages: Covering happened in waves—some during COVID chaos, more during Q1 2022 rally, showing different shorts had different risk tolerances and timeframes.
3. New Shorts at Higher Prices: The late-2022 borrowing increase showed some investors were willing to short energy at $110 after it rallied from $30—either profit-taking or macro bears betting on recession.
4. Contrarian Opportunity: The 2020-2021 period of sustained bearish sentiment ($180M average loans) during $31-66 prices marked the bottom. Peak sector pessimism often creates opportunity.
5. Narrative Permanence Myth: Shorts in 2020-21 believed structural changes (EVs, renewables, ESG) would permanently impair oil demand. Geopolitical reality and inflation overrode this thesis—beware assuming "this time is different" narratives are permanent.
6. Time Horizon: This rotation took 2+ years from bottom to new regime. Sector rotations require patience; they don't happen in days or weeks like individual stock squeezes.

Universal Patterns Observed

1. Massive Short Interest + Catalyst = Squeeze: GME (100M+ shares loaned + retail coordination), TSLA ($1.3B loans + fundamental improvement), both created sustained squeezes
2. Adding to Losers Multiplies Pain: GME shorts adding 27% during early rally, TSLA borrowing increasing 892% during 403% price rise—fighting momentum is expensive
3. Smart Money Shows Itself: FRC borrowing explosion AFTER rescue attempt signaled sophisticated assessment. SRPT borrowing decline before FDA showed disciplined risk management
4. Pre-Event De-Risking = Signal: Declining borrowing before binary events (SRPT before FDA) often indicates contrarian positive sentiment
5. Persistent Elevation = Justified Concern: FRC's sustained high borrowing despite rescue, XOM's 18-month elevated loans during recovery—when borrowing stays high, skepticism is real
6. Dollar Amounts Need Context: GME's $7.2B peak was partly price effect. TSLA's 892% loan increase was less dramatic relative to market cap. Always consider shares loaned AND stock price

Practical Applications by Investor Type

• For Long Investors: Use borrowing spikes as warning signals (FRC post-rescue surge). High sustained borrowing deserves investigation, not dismissal. The OCC data can protect you from catastrophic holdings.
• For Short Sellers: Confirm your thesis aligns with smart money visible in borrowing data. Declining borrowing into your thesis (SRPT pre-FDA) might signal you're wrong. Adding to losers (GME, TSLA pattern) almost never works.
• For Squeeze Traders: High borrowing + improving fundamentals (TSLA 2020) or coordination (GME) creates opportunity. But distinguish squeeze-driven moves from fundamental revaluation (SRPT).
• For Risk Managers: Sudden sector-wide borrowing changes (FRC, other regionals in March 2023) may indicate systemic risk. One stock's spike might be idiosyncratic, but correlated spikes signal broader issues.
• For Sector Investors: Track aggregate borrowing across major sector names (XOM approach). Synchronized changes in 70%+ of sector constituents indicate major rotation underway. Time horizon is months to years, not days.
• For Catalyst Traders: Monitor borrowing trends before known events (FDA approvals, earnings, mergers). Pre-event decline often bullish, pre-event increase often bearish—but confirm with other data.

Critical Interpretation Reminders

• OCC data shows borrowing, NOT sentiment. High borrowing might be hedging, arbitrage, or directional shorts. Context is essential.
• Dollar amounts and share counts tell different stories. Both matter. Normalize by market cap when comparing stocks.
• Borrowing changes lag price sometimes, lead price other times. No single pattern works always.
• Post-event analysis is easy; real-time interpretation is hard. These case studies benefit from hindsight—your analysis won't.
• Combine OCC data with fundamentals, sentiment, technical analysis, and news flow. Single data sources create blind spots.

Primary Data Source: OCC Stock Loan Program

All stock loan balance data originates from The Options Clearing Corporation's publicly available market data reports:

• Official Source: https://www.theocc.com/market-data/market-data-reports/volume-and-open-interest/stock-loan-volume
• Update Frequency: Daily, after market close (typically published by 8:00 PM ET)
• Data Format: Structured CSV files containing ticker symbols and corresponding loan balances
• Historical Availability: OCC began publicly reporting this data on September 7, 2018. No historical data exists before this date.
• Coverage: All equity securities eligible for the OCC Stock Loan Program (thousands of individual stocks and ETFs)

Automated Collection System

We maintain a Python-based automated collection system with the following architecture:

• Daily Schedule: Script executes hourly after every trading day to check for new data
• Data Retrieval: Programmatic download of latest OCC CSV file
• Validation Checks: Automated verification that data meets expected format and completeness standards
• Database Storage: Parsed data is stored in a structured database with date and ticker indexing
• Redundancy: Backup systems ensure no data loss if primary collection fails
• Historical Backfill: All data since September 7, 2018 was retroactively collected and validated

What Data Points Are Collected

For each ticker symbol on each trading date, we collect:

• Stock Loan Balance: Dollar value of shares borrowed (provided directly by OCC)
• Trading Date: The date to which the loan balance applies
• Ticker Symbol: OCC's symbol for the security (note: may differ from Yahoo Finance in some cases)

Supplementary Price Data: Yahoo Finance

Candlestick (OHLC) price data comes from Yahoo Finance:

• Source: https://finance.yahoo.com
• Data Retrieved: Open, High, Low, Close prices plus trading volume
• Collection Method: On-demand retrieval when user selects a ticker for candlestick display
• Date Matching: System automatically aligns OCC loan dates with Yahoo Finance trading dates
• Symbol Translation: Automatic and manual ticker symbol mapping handles differences between OCC and Yahoo Finance naming conventions

Number of Shares Loaned Calculation

While OCC provides Stock Loan Balance (dollar amount), the number of shares borrowed is calculated by our system:

Example:

• Stock: AAPL (Apple Inc.)
• Date: January 15, 2024
• Stock Loan Balance: $500,000,000 (from OCC)
• Closing Price: $185.50 (from Yahoo Finance)
• Calculated Shares Loaned: $500,000,000 ÷ $185.50 = 2,694,594 shares

Important Calculation Notes

• Price Source: We use the closing price from Yahoo Finance on the same date as the OCC loan balance
• Accuracy: This calculation may differ slightly from OCC's internal calculations if: (a) OCC uses a different price source, (b) there's a timing mismatch, or (c) corporate actions affect share counts
• Corporate Actions: Stock splits, reverse splits, and similar events can create temporary calculation anomalies that resolve once historical data is adjusted
• Precision: Share counts are displayed rounded to whole shares; actual calculations use full precision

Date Alignment and Business Day Handling

Stock markets only operate on business days (weekdays excluding holidays). Our system handles this as follows:

• Trading Days Only: Data is only collected for days when US markets were open
• Gap Handling: Weekends and holidays appear as gaps in time-series graphs
• Holiday Calendar: System references official NYSE/NASDAQ holiday calendar
• User Date Selection: When users select date ranges including non-trading days, system automatically uses available trading days within that range

Automated Quality Checks

Every data point undergoes multiple validation checks before being displayed:

1. Format Validation: Ensures data structure matches expected OCC CSV format
2. Completeness Check: Verifies that all expected fields are present and non-null
3. Value Range Validation: Flags loan balances that are negative or exceed reasonable thresholds
4. Date Continuity: Alerts on unexpected gaps in daily data collection
5. Ticker Consistency: Identifies when ticker symbols change or disappear (due to mergers, delistings, etc.)
6. Cross-Reference Verification: Compares against previous days' data to identify anomalous jumps that may indicate data errors

Known Data Limitations and Edge Cases

Users should be aware of the following limitations and scenarios:

1. Ticker Symbol Inconsistencies

• Different Naming: OCC may use different ticker symbols than Yahoo Finance (e.g., "BRKB" vs. "BRK-B")
• Solution: Our system includes a mapping table for known differences, and users can manually enter Yahoo Finance tickers
• User Action Required: If candlestick chart doesn't load automatically, manually enter the correct Yahoo Finance ticker

2. Corporate Actions

• Stock Splits: Can cause sudden changes in share counts; loan balance (dollar amount) remains accurate
• Mergers/Acquisitions: Ticker symbols may change or disappear; historical data remains under old ticker
• Delistings: OCC stops reporting data when a stock is delisted; historical data remains accessible
• New Listings: Stocks only appear in data from the date they became OCC-eligible

3. Data Anomalies

• Zero Balance Days: Some tickers show zero loan balance on certain days (no borrowing activity that day)
• Large Jumps: Sudden 10x+ increases usually reflect real events (short interest surge, squeeze, etc.) but are visually validated
• Missing Tickers: If a ticker doesn't appear in our database, it either: (a) wasn't eligible for OCC loans, (b) had zero loan activity, or (c) didn't exist during selected date range

4. Reporting Timing

• Publication Delay: OCC publishes data after market close; typically available by 8 PM ET
• System Update: Our database updates shortly after OCC publishes
• User Access: Latest data is available on this platform within hours of market close

Chart Technology

Our interactive charts are built using industry-standard visualization libraries:

• Library: Highcharter for R (Highcharts.js under the hood)
• Features: Interactive hover, zoom, pan, export capabilities
• Stacked Graphs: Stock loan balance on top, candlesticks with volume on the bottom
• Dual Y-Axes: Left axis for stock loan balance, right axis for number of shares loaned
• Responsive Design: Charts automatically adapt to screen size and orientation

Graph Limitations

Due to browser memory and performance constraints:

• Maximum Data Points: Approximately 1,758 days (~5 years) can be visualized in a single chart
• Reason: Browser rendering limitations with complex interactive visualizations
• Solution: For date ranges exceeding this limit, the chart displays the most recent 1,758 days, but the data table below shows all selected data
• Recommendation: For analysis beyond 5 years, use the Excel export feature which contains unlimited data

Color Coding and Visual Design

Our visual design choices are intentional for analytical clarity:

• Stock Loan Balance: Blue bars on left axis—primary focus of analysis
• Candlestick Chart: Traditional red/green coloring—red for down days, green for up days
• Multiple Tickers: When multiple stocks selected, each receives a distinct color for easy comparison
• Grid Lines: Subtle grid aids in reading exact values without cluttering the visualization
• Hover Information: Displays date, ticker, loan balance, share count, and OHLC price data

Data Table Formatting

The tabular data below each chart provides:

• Searchable: Filter table by typing in search box
• Format: Numbers formatted with thousand separators and appropriate decimal precision
• Completeness: Shows all data points even when chart is limited to 1,758 days
• Cumulative Stats: Shows total borrowed per stock, average borrowed per stock, and daily sums

What's Included in Excel Exports

The downloadable Excel file contains:

1. Raw Data Sheet: All selected ticker-date combinations with loan balances, share counts, and prices
2. Formatted Tables: Professional styling with headers, borders, and number formatting
3. Embedded Charts: Visual replications of the web-based charts for offline viewing
4. Calculation Formulas: Share count calculations visible and auditable
5. Metadata: Export date, date range, and tickers included documented on summary sheet

Excel File Specifications

• Format: .xlsx (Excel 2007+)
• Compatibility: Opens in Microsoft Excel, Google Sheets, LibreOffice Calc, and other spreadsheet applications
• File Size: Varies based on date range; typically 500KB - 5MB
• Data Limits: No artificial limits; entire selected dataset included regardless of size

Intended Uses for Excel Exports

• Further Analysis: Import into statistical software (R, Python, MATLAB) for advanced modeling
• Custom Visualizations: Create specialized charts using Excel's charting capabilities
• Reporting: Incorporate into investment memos, research reports, or presentations
• Archiving: Maintain historical snapshots for longitudinal studies
• Sharing: Distribute findings to colleagues or clients in universally-accessible format

Technology Stack

This platform is built using:

• Backend: R programming language with Shiny framework
• Database: Structured data storage with date/ticker indexing for fast retrieval
• Data Collection: Python scripts for automated OCC data retrieval
• Visualization: Highcharts for interactive JavaScript-based charts
• Hosting: Cloud infrastructure ensuring 99.9% uptime
• Updates: Automated daily refresh process

Performance Characteristics

• Query Speed: Typical data retrieval: <2 seconds for single stock, <5 seconds for 5+ stocks
• Chart Rendering: <3 seconds for standard date ranges
• Export Generation: Excel files generated in 5-15 seconds depending on data volume
• Concurrent Users: System handles multiple simultaneous users without performance degradation
• Data Freshness: Latest market data available within a few hours of market close

Reliability and Uptime

• Target Uptime: 99.9% availability
• Monitoring: 24/7 automated system monitoring
• Redundancy: Multiple backup systems ensure data collection never fails
• Disaster Recovery: Full database backups maintained with point-in-time recovery capability
• Maintenance: Scheduled maintenance occurs during off-market hours (weekends) with advance notice

OCC vs. FINRA Short Interest Reports

Users often ask how our OCC data compares to FINRA's bi-monthly short interest reports. Here's the difference:

Relationship Between Sources:

• OCC represents a portion (often 20-40%) of total short interest reported by FINRA
• Daily OCC trends usually correlate with bi-monthly FINRA changes
• Divergences can occur when shorts shift between lending programs
• Best Practice: Use OCC data for daily monitoring; validate against FINRA for absolute levels

Why Multiple Sources Matter

Comprehensive short interest analysis should incorporate:

1. OCC Daily Data (This Platform): Trend identification and real-time monitoring
2. FINRA Bi-Monthly Data: Absolute short interest levels and comprehensive coverage
3. Options Market Data: Put/call ratios for sentiment confirmation
4. Institutional Filings (13F): Long holdings context
5. Earnings Transcripts: Management commentary on short interest

No single source provides complete picture. Triangulating across sources yields highest-quality insights.

Data Accuracy Disclaimer

While we employ rigorous quality controls, users should understand:

• Data originates from third parties (OCC and Yahoo Finance) over whom we have no control
• We make no warranties, express or implied, regarding data accuracy, completeness, or timeliness
• Errors in source data will propagate to our platform
• We are not liable for trading or investment decisions made using this data
• Users should independently verify critical data points before making financial decisions

Not Investment Advice

IMPORTANT: This platform provides data visualization and analysis tools only. It does NOT provide investment advice.

• All content is for informational and educational purposes
• Historical data does not predict future performance
• Short interest data represents one factor among many in investment analysis
• Consult qualified financial advisors before making investment decisions
• We do not recommend buying, selling, or holding any securities

Scope and Coverage Limitations

Users should understand what this data does and doesn't represent:

• Partial Short Interest: OCC captures only loans through its program, not all short positions
• US Markets Only: Data covers US-listed securities only
• Program Eligibility: Not all securities are eligible for OCC loans; absence from data doesn't mean no short interest exists
• Historical Limitations: Data begins September 7, 2018; earlier periods not available
• Real-Time Gap: Data reflects previous day's close, not intraday activity

Interpretation Guidance

High borrowing can indicate various things beyond bearish sentiment:

• Options market maker hedging
• Merger arbitrage positions
• Tax-loss harvesting strategies
• Dividend capture plays
• Pairs trading and relative value strategies

Context and additional research are essential for proper interpretation.

We continuously work to improve this platform. Planned enhancements include:

• Advanced Analytics: Statistical measures like Z-scores, percentile rankings, rate of change
• Alerts System: Email notifications when borrowing crosses user-defined thresholds
• Sector Aggregation: Industry-level borrowing trends and comparisons
• Options Integration: Overlay options volume and open interest alongside loan data
• Mobile Optimization: Enhanced mobile experience with touch-optimized charts [Completed ✅]
• API Access: Programmatic data access for institutional users and researchers [Completed ✅]
• Extended History: Working to acquire pre-2018 data if/when available
• Custom Dashboards: User accounts with saved watchlists and custom analysis layouts

Our API provides JSON and CSV responses for stock loan data queries. All endpoints are publicly accessible without authentication.

curl "https://stockloandata.com/api/loan-data?tickers=AAPL&format=json"

GET /api/loan-data — Retrieve stock loan data for specified tickers and date ranges.

Parameters

Response Fields

When format=json (default), the response includes:

• metadata: Information about the query including record count, tickers found, and date range
• data: Array of loan records with the following fields:
  • Symbol — Stock ticker symbol
  • Market Loan-Loan Balance — Market loan balance value (if data_type is "market" or "both")
  • Hedge Loan Balance — Hedge loan balance value (if data_type is "hedge" or "both")
  • Date — Date of the record in YYYY-MM-DD format

When format=csv, the response is a downloadable CSV file with the same data fields.

Single Ticker, All Data (JSON)

curl "https://stockloandata.com/api/loan-data?tickers=AAPL"

Multiple Tickers with Date Range

curl "https://stockloandata.com/api/loan-data?tickers=AAPL,MSFT,GOOGL&start_date=2024-01-01&end_date=2024-12-31"

Market Loan Data Only

curl "https://stockloandata.com/api/loan-data?tickers=TSLA&data_type=market"

CSV Format Download

curl "https://stockloandata.com/api/loan-data?tickers=AAPL,MSFT&format=csv" -o loan_data.csv

JSON Response (abbreviated)

{
  "metadata": {
    "total_records": 250,
    "tickers_requested": ["AAPL", "MSFT"],
    "tickers_found": ["AAPL", "MSFT"],
    "date_range": {
      "start": "2024-01-01",
      "end": "2024-12-31"
    },
    "data_type": "both"
  },
  "data": [
    {
      "Symbol": "AAPL",
      "Market Loan-Loan Balance": 1500000000,
      "Hedge Loan Balance": 2300000000,
      "Date": "2024-01-02"
    },
    {
      "Symbol": "MSFT",
      "Market Loan-Loan Balance": 1200000000,
      "Hedge Loan Balance": 1800000000,
      "Date": "2024-01-02"
    }
  ]
}

CSV Response

Symbol,Market Loan-Loan Balance,Hedge Loan Balance,Date
AAPL,1500000000,2300000000,2024-01-02
AAPL,1520000000,2310000000,2024-01-03
MSFT,1200000000,1800000000,2024-01-02
MSFT,1210000000,1810000000,2024-01-03

Python

import requests
import pandas as pd

# Get JSON response
response = requests.get("https://stockloandata.com/api/loan-data", params={
    "tickers": "AAPL,MSFT",
    "start_date": "2024-01-01",
    "end_date": "2024-12-31",
    "data_type": "both"
})
data = response.json()

# Get CSV response and load into pandas
response_csv = requests.get("https://stockloandata.com/api/loan-data", params={
    "tickers": "AAPL,MSFT",
    "start_date": "2024-01-01",
    "end_date": "2024-12-31",
    "format": "csv"
})
df = pd.read_csv(pd.io.common.StringIO(response_csv.text))

R

library(httr)
library(jsonlite)

# Get JSON response
response <- GET(
  "https://stockloandata.com/api/loan-data",
  query = list(
    tickers = "AAPL,MSFT",
    start_date = "2024-01-01",
    end_date = "2024-12-31",
    data_type = "both"
  )
)
data <- fromJSON(content(response, "text"))

# Get CSV response
response_csv <- GET(
  "https://stockloandata.com/api/loan-data",
  query = list(
    tickers = "AAPL,MSFT",
    start_date = "2024-01-01",
    format = "csv"
  )
)
df <- read.csv(text = content(response_csv, "text"))

JavaScript/Node.js

const axios = require("axios");

// Get JSON response
async function getLoanData() {
  const response = await axios.get("https://stockloandata.com/api/loan-data", {
    params: {
      tickers: "AAPL,MSFT",
      start_date: "2024-01-01",
      end_date: "2024-12-31",
      data_type: "both"
    }
  });
  console.log(response.data);
}

// Get CSV response
async function getLoanDataCSV() {
  const response = await axios.get("https://stockloandata.com/api/loan-data", {
    params: {
      tickers: "AAPL,MSFT",
      format: "csv"
    },
    responseType: "blob"
  });
  // Save to file or process
}

GET /api/ — API Information

Returns API documentation, version information, data coverage details, and available endpoints with examples.

curl "https://stockloandata.com/api/"

GET /api/tickers — Available Tickers

Returns a complete list of all available ticker symbols in the dataset. Useful for validation or building ticker selection interfaces.

curl "https://stockloandata.com/api/tickers"

Response:

{
  "total_tickers": 5432,
  "tickers": ["A", "AA", "AAAU", "AABA", ...]
}

GET /api/health — Health Check

Returns API health status and basic system information. Useful for monitoring and uptime checks.

curl "https://stockloandata.com/api/health"

Response:

{
  "status": "healthy",
  "timestamp": "2024-01-30T10:30:00Z",
  "data_loaded": true,
  "record_count": 12127212
}

GET /api/stats — Usage Statistics

Returns aggregate usage statistics combining both API requests and web app usage. Privacy-friendly: contains only totals and trends, no personal information like IP addresses.

curl "https://stockloandata.com/api/stats"

Response includes:

• Summary: Total requests broken down by API vs web app, with 24-hour activity
• API Endpoints: Most popular API endpoints
• App Events: User activity in the web interface (page views, data queries, downloads)
• Most Requested Tickers: Combined ticker popularity from both API and web app usage
• Daily Request Counts: Activity by date for the last 30 days
• Hourly Usage Patterns: Traffic patterns by hour of day for the last 7 days

{
  "summary": {
    "total_requests": 1547,
    "api_requests": 823,
    "app_requests": 724,
    "requests_last_24h": 156,
    "api_last_24h": 89,
    "app_last_24h": 67
  },
  "api_endpoints": [
    {"endpoint": "/loan-data", "requests": 456},
    {"endpoint": "/tickers", "requests": 123}
  ],
  "most_requested_tickers": [
    {"ticker": "AAPL", "requests": 234},
    {"ticker": "TSLA", "requests": 189}
  ],
  "requests_by_date_last_30d": [...],
  "hourly_pattern_last_7d": [...]
}

Note: This endpoint is safe for public access and contains no personally identifiable information. Ticker statistics combine both API requests and web app usage for a holistic view of data interest.

Our API tracks comprehensive usage analytics to help understand market interest and data consumption patterns.

What We Track

• API Requests: All programmatic data access via the API endpoints
• Web App Usage: User interactions with our data visualization tools
• Ticker Popularity: Which stocks are most frequently queried across all platforms
• Usage Patterns: When and how users access the data

Privacy & Transparency

We believe in transparent data practices:

• Public Statistics: The /stats endpoint shows aggregate usage data
• No Personal Data: Personal data is never exposed publicly
• Privacy-Conscious: Only totals and trends are shared, protecting individual user privacy
• Combined View: Ticker statistics merge both API and web app usage for comprehensive market interest insights

Use Cases

The /stats endpoint can help you:

• Identify trending stocks based on community query patterns
• Understand peak usage times for optimal API access
• Discover popular tickers you might want to monitor
• Monitor API health and availability
• Track overall platform adoption and growth

The API returns helpful error messages when requests are invalid:

Missing Required Parameter

{
  "error": "Missing required parameter",
  "message": "Please provide at least one ticker symbol using the 'tickers' parameter",
  "example": "/loan-data?tickers=AAPL"
}

No Data Found

{
  "error": "No data found",
  "message": "No data found for the specified ticker(s)",
  "requested_tickers": ["INVALID"]
}

Invalid Date Format

{
  "error": "Invalid date format",
  "message": "Dates must be in YYYY-MM-DD format",
  "example": "2024-01-01"
}

Optimize Your API Usage

# Good - One request
curl "https://stockloandata.com/api/loan-data?tickers=AAPL,MSFT,GOOGL"

# Avoid - Three separate requests
curl "https://stockloandata.com/api/loan-data?tickers=AAPL"
curl "https://stockloandata.com/api/loan-data?tickers=MSFT"
curl "https://stockloandata.com/api/loan-data?tickers=GOOGL"

curl "https://stockloandata.com/api/loan-data?tickers=AAPL&format=csv" -o data.csv

curl "https://stockloandata.com/api/loan-data?tickers=AAPL&start_date=2025-01-01&end_date=2025-12-31"

# Get list of valid tickers
curl "https://stockloandata.com/api/tickers"

Data Freshness

• New data is available by 8:00 PM ET each trading day
• Data reflects the previous trading day's close
• No intraday updates - data is end-of-day only
• Use the /health endpoint to verify data is loaded before making requests

The API is currently provided free of charge for reasonable use. We ask that you:

• Cache responses where appropriate to minimize redundant requests
• Avoid making excessive concurrent requests
• Use batch queries (multiple tickers) instead of individual requests when possible
• Consider downloading full datasets via CSV for bulk analysis rather than making thousands of individual API calls

• Historical Range: Data available from September 7, 2018 to present
• Update Frequency: Data is updated daily after market close
• Coverage: Only includes stocks participating in the OCC Stock Loan Program
• Delay: Data reflects the previous trading day, not real-time
• Market Hours: New data typically available by 8:00 PM ET after the trading day

Questions about the API? Need help with integration? Have feature requests?

Stock Loan Data was founded out of personal frustration. Like many retail traders, our founder discovered the OCC Stock Loan Program data during the meme stock events of 2021 and realized it contained valuable signals about institutional short positioning — signals that were hiding in plain sight on the OCC's website but almost impossible to use in practice.

The OCC publishes this data publicly, but only one trading day at a time. Downloading weeks or months of data meant manually retrieving hundreds of individual CSV files. There was no way to visualize trends, compare stocks, or correlate borrowing activity with price movements without spending hours on data preparation before any analysis could even begin.

We built Stock Loan Data to solve that problem — first for ourselves, then for anyone else who found value in it. What started as a personal data archive grew into a full platform with interactive charts, downloadable reports, and a public API. Today it covers more than 7 years of daily data across thousands of securities, updated automatically after every trading session.

Stock Loan Data is an independent project built and maintained by a self-directed investor and software developer based in the United States. Our background spans financial markets, quantitative data analysis, and software development — a combination that made building this kind of tool a natural fit.

We are not a financial institution, broker-dealer, investment advisor, or research firm. We are individual market participants who believe that access to quality financial data should not be limited to those with expensive institutional subscriptions. The OCC publishes this data publicly — we simply make it usable.

Have a question, found an issue, or want to suggest a feature? We read every email: [email protected]

Everything on this platform is either free to use or openly accessible. We do not sell data subscriptions, require account registration, or restrict access to historical data.

All loan data is sourced directly from the Options Clearing Corporation (OCC), a SEC-registered clearing agency and the world's largest equity derivatives clearing organization. The OCC publishes daily stock loan balance data for all securities in their Stock Loan Program at theocc.com.

Our automated collection system retrieves each day's data file after market close and appends it to our database. The process has been running continuously since September 2018 with no gaps in coverage for trading days. Raw CSV files are preserved and the database is rebuilt nightly to ensure consistency.

Candlestick and volume data displayed in the charts is fetched in real time from Yahoo Finance via the quantmod R package at the time of your query — it is not stored on our servers.

For complete details on our data collection process, calculations, and known limitations, see the Methodology tab.

Not Investment Advice. Stock Loan Data is a data visualization and research tool. Nothing on this website constitutes investment advice, a recommendation to buy or sell any security, or a solicitation of any investment decision. All data is provided for informational and educational purposes only.

No Affiliation with the OCC. Stock Loan Data is an independent platform with no affiliation, partnership, or endorsement relationship with the Options Clearing Corporation. We display publicly available data published by the OCC on their website.

Data Accuracy. We present OCC data as published. We do not independently verify, adjust, or modify the source data. Occasional errors, revisions, or omissions in the OCC's published figures may be reflected in our database.

Past Patterns Are Not Predictive. Historical correlations between stock loan data and price movements do not guarantee future results. Financial markets are complex and no single data source provides a reliable predictive signal.

We welcome feedback, bug reports, data questions, and feature suggestions. This is an independently maintained project and user input directly shapes what we work on next.

Email: [email protected]

Response times may vary, but we read everything. If you've spotted a data discrepancy, found a bug, or have an idea for improving the platform, we'd genuinely like to hear from you.