Prediction Market Data in Google Sheets

Google Sheets can display live prediction market consensus using Apps Script and the Meridian Edge API.

Google Sheets can display live prediction market consensus using Apps Script and the Meridian Edge API. Apps Script setup, auto-refresh, and data formatting.

Overview

Apps Script setup, auto-refresh, and data formatting. The Meridian Edge API makes this data programmatically accessible in a structured JSON format with named fields for probability, confidence, spread, and market count.

Getting started takes under 5 minutes: get an API key at the pricing page, then call GET /api/v1/consensus with your X-API-Key header. The response includes up to 100 events per call with full consensus data.

For researchers and developers building production applications, Starter tier ($29/mo) includes 1,000 calls/day, 30-day historical data, and the /api/v1/opportunities endpoint which surfaces high-divergence events automatically.

How to get started

Get an API key at the pricing page — instant activation
Call GET /api/v1/consensus?sport=NBA&limit=10 with your X-API-Key header
Parse the events array — each event includes consensus_prob, confidence, divergence_pct, and market_count
See the full API reference for all available endpoints and parameters

Related resources

Frequently asked questions

What is prediction market data in google sheets?

Google Sheets can display live prediction market consensus using Apps Script and the Meridian Edge API. Meridian Edge aggregates consensus from multiple regulated prediction market sources, giving you a single calibrated probability updated continuously.

How do I access this data via API?

The Meridian Edge API provides programmatic access to prediction market data in google sheets and more. Starter tier: 100 calls/day. Get a key at meridianedge.io/#pricing.

What does the Meridian Edge starter tier include?

Yes. The starter tier includes 100 API calls per day with access to the consensus endpoint covering all major sports and political events. Starter ($29/mo) includes 1,000 calls/day plus the divergence opportunities endpoint.

Get API Access

Plans start at $29/mo. 1,000 calls/day. Key in 10 seconds.

View Plans →

Need more? Starter ($29/mo) — 1,000 calls/day + divergence signals