Full listing

This function call will return the list of all markets along with all their data point. It is recommend to use this to avoid the Google Sheets imposed API call quota.

=CRYPTOFINANCE("IDEX")

Specific market data

In a nutshell, call =CRYPTOFINANCE("IDEX:AURA/ETH") to get the current Aura price in Ether.

All information are returned from the IDEX ticker public API, 6 ticker information can be retrieved: last, high, low, change, volume, quote_volume.

Examples:

  • =CRYPTOFINANCE("IDEX:AURA/ETH") will return Aura price in Ether. Same thing as calling =CRYPTOFINANCE("IDEX:AURA/ETH", "price") or =CRYPTOFINANCE("IDEX:AURA/ETH", "last").
  • =CRYPTOFINANCE("IDEX:AURA/ETH", "change") will return Aura price change percentage over the last 24 hours.
  • =CRYPTOFINANCE("IDEX:AURA/ETH", "high") will return Aura highest price in Ether over the last 24 hours.
  • =CRYPTOFINANCE("IDEX:AURA/ETH", "low") will return Aura lowest price in Ether over the last 24 hours.
  • =CRYPTOFINANCE("IDEX:AURA/ETH", "volume") will return Aura volume in Ether over the last 24 hours.
  • =CRYPTOFINANCE("IDEX:AURA/ETH", "base_volume") will return Aura volume in Aura over the last 24 hours.