Excel Add-in
Live market data, in every cell.
The Windy Network Excel add-in adds 22 custom functions for accessing multi-asset market data — crypto, fiat, derivatives, technical indicators, and institutional reference rates — directly from spreadsheet formulas.
Works with Excel for Windows, Mac, Web, and Microsoft 365 (2019+).
Install
The add-in is sideloaded from a manifest. You only need to do this once per workbook.
-
Download the manifest:
https://excel-addin.windy.network/manifest.xml -
Upload to Excel via Insert → Get Add-ins → My Add-ins → Manage My Add-ins → Upload My Add-in, then select
manifest.xml. -
Paste your API key in the Windy ribbon button, then Save & Validate. Get a key at windy.network/account/api-keys.
-
Type a formula in any cell:
=WINDY.RATE("BTC","USD")
Function Reference
All functions are namespaced under WINDY. and resolve asynchronously — Excel will show #BUSY! for a fraction of a second on first call, then update with live data. Functions that return multiple values spill into adjacent cells.
Rates & candles
| Formula | Returns |
|---|---|
=WINDY.RATE(base, term) | Aggregated mid-rate across all sources |
=WINDY.RATE_AT(base, term, isoTime) | Mid-rate at a specific timestamp |
=WINDY.OHLC(base, term, tf, count) | Spills a 24×6 grid: timestamp, open, high, low, close, volume |
=WINDY.OHLC_HISTORIC(base, term, tf, fromIso, toIso) | Date-range candles |
=WINDY.TICKER(exchange, base, term) | Per-exchange bid/ask/vwap/high/low/volume |
Technical indicators
| Formula | Returns |
|---|---|
=WINDY.SMA(base, term, tf, window) | Simple/exponential moving average |
=WINDY.RSI(base, term, tf, window) | Relative strength index, 0–100 |
=WINDY.MACD(base, term, tf) | macd / signal / histogram in one row |
=WINDY.BBANDS(base, term, tf, window) | Upper/middle/lower Bollinger Bands |
Liquidity, derivatives & reference rates
| Formula | Returns |
|---|---|
=WINDY.LIQUIDITY(base, term) | 0–100 score with rating, spread (bps), exchange count |
=WINDY.SLIPPAGE(base, term, side, amount) | Pre-trade slippage estimate in basis points |
=WINDY.FUNDING(exchange, base, term) | Perpetual funding rate |
=WINDY.OPEN_INTEREST(exchange, base, term) | Open interest in base units |
=WINDY.REFRATE(type, base, term) | Institutional benchmark fixing (Fix, TCUT, TWAP) |
24/7 fiat
Fiat rates derived from cryptocurrency markets — available 24/7, including weekends and holidays when traditional FX markets are closed.
| Formula | Returns |
|---|---|
=WINDY.FX(base, term) | Live 24/7 derived fiat rate |
=WINDY.FX_OHLC(base, term, tf, count) | Fiat candles |
=WINDY.FX_RSI(base, term, tf, window) | RSI on fiat data |
Calendar & discovery
| Formula | Returns |
|---|---|
=WINDY.FOREX_SESSIONS() | Sydney / Tokyo / London / NY session status |
=WINDY.HOLIDAYS(countryCode) | National holidays for an ISO-2 country code |
=WINDY.ASSETS() | All supported crypto assets |
=WINDY.EXCHANGES() | All supported exchanges |
Conventions
- Asset symbols are uppercase (
BTC,ETH,USDT,GBP,USD). - Country codes use ISO-2 format (
US,GB,DE,JP). - Timestamps are ISO 8601 in UTC (e.g.
2026-04-17T16:00:00Z).
Timeframes
The tf parameter accepts:
| Code | Interval |
|---|---|
m1 | 1 minute |
m5 | 5 minutes |
m15 | 15 minutes |
m30 | 30 minutes |
h1 | 1 hour |
h4 | 4 hours |
d1 | Daily |
w1 | Weekly |
mo1 | Monthly |
Resources
| Asset | URL |
|---|---|
| Manifest | excel-addin.windy.network/manifest.xml |
| Task pane | excel-addin.windy.network/taskpane.html |
| Function metadata | excel-addin.windy.network/functions.json |
| REST API | api.windy.network |
| API keys | windy.network/account/api-keys |
Need help?
- Read the API Reference for the underlying endpoints each function calls.
- Open an issue or ask a question via Windy Network Support.