Function Coins Stat TRH
Convert any coins to fiat currency at specific intervals using a chosen exchange’s latest prices. This function also returns the 7 days main statistic (with throttling)
1. Syntax
=st_coins_stat_trh ( from_coin, to_coin, [exchange], [trh_sec])
2. Parameters
| Parameter | Required | Description | Example |
| from_coin | Y | Coin you want to convert. Can be a range ( multiple coins) | “ATOM”,”BTC” |
| to_coin | Y | fiat currency | “USD” |
| Exchange* | N Default Binance | Exchange you want to use for the conversion | “Bitmex” |
| trh_sec | N Default 300. | Seconds interval between consecutive calls | 120 |
*you can choose any exchange amongst the supported one which has the from_coin and to_coin listed
from_coin
Required: Y
Description: Coin you want to convert. Can be a range ( multiple coins)
Example: “ATOM”, “BTC”
to_coin
Required: Y
Description: fiat currency
Example: “USD”
exchange
Required: N. def “Binance”
Description: Exchange you want to use for the conversion
Example: “bitmex”
You can choose any exchange amongst the supported one which has the from_coin and to_coin listed
trh_sec
Required: N. def 300.
Description: seconds interval between consecutive calls
Example: 120
3. Return Value
| Value | Description |
| Time | time of the conversion |
| Coin | Coin |
| 1H% | One hour percentage change |
| 24H% | 24 hours percentage change |
| 7D% | 7 days percentage change |
| 7D MAX | 7 days Max price |
| 7D MIN | 7 days Min Price |
| Last | Last price |
Time
time of the conversion
Coin
Coin
1H%
One hour percentage change
24H%
24 hours percentage change
7D%
7 days percentage change
7D MAX
7 days max price
7D MIN
7 days min price
Last
Last coin Price
4. Rate limits
This function send 1 request to the exchange even if you want to convert multiple coins at once
Tip. Use st_watch_requests() to monitor your requests.
5. Usage
The Coins Stat TRH function returns the Time, the conversion rate and the main statistic for one or multiple coins in the desired fiat. You can specify the Exchange that will be used for the conversion. Data are refreshed automatically at defined intervals. (trh_sec). Both from and to coins must be listed on the specified exchange This function does not require Authentication