#Custom cryptocurrency ticker how to

Here is a step by step guide on how to do it. If you have some experience in JavaScript, this shouldn’t prove hard by any stretch of the imagination. To get the most out of your custom cryptocurrency portfolio tracker, you need to write it yourself. How to create a cryptocurrency spreadsheet for coders and power users To customize these templates and custom functions even further, you’ll have to know a bit about programming. That’s it, if you’re done with the steps above, you’re already tracking crypto! Your next step is to learn the ropes and experiment with different templates. When you do that, you can use custom functions =CRYPTOFINANCE to create your own custom spreadsheet for tracking crypto.

#Custom cryptocurrency ticker code

The source code is available on the add-on’s website. If you want a simpler option, Cryptofinance is way easier to set up, albeit it doesn’t provide as much data.Īll you have to do is to create a new Google Sheet, go to Tools > Script Editor, and paste the source code there. That is a bit complicated to set up, but you do have the ability to customize the data you receive. It will also import JSON to Google Sheets, and perform all the necessary calculations.

#Custom cryptocurrency ticker update

Put the refreshment rate in the dedicated cell as written in the instructions, and the custom query will update and pull the data you need to your new spreadsheet for cryptocurrency. Once you type that in, the spreadsheet is ready to go. You can find those names on the Cryptosheets website by going to Workspace > API > Endpoint and looking for the ones you need. You’ll have to write the names of the API endpoints you’re going to access in dedicated cells of the sheet labeled “Query Builder.” Once that is done, go to the sheet labeled “Help” and follow instructions to set it up. Hover over that template and add it to the current document - you’ll see new sheets appear in the panel below. To get that template, add Cryptosheets to your add-ons panel, log in, and go to Add-ons > Cryptosheets > Templates. You can easily update it further down the road as you learn the ropes. You can import one and use it right away without having to set up a custom spreadsheet.įor a complete beginner, it’s better to go with the Crypto Portfolio Fundamentals. Here’s why Cryptosheets is such a good choice for beginners: it has almost a hundred templates.

#Custom cryptocurrency ticker free

That said, if you don’t want to get into another SaaS subscription, you can do away with the free plan, or use CRYPTOFINANCE to pull the cryptocurrency data in a Google spreadsheet. Even though you’d have to pay $250 per month for more advanced features, it’s certainly cheaper than hiring a programmer to write all of that for you. The free plan will get you quite a long way with 1000 monthly requests and all the important functions available. Get an accountĬryptosheets is an add-on, but one that operates on a SaaS model, so you will need to get an account to access its features. We’ll use the example of Cryptosheets as it’s probably the best spreadsheet for tracking cryptocurrency portfolios. Now, let’s look at how you can create a custom crypto tracker step by step.

#Custom cryptocurrency ticker download

Credit: Cryptosheets / GoogleĪll you have to do is download the add-on, register an account, and connect an API or two. With Cryptosheets, you can start much faster by getting a template. However, you’d have to fill in every cell with a variation of the custom formula, =CRYPTOFINANCE. If you were to create your own cryptocurrency tracker with CRYPTOFINANCE, it would look something like this.

CRYPTOFINANCE - another all-in-one add-on, but with fewer APIs available.

Cryptosheets - an all-in-one solution with hundreds of APIs.

There are several add-ons that allow beginners in the world of cryptocurrency to create custom trackers like this. There is still a way for you to create your own custom cryptocurrency tracker - via Google Sheets add-ons. If you don’t have coding skills, don’t worry. How to build cryptocurrency tracker for non-coders There are several options for both non-coders and people with some coding experience, all of them fully customizable. You can build your own crypto portfolio spreadsheet tracker in Google Sheets! It’s not nearly as hard as it may sound at first. But what do you do if you trade across multiple platforms and hold dozens of altcoins? The easiest solution is to check the latest rates on your platform of choice. Keeping your hand on the pulse of the market may be a bit of a chore, though. With Bitcoin reaching an all-time high and altcoins showing signs of good performance in the coming year, now is the perfect time to get into crypto trading or double down on market signals if you already hold altcoins.