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 — "weather", "currency", "goldprice". Autocomplete lists every source as you type, so you never have to memorize one.
- =VERVE("goldprice")
Then plain arguments
Everything after is the input that source needs — a city, a pair of currency codes, a field name. Pass them as plain strings or cell references.
- =VERVE("weather","Paris")
- =VERVE("currency","USD","EUR")
Ask for one field
Add a field name to return just the value you want instead of the whole record — handy when a cell should hold a single number.
- =VERVE("weather","London","temp")
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
=VERVE("timezone", A2:A9) resolves every row in a single call and spills the results down the column — no dragging, no copying the formula cell by cell.
- 03
It stays in sync
Add a row to the input 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"), 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("weather","London","temp")>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("weather","Paris")
Convert a currency
Returns the live exchange rate between two currency codes — here USD to EUR.
- =VERVE("currency","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("timezone",A2:A9)
Just the temperature
Returns a single field — the temperature in London — as one number.
- =VERVE("weather","London","temp")
Enrich a domain
Look up DNS, WHOIS or SSL details for a site to validate or enrich a list.
- =VERVE("dnslookup",A2)