YYYY-MM-DD
, example: 2017-01-13
.A1
contains BTC
, and A2
contains 2016–10–22
.A2
as plain text. To do this select cell A2
, then go to:Format
> Number
> Plain text
.A3
enter this formula:&
to concatenate (glue together) cells and text to forge the function’s argument.TODAY()
FunctionTODAY()-10
:=CRYPTOFINANCE("BTC/USD", "open", "2018-12-25")
=CRYPTOFINANCE("BTC/USD", "high", "2018-12-25")
=CRYPTOFINANCE("BTC/USD", "low", "2018-12-25")
=CRYPTOFINANCE("BTC/USD", "close", "2018-12-25")
price
will return the close
price.
The above logic works for NFT data as well. Note that with NFT data, you can also pull data without specifying a date. For example:=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "open")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "high")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "low")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "close")
BTC/USD
open price for November 2nd 2015:TODAY()
function: