CRYPTOCOMPARE.PRICE

Premium

Get the price of each specified cryptocurrencies converted into other listed currencies.

Syntax

=CRYPTOCOMPARE.PRICE(FSymbols, TSymbols, [ParametersJSON], [ResponseTarget])

Arguments

Name	Type	Description
FSymbols	String	A comma separated list of cryptocurrency symbols. Maximum number of symbols is 300.
TSymbols	String	A comma separated list of currency symbols to convert price into. Maximum number of symbols is 100.
ParametersJSON (optional)	JSON	JSON which defines additional parameters as key value pairs. See CryptoCompare API for supported parameters and their values.
ResponseTarget (optional)	Target	Specify inbox, outbox, cell or cell-range to write any response to

Return

Type	Description
JSON	Response if successful.

Examples

	A	B
1	e	BTCE

Formula	Result	Comment
=CRYPTOCOMPARE.PRICE("BTC","USD,JPY,EUR")	JSON	Retrieves current Bitcoin price in Dollar, Yen and Euro
=CRYPTOCOMPARE.PRICE("BTC","USD,JPY,EUR", JSON(A1:B1))	JSON	Same as before but uses a different exchange server specified via additional JSON parameter