macrotrends

Scrape historical financial statements and ratios from Macrotrends for US-listed stocks and ADRs.

173|28|Updated Jun 2, 2026

Search Tags:#finance #scraper #ratios #stocks #investing #financial statements

Ready to run

npx skills add https://github.com/gauss314/skills --skill macrotrends

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: macrotrends
Source: https://github.com/gauss314/skills/tree/main/skills/macrotrends
Command: npx skills add https://github.com/gauss314/skills --skill macrotrends

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires requests, beautifulsoup4, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This skill solves the difficulty of accessing long-term historical financial statements and ratios for US-listed companies and ADRs without needing a paid API key.

Core Features & Use Cases

Financial Statement Extraction: Retrieve income statements, balance sheets, and cash flow data for over 6,500 tickers.
Ratio Analysis: Access 20+ key financial ratios including ROE, ROA, and profit margins.
Use Case: Quickly gather 15 years of annual revenue and net income data for a specific ticker to perform a longitudinal fundamental analysis.

Quick Start

Use the macrotrends skill to fetch all available annual financial statements and ratios for the ticker NVDA.

Frequently Asked Questions about macrotrends

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I extract historical financial statements for stocks without a paid API?▼

You can extract historical financial statements for stocks without a paid API by scraping the Macrotrends website. This approach retrieves 15+ years of income statements, balance sheets, and cash flow data for US-listed companies and ADRs.

Can I scrape 15 years of balance sheet and cash flow data using Python?▼

Yes, you can scrape 15 years of balance sheet and cash flow data using Python. By utilizing the requests and beautifulsoup4 libraries, the scraper parses embedded JSON data from web pages to retrieve long-term financial records.

Does web scraping for financial ratios support international ADR tickers?▼

Web scraping for financial ratios does support international ADR tickers alongside US-listed stocks. The process resolves over 6,500 tickers to internal website slugs to accurately extract 20+ key ratios like ROE and ROA.

What's the best way to get 20+ key financial ratios like ROE and profit margins for longitudinal analysis?▼

The best way to get 20+ key financial ratios like ROE and profit margins for longitudinal analysis is scraping Macrotrends. It provides 15+ years of historical ratio data, enabling deep fundamental performance tracking over time.

Are there rate limits when scraping historical financial data with requests and beautifulsoup4?▼

Yes, there are rate limits to respect when scraping historical financial data with requests and beautifulsoup4. The extraction process is designed to respect these limits while parsing embedded JSON data to prevent access blocks.

Why does my historical financial data scraper fail to retrieve data for certain stock tickers?▼

A historical financial data scraper may fail to retrieve data for certain stock tickers if they are not supported. The tool only covers US-listed stocks and international ADRs, resolving valid tickers to internal slugs before parsing data.