How to Code Google Sheets to Track Cryptocurrencies' Prices

audreyling (37)in #beyondbitcoin • 6 years ago

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 - you can buy cryptocurrencies with USD (I've tried it).

Gemini has rather similar API protocols as the exchanges below:

Bitfinex - 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 - 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.

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 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
✅ Please share with anyone who might benefit from this!!

#programming #howto #investing #finance

6 years ago in #beyondbitcoin by audreyling (37)

Sort:

audreyling (37) 6 years ago

There are people who PMed me and asked me about coding.
I learned to code at NEXT Academy 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.

$2.88

2 votes

[-]

battlescard (25) 6 years ago

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?

$0.00

[-]