How to Web Scrape Data in Google Sheets! (Import HTML)
35.8 هزار بار بازدید -
3 سال پیش
-
Access Tickerdata and my Spreadsheets:
Access Tickerdata and my Spreadsheets: https://tickerdata.com/
In this video, I take you step by step on how to web scrape data in google sheets. I focus on following three main web scraping strategies in this video:
1. Scraping full data sets
2. Scraping individual metrics from data sets
3. Automating the web scraping process in google sheets
The HTML code I use to inspect tables is the following:
var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); });
If you are trying to inspect a list instead of a table, use the following HTML code:
var i = 1; [].forEach.call(document.querySelectorAll('ul,ol'), function(x) { console.log(i++, x); });
The google sheets codes used in this video are below:
=IMPORTHTML("https://en.wikipedia.org/wiki/List_of...","Table","2")
=IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL","Table","7")
=(index(IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL","Table","7"),7,2))
=(index(IMPORTHTML("https://finviz.com/quote.ashx?t="&A3,"Table","7"),7,2))
I hope this tutorial was helpful! Let me know if you have any questions. Don't forget to like and subscribe to the channel!
Link to download my portfolio tracking spreadsheets: Patreon: dividendology
Get 50% off of Seeking Alpha Premium!
https://www.sahg6dtr.com/9D5QH2/R74QP/
The microphone I use: https://amzn.to/3ngqbVz
In this video, I take you step by step on how to web scrape data in google sheets. I focus on following three main web scraping strategies in this video:
1. Scraping full data sets
2. Scraping individual metrics from data sets
3. Automating the web scraping process in google sheets
The HTML code I use to inspect tables is the following:
var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); });
If you are trying to inspect a list instead of a table, use the following HTML code:
var i = 1; [].forEach.call(document.querySelectorAll('ul,ol'), function(x) { console.log(i++, x); });
The google sheets codes used in this video are below:
=IMPORTHTML("https://en.wikipedia.org/wiki/List_of...","Table","2")
=IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL","Table","7")
=(index(IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL","Table","7"),7,2))
=(index(IMPORTHTML("https://finviz.com/quote.ashx?t="&A3,"Table","7"),7,2))
I hope this tutorial was helpful! Let me know if you have any questions. Don't forget to like and subscribe to the channel!
Link to download my portfolio tracking spreadsheets: Patreon: dividendology
Get 50% off of Seeking Alpha Premium!
https://www.sahg6dtr.com/9D5QH2/R74QP/
The microphone I use: https://amzn.to/3ngqbVz
3 سال پیش
در تاریخ 1400/07/06 منتشر شده
است.
35,857
بـار بازدید شده