CryptoExcel

Crypto Excel » Docs_functions Fetch Convert

Function Convert

Convert any coins to a fiat currency using a specific exchange last prices. 

convert coins to fiat
Function Convert

1. Syntax

=ST_convert ( from_coin, to_coin, [exchange])

2. Parameters

 

ParameterRequiredDescriptionExample
from_coinYCoin you want to convert. Can be a range ( multiple coins)“ATOM”,”BTC”
to_coinYfiat currency“USD”
Exchange*N Default BinanceExchange 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

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

3. Return Value

ValueDescription
Timetime of the conversion
RateConversion rate

Time

time of the conversion

Rate

conversion rate

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 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

6. Convert related functions