Function Watch OHLCV
Watch OHLCV Streams live Open, High, Low, Close, Volume (OHLCV/candels) from a selected exchange and trading pair into Excel in real time.
1. Syntax
=ST_WATCH_OHLCV( exchange, symbol, TF, [sec], [reverse], [Max_rov],)
2. Parameters
| Parameter | Required | Description | Example |
| Exchange | Y | Exchange name (e.g., binance, coinbase, kraken, my_exc) | “binance” |
| Symbol | Y | Trading pair | “BTC/USDT” |
| TF* | Y | Time frame | 1m, 1d |
| Sec | N. Default 2 | Update time in seconds | 2.5 |
| Reverse | N. Default 0 | Time Order | 0 or 1 |
| Max Row | N Default 50 | Max Number of rows/trades | 10 |
*For a list of Supported OHLCV TF = St_watch_ohlcv_tf().
1m, 3m, 5m, 15m, 1h, 2h, 4h, 6h, 12h, 1d, 3d, 1w, 1M
Exchange
Required: Y
Description: Exchange name (e.g., binance, coinbase, kraken)
Example: “binance”
Symbol
Required: Y
Description: Trading pair
Example: “BTC/USDT”
TF
Required: Y
Description: Time Frame
Example: 1m, 1d
For a list of supported OHLCV TF = St_watch_ohlcv_tf().
1m, 3m, 5m, 15m, 1h, 2h, 4h, 6h, 12h, 1d, 3d, 1w, 1M
Sec
Required: N default 0
Description: Update time in seconds
Example: 2.5
Reverse
Required: N default 0
Description: Time order
Example: 0 or 1
Max Row
Required: N default 50
Description: Max number of rows/trades
Example: 10
3. Return Value
| Value | Description |
| Time | Local time TF started |
| Open | Open TF price |
| High | Highest TF price |
| Low | Lowest TF price |
| Close | Close TF price |
| Vol | Volume |
Time
Local time TF started
Open
Open TF Price
High
Highest TF price
Low
Lowest TF price
Close
Close TF price
Vol
Volume
4. Rate limits
This function uses a WebSocket connection and does not consume your rate limit
Tip. Use st_watch_requests() to monitor your requests.
5. Usage
The Watch OHLCV function aggregates essential market data into pivotal points (Open. high, Low, Close, Volume ) which are used for charting and backtesting. OHLCV, combined with Volume, informs traders not just where prices are moving, but how strongly they’re moving.