Subscribe
Market valuations/Stock market data in Excel

Global stock market valuation data in Excel, with one formula

All the key valuation multiples for major stock indices worldwide, including sector indices, loaded straight to your worksheet. Refresh All brings in the latest values.

No add-in to install, no macros, no code. One built-in Excel function and a web address are all it takes.

B2fx =IMPORTCSV("https://siblisresearch.com/api/v1/USA/pe-trailing/latest?format=value")
ABCD
1IndexTrailing P/EForward P/ECAPE
2U.S. Large Cap
3NASDAQ 100
4STOXX Europe 600
5FTSE 100
6DAX
7Nikkei 225
8NIFTY 50
9Emerging markets
10Global stock market
Click a figure to see its formula. Readings at 30 September 2026, from the free tier.
1. Copy the formulaEach one names an index and a ratio: NDX, cape.
2. Paste it into a cellThe latest value fills the cell. Add a date for a past value, or ask for the whole history.
3. Refresh AllEvery figure in the workbook updates. Charts and formulas built on them follow.

What you can pull into Excel

Indices
91
47 country and regional · 44 sector
History from
1970
on the longest series
Updated
Daily
end-of-day, every trading day

Valuation multiples: trailing and forward P/E, CAPE (the Shiller P/E), price to book, dividend yield and EV/EBITDA. Indices: the major stock markets of every developed and emerging region, the world, developed, emerging and European aggregates, the NASDAQ 100, small caps, growth and value, and the eleven equity sectors for the United States, the world and the world excluding the United States.

Every ratio is calculated in-house from company filings, on the aggregate: the index's total market value over its total earnings, book value or EBITDA. Past readings are point-in-time and are never restated.

Valuations, not stock prices

Excel's built-in stock functions give prices. They don't tell you what a market is worth relative to what it earns: the P/E of the NASDAQ 100 today, the CAPE of Japan in 2008, or whether European stocks are cheap against their own history. That is what this data is for.

A valuation dashboardMarkets and sectors side by side, refreshed in one click instead of copied by hand every month.
Asset allocation modelsCAPE and forward P/E as inputs, with decades of history behind every reading.
Backtests in ExcelPoint-in-time history, so a test sees only what was known on each date.
Client reports and chartsCharts that update with the data, for reports that go out every month or quarter.

Try it without a key

The free tier: no account, period-end readings

Paste this into any cell in Microsoft 365 Excel. It fills the cell with the latest CAPE of the NASDAQ 100 on the free tier:

=IMPORTCSV("https://siblisresearch.com/api/v1/NDX/cape/latest?format=value")

Change NDX to another index, such as UKX or N225, or cape to pe-forward, and the formula follows. For every reading the free tier holds, one row per date, use =IMPORTCSV("https://siblisresearch.com/api/v1/NDX/cape?format=csv"). A subscription gives every index, every trading day and the complete history through the same formulas. Google Sheets, Python and R use the same addresses: see the API page.

Plans

Every plan carries the Excel formulas, the API and the monthly Excel dashboard.

Pro

One analyst, the whole database.

$768/year

One payment a year — works out at $64 a month

  • 1 user
  • 5,000 API requests a day
  • Monthly Dashboard (Excel)
  • Complete history, back to 1970 on the longest series
  • Full API access, every trading day
  • Statistical aggregates endpoint
  • Priority support
Start annual subscription

Enterprise

A team, plus bulk delivery.

$3,840/year

One payment a year — works out at $320 a month

  • Up to 5 users
  • 50,000 API requests a day
  • Monthly Dashboard (Excel)
  • Complete history, back to 1970 on the longest series
  • Full API access, every trading day
  • Statistical aggregates endpoint
  • Bulk CSV download
  • Priority support
Start annual subscription

Custom

More seats, redistribution rights, or something the standard plans do not cover.

By quote

Usually a reply within one business day

  • 5+ users
  • Negotiable rate limits
  • Everything in Enterprise
  • Custom index coverage
  • Alternative file formats
  • Redistribution and white-label licensing (valuations data)
Ask for a quote

30-day money-back guarantee on everything here. Subscriptions can be cancelled or paused at any time — no hidden fees.

Questions

Do I need an Excel add-in?

No. The data comes in through IMPORTCSV, a built-in Excel function. There is nothing to install, no macros and no add-in for IT to approve; the workbook stays an ordinary .xlsx file.

Which version of Excel do I need?

IMPORTCSV is part of Microsoft 365. In Google Sheets, IMPORTDATA does the same with the same addresses.

Can I get prices of individual stocks?

No. This is market-level valuation data: the P/E, forward P/E, CAPE, price to book, dividend yield and EV/EBITDA of whole indices and sectors. For prices of single stocks, Excel’s own stock data type is the place to start.

How far back does the data go?

To 1970 on the longest series, with twenty years or more for most indices. A subscription carries the complete daily history.

Is there a free version?

Yes. The free tier needs no key and no account, and carries period-end readings for a selection of indices: enough to build and test a workbook before subscribing.

Does it work in Google Sheets, Python or R?

Yes. The same addresses work with IMPORTDATA in Google Sheets and with any language that can read a URL. The API page has examples.

Where this data is used

Some examples. Siblis valuation data appears in peer-reviewed journals, central bank publications and the financial press.

Modern Portfolio Theory and the Efficient Markets Hypothesis Jim Fischer12th Economics and Finance Conference, International Institute for Social and Economic Sciences · 2019
Es-CAPE Velocity: Value-Driven Sector Rotation Corey HoffsteinNewfound Research · 2019
Political and Economic Freedoms and Global Equity Valuations Bahram Adrangi, Arjun Chatrath, Suphachok Ampai, Zachary Lum & Decclan McLeanThe American Economist, 71(1) · 2026