scraping data using Google App Script
Budget: $10 – $30 USD
See the more detail at url:https://docs.google.com/document/d/1oYiznRJsMv8sPfHCUOkGHpO2dn7bOHEwk3DDEhLRpDA/edit?usp=sharing
1.Clean and create tab:Clean and create the amount of blank stock tab at google sheet (input). The tab name is the cell at "input" _+A2-Ax,(x is the number isn’t blank), I assume it’s a variable called {{stock_no}}. For example _1101,_1102,_2232…
2.Download url table data:download the data at website to google sheet:
Here is the following url:
url1:http://5850web.moneydj.com/z/zc/zca/zca_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “A1” cell
url2:http://5850web.moneydj.com/z/zc/zcr/zcr_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “A34” cell
url3:http://5850web.moneydj.com/z/zc/zch/zch_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “A106” cell
url4:http://5850web.moneydj.com/z/zc/zcq/zcqa/zcqa_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “K2” cell
url5:http://5850web.moneydj.com/z/zc/zcq/zcq_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at
url6:http://norway.twsthr.info/StockHolders.aspx?stock={{stock_no}}
download the table data into the same {{stock_no}} tab at
Here is the sample sheet I want:
https://docs.google.com/spreadsheets/d/1tbKI3oyXE3pKfXItkxQc3XJ7l9Thp-UrUqlr278RPi4/edit#gid=192230294
3.Set the formula:Go to the "input" tab and let B2 to CP2 drop down to the cell where the A column isn’t blank.
1.Clean and create tab:Clean and create the amount of blank stock tab at google sheet (input). The tab name is the cell at "input" _+A2-Ax,(x is the number isn’t blank), I assume it’s a variable called {{stock_no}}. For example _1101,_1102,_2232…
2.Download url table data:download the data at website to google sheet:
Here is the following url:
url1:http://5850web.moneydj.com/z/zc/zca/zca_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “A1” cell
url2:http://5850web.moneydj.com/z/zc/zcr/zcr_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “A34” cell
url3:http://5850web.moneydj.com/z/zc/zch/zch_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “A106” cell
url4:http://5850web.moneydj.com/z/zc/zcq/zcqa/zcqa_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “K2” cell
url5:http://5850web.moneydj.com/z/zc/zcq/zcq_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at
url6:http://norway.twsthr.info/StockHolders.aspx?stock={{stock_no}}
download the table data into the same {{stock_no}} tab at
Here is the sample sheet I want:
https://docs.google.com/spreadsheets/d/1tbKI3oyXE3pKfXItkxQc3XJ7l9Thp-UrUqlr278RPi4/edit#gid=192230294
3.Set the formula:Go to the "input" tab and let B2 to CP2 drop down to the cell where the A column isn’t blank.