Macrotrends Scraper for Long-Run Financials and Price Charts

Macrotrends prints every metric twice, as a sentence and as a table. Our Macrotrends scraper keeps the tables: one row per company, metric and period end date.

Plans from €169 a month · Free project assessment · Reply within 1 business day

CSV · Excel · JSON · XML · FTP · SFTP · Amazon S3 · Google Cloud

macrotrends.net
Macrotrends Scraper for Long-Run Financials and Price Charts
macrotrends.netwhat you get
Typical fields for financial sites
tickerpricechange_pctvolumemarket_capupdated_at
Delivery

API, JSON feed or CSV, XLSX and JSON files

Schedule

One-time, monthly, weekly, daily or 3 times a day

Macrotrends Scraping as a Managed Service

  1. You send

    Macrotrends pages, filters, fields and a schedule

  2. We run the scrapers

    Built, monitored and repaired by our team

  3. You receive the data

    API, JSON feed or CSV, XLSX and JSON files

Macrotrends scraping is hard to run yourself at volume: the site sits behind a bot check that turns away unfamiliar traffic, and one company profile spreads over dozens of URLs. You send the list - tickers, a screener result, a set of commodity and economy charts - and the metrics you need. We build the crawlers, run them one-off or on your schedule and keep them working; anti-bot handling, rendering, pacing and proxy rotation are part of the service.

Output arrives as CSV, XLSX, JSON or JSONLines, via our API, a JSON feed, Amazon S3, Dropbox or e-mail, with field documentation that names the Macrotrends page each column came from.

Macrotrends Financial Data: Fields per Company

A Macrotrends company lives under one address pattern - /stocks/charts/AAPL/apple/ followed by the metric - and eight tabs: Prices, Financials, Revenue & Profit, Assets & Liabilities, Margins, Price Ratios, Other Ratios and Other Metrics. Each metric page opens with plain sentences about the latest quarter and year and then gives annual and quarterly tables. We take the tables, not the sentences, and key every value on ticker, metric and period end date.

  • Revenue and profitrevenue, gross profit, operating income, EBITDA, net income, EPS and shares outstanding, annual and quarterly, in millions of US dollars.
  • Assets and liabilitiestotal assets, cash on hand, long term debt, total liabilities and shareholder equity.
  • Marginsgross margin, operating margin, EBITDA margin, pre-tax margin and net margin, each with the TTM revenue and TTM profit behind it.
  • Price ratiosPE ratio with the stock price and TTM net EPS, P/S, price/book and price-FCF ratios, and net worth.
  • Other ratioscurrent ratio with current assets and liabilities, quick ratio, debt/equity, ROE, ROA, ROI and return on tangible equity.
  • Pricesstock price history adjusted for splits and dividends, with average price, year open, high, low, close and annual change, the all-time high close and its date, the 52-week range, stock splits and market cap history.
  • Other metricsdividend yield with the TTM payout, and the annual employee count.
  • Statementsincome statement, balance sheet, cash flow statement and key ratios, in annual or quarterly format.
  • Company cardsector, industry, market cap, revenue and the business description.

Units stay as Macrotrends shows them - millions of dollars for statement lines, dollars per share for EPS, percentages for margins - and the documentation states each one.

Macrotrends Financial Data: Fields per Company
Macrotrends Historical Data for Commodities and the Economy

Macrotrends Historical Data for Commodities and the Economy

The other half of the site is long-run chart pages. Precious metals cover gold, silver, platinum and copper; energy covers WTI and Brent crude, natural gas and heating oil; the commodities group covers corn, soybeans, wheat, cotton, coffee, oats, sugar, soybean oil and lumber. Index pages chart the Dow, the S&P 500 and the NASDAQ, and the economy pages cover GDP, GDP growth, GDP per capita, inflation and debt to GDP by country, with population and city rankings under Global Metrics.

Many series are inflation adjusted with the headline CPI: gold prices per ounce back to 1915, oil prices per barrel back to 1946, the S&P 500 as month-end closes. Wheat, by contrast, is a daily price in dollars per bushel. We record for each series whether it is real or nominal and in which unit.

The current month on these charts updates hourly, so repeated runs build what the page does not keep: a daily record of the latest value. The Stock Research page adds rankings - top stocks by market cap and by dollar volume, stocks by industry - that work as a seed list for a company crawl.

About Macrotrends and Its Long-Run Charts

Source
macrotrends.net
Category
financial sites
Delivery
API, JSON feed, CSV, XLSX
Plans
From €169 a month
Get a quote

Macrotrends is a research site run by Macrotrends LLC under the line The Long Term Perspective on Markets. It is built for investors who think in decades rather than days: each company and each market series is drawn as a long chart with its table beneath, and the pages carry a credit line naming where the numbers come from.

The home page lists ten sections: Stock Screener, Stock Research, Market Indices, Precious Metals, Oil & Gas, Commodities, Exchange Rates, Interest Rates, Economy and Global Metrics. Company pages are the deepest part: each company has a slug of ticker and name, eight metric tabs and a financial statements view, so one company is several dozen pages. Commodity and macro pages are numbered instead, such as /1333/ for the gold chart, and often come in pairs - a long-run history page and a daily page.

