Hey Julien,
Thanks for responding. I am trying to populate a spreadsheet that is pulling all the possible data fields from coinmarketcap.com and from the exchanges, I guess you only support kraken.com for now.
Rather than retype the currency pairs into 30 cells every time I add a coin I wanted to have a cell that I type the coin and currency pair (BTCUSD) into and then reference that cell in your function.
Using your example…
C4 = BTCUSD
=CRYPTOFINANCE(C4)
This would allow me to copy all the cell functions from one row to another row avoiding the need to type out BTCUSD, ETHUSD, DASHUSD, etc. repeatedly in each row of cells.
But when I do that I get an error, it says it doesn’t understand “c4”. I tried it with just (BTC) in the cell and that didn’t work either.
I did locate a find a replace function that avoids having to type it all out but being able to reference a cell with the specific currency pairs would be better than having to do the find replace every time.
Thanks again! Great tool!!
