How to Code Google Sheets to Track Cryptocurrencies' Prices by audreyling

View this thread on: hive.blog | peakd.com | ecency.com

beyondbitcoin · @audreyling · Dec 26 '17

$2.18

How to Code Google Sheets to Track Cryptocurrencies' Prices

### Why not learn a bit of coding while having fun with your cryptocurrency trading?
___

You see all the amazing apps that's around and you may have wondered...
- "how did they do that?" 
- "damn... I want to get those info out quickly and do some quick calculation.... 😟"

If you were like me thinking about these 2 big questions, GREAT!! 🎉
It's really not hard to diy!
___
All you need is 
- a Google sheet, 
- an open mind and 
- links to the exchanges' API documentations!!
___
I'll start off with [Gemini](https://gemini.com/) - you can buy cryptocurrencies with USD (I've tried it).

Gemini has rather similar API protocols as the exchanges below:

- [Bitfinex](https://www.bitfinex.com/) - you can trade with quite a number of coins here (I've tried it, though I heard they are in some kinda situation now, use with care.)
- [Coinbase](https://www.coinbase.com/) - similar to Gemini (I've never tried it).
- There maybe more, I just didn't have time to research.

These exchanges are here because they are rather popular. 🌟 
I've attached the links, feel free to click on them if you want to sign up!!

For my **next video**, I'll look into a popular exchange where you can trade alt coins - [Binance](https://www.binance.com/?ref=12762699). 
____

https://www.youtube.com/watch?v=XQjcLG5PYu8
###### _This is my first time making a video, very amateurish. Please don't mind my silly face..._
___

I considered this as a "basic". If you are able to do this, you are ready for more complex code logics. For example, we'll be able to connect to our exchange and grab our portfolio information.

You can also check out [coinapps.co](https://www.coinapps.co/) which is done by my friend. I was really impressed with it!! ❤️ For one, he's definitely much more organised than me. 😂

You can get the Google sheets add-on off him.
___
> 🌟 _**Feel free to make a request on what other exchanges you want!**_

### If you ❤️ what I'm doing, please:
✅ Upvote this post 👍
✅ Follow me on Steemit: https://steemit.com/@audreyling
✅ Comment and say HI!
✅ Subscribe to me on Youtube - [Audrey Ling](https://www.youtube.com/channel/UC3AnvpAQvsQ0UBUIH1pYLAQ?view_as=subscriber)
✅ Please **share** with anyone who might benefit from this!!

👍 khackett, awesomianist, olayar, tensaix2j, izlim96, khaiyong, audreyling, clairev, messiahhh667, cswong, dudizx, chrislo2004, gleb0031, crazyfishman, jinng, steemitboard, ryansatterlee, battlescard, realhumangirl, cryptocurrencytr, perwest

`author`	audreyling
`permlink`	how-to-code-google-sheets-to-track-cryptocurrencies-prices
`category`	beyondbitcoin
`json_metadata`	{"tags":["beyondbitcoin","programming","howto","investing","finance"],"image":["https://img.youtube.com/vi/XQjcLG5PYu8/0.jpg"],"links":["https://gemini.com/","https://www.bitfinex.com/","https://www.coinbase.com/","https://www.binance.com/?ref=12762699","https://www.youtube.com/watch?v=XQjcLG5PYu8","https://www.coinapps.co/","https://steemit.com/@audreyling","https://www.youtube.com/channel/UC3AnvpAQvsQ0UBUIH1pYLAQ?view_as=subscriber"],"app":"steemit/0.1","format":"markdown"}
`created`	2017-12-26 07:29:33
`last_update`	2017-12-26 07:29:33
`depth`	0
`children`	10
`last_payout`	2018-01-02 07:29:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	1.687 HBD
`curator_payout_value`	0.489 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	2,226
`author_reputation`	26,031,974,504
`root_title`	"How to Code Google Sheets to Track Cryptocurrencies' Prices"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	25,290,036
`net_rshares`	376,900,662,254
`author_curate_reward`	""

properties (23)vote details (21)

voter	rshares	pct
perwest	0	100%
tensaix2j	2,055,880,710	100%
steemitboard	263,088,302	1%
awesomianist	11,949,157,808	42%
jinng	619,520,000	100%
olayar	6,028,958,543	100%
cryptocurrencytr	0	100%
chrislo2004	943,647,433	1%
crazyfishman	658,781,846	100%
ryansatterlee	67,777,297	100%
khackett	345,453,390,877	40%
izlim96	1,160,550,622	100%
khaiyong	1,160,502,863	100%
audreyling	1,160,502,686	100%
clairev	1,160,501,837	100%
messiahhh667	1,160,499,738	100%
gleb0031	736,916,084	100%
cswong	1,160,494,442	100%
dudizx	1,160,491,166	100%
realhumangirl	0	100%
battlescard	0	100%

@audreyling · Jan 6 '18

$2.89

There are people who PMed me and asked me about coding. 
I learned to code at [NEXT Academy](https://www.nextacademy.com/?utm_source=audrey-steemit&utm_medium=blog&utm_campaign=learn-coding-gs-gemini) in June 2017. 

I am not a professional coder, I learned coding out of curiosity and I am doing this as a hobby on the side.

👍 thing-2, perwest

`author`	audreyling
`permlink`	re-audreyling-how-to-code-google-sheets-to-track-cryptocurrencies-prices-20180106t110013683z
`category`	beyondbitcoin
`json_metadata`	{"tags":["beyondbitcoin"],"links":["https://www.nextacademy.com/?utm_source=audrey-steemit&utm_medium=blog&utm_campaign=learn-coding-gs-gemini"],"app":"steemit/0.1"}
`created`	2018-01-06 11:00:15
`last_update`	2018-01-06 11:00:15
`depth`	1
`children`	1
`last_payout`	2018-01-13 11:00:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	2.165 HBD
`curator_payout_value`	0.720 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	325
`author_reputation`	26,031,974,504
`root_title`	"How to Code Google Sheets to Track Cryptocurrencies' Prices"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	27,498,384
`net_rshares`	296,902,739,335
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
perwest	0 B		0	100%
thing-2	0 B		296,902,739,335	100%

@battlescard · Aug 8 '18

Thanks a Million, for this. It's much more simple than other examples - but I'm still kinda clueless. Do you know where I can pay to have this done for me?

properties (22)

`author`	battlescard
`permlink`	re-audreyling-re-audreyling-how-to-code-google-sheets-to-track-cryptocurrencies-prices-20180808t213019088z
`category`	beyondbitcoin
`json_metadata`	{"tags":["beyondbitcoin"],"app":"steemit/0.1"}
`created`	2018-08-08 21:30:21
`last_update`	2018-08-08 21:30:21
`depth`	2
`children`	0
`last_payout`	2018-08-15 21:30:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	155
`author_reputation`	15,080,681
`root_title`	"How to Code Google Sheets to Track Cryptocurrencies' Prices"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	67,566,430
`net_rshares`	0

@khackett · Dec 26 '17

Great work! I didn't know this was possible. I'm gonna give it a try! 👍

👍 audreyling, perwest

`author`	khackett
`permlink`	re-audreyling-how-to-code-google-sheets-to-track-cryptocurrencies-prices-20171226t151804544z
`category`	beyondbitcoin
`json_metadata`	{"tags":["beyondbitcoin"],"app":"steemit/0.1"}
`created`	2017-12-26 15:18:03
`last_update`	2017-12-26 15:18:03
`depth`	1
`children`	1
`last_payout`	2018-01-02 15:18:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	71
`author_reputation`	5,706,172,279,793
`root_title`	"How to Code Google Sheets to Track Cryptocurrencies' Prices"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	25,352,581
`net_rshares`	1,160,502,686
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
perwest	0 B		0	100%
audreyling	0 B		1,160,502,686	100%

@audreyling · Dec 28 '17

thank you! have fun!

properties (22)

`author`	audreyling
`permlink`	re-khackett-re-audreyling-how-to-code-google-sheets-to-track-cryptocurrencies-prices-20171228t164904837z
`category`	beyondbitcoin
`json_metadata`	{"tags":["beyondbitcoin"],"app":"steemit/0.1"}
`created`	2017-12-28 16:49:03
`last_update`	2017-12-28 16:49:03
`depth`	2
`children`	0
`last_payout`	2018-01-04 16:49:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	20
`author_reputation`	26,031,974,504
`root_title`	"How to Code Google Sheets to Track Cryptocurrencies' Prices"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	25,720,512
`net_rshares`	0

@messiahhh667 · Dec 27 '17

I've just started using google sheets, after reading your article. Thank you, Audrey!

👍 audreyling

`author`	messiahhh667
`permlink`	re-audreyling-how-to-code-google-sheets-to-track-cryptocurrencies-prices-20171227t030130598z
`category`	beyondbitcoin
`json_metadata`	{"tags":["beyondbitcoin"],"app":"steemit/0.1"}
`created`	2017-12-27 03:01:33
`last_update`	2017-12-27 03:01:33
`depth`	1
`children`	1
`last_payout`	2018-01-03 03:01:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	85
`author_reputation`	36,849,143
`root_title`	"How to Code Google Sheets to Track Cryptocurrencies' Prices"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	25,440,423
`net_rshares`	1,119,885,092
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
audreyling	0 B		1,119,885,092	100%

@audreyling · Jan 6 '18

Thanks!

properties (22)

`author`	audreyling
`permlink`	re-messiahhh667-re-audreyling-how-to-code-google-sheets-to-track-cryptocurrencies-prices-20180106t105525567z
`category`	beyondbitcoin
`json_metadata`	{"tags":["beyondbitcoin"],"app":"steemit/0.1"}
`created`	2018-01-06 10:55:24
`last_update`	2018-01-06 10:55:24
`depth`	2
`children`	0
`last_payout`	2018-01-13 10:55:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	7
`author_reputation`	26,031,974,504
`root_title`	"How to Code Google Sheets to Track Cryptocurrencies' Prices"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	27,497,587
`net_rshares`	0

@steemitboard · Dec 27 '17

Congratulations @audreyling! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

[![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/voted.png)](http://steemitboard.com/@audreyling) Award for the number of upvotes received

Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click [here](https://steemit.com/@steemitboard)

If you no longer want to receive notifications, reply to this comment with the word `STOP`

> By upvoting this notification, you can help all Steemit users. Learn how [here](https://steemit.com/steemitboard/@steemitboard/http-i-cubeupload-com-7ciqeo-png)!

properties (22)

`author`	steemitboard
`permlink`	steemitboard-notify-audreyling-20171227t051229000z
`category`	beyondbitcoin
`json_metadata`	{"image":["https://steemitboard.com/img/notifications.png"]}
`created`	2017-12-27 05:12:30
`last_update`	2017-12-27 05:12:30
`depth`	1
`children`	0
`last_payout`	2018-01-03 05:12:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	699
`author_reputation`	38,975,615,169,260
`root_title`	"How to Code Google Sheets to Track Cryptocurrencies' Prices"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	25,453,941
`net_rshares`	0

@tensaix2j · Dec 27 '17

👍

👍 audreyling

`author`	tensaix2j
`permlink`	re-audreyling-how-to-code-google-sheets-to-track-cryptocurrencies-prices-20171227t130630208z
`category`	beyondbitcoin
`json_metadata`	{"tags":["beyondbitcoin"],"app":"steemit/0.1"}
`created`	2017-12-27 13:06:33
`last_update`	2017-12-27 13:06:33
`depth`	1
`children`	0
`last_payout`	2018-01-03 13:06:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1
`author_reputation`	5,077,426,415,725
`root_title`	"How to Code Google Sheets to Track Cryptocurrencies' Prices"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	25,509,653
`net_rshares`	614,860,000
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
audreyling	0 B		614,860,000	100%

@xzod · Dec 27 '17

Love it. Thanks Audrey!

👍 audreyling, xzod

`author`	xzod
`permlink`	re-audreyling-how-to-code-google-sheets-to-track-cryptocurrencies-prices-20171227t015934957z
`category`	beyondbitcoin
`json_metadata`	{"tags":["beyondbitcoin"],"app":"steemit/0.1"}
`created`	2017-12-27 01:59:33
`last_update`	2017-12-27 01:59:33
`depth`	1
`children`	1
`last_payout`	2018-01-03 01:59:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	23
`author_reputation`	45,517,539
`root_title`	"How to Code Google Sheets to Track Cryptocurrencies' Prices"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	25,433,840
`net_rshares`	1,137,292,632
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
xzod	0 B		0	100%
audreyling	0 B		1,137,292,632	100%

@audreyling · Jan 6 '18

thanks!

properties (22)