The Stock Screener filters by market cap, PE ratio, dividend yield, price, P/B ratio, LT debt/equity, ROE, operating margin and net margin. Each company table covers the span of years its public page shows, and that is the span we collect; runs repeated over time extend a series from the day a project starts.

25Developers
500+Customers
1.5BPages extracted
15,000+Hours saved for our clients

Macrotrends scraping plans and pricing

Airplane

€199one-time

Setup fee included

100,000
One-time
Up to 5 days
7 days

Helicopter

€169/ mo

Setup fee €499

250,000
Monthly
Up to 5 days
14 days

Glasses

€229/ mo

Setup fee €499

1,000,000
Weekly
Up to 5 days
30 days

Microscope popular

€349/ mo

Setup fee €499

2,000,000
Daily
Same day
60 days

DNA

€549/ mo

Setup fee €799

3,000,000
3 times daily
Same day
90 days

Delivery: CSV, JSON or XLSX files, our API or a JSON feed. MCP server on request.

Full plan details

Why Long-Run Macrotrends Series Are Worth Collecting

Macrotrends lines up ten years of quarterly fundamentals in the same layout for every company, which is what a factor or valuation study needs: PE ratio, price/book and price-FCF over many quarters, margins next to revenue growth, debt/equity and current ratio next to cash on hand. Collected for a whole sector, these tables make a peer panel without stitching statements together by hand.

The commodity and macro series serve a different crowd. Procurement and agricultural analysts use the long histories of wheat, corn, soybean, coffee and lumber prices for seasonality and long-cycle comparisons; macro researchers put inflation-adjusted gold and oil prices next to GDP and inflation by country.

Is Macrotrends data reliable enough for a model? Treat it like any secondary source: we keep the page URL, the source line and the capture date with every value, so a figure can be checked against the original filing or price series first.

About ScrapeIt

ScrapeIt is a managed scraping service for teams that need data rather than tools. Research sites like Macrotrends bring dozens of pages per company, tables that grow every quarter, and a bot check that stops casual crawling. A project starts with a free assessment, and a sample on your own tickers or series can come first; after that we build and run the crawlers and deliver the tables with documentation.

FAQ

Still unsure? Write to info@scrapeit.io

Where does Macrotrends get its data, and do you keep the source?

Macrotrends prints a credit line on its pages: company fundamentals are attributed to an equity research provider, country series to an international statistics body. We store that line, the page URL and the capture date with each value, so every number in the delivery can be traced back.

Can you build a Macrotrends database for a whole stock universe?

Yes. We start from the Stock Screener or your ticker list, collect the metric tabs you choose for every company and key each value on ticker, metric and period end date. New quarters are appended as Macrotrends adds them, so the database keeps every period you have collected.

How often do you refresh Macrotrends commodity and stock pages?

Metal, oil and index charts update their current month hourly, so daily or weekly runs suit price series. Company fundamentals change when a new quarter is reported, and a weekly or post-earnings run is usually enough; stock price history and PE ratio pages move with the market and can run daily.

Do you offer a Macrotrends API for financials and price series?

Yes. The ScrapeIt Macrotrends API returns revenue, net income, EPS, PE ratio, gross margin and gold or oil price series as JSON from an endpoint we host, refreshed on the schedule you set. You can also take it as XLSX or CSV exports, a JSON feed or a load into your own warehouse.

Is it legal to scrape Macrotrends?

Yes. The charts, tables and company metric pages are free content that Macrotrends publishes for every reader. We collect only publicly available data - everything a visitor can see on Macrotrends - and we collect it legally.

How it works

  1. 1

    Make a request

    You share your needs, expectations, and desired timeframe. We'll suggest the best solution based on your request and budget.

  2. 2

    We configure the crawlers

    Our specialists configure the crawlers and extract a sample dataset for your review before proceeding with the full-scale extraction.

  3. 3

    Collect and deliver

    Once you approve the sample, we launch the project and start full data collection. We gather, filter, and structure the data for easy use, delivering it on time in your preferred format.

  4. 4

    Maintain and support

    Our team manages ongoing processes, monitors website changes, and supports all data extraction cycles. We can also help integrate data into your systems or create dashboards to simplify analysis.

Request a quote

Tell us which sites, which fields and how often. A couple of lines is enough to start.

  • We reply within 1 business day
  • A sample dataset before the full run
  • We sign an NDA on request
  • Delivery by API, JSON feed or files
Which sites, which fields, how often. A couple of lines is enough.

This form is protected by Google reCAPTCHA, which loads when you start filling it in; the Google Privacy Policy and Terms of Service apply. If you prefer not to use it, email us at info@scrapeit.io. Privacy & Cookie Policy

We reply within 1 business day. No obligation.

Macrotrends data from €169/month. Free project assessment, reply within 1 business day.