What's new
Fantasy Football - Footballguys Forums

Welcome to Our Forums. Once you've registered and logged in, you're primed to talk football, among other topics, with the sharpest and most experienced fantasy players on the internet.

Cavalier Crypto 101 (1 Viewer)

JerseyToughGuys said:
Anyone care to update this? Once BTC breaks 6200, we are off to the races again. Might take a heck of a long time to recoup the losses, but what more do we have to lose? 

😂
don't know why it doesn't update.  Appears the format changed.  Have no time to figure it out.

 
don't know why it doesn't update.  Appears the format changed.  Have no time to figure it out.
Error: You reached your request quota of 50 requests/day for CoinMarketCap data. Your quota resets itself every day at midnight GMT time. For unlimited CoinMarketCap data see here: https://cryptofinance.ai/data-availability-service/ (line 238).
Looks like you can only have it update about once per day with the number of coins on the sheet.  You could pay $10 per month for unlimited queries, but that might run through our holdings pretty quickly.

 
I was able to get new links for pricing on btc, xrp.  The rest didnt work and cant figure out why. 
Try changing the 2 in this formula to 1 or 0.  I believe that is what the error message is referring to.   :shrug:

=VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTDATA("https://api.gdax.com/products/nano-USD/ticker"),0,2), "price:",""), """", ""))


Nevermind.   Doesn't look like that works either.  :shrug:  

 
Last edited by a moderator:
Looks like you can use coinmarketcap

=INDEX(IMPORTHTML("https://coinmarketcap.com/currencies/basic-attention-token/","table",0),2,5)

=INDEX(IMPORTHTML("https://coinmarketcap.com/currencies/nano/","table",0),2,5)


You already have the URLs you need to insert.  :)

 
Last edited by a moderator:

Users who are viewing this thread

Top