CryptoExcel Functions in Microsoft Excel
CryptoExcel provides custom Excel functions (User-Defined Functions or UDFs) for retrieving live and historical cryptocurrency data. Use familiar worksheet formulas to build portfolio trackers, order book dashboards and custom analysis without writing code.
1. How CryptoExcel Functions Work
CryptoExcel functions are Python-based UDFs that use libraries including CCXT, Pandas and xlOil. They behave like regular Excel formulas while connecting your worksheets to cryptocurrency exchange data.
For example, enter =st_watch_trades("binance","BTC/USDT") in a cell. Alternatively, put binance in A1 and BTC/USDT in A2, then use =st_watch_trades(A1,A2).
Tip: Cell references make formulas easier to maintain. Depending on your regional Excel settings, you may need semicolons instead of commas as argument separators.
1A. Function Parameters
Functions can have required parameters, such as the exchange and trading pair, and optional parameters for settings such as timestamp precision or filters. For example, the sixth parameter of the trade-watching function can enable millisecond timestamp precision.
2. How CryptoExcel Functions Update
2A. HTTP vs WebSocket Connections
HTTP requests retrieve data in individual requests, such as fetching an account balance. WebSocket connections stay open for continuous updates, such as live trades and order books. Exchanges enforce rate limits, so the connection method affects how frequently data can be retrieved.
2B. Update Timing in CryptoExcel
Throttle Time controls the minimum interval between HTTP queries. Update Time controls how frequently incoming WebSocket data is refreshed in Excel, even when messages arrive more often.
2C. WebSocket Functions in Excel
Streaming functions generally include watch in their names, such as st_watch_trades. You can configure the update interval so the worksheet refreshes periodically while the connection continues receiving data in the background.
2D. Real-Time Data (RTD) Integration
CryptoExcel uses Excel's Real-Time Data (RTD) engine to refresh live values. Excel's default RTD throttle interval is two seconds. You can adjust the interval, including fractional seconds such as 0.5; this setting persists after Excel is closed and reopened.
3. Finding CryptoExcel Functions in Excel
Use the Insert Function dialog (the fx button next to the formula bar, or Formulas → Insert Function) to explore functions in the Public, Private, Portfolio, Indicators, Analysis and Utility groups. Alternatively, type =st_ in a worksheet cell to see the available functions.
3A. CryptoExcel Function List
The available functions cover market data, account balances, portfolio analysis, indicators and utilities. The following names follow the function list shown in the existing documentation.
- OHLCV
- Convert
- Convert Trh
- Convert at Specific Time
- Convert History
- Ticker Spot
- Ticker Spot Trh
- Supported Spot Coins
- Coins Stat
- Coins Stat Trh
- Watch OHLCV
- Watch Trades
- Watch Trades Agg
- Watch Book
- Instantiate
- Balance
- Balance Trh
- Balance Converted
- Balance Converted Trh
- Balance History
- Balance History Trh
- Supported Exchanges
- Supported Functions
- OHLCV Tf
- OHLCV Watch Tf
- Watch Exceptions
- Watch Request
- Symbol Info
- Debug
- Alert
- PortVar
- Stat Port
- Stat Trades
- Graph Equity Line
- Rsi
- Sma
- Wma
- Ema
- Macd
- Percent Return
- Log Return
- DrowDown
- Cross Above
- Cross Below