Google Sheet Open Source CryptoTools Set-Up

Objective: Show users how they can easily access the custom built-in CryptoTools formulas in Google Sheet:

• CRYPTOBALANCE()
• CRYPTOLENDING()
• CRYPTOSTAKING()
• CRYPTOFARMING()
• CRYPTOREWARDS()

ACCESS LIVE SAMPLE SHEET to have a better idea of how they can be used.

You will need:

• a Google Account for Google Sheets
• to Copy Paste Version 2 (V2) code from Github
• 5 minutes of your time

How to :

1. Open a Google sheet where you wish to use CRYPTOTOOL’s functions

Google Blank Sheet

2. Go to Tools › Script editor

Google Script Editor

3. From the Github, copy the content of CRYPTOTOOLS and paste it in the script editor (replace any existing content)

Copy Paste Code from https://raw.githubusercontent.com/Eloise1988/CRYPTOBALANCE/master/CRYPTOTOOLS_V2.gs

4. Save the script with File › Save, name it CRYPTOTOOLS, then close the script editor

Paste & Save Code as CRYPTOTOOLS in Google Script

5. Back to your Google sheet, refresh the page, a CRYPTOTOOLS menu will appear with parameters, an example and contact info.

Go back to Google Sheet and check that the CRYPTOTOOLS tab exist with info

How to get CoinGecko formulas:

Follow exactly the 5 same steps as above to access:

• GECKOPRICE()
• GECKOVOLUME()
• GECKOCAP()
• GECKOPRICEBYNAME()

Copy the code from this Github link and save it as a new Project

Copy Paste Code from https://raw.githubusercontent.com/Eloise1988/COINGECKO/master/CoinGeckoV2.gs

Don’t forget to Authorize Google Services

Apps Script requires user authorization to access private data from built-in Google services or advanced Google services.

Top left: Authorization required Continue — — — Top Right: Chose the gmail account for running the code — — — Bottom Left: App isn’t verigied, go to advanced, go to the project name — — — Bottom Right: Allow access to your newly created project

Now ALL functions are available for use! Try it out!

ACCESS LIVE SAMPLE SHEET

This is ongoing work. If you find errors, please do not hesitate to let me know. Feedback is very welcomed. A telegram chat is also available for support.

If this project adds any value to you or your company, do not hesitate to drop comments.

Thank you.

Annex: remarks Google sheet’s formula syntax :

In some countries like Italy and Russia, Google sheet’s formula syntax is done with semicolon ‘ ; ’ instead of the comma ‘ , ’
If you get an error message from the formula, it might be the reason. In this case, the formula then becomes :

=GECKOPRICE(“BTC”;”USD”)