Click this URL — or paste it into your browser’s address bar

https://siblisresearch.supabase.co/functions/v1/free-data-api/v1/NDX/pe-forward

You’ll see the NASDAQ 100 forward P/E for the available historical month-ends, returned as JSON. This is the API call — exactly the same URL you’d use from Python, curl, or Excel. Modern browsers format JSON automatically, no tooling required.

More examples (click or paste into address bar):

What you get back

Each ratio endpoint returns a JSON object with the time series. Here’s the shape of the response:

{
  "ticker":     "NDX",
  "index_name": "NASDAQ 100",
  "currency":   "USD",
  "frequency":  "daily",
  "ratio":      "pe_forward",
  "data": [
    { "trading_day (EOD)": "2024-06-28", "value": 26.62 },
    { "trading_day (EOD)": "2024-12-31", "value": 26.41 },
    { "trading_day (EOD)": "2025-06-30", "value": 27.62 },
    { "trading_day (EOD)": "2025-09-30", "value": 28.09 },
    { "trading_day (EOD)": "2025-12-31", "value": 27.44 }
  ]
}

Use it in your tools

Microsoft Excel — Power Query

1. Open Excel, go to the Data tab, click From Web.
2. Paste any URL from above into the URL field, click OK.
3. In the Power Query Editor, click the [List] value next to data, then click To Table, then expand the columns.
4. Click Close & Load.

Google Sheets

=IMPORTDATA("https://siblisresearch.supabase.co/functions/v1/free-data-api/v1/NDX/pe-forward")

Paste into any cell. The response will populate down the column.

Python

import requests

url = "https://siblisresearch.supabase.co/functions/v1/free-data-api/v1/NDX/pe-forward"
data = requests.get(url).json()["data"]

for row in data:
    print(row["trading_day (EOD)"], row["value"])

curl

curl "https://siblisresearch.supabase.co/functions/v1/free-data-api/v1/NDX/pe-forward"