Uploaded March 2024 | Updated November 2026, 1 day ago
So my old method to import live cryptocurrency data doesn't work anymore, so I decided to come up with a more stable solution, which is to create a custom function called getCoinInfo() to fetch live crypto data. By using a custom function, we have the flexibility to pick and choose what information we want to display. And by using an actual API instead of web scraping, we no longer need to worry about if the source page's HTML code is updated. This tutorial is ideal for anyone who is looking for a free solution to import live cryptocurrency data.
In this tutorial I will cover two things:
1) Create getCoinInfo function.
2) How to schedule data refresh.
π Source Code: wp.me/payCAw-1mQ
π» Live Coin Watch website: livecoinwatch.com/tools/api
π Show Support
β Paypal: paypal.me/jiejenn/5
β Venmo: @Jie-Jenn
π³ Patreon: patreon.com/JieJenn (early access to tutorial source code)
βοΈ Business Inquiring: YouTube@LearnDataAnalysis.org
0:00:00 - Introduction to the tutorial on retrieving live crypto data.
0:00:09 - Announcement of a new robust solution for crypto pricing information.
0:00:20 - Quick demo of the proposed solution.
0:00:26 - Introduction of the GetCoinInfo function.
0:00:38 - Requirement to register for LiveCoinWatch for API access.
0:01:15 - Detailed explanation of using the coins/single endpoint.
0:02:08 - Overview of the GetCoinInfo function parameters.
0:03:28 - Google Sheets setup for implementing the function.
0:04:18 - Scripting in Google Sheets to enhance functionality.
0:09:38 - How to refresh formulas using Apps Script triggers.
0:12:25 - Confirmation and testing of the trigger functionality.
#googlesheets #cryptodata #crypto #cryptocurrency #googleappscript
So my old method to import live cryptocurrency data doesn't work anymore, so I decided to come up with a more stable solution, which is to create a custom function called getCoinInfo() to fetch live crypto data. By using a custom function, we have the flexibility to pick and choose what information we want to display. And by using an actual API instead of web scraping, we no longer need to worry about if the source page's HTML code is updated. This tutorial is ideal for anyone who is looking for a free solution to import live cryptocurrency data.
In this tutorial I will cover two things:
1) Create getCoinInfo function.
2) How to schedule data refresh.
π Source Code: wp.me/payCAw-1mQ
π» Live Coin Watch website: livecoinwatch.com/tools/api
π Show Support
β Paypal: paypal.me/jiejenn/5
β Venmo: @Jie-Jenn
π³ Patreon: patreon.com/JieJenn (early access to tutorial source code)
βοΈ Business Inquiring: YouTube@LearnDataAnalysis.org
0:00:00 - Introduction to the tutorial on retrieving live crypto data.
0:00:09 - Announcement of a new robust solution for crypto pricing information.
0:00:20 - Quick demo of the proposed solution.
0:00:26 - Introduction of the GetCoinInfo function.
0:00:38 - Requirement to register for LiveCoinWatch for API access.
0:01:15 - Detailed explanation of using the coins/single endpoint.
0:02:08 - Overview of the GetCoinInfo function parameters.
0:03:28 - Google Sheets setup for implementing the function.
0:04:18 - Scripting in Google Sheets to enhance functionality.
0:09:38 - How to refresh formulas using Apps Script triggers.
0:12:25 - Confirmation and testing of the trigger functionality.
#googlesheets #cryptodata #crypto #cryptocurrency #googleappscript










