W Windy Network
Excel Add-in

Live market data, in every cell.

Windy Network for Excel exposes our multi-asset market data API as 22 custom functions — =WINDY.RATE, =WINDY.OHLC, =WINDY.RSI, and more — across crypto, 24/7 fiat, derivatives, indicators, reference rates, and market calendars.

Download manifest.xml Get an API key

Works with

Excel for Windows Excel for Mac Excel for the Web Microsoft 365 Excel 2019+
Step by step

Install in under a minute.

Until the add-in lands on Microsoft AppSource, install it directly from the manifest. No account, no compile, no permissions screen.

1

Download the manifest

manifest.xml — a small XML file Excel uses to register the add-in.

2

Upload to Excel

In Excel: Insert → Get Add-ins → My Add-ins → Manage My Add-ins → Upload My Add-in — pick the file you just downloaded.

3

Paste your API key

Click the Windy ribbon button under Home, paste your key, hit Save & validate.

4

Type a formula

In any cell:

=WINDY.RATE("BTC","USD")
22 functions

Everything you'd ask the API for, but spilled into a sheet.

Each function returns a typed value or a 2-D range — Excel's dynamic arrays handle the layout automatically.

Rates & candles

Live mid-rate

=WINDY.RATE("BTC","USD")

Aggregated mid-rate across all sources.

Historical rate

=WINDY.RATE_AT(base, term, isoTime)

Mid-rate at a specific timestamp.

OHLC candles

=WINDY.OHLC("BTC","USD","h1",24)

Spills a 24×6 grid: timestamp, open, high, low, close, volume.

Historical OHLC

=WINDY.OHLC_HISTORIC(base, term, tf, fromIso, toIso)

Date-range candles for backtests.

Exchange ticker

=WINDY.TICKER("binance","BTC","USDT")

Per-exchange bid, ask, vwap, high, low, volume.

Technical indicators

SMA / EMA

=WINDY.SMA(base, term, tf, window)

Simple and exponential moving averages.

RSI

=WINDY.RSI("ETH","USD","h1",14)

Relative strength index, 0–100.

MACD

=WINDY.MACD(base, term, tf)

Returns macd / signal / histogram in one row.

Bollinger Bands

=WINDY.BBANDS(base, term, tf, window)

Upper / middle / lower bands.

Liquidity, derivatives, refrate

Liquidity score

=WINDY.LIQUIDITY("BTC","USD")

0–100 score with rating, spread (bps), exchange count.

Pre-trade slippage

=WINDY.SLIPPAGE(base, term, side, amount)

Estimated slippage in bps for a given size.

Funding rate

=WINDY.FUNDING(exchange, base, term)

Latest perpetual funding rate.

Open interest

=WINDY.OPEN_INTEREST(exchange, base, term)

Open interest in base units.

Reference rate

=WINDY.REFRATE("fix", base, term)

Institutional benchmark fixings: fix / tcut / twap.

24/7 Fiat (Fiat247)

Live fiat rate

=WINDY.FX("GBP","USD")

Real-time 24/7 derived fiat rate.

Fiat OHLC

=WINDY.FX_OHLC(base, term, tf, count)

Candles for fiat pairs, around the clock.

Fiat RSI

=WINDY.FX_RSI(base, term, tf, window)

RSI on fiat candles.

Calendar & discovery

Forex sessions

=WINDY.FOREX_SESSIONS()

Sydney / Tokyo / London / NY open status.

Holidays

=WINDY.HOLIDAYS("US")

National holidays for an ISO country code.

All assets

=WINDY.ASSETS()

Every supported crypto asset.

All exchanges

=WINDY.EXCHANGES()

Every supported exchange.

Reference

Conventions & timeframes.

Asset symbols are uppercase (BTC, ETH, USDT, GBP). Country codes use ISO-2 (US, GB, DE).

TimeframeMeaning
m11 minute
m5 · m15 · m305 / 15 / 30 minutes
h1 · h41 / 4 hours
d1Daily
w1Weekly
mo1Monthly
manifest.xml Office Add-in manifest — download & sideload → taskpane.html Task pane preview (loads inside Excel) → functions.json Custom function metadata → api.windy.network REST API the add-in calls →