- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Coaching Changes
- 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 5/27/17 at 10:12 pm to iAmBatman
Posted on 5/27/17 at 10:12 pm to iAmBatman
quote:
Hope they don't wait over the long weekend to approve.
I agree. I was hoping to be locked and loaded by Monday/Tuesday am, with funds transferred, etc. I think I read on here also that they limit your daily deposit to $500? I'll have to go back and read the fine print.
Posted on 5/27/17 at 10:12 pm to iAmBatman
I sent my verification to Gemini on a Monday morning and it was verified when i woke up that Wednesday. Just for some reference
Posted on 5/27/17 at 10:14 pm to dkreller
I don't want to get into any other cryptos so Gemini is good for me. Just want to be able to bounce in and out of ETH or BTC without the crazy fees that CB charges.
Posted on 5/27/17 at 10:14 pm to MrSmith
quote:
I sent my verification to Gemini on a Monday morning and it was verified when i woke up that Wednesday. Just for some reference
I'm thinking we are hitting a snag due to either the holiday weekend or the (presumed) recent influx of accounts.
Can you comment on the $500 daily deposit limit?
Posted on 5/27/17 at 10:14 pm to MrSmith
I imagine there are no limitations if you transfer your wallet to Gemini huh?
Posted on 5/27/17 at 10:14 pm to iAmBatman
quote:
Just want to be able to bounce in and out of ETH or BTC without the crazy fees that CB charges.
Same here.
Posted on 5/27/17 at 10:15 pm to TigeRoots
That's correct. 500/day. You can buy your larger orders elsewhere and transfer the ether to your Gemini wallet. That's what I ended up doing from coinbase.
Posted on 5/27/17 at 10:25 pm to dkreller
For BTC, just change the formula to:
=VALUE(ImportJSON("https ://min-api.cryptocompare.com/data/price?fsym=BTC&tsyms=USD&e=Coinbase","/USD","noHeaders",$C$2))
GNT:
=VALUE(ImportJSON("https ://min-api.cryptocompare.com/data/price?fsym=GNT&tsyms=USD","/USD","noHeaders",$C$2))
SIA:
=VALUE(ImportJSON("https ://min-api.cryptocompare.com/data/price?fsym=SC&tsyms=USD","/USD","noHeaders",$C$2))
ETA: it's autoformatting as links
remove the space after each https
=VALUE(ImportJSON("https ://min-api.cryptocompare.com/data/price?fsym=BTC&tsyms=USD&e=Coinbase","/USD","noHeaders",$C$2))
GNT:
=VALUE(ImportJSON("https ://min-api.cryptocompare.com/data/price?fsym=GNT&tsyms=USD","/USD","noHeaders",$C$2))
SIA:
=VALUE(ImportJSON("https ://min-api.cryptocompare.com/data/price?fsym=SC&tsyms=USD","/USD","noHeaders",$C$2))
ETA: it's autoformatting as links
This post was edited on 5/27/17 at 10:30 pm
Posted on 5/27/17 at 10:34 pm to MrSmith
Do you need some type of plugin to run those within Excel? I keep getting an error when trying to run any even with removing the space.
Posted on 5/27/17 at 10:45 pm to okietiger
Are you using it in the Google sheet I made? I loaded the JavaScript into that sheet. It won't work without it.
Posted on 5/27/17 at 10:47 pm to MrSmith
yeah I tried saving your sheet as an Excel spreadsheet and all the formulas showed errors. 
Posted on 5/27/17 at 10:49 pm to MrSmith
No, I was trying to input into my own Excel sheet I use, oops.
Link?
Edit: found it thanks
Link?
Edit: found it thanks
This post was edited on 5/27/17 at 10:50 pm
Posted on 5/27/17 at 10:51 pm to dkreller
Haha sorry. It requires some javascript that I preloaded into the sheet in order to make the api call.
Here is the link to the sheet again
Here is the link to the sheet again
Posted on 5/27/17 at 10:55 pm to MrSmith
Looks like we're still trending upwards


Posted on 5/27/17 at 10:57 pm to MrSmith
quote:
MrSmith
You're the man
I'm working on getting my Excel skills up to expert level. I've learned a lot on my own but I want to learn more about the complex functions and macros.
I use Excel a lot for work.
Posted on 5/27/17 at 11:00 pm to MrSmith
Awesome man. Been trying to figure how to do this on Excel Spreadsheet I have (with a little more detail).
I'll just update that one manually and use yours for more day to day stuff.
Thanks again!
I'll just update that one manually and use yours for more day to day stuff.
Thanks again!
Posted on 5/27/17 at 11:01 pm to dkreller
Haha thanks. By the way I'm not an expert excel user at all. I use it maybe once a year. I'm just a programmer so It's easy to port over that knowledge to figure out simple excel scripts.
Posted on 5/27/17 at 11:05 pm to MrSmith
Yeah I just stumbled upon some API documentation on Polo and my mind is officially blown. 
Popular
Back to top


1





