If you can write a formula, you can pull live data
One function does all of it: =VERVE("source", …args). Reference cells like any spreadsheet function, fill a whole column from a range in one call, and nest it inside SUM, IF or a chart. Here's the complete reference — syntax, range fill, and nesting — with real formulas you can copy.
- One function
- Range-aware
- Composable
- Source name"weather"
- Arguments"Paris"
- Optional field"temp"
- Range fillA2:A9
=VERVE("source", …args)
Source name first, then plain arguments — a city, a ticker, a domain, an optional field to return.
The source name comes first
The first argument names the source as a string — "weatherforecast", "currencyconverter", "goldprice". On its own it spills the whole record as a two-column table, so you can see every value a source returns before you pick one.
- =VERVE("goldprice")
Then the inputs it needs
Next come the source's required inputs, in the order the sidebar lists them — a city, an amount and a currency pair. Pass them as plain strings, numbers or cell references.
- =VERVE("weatherforecast","Paris")
- =VERVE("currencyconverter",100,"USD","EUR")
Then options, as "name", value
Anything optional is a name followed by its value, repeated — the same shape as SUMIFS or GETPIVOTDATA. The name "field" is reserved: it picks the single value the cell should hold.
- =VERVE("weatherforecast","London","field","tempC")
- =VERVE("goldprice","currency","EUR","field","gram")
One call fills a whole column
Pass a range instead of a single value and every row resolves in one call — no dragging, no cell-by-cell copy.
- 01
Point it at a range
Instead of a single value, pass a range like A2:A9 as the argument — a column of cities, tickers, or domains.
- 02
One call fills the column
In Google Sheets, =VERVE("timezonelookup", A2:A9, "field", "timezone") resolves every row in a single call and spills the results down the column. In Excel, point the formula at one cell and drag it down — or let the sidebar write the whole column for you.
- 03
It stays in sync
Add a row to a spilled range and the output grows with it, and every filled cell refreshes on the same schedule as the rest of your sheet.
It composes like any other value
=VERVE() returns an ordinary value, so wrap it in the formulas, logic and charts you already use.
Wrap it in a calculation
=VERVE() returns an ordinary value, so SUM, AVERAGE, ROUND and friends treat it like any other cell — total a column of live prices in one step.
- =SUM(VERVE("goldprice","field","ounce"), B2)
Branch on it with IF
Feed a live value straight into logic — flag a threshold, pick a label, drive conditional formatting off a number that updates itself.
- =IF(VERVE("weatherforecast","London","field","tempC")>20,"Warm","Cool")
Chart it like any value
Because the output lands in real cells, charts, pivot tables and sparklines read from it directly — build a live chart with no extra plumbing.
- charts
- pivots
- sparklines
Formulas to copy
Real =VERVE() calls and what each one returns. Paste one in and see it resolve.
Weather for a city
Returns current conditions and temperature for any city or coordinate on earth.
- =VERVE("weatherforecast","Paris")
Convert a currency
Returns the live exchange rate between two currency codes — here USD to EUR.
- =VERVE("currencyconverter",100,"USD","EUR")
Live gold price
Returns the current gold price per ounce, no arguments needed.
- =VERVE("goldprice")
Timezones down a column
Fills the timezone for every row in the range A2:A9 in a single call.
- =VERVE("timezonelookup",A2:A9,"field","timezone")
Just the temperature
Returns a single field — the temperature in London — as one number.
- =VERVE("weatherforecast","London","field","tempC")
Enrich a domain
Look up DNS, WHOIS or SSL details for a site to validate or enrich a list.
- =VERVE("dnslookup",A2)