Coinmarketcap.com API on Google Sheets with dashboard

By Adel Chemi
Coinmarketcap.com is one from the best and Cryptocurrency Market Capitalizations website, it gives how much the global currencies and cryptocurrencies (Bitcoins, ethereum,..) worth in hard currency, this free template help you to control and track changing that values with clear dashboard included with wallets and convert to any other hard currency 




 How to use it :

 I made custom functions to use it in any other sheet

Cryptocurrencies :
=getCC("Symbol",'CC Data'!$B$1)
 E.g : =getCC("EUR",'CC Data'!$B$1)
Symbols: AUD,BRL,CAD,CHF,CLP,CNY,CZK,DKK,EUR,GBP,HKD,HUF,IDR,ILS,INR,JPY,KRW,MXN,MYR,NOK,NZD,PHP,PKR,PLN,RUB,SEK,SGD,THB,TRY,TWD,ZAR

Global Currencies:
=getGC("Symbol",'CC Data'!$B$1)
 E.g : =getGC("AUD",'CC Data'!$B$1)
Symbols: AUD,BRL,CAD,CHF,CLP,CNY,CZK,DKK,EUR,GBP,HKD,HUF,IDR,ILS,INR,JPY,KRW,MXN,MYR,NOK,NZD,PHP,PKR,PLN,RUB,SEK,SGD,THB,TRY,TWD,ZAR
  • Videos :
A soon !
  • Pictures :
Convert CC sheet for Crypto Currencies on this spreadsheet you can change the the currency to convert the worth in any hard currency you want and also refresh button to get new data updated from the site 

Notice: don't remove formula on A1 or enter data on range A1:G

Dashboard idea from that guy , On Youtube: @jacksonz11
if you want to use his template for excel : https://youtu.be/2aOsUw8xPNk

Dashboard is the most important part in that template it helps you to calculate the values of your wallet balance with any other cryptocurrency all you need to do is selecting the cryptocurrency from row 1 and the balance on your wallets on the range A7:15 here it's converted to EUR and USD is default just change the currency on the cell A3 to convert it for other hard currency

Notice: all you allowed to change is cell A3 and Balances values table

here will populate the values of by mulplicating  for each (wallet balance*worth) in USD on default and converted currency e.g here converted EUR 


table for calculating the percentage of each cryptocurrencies in any currency because it all same and pie chart to make the data looks more cool



  • The Spreadsheet
Location: Venice, Los Angeles, CA, USA

Comments

Post a Comment

Popular posts from this blog

Email a Custom Sheets as PDF in Attachment

By Adel Chemi
Image
Script export and send email of custom sheet on PDF in Attachment for Google Sheets with GAS (Google Apps Script) & Javascript Language, don't forget to change the variables according to your goal, read tips and watch video to understand more about how to run it even you are not a programmer
Read more

Export and Email Specific Range in Google Sheets in CSV,PDF or XLSX

By Adel Chemi
Image
Script for Exporting a specific Range from spreadsheet and save it in drive or email it in attachment in CSV, PDF or XLSX . If you want to export just specific sheets in the spreadsheet just check this  Tutorial  . How to use it : In Spreadsheet Menu Click Tools and select Script Editor from spinner to go put your script, in Excel "Visual Basic" on developer mode. 1- Open Google Apps Script file or create new one : File > New > Script File and name it with whatever you want . 2- Past the script in the bottom of Article and Save the Script . What necessary to change : Line 5 : Range you want to export it. Line 6: Sheet who has that range . LINE 59 : Email Receiver, if you want to email a multiple emails just make comma between each email address e.g : 'pace3man@gmail.com ,spider-max@live.fr,......'  . LINE 60 : replace Title word with whatever. LINE 61 : The body of Email. LINE 64 : The Attachment file name.
Read more

Google Sheets vs MS Excel - What to choose in 2020 ?

By Adel Chemi
Image
Google Sheets and MS Excel are the most popular for data  visualization and analysis tools in the market. So if you are asking which one fits better for task here's some points : - Performance and big data  : MS Excel wins this easily because its use your desktop and it has better performance then limited Google sheets cloud : Using formulas for big rows in Google sheets make your browser to consume too much ram and will crash. MS Excel VBA forms and scripts are much faster because its run your script immediately without checking authentication and quotas each time you run script MS Excel better in BIG data importing, If you have some big data and you import it to G Sheets it may cause your chrome crashing Google sheets is limited : 400,000  cells maximum of 256  columns  per  sheet .  Uploaded  spreadsheet  files that are converted to  Google spreadsheets  format can't be larger than 20MB, and need to be under 400,000  cells  and 256  columns  per  sheet .
Read more