Open the local server
This app cannot run correctly from the filesystem because it needs to load ETF dataset files. Open it through the local server instead.
Open ETF analyserData quality
Future ratio readiness
| Metric | Priority | Stocks | Weight | Most missing fields |
|---|
ETF coverage
| ETF | Holdings | Mapped weight | Official fundamentals |
|---|
Open issues
| Severity | Category | Target | Message | Suggested action |
|---|
Stocks
Browse the normalized company fundamentals used by ETF and portfolio calculations.
| Ticker | Company | Exchange | Country | Currency | Source currency | Market cap (USD) | Provider mcap (USD) | Price mcap (USD) | Mcap accepted | Price (USD) | Shares out | Earnings (USD) | Forward earnings (USD) | Fwd earn low | Fwd earn high | Fwd earn sources | Revenue (USD) | Forward revenue (USD) | Fwd rev low | Fwd rev high | Fwd rev sources | P/E | Forward P/E | P/S | Forward P/S | Earnings yield | Fwd earnings yield | Sales yield | Fwd sales yield | As of | Financials date | Revenue date | Price date | Shares date | Financials provider | Price provider | Mcap source | Status |
|---|
Portfolios
Build a local portfolio from stocks and ETFs, then analyse it with the same look-through fundamentals.
| Name | Items | Stocks | ETFs | Total weight | Weight balance | Look-through holdings | Look-through P/E | Forward P/E | Forward P/E range | Look-through P/S | Forward P/S | Forward P/S range | Earnings yield | Fwd earnings yield | Sales yield | Fwd sales yield | P/E included wt | P/E excluded wt | Fwd P/E included wt | Fwd P/E excluded wt | P/S included wt | P/S excluded wt | Fwd P/S included wt | Fwd P/S excluded wt | Warnings | Created | Updated | Status |
|---|
ETF list
Open an ETF to inspect its look-through fundamentals and holdings-level inputs.
| Ticker | ETF | Issuer | Market | Exchange | Currency | Listing type | Relationship | Primary | Benchmark | As of | Holdings | Total weight | Look-through P/E | Forward P/E | Fwd P/E min | Fwd P/E max | Look-through P/S | Forward P/S | Fwd P/S min | Fwd P/S max | Earnings yield | Fwd earnings yield | Sales yield | Fwd sales yield | P/E included wt | P/E excluded wt | Fwd P/E included wt | Fwd P/E excluded wt | P/S included wt | P/S excluded wt | Fwd P/S included wt | Fwd P/S excluded wt | Warnings | Status |
|---|
Look-through result
Calculation
Look-through P/E is calculated as
included weight / SUM(weight * earnings / market cap).
Each included holding contributes its holding weight multiplied by
the company's earnings yield. P/S uses the same look-through logic:
included weight / SUM(weight * revenue / market cap).
Forward P/E uses analyst-estimated forward earnings:
included weight / SUM(weight * forward earnings / market cap).
Forward P/S uses analyst-estimated forward revenue:
included weight / SUM(weight * forward revenue / market cap).
Dataset source
Data summary
Holdings
| Holding | Exchange | Weight | Market cap (USD) | Earnings (USD) | Forward earnings (USD) | Revenue (USD) | Forward revenue (USD) | Company P/E | Company forward P/E | Company P/S | Company forward P/S | Status | Data quality |
|---|