Shiguang AI StudioDigital Products
Taiwan ETF Dividend Summary Generator
A small program that needs no account or API key. It pulls dividend records for all Taiwan ETFs in about 30 seconds and outputs a filterable, sortable Excel summary and a detailed dividend history. Run it again anytime to update.
Why You Need This Pack
If you want to compare monthly-dividend ETFs, the query websites only let you look at one at a time.
If you want to see "roughly how much you'd receive per year for every NT$100,000 invested," you have to use a calculator and work through each ETF yourself.
You might be struggling with these:
"I want to see everything at once and sort it myself." The website's ranking uses its own method, and you can't filter its columns the way you want. What you need is your own table.
"I have to look everything up again every time." Dividends change every month, so a manually compiled table is outdated within two weeks.
"How is yield actually calculated?" Some sites multiply the latest dividend by the number of payments, and others use the full previous year. When you see a very high number, you can't tell whether it reflects a one-time special dividend.
What this package solves
Turn "looking things up" into "one click." The program reads the official ETF lists and closing prices directly from the Taiwan Stock Exchange (TWSE) and the Taipei Exchange (TPEx), adds dividend records from Yahoo Finance, and compiles everything into Excel using a fixed, public method. To update, just run it again. How each column is calculated is written in the workbook itself.
Contents
1️⃣ Main program etf_dividend_table.py
- Covers all TWSE-listed and TPEx-listed ETFs. The list is pulled directly from official OpenAPI data, so newly listed ETFs appear automatically. Leveraged and inverse ETFs are excluded by default, but one parameter includes them.
- Finishes in about 30 seconds. It queries multiple ETFs at once. In testing, all 319 ETFs took about 30 seconds.
- No accounts or API keys required.
- You can query only specific ETFs or choose the output folder.
2️⃣ Output Excel file (three worksheets)
Summary: one row per ETF
- Code, name, listing market (TWSE or TPEx), closing price
- Dividend frequency (monthly, quarterly, semiannual, annual)
- Most recent ex-dividend date, most recent dividend amount
- Total dividends over the past 12 months, 12-month yield
- Approximately how much you'd receive per year on NT$100,000 invested
- Notes: automatic alerts when yield is unusually high or there has been no ex-dividend date in the past year
Filters and frozen panes are already set. Sorted by yield, high to low, by default.
Dividend Details: every ex-dividend date and amount for each ETF over the past 3 years.
Notes: the calculation method and data source for each column.
A CSV with the same content is also included, which you can import directly into Google Sheets.
3️⃣ Double-click the program file 產生配息總表.bat
On Windows, just double-click to run. When it finishes, it automatically opens the output folder.
4️⃣ 使用說明.md (User Guide)
Includes installing Python and packages, two ways to run the program, a parameter reference, how each column is calculated, Excel filtering tips, automatic weekly updates with the Windows Task Scheduler, and 10 troubleshooting tips.
5️⃣ Data quality handling
- Yahoo sometimes records a single dividend as two entries one or two days apart. The program automatically merges them.
- Yields of 12% or more trigger a note reminding you to "verify against the fund manager's announcement."
- Yield is based on "dividends actually paid over the past 12 months," not extrapolated from the number of payments.
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're comparing Taiwan ETF dividends and want one summary table you can filter and sort yourself
- You often organize data in Excel or Google Sheets
- You want to update regularly without looking everything up by hand
- You're willing to follow the instructions to install Python once (after that, double-clicking is all you need)
❌ This package is not for you if...
- You want someone to tell you which ETF to buy. This package only organizes past dividend data.
- You need "estimated next dividend" or "upcoming ex-dividend date" alerts. The program only organizes dividends that have already been paid.
- You only use a phone and don't have a computer.
- You need data on overseas ETFs. It currently covers only ETFs listed on TWSE and TPEx.
FAQ
I don't know how to code. Can I still use it?
Yes. You need to install Python and paste one install command into the command window. After that, double-clicking 產生配息總表.bat generates the Excel file. The instructions cover every step.
Does it work on Mac?
The program itself works on other systems: run python3 etf_dividend_table.py in a terminal. The .bat file for double-clicking and the Task Scheduler instructions apply only to Windows.
Is there a monthly fee, or do I need to register for an account?
No. The program only reads public data from TWSE, TPEx, and Yahoo Finance. It requires no accounts or API keys.
Is the data accurate?
ETF lists, names, and closing prices come from official TWSE and TPEx data. Dividend records come from Yahoo Finance, a third-party source that is sometimes delayed, incomplete, or duplicated. The program merges obvious duplicate records and flags unusually high yields. Before making any decision, check each fund manager's official announcements on its website.
Is this investment advice?
No. Yield is "dividends paid over the past 12 months ÷ current price." Past dividends don't guarantee future dividends, and a high yield can result from a falling share price or a one-time payout. This tool is for organizing information and learning only. It does not constitute investment advice. Data may be delayed or wrong, so make your own investment decisions and accept the risk.
Will it upload my data?
No. The program only <em>reads</em> public data, and the output Excel file is stored on your own computer. All the source code is public, so you can review it yourself.
What if TWSE or Yahoo redesigns its site?
If a data source changes its format, the program may need adjustments. We don't commit to regular updates. If an update is released, people who already purchased can get the new version through their original download link.
What file format is it?
A single zip file containing the Python source code (.py), the Windows launcher (.bat, plain text that you can open in Notepad to see its contents), a package list, and two Markdown instruction documents.
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.
Can I get a refund if I'm not satisfied?
Yes. Under Portaly's platform policy, you can request a refund within 7 days of purchase. If files won't open or the program won't run, please email xyzhkwork@gmail.com first, and we will help resolve it.
Related Free Tutorials
- What Is Grok? Latest Version Grok 4.7, Features, and Plan Pricing Overview
- 100 Files Named "Final (2)": Batch-Renaming with Claude Code, and Recovering from Mistakes
- What Is Gemini 4? How Hydrogen, Carbon, and Argon Differ, and How to Choose
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.