How to keep track of your coins using coinigy on google sheets


Source

I personally use Google Sheets to keep track of everything. I use both coinigy and crypto finance to keep track of all my coins. Coinigy is a platform that lets you buy and sell your alt coins with ease. And it also has a built in API that connects to google sheets. And with that, I can keep track of every market that is connected to coinigy. It's a unique function that allows you to specifally see the amount of coins you have in each market.  And it is safe! You don't haft to give google any special permissions to add your API. All you haft to do is download the spreadsheet from coinigy to get started. 

Here are the functions I use typically in my google sheets (after connecting to coinigy)

Getting balances of a particular market (Must have coinigy connected!):

=CoinigyGetBalance(11111, "XRP", false, A1)

Getting the market price of a particular coin on a certain market:

=CRYPTOFINANCE("BITTREX:XRP/BTC", "", $A$1)

Getting the price of bitcoin:

=GOOGLEFINANCE("BTCUSD")

After this the math and organization is relatively simple. If you have any questions feel free to leave a comment below!

@johngentryjr

H2
H3
H4
3 columns
2 columns
1 column
Join the conversation now