Crypto Price Fetcher

Introduction

This Google Apps Script will fetch the last selling price of crypto currencies from Cex.io public API.

Usage

1. In the Spread Sheet go to Tools -> Script Editor
2. Copy the content of the CryptoPriceFetcher.gs and paste in in the new file created in the Script Editor
3. Run the main function in the editor

Add appropriate values for the sheet index & cell in the main function.

By utilizing the Trigger mechanism in the G Suit Developer Hub we can set automatic refresh triggers for the prices.