//SHEETS · LIVE FORMULAS · IFRAME
Free, pro-quality spreadsheets.
With live market formulas.
=PRICE(), =STOCK(), =BLACKSCHOLES() — formulas that pull live market data through Finterm’s edge-cached gateway. Embed in one line. No SDK, no API key, no signup.
Pick how to embed
React is the shorter path — typed props, tree-shakeable, no string-templating the query params. The plain <iframe> is there if you don’t ship a build step.
npm i @finterm/reactimport { FintermSheet } from '@finterm/react';
<FintermSheet
theme="night"
height={600}
/>Framework-agnostic? Import @finterm/react/elements once and use <finterm-sheet> in Vue, Svelte, Astro, plain HTML — same props, no React runtime.
import '@finterm/react/elements';
<finterm-sheet theme="night"></finterm-sheet>No build step. Drops into any HTML page, every query-param is optional, cross-origin works out of the box.
<iframe
src="https://sheets.finterm.xyz/embed"
width="100%" height="600"
style="border:0"
loading="lazy"
title="Finterm spreadsheet"
></iframe>Live formulas
Everything refreshes in place as the market moves. No add-in, no vendor API key, no rate-limit messages.
| =PRICE("BTCUSDT") | Live price from Binance / Yahoo, refreshed every few seconds. |
| =STOCK("AAPL") | Equity quote — last, change, percent. |
| =BLACKSCHOLES(S, K, T, r, σ, "call") | Closed-form option value. |
| =VOL(symbol, window) | Realized volatility over a trailing window. |
| =TREND(range) | Linear-regression slope of a column. |
| =ZSCORE(range) | z-score of the last value vs the rest of the column. |
| SUM, AVG, COUNT, MIN, MAX, IF, … | Everything else you expect from a spreadsheet. |
Configure via query params
| param | values | notes |
|---|---|---|
| content | base64-url CSV | Pre-fill the sheet. Encode with btoa() then base64-url replacement. |
| theme | sand, night, ledger, high-contrast | Visual palette. Default is high-contrast. |
//WANT MORE THAN JUST A SPREADSHEET?
Open the full terminal.
Multi-window workspaces, WebGL charts, SEC filings, earnings calls, and a JS-sandboxed backtester. Same free, no-signup deal.