The Scenario
You're an ESG researcher and you've spent the last two weeks tagging risk factor disclosures for eight energy companies. The tagging framework is ready. What you don't have is the source text — the risk factors section from each company's most recent 10-K filing. Your team lead asked you to pull it three days ago. You've been chasing it through EDGAR, Polygon's SEC filing endpoint, and two different PDF parsers, and you still have three companies unresolved.
The bad version:
- Query Polygon's reference filings endpoint for the first ticker, get the list of recent 10-K filings.
- Open the filing URL, locate the "Risk Factors" section, copy the text.
- Paste it into column B next to the ticker, trim the formatting artifacts, repeat.
- Discover that two of the eight companies filed their 10-K under a different entity name, which means the ticker lookup returned nothing and you have to search by CIK instead.
Three companies left to find. The tagging is supposed to start tomorrow. Nothing about this should have taken a week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads Polygon's SEC reference and filings endpoints and extracts the text you need without you navigating EDGAR by hand.
For each ticker in column A, fetch the risk factors section of the most recent 10-K from Polygon and paste the text into column B of my Risk Factors sheet, one company per row.
What You Get
- Column B populated with the full risk factors section text for each ticker.
- Text extracted from the most recent available 10-K filing.
- Companies where the filing is not findable by ticker flagged with a note in column B so you can resolve manually.
- Text trimmed of HTML formatting artifacts and rendered as clean prose.
What If the Data Is Not Quite Ready
I need the filing metadata, not the full text
Pull the list of all recent 10-K filings from Polygon for the tickers in column A and write the filing date, accession number, and SEC filing URL into columns B, C, and D.
Some tickers in my list filed under a different entity — I need to search by company name instead
For each company name in column A, search Polygon's ticker lookup to find the correct ticker symbol, then fetch the most recent 10-K risk factors section and write the resolved ticker into column B and the risk factors text into column C.
I need risk factors from the last three annual filings, not just the most recent
For each ticker in column A, fetch the risk factors section from the last 3 annual 10-K filings from Polygon and write each filing's text into a separate column (B for most recent, C for prior year, D for two years ago) with the filing date in row 1.
Pull the risk factor text, count the word frequency of "climate," "transition," and "physical risk," and flag companies where any term appears more than 5 times
For each ticker in column A, fetch the most recent 10-K risk factors text from Polygon, count the occurrences of the words "climate," "transition," and "physical risk" in that text, write the counts into columns C, D, and E, and flag any company where any count exceeds 5 in column F.
The combined text pull and keyword analysis saves a separate pass through NLP tooling for a first-pass screen.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you track your ESG coverage universe, then ask it to pull 10-K risk factor text from Polygon for your company list. You might also want to pull income statement data for the same companies to add financial context to your disclosures analysis.