20DMF

[Pascal]

Hello Pascal,

The link and table are fantastic, thank you again! Is it possible to add the daily InvETF values to the table too?

Harry

Yes. That is possible

Pascal

[asomani]

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?

Thanks.

[Pascal]

Sorry, but I have no idea what the problem is.
This Figure is the MF and is in the spreadsheet.
What are you talking about?


Pascal

[asomani]

Sorry, I misunderstood what the second column contained.

[Harry]

As per a request from a user, we are now able to update the 20DMF Zoom section between 30 minutes and one hour after the market closes.

I have also added the OB/OS Zoom figure with the EOD value in the title.
The zoom section is still updated several times a day.



Pascal

Attachment 17796

Pascal,

I have noticed the zoom has not been updating these past few days. Can you please check? Thank you!

[Pascal]

Pascal,

I have noticed the zoom has not been updating these past few days. Can you please check? Thank you!

Indeed, I have been using the system to make stock selection back-tests calculations.


Pascal

[Harry]

OK, thank for the update.