Data Sources & Integrations

Shortcut connects to EDGAR SEC filings, databases, APIs, and cloud storage, automatically pulling 10-Ks, 10-Qs, and financial data into Excel models without manual downloads or data entry.

Analyzing public companies means hours on SEC.gov downloading 10-Ks and 10-Qs, then manually transcribing data into Excel. Shortcut's data integrations eliminate this entirely with automatic connections to multiple data sources.

Available Data Sources

EDGAR SEC Filings

Pull SEC filings directly from the EDGAR database. Prompt "pull Adobe's last three 10-Ks" and Shortcut handles fetching, parsing, and populating your model with SEC data.

5-Step Automated Process

  1. Identifies the company's CIK (Central Index Key) automatically
  2. Fetches the requested filings from EDGAR
  3. Uses specialized PDF parsing technology to extract financial data
  4. Structures the data according to your model format
  5. Populates your spreadsheet with properly formatted financials

All of this happens in seconds, triggered by a simple natural language prompt.

Example Prompts:

Building Models from Scratch

"Build a DCF model for Salesforce using their last 10-K"

Updating Existing Models

"Update my Microsoft model with Q3 2024 10-Q results"

Comparative Analysis

"Compare revenue growth and margin trends for Snowflake, Databricks, and MongoDB over the last 3 years"

APIs & External Services

Connect to external APIs and data services to pull real-time market data, financial metrics, and business intelligence.

  • • Financial market data APIs
  • • CRM and business software
  • • Analytics platforms
  • • Custom REST APIs

Databases

Connect directly to SQL databases and data warehouses to pull structured data into your models.

  • • PostgreSQL, MySQL, SQL Server
  • • Snowflake, BigQuery, Redshift
  • • MongoDB and other NoSQL
  • • Custom database connections

Cloud Storage

Access files stored in cloud platforms and automatically sync data to your spreadsheets.

  • • Google Drive, Dropbox, OneDrive
  • • AWS S3, Azure Storage
  • • SharePoint and enterprise systems
  • • FTP and SFTP servers

File Uploads

Upload documents directly and extract structured data automatically.

  • • PDF financial statements
  • • Excel and CSV files
  • • Word documents and reports
  • • Images and scanned documents

Data Quality & Verification

All data pulled from EDGAR is directly from official SEC filings—no third-party data providers, no delayed feeds. You're analyzing the same source documents that institutional investors use.

Shortcut includes source citations showing exactly which filing and page number data came from. Verify any number by clicking through to the original filing.

How to Connect Data Sources

1

Identify Your Data Source

Determine which data source you need: EDGAR for public company filings, API for real-time data, database for internal data, or file upload for documents.

2

Use Natural Language

Simply describe what data you need in plain English:

"Pull Microsoft's last 3 years of 10-K filings and create a revenue trend analysis"

3

Automatic Processing

Shortcut automatically connects to the data source, extracts relevant information, and populates your spreadsheet with properly formatted data.

4

Verify & Cite Sources

Review the imported data with source citations. Click any cell to see where the data originated and verify accuracy.

Key Takeaways

  • EDGAR Integration - Pull 10-Ks and 10-Qs automatically from SEC
  • Database Connections - Connect to SQL, NoSQL, and data warehouses
  • API Integration - Access real-time market and business data
  • Cloud Storage - Sync files from Drive, Dropbox, S3
  • Source Citations - Verify data with automatic source tracking

Learn More About EDGAR Integration

Dive deeper into how Shortcut's EDGAR integration works with our comprehensive blog post.

Read: EDGAR Integration Guide →

Frequently Asked Questions

Which companies can I access through EDGAR?

All public companies that file with the SEC. This includes every publicly traded company in the US, plus many international companies with US listings. Simply use the company name or ticker symbol in your prompt.

How current is the EDGAR data?

Shortcut pulls data directly from SEC EDGAR in real-time. As soon as a company files a new 10-K, 10-Q, or other document with the SEC, it's available through Shortcut—typically within minutes of public filing.

Can I connect to my company's internal database?

Yes! Shortcut supports connections to internal databases including PostgreSQL, MySQL, SQL Server, and cloud data warehouses like Snowflake and BigQuery. Contact our team for enterprise database integration setup.

Is my data secure when connecting external sources?

All data connections use enterprise-grade encryption (TLS/SSL). Database credentials are encrypted at rest, and we never store raw financial data longer than necessary for processing. Shortcut is SOC 2 Type II compliant.