Import Cryptocurrency Live Data In Google Sheets (Template Free Download)
Автор: Jie Jenn
Загружено: 2022-01-19
Просмотров: 16922
Описание:
Important: Giving this method is outdated I have came with a more robust, stable, and flexible solution: • Import Live Cryptocurrency Price (And More...
From one of my previous video "Import Cryptocurrency Price In Real Time In Google Sheets ( • Import Cryptocurrency Price In Real Time I... )", I shared how we can use IMPORTXML function to import cryptocurrency price in real life. However, after some feedback, I noticed there were a couple of limitations need to be added. In this follow up web scraping crypto data in Google Sheets tutorial, we will 1) build a more complete crypto scraper template for re-usability, 2) create a macro to update crypto data, and 3) insert a time trigger to automatically update crypto information.
PS: Looks like the API is broken, please see updated video here: • Import Live Cryptocurrency Price (And More...
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: https://www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: https://bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: / jiejenn
🛒 By shopping on Amazon → https://amzn.to/2JkGeMD
📘 Facebook Page → / madeinpython
📘 More tutorial videos on my website → https://LearnDataAnalysis.org
✉️ Business Inquiring: [email protected]
⏰ Timestamp:
00:00 - Intro & Agenda
01:10 - Crypto Scraper Template Demo
04:45 - Dive Into The Tutorial
14:40 - App Script Code To Update Crypto Data
21:00 - Add Time Trigger To Auto Refresh Crypto Data
#Sheets #GoogleSheets #Cryptocurrency #Crypto #webscraping
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: