- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Official CryptoTalk Thread
Posted on 6/5/17 at 9:26 pm to MSTiger33
Posted on 6/5/17 at 9:26 pm to MSTiger33
This is the formula for GNT price that MrSmith gave me:
=VALUE(ImportJSON("https:// min-api.cryptocompare.com/data/price?fsym=GNT&tsyms=USD","/USD","noHeaders",$C$2))
Remove the space after https:// when you paste it. It was posting as a link so I had to add the space.
Nvmd....I see y'all are going a different direction.
=VALUE(ImportJSON("https:// min-api.cryptocompare.com/data/price?fsym=GNT&tsyms=USD","/USD","noHeaders",$C$2))
Remove the space after https:// when you paste it. It was posting as a link so I had to add the space.
Nvmd....I see y'all are going a different direction.
This post was edited on 6/5/17 at 9:32 pm
3
Posted on 6/5/17 at 9:34 pm to dkreller
Thanks! Works now. 
Posted on 6/5/17 at 9:35 pm to dkreller
You're on the right path though. I'm not doing much more than that. I just added a conversion.
MSTiger, the template is definitely updated. Did you "save as"? You'll have to grab the template again. It won't update your copy.
MSTiger, the template is definitely updated. Did you "save as"? You'll have to grab the template again. It won't update your copy.
Posted on 6/5/17 at 9:41 pm to dkreller
Looks like bitcoin peaked and is correcting big time right now.
ETA: Nevermind
this volatility is insane.
ETA: Nevermind
this volatility is insane.This post was edited on 6/5/17 at 9:50 pm
Page 1 of 1
Back to top
Follow TigerDroppings for LSU Football News