This is correct: the 20DMF is simply the average of the MF of each sector.
The problem is that I do not keep track of these individual sectors MF.
The 20DMF and other tools visit all the sectors data and calculate its average on the fly.
This means that if I want to build a table of past MF for individual sectors, I would need to use the sector composition of today, which is different from the sectors composition in the past. We have indeed added stocks in sectors and new sectors too have been added. This means that whatever study we can make of past individual sectors MF would lead to different results compared to the 20DMF measured at that time, because the 20DMF had been using a different sectors composition.
In other words: impossible!
Pascal
Hi Pascal,
I don't mean the individual sector MFs.
Just the daily total MF. Please see the circled number in the attached for what I mean.
Is it possible to include this daily number in the spreadsheet?