The Scenario
You're a hedge fund analyst doing due diligence on 20 small-cap names. Your checklist requires institutional ownership data: total ownership percentage, institution count, and the top-5 holders by name and percentage. The portfolio manager reviews the due-diligence workbook Wednesday morning. It's Monday at 3 PM and the ownership column is empty.
You have back-to-back meetings until 6 PM. After that you have the ownership pull, plus a valuation model update, plus a comps table.
The bad version:
- Open an institutional holdings data source for the first ticker. Record total institutional ownership, institution count, and the top 3 holders with names and percentages — six fields per ticker.
- Repeat for 19 more tickers across sources that don't all cover small caps with the same depth, requiring you to switch between two or three platforms mid-process.
- Finish with a workbook that has consistent data for 16 tickers and estimates or blanks for the other four because the small-cap coverage was thin on every source you tried.
A due-diligence workbook with four blank rows is not a due-diligence workbook. It's a question the PM will ask you about Wednesday morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the 20 tickers in column A and, through its built-in Twelve Data integration, fetches institutional ownership data for each position and writes all fields across adjacent columns.
Fetch institutional holder data from Twelve Data for each ticker in column A. Write total institutional ownership percentage into column B, total institution count into column C, and the names and ownership percentages of the top 3 holders into columns D through I (holder name and percentage alternating for each of the 3 holders).
What You Get
- Total institutional ownership percentage in column B.
- Institution count in column C.
- Top 3 holder name and percentage pairs in columns D through I.
- Tickers with no institutional data (very recent IPOs, unlisted OTC stocks) noted with NO DATA in column B.
What If the Data Is Not Quite Ready
If you want mutual fund holder data alongside institutional data
Fetch mutual fund holder data from Twelve Data for each ticker in column A. Write fund holder count into column B, total shares held by funds into column C, and percentage of shares outstanding owned by funds into column D. Fetch total institutional ownership percentage and write into column E.
If you want to flag tickers where one institution holds more than 10% of shares
Fetch institutional holder data from Twelve Data for each ticker in column A. Write total institutional ownership into column B and top holder name and percentage into columns C and D. In column E, write CONCENTRATED if the top holder owns more than 10%, otherwise DISTRIBUTED.
If you want to detect whether institutional ownership has changed significantly since last quarter
Fetch current institutional ownership percentage from Twelve Data for each ticker in column A and write into column B. Compare to the prior quarter figure in column C. Write the change in percentage points into column D. Flag tickers with more than a 5-point decrease as SELLING PRESSURE in column E.
Kill-chain: pull ownership data, flag concentration, and calculate a conviction score for prioritization
Fetch institution count, total institutional ownership percentage, and top holder percentage from Twelve Data for each ticker in column A. Write to columns B, C, D. In column E, calculate a conviction score: total institutional ownership divided by institution count (high score means concentrated conviction). Flag scores above 2.0 as HIGH CONVICTION and below 0.5 as WIDELY DISTRIBUTED in column F. Sort by conviction score descending.
Try It
Get the 7-day free trial of SheetXAI and open your due-diligence workbook with small-cap tickers in column A, then ask it to populate institutional ownership data for all 20 positions before Wednesday's review. Also see pulling analyst consensus data and the full Twelve Data overview.