How sector ETF lists are actually built in 2026: GICS vs ICB, issuer labels, look-through weights, inverse sector funds, and how to rebuild the
FactSet Pricing: What It Costs in 2026
Dated figures for FactSet seats, feeds and APIs, what its pricing model actually charges for, and when a CSV feed is cheaper.
PE of S&P 500: Why the Numbers Disagree
How the S&P 500 P/E is built, why trailing, forward and Shiller versions differ, and how to compute it from constituent data.
Build the P/E Ratio S&P 500
How the S&P 500 P/E ratio is actually computed in 2026: trailing vs forward, GAAP vs operating, and how to rebuild it from constituents.
24×5 Trading: What It Breaks in Data
What 24×5 US equity trading is, where the exchange and DTCC timelines stand in 2026, and how it changes reference data pipelines.
Full File Now Available Also in Smaller ...
We now cover 3898 ETPs. There are over 5500 ETPs in the marketplace. We have a ways to go. The file containing the ETF holdings lists is currently 1,143.567 lines long. The maximum number of rows in Excel is 1,048,576. In other words, you cant’ open the full file in Excel. The full file is […]
403 Indexes and ETFs Added To Coverage
403 additional composites are now added to our ETP coverage. This includes 5 US indexes, 1 global index, 6 commodity based ETFs, 3 crypto based ETFs, 82 global equity ETFs, 62 derivative based ETFs, 73 US equity based ETFs, 85 US fixed income, 45 US option based ETFs, and 14 global fixed-income ETFs.We now cover […]
New Fundamental Additions to ETF Constit...
The ETF constituent list data files are undergoing a major upgrade. The structure of the current files will remain in place for the next two weeks, through December 15, 2025. Many previously blank values will now be filled in. In particular, the BBG-ID (FIGI) column is more complete, along with the DividendAmt, XDate, and DividendYield […]
186 ETFs Added To Coverage
186 additional ETFs are now added to our ETP coverage. This includes 1 global index, 6 commodity based ETFs, 3 crypto based ETFs, 34 globally based ETFs, 8 derivative based ETFs, 62 US equity based ETFs, 46 US fixed income, 13 US option based ETFs, and 22 US and 10 global fixed-income ETFs.We now cover […]
246 ETPs Added to Files
Every Spring it seems like ETP providers decide to “update” their website reports. So last year wasn’t done right? But this year we’ll get it right, right? In any event, this sort of thing keeps you busy. I believe things are settling down now. With the season of change more or less behind us, I […]