ManticView logo ManticView

Guide · Google Sheets

Probabilities as plain numbers.

ManticView adds eight custom functions to Google Sheets — live probabilities, market attributes, answer tables, search, price history, and portfolios — plus a sidebar for finding markets and inserting them with one click. Everything returns plain values your spreadsheet can chart, average, and alert on.

Quick start · three steps

From zero to a live probability

The whole loop takes about a minute. Do these three things and you're running; the walkthrough below goes deeper on each function when you want it.

1

Get the functions

Make a copy of the ready-made template (File → Make a copy), or paste Code.gs into Extensions → Apps Script and save.

no API key · no login

2

Type a formula

In any cell, start typing =MANIFOLD and pick one from autocomplete. Pass a market slug or its full URL.

=MANIFOLD_PROB("will-x-happen-by-2030")
3

Format & keep it live

Format the cell as a percentage to read 72%. To refresh, pass a cell holding =NOW() as the last argument — or use the add-on's auto-refresh.

=MANIFOLD_PROB("will-x…", $A$1)
Step 1 · Setup — about one minute

Get the functions into your spreadsheet

The easy way: make a copy of the ready-made template (File → Make a copy) — the functions come with it. Or add them to any existing spreadsheet: open Extensions → Apps Script, replace the placeholder with the contents of Code.gs, and save. No authorization prompts, no API key. For the full add-on — search sidebar, one-click inserts, auto-refresh — add the three companion files too, or wait for the Google Workspace Marketplace listing, coming soon.

Step 2 · The headline function

=MANIFOLD_PROB — a market's live probability

fx=MANIFOLD_PROB("will-x-happen-by-2030")
AB
1Will X happen by 2030?72%
2

works with a slug or the full manifold.markets URL

  1. Paste the market. Grab the slug (the last part of a market's URL) or just paste the whole URL — both work.
  2. Get a real number back. The function returns the probability as a value between 0 and 1 — here 0.72.
  3. Format the cell as a percentage and it reads 72%. Because it's a plain number, you can chart it, average a basket of markets, or conditionally format when it crosses a threshold.
Step 3 · Any market attribute

=MANIFOLD — question, close date, volume, and more

fx=MANIFOLD("will-x-happen-by-2030", "closeTime")
AB
1questionWill X happen by 2030?
2closeTime12/31/2030
3volume24Hours1,204
4isResolvedFALSE

time attributes return real dates you can sort and format

  1. Second argument picks the attribute — question, closeTime, volume, isResolved, resolution, and more. Omit it and you get the probability.
  2. Dates come back as dates, not timestamps — sortable and formattable like anything else in your sheet.
  3. Build dashboards by mixing attributes: one row per market, columns for probability, close date, and 24-hour volume.
Step 4 · Tables that spill

=MANIFOLD_ANSWERS and =MANIFOLD_SEARCH

fx=MANIFOLD_ANSWERS("who-wins-the-final")
AB
1AnswerProbability
2🇫🇷 France76%
3🇲🇦 Morocco24%

one formula, a whole table — recalculates in place

  1. Multiple-choice markets spill: one formula fills a two-column table, one row per answer — sorted by probability (highest first) by default. Pass "alphabetical" as the second argument to sort A→Z instead.
  2. Search without leaving the sheet: =MANIFOLD_SEARCH("bitcoin", 5) spills matching markets — question, probability, slug, and URL — ready to feed into the other functions.
  3. Everything stays live. The spilled tables recalculate along with the rest of your spreadsheet.
Step 5 · The shape of the odds

=MANIFOLD_HISTORY — sparklines of probability

fx=SPARKLINE(MANIFOLD_HISTORY("will-x-happen-by-2030"))
AB
1Will X happen by 2030?

the market's recent path, drawn by Sheets itself

  1. History as a column of numbers. MANIFOLD_HISTORY samples a binary market's recent betting history — chronological, oldest first, 50 points by default.
  2. Wrap it in SPARKLINE and the whole story fits in one cell. Pass options like {"color","#4F46E5"} to style it.
  3. Or chart it properly: spill the raw column into a range and point a real Sheets chart at it.
Step 6 · People, not just markets

=MANIFOLD_PORTFOLIO, =MANIFOLD_POSITIONS, =MANIFOLD_USER

fx=MANIFOLD_PORTFOLIO("YourUsername")
AB
1MetricMana
2Balance12,480
3Net worth19,214
4Daily profit+312

public data by username — no API key, no login

  1. Track any portfolio — yours or a trader you admire. MANIFOLD_PORTFOLIO spills balance, investment value, net worth, and profit.
  2. See the positions behind it: =MANIFOLD_POSITIONS("YourUsername", 10) lists open positions by value, with profit and a link per market.
  3. Single user facts come from MANIFOLD_USER — balance by default, or any public attribute by name.
Step 7 · Freshness

Refreshing on your schedule

fx=MANIFOLD_PROB("will-x-happen-by-2030", $A$1)
AB
17/10/2026 18:25:0372%

A1 holds =NOW() — every recalculation refreshes the market

  1. Results are cached for five minutes to stay friendly to Manifold's free API — plenty fresh for prediction markets.
  2. Sheets also caches custom functions, so to force a refetch, pass any changing value as the last argument — a cell containing =NOW() works perfectly. With the add-on installed, Extensions → ManticView → Refresh markets now does it for every formula at once, and auto-refresh can repeat it on the cadence you choose — from ~5 minutes to once a day — even with the sheet closed. These run on Google's schedule, so they fire about that often (hence the ~), not exactly from the moment you set them; the sidebar's Refresh log shows each run so you can confirm it's working.
  3. No key, no quota to manage: the functions read Manifold's public API anonymously.
Step 8 · The sidebar

Search, sight, insert

With the add-on files installed, Extensions → ManticView → Search & insert markets… opens a sidebar that does the slug-hunting for you.

  1. Pick a cell first. Every insert lands at the selected cell, and the selection steps below it afterwards, so repeated inserts stack into a tidy list.
  2. Search and filter. Type a few words, then narrow with the chips — open markets only, Yes/No, or multiple choice. Each result shows the live probability, traders, and close date.
  3. Four inserts per market: % drops a live probability · Row writes question, probability, 24h volume, close date, and a link · Answers spills the answers table · Spark draws a mini price-history chart.
  4. The "titles" toggle writes the market's name beside the number — and portfolios get a linked @username heading — so a column of inserts stays readable without extra typing.
  5. Portfolios too: load any Manifold username in the sidebar's Portfolio section to preview their net worth and top positions, then insert the summary or positions table.
  6. Need a reminder? The sidebar's own How to use section repeats all of this two clicks away from your sheet.
Open the template Next: the Android app →