ETF Forward PE (Updated on 3/24)
QQQ (Process): 27.69 (2024), 23.55 (2025), 36.30 (Trailing), 7.33 (PB)
SOXX (Process): 29.26 (2024), 22.19 (2025), 47.17 (Trailing), 3.68 (PB)
XLK (Process): 29.54 (2024), 25.04(2025), 36.94 (Trailing), 9.91 (PB)
QCLN (Process): -105.08 (2024), 54.75 (2025), -25.74 (Trailing), 1.29 (PB)
00878.TW (Process): 17.49 (2024), 14.25 (2025), 19.86 (Trailing), 1.81 (PB)
006208.TW (Process): 18.36 (2024), 15.19 (2025), 21.40 (Trailing), 2.96 (PB)
Moving Average (Updated on 3/24)
Understand the level of cost — We looked into 20 ETFs’ (VT, VTI, XLP, 0050.TW, etc) moving average ranged from 250 days to 2500 days,
- Tickers with price lower than 250&500-Days MA in yellow
- Tickers with price lower than 750-Days MA in orange
- Tickers with price lower than 1250&2500-Days MA in red
How to Create X-days Moving Average Chart in stock market via Python (Plotly & Pandas)
Reference Article
MA Research — XLU / IWM & XLP/ VT & QQQ / SOXX/ VTI & EWT / EWS/ EWJ
Adding key large-cap tickers (3/24)
We took top large-cap tickers from ETF XLP, XLY, XLC, XLF, etc. and run the moving average ranged from 250 days to 2500 days. Here is the list meet the criteria (lower than 750 days or 1250 days or 2500 days).
Monthly YOY aggregated view (Revenue till 2024 Feb)
Reference — How to Extract Monthly Revenue Information in Taiwan Stock Exchange via Python?
As New Year festival is in Feb this year (in Jan last year), we combined Jan and Feb to do the comparison.
MCU Group (6202.TW, 6206.TW, 5471.TW, 6494.TWO)
ABF Group (3037.TW, 8046.TW, 3189.TW)
GaAs Group (3105.TWO, 8086.TWO, 2455.TW)
Passive components/ inductor / Resistor (2327.TW, 2492.TW, 3026.TW)
Bearing (3376.TW, 3548.TWO, 6805.TW)
