Shiguang AI StudioDigital Products
Google Sheets Taiwan Stock Watchlist Helper
No software to install, no computer left running. Google records your watchlist stocks' closing prices every day and sends you a Telegram alert when they hit your set price.
Why You Need This Pack
You track a dozen or more watchlist stocks and end up opening each one, one by one, after the market closes every day.
You might be struggling with these:
"I want to record closing prices every day, but I always forget." Pasting data into Excel by hand rarely lasts a week. Gaps in the data make it impossible to look back.
"I want price alerts, but broker apps only let me set them one stock at a time." Switching phones or brokers means setting everything up again, and the alerts can't live alongside your notes.
"Online programs require installing Python and leaving a computer running." When the computer shuts down, the schedule stops.
What this package solves
Keep your watchlist in Google Sheets and let Google run the rest on schedule. It runs even when your computer is off, and you can check the sheet on your phone anytime.
Contents
1️⃣ Script 自選股小幫手.gs (Google Apps Script)
- After each trading day's close, automatically records each stock's closing price, change, percent change, and trading volume.
- Checks price alerts (price rises to or falls to a target) every 10 minutes during trading hours. When triggered, it sends a Telegram message, once per stock per day.
- Sends an after-hours summary. Optionally, add a free Gemini API key for plain-language AI commentary (it only describes the numbers).
- Supports listed stocks, ETFs, OTC stocks, and bond ETFs. Enter a stock code and the Chinese name is filled in automatically.
- A Chinese menu at the top of the spreadsheet: Initialize, Set Keys, Record Now, Check Now, Stop Schedule.
2️⃣ 00 開始這裡.md: 10-minute quick start
3️⃣ 使用說明.md
Setup steps (including how to respond to each Google authorization screen), how to get a Telegram bot and Chat ID, an explanation of the three tabs, how to adjust timing, 9 troubleshooting items, and privacy and security notes.
Who It's For / Who It's Not For
30-second self-check: is this package right for you?
Check the boxes that apply to you.
✅ This package is for you if...
- You have a fixed watchlist and want to automatically keep a daily closing record
- You want price alerts but don't want to install software or leave a computer running
- You already use Google Sheets, or want to check your data anytime on your phone.
- You're willing to spend 10 minutes pasting code as instructed and approving access once.
❌ This package is not for you if...
- You want someone to tell you what to buy. This is a tool for organizing data and sending reminders. It does not offer stock picks or buy/sell advice.
- You need second-by-second real-time quotes or automatic trading. Intraday alerts check every 10 minutes, so there is a delay.
- You want to track emerging stocks, warrants, futures, or overseas stocks (not supported).
- You don't have a Google account.
FAQ
Do I need to apply for any accounts or API keys?
You only need one Google account. Telegram notifications and Gemini AI summaries are optional. Without them, daily market records still run automatically.
Do I need to keep my computer on?
No. The program runs on a schedule in your own Google account, so it still runs when your computer is off.
Is it safe when "Google hasn't verified this app" appears during authorization?
Yes. This appears because you pasted the program yourself and it wasn't submitted for Google review. The guide explains each screen. All source code is public, so you can review it before granting access.
Can you see my data or keys?
No. The program runs only in your Google account and connects only to TWSE, Telegram, and Gemini (the last two only if you set them up). Keys are stored in Apps Script's script properties, not in spreadsheet cells.
Does it cost anything? Will Google charge me?
A standard free Google account's quota is enough. Telegram and free Gemini API keys are also free.
Can I set it up on my phone?
Installation requires a one-time setup in a desktop browser. After that, use the Google Sheets app on your phone to view data and edit your watchlist and price alerts.
What file format is it?
One zip file containing an Apps Script program (.gs, opens in Notepad) and two Markdown guides.
Can I modify the code and use it for work?
You may modify the code freely for personal use and internal use within your own team. Please don't resell it, share the download link, or modify it to sell as your own product.
Is this investment advice?
No. This tool is for information organization and learning only and does not constitute investment advice. Data may be delayed or inaccurate. Make your own investment decisions and assume the risks. Price alerts are simply notifications for prices you set, and AI summaries only describe numbers.
Will it be updated?
We don't promise regular updates. When an update is available, use the original download link to get the new version at no extra charge.
Can I get a refund if I'm not satisfied?
Yes. Per Portaly platform rules, you may request a refund within 7 days of purchase. If it won't install or run, please email xyzhkwork@gmail.com first, and we'll help you resolve the issue.
Related Free Tutorials
- What Is Gemini 4? How Hydrogen, Carbon, and Argon Differ, and How to Choose
- Grok vs ChatGPT vs Claude: Pros, Cons, and Who Each Is For (Including Gemini)
- What Is Agentic Commerce? Three Camps of AI Agents That Place Orders for You
Launch offer valid until 2026-11-25
This page was machine-translated from Traditional Chinese. If anything differs, the Traditional Chinese original prevails. Purchases and support are in Traditional Chinese.