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.
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.
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.
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.
Pro
One analyst, the whole database.
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
Enterprise
A team, plus bulk delivery.
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
Custom
More seats, redistribution rights, or something the standard plans do not cover.
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)
30-day money-back guarantee on everything here. Subscriptions can be cancelled or paused at any time — no hidden fees.
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.