This project scrapes 0.8 Million data from stockanalysis.com along with all the filters and updates it on a Google Sheet every 15 minutes.
Setup Procedure:
-
Access the Extensions and select Apps Script.
-
Paste your script and save it.
-
Navigate to the Trigger page, click Add Trigger, and configure the settings as shown below. Authorize necessary permissions by clicking "Go to Your script name (unsafe)" and then "Allow."
Note: Adjust the update frequency but consider Google App Script's daily quota limit of 20,000 requests. Avoid intervals shorter than 15 minutes without a Google Workspace account. -
Refresh your Google Sheet. Look for the Stock Analysis menu and select Insert Stock Analysis Data to populate or update the data.
Usage:
- Data will update automatically based on the trigger setup.
- Manually refresh data by clicking Insert Stock Analysis Data under the Stock Analysis menu.
