Crypto Excel » Docs_functions Fetch Convert
Convert any coins to a fiat currency using a specific exchange last prices.
=ST_convert ( from_coin, to_coin, [exchange])
| 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” |
*you can choose any exchange amongst the supported one which has the from_coin and to_coin listed
Required: Y
Description: Coin you want to convert. Can be a range ( multiple coins)
Example: “ATOM”, “BTC”
Required: Y
Description: fiat currency
Example: “USD”
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
| Value | Description |
| Time | time of the conversion |
| Rate | Conversion rate |
time of the conversion
conversion rate
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.
The Convert function returns the Time and the conversion rate for one or multiple coin to the desired fiat. You can specify the Exchange that will be used for the conversion. Both from and to coins must be listed on the specified exchange This function does not require Authentication