Hello.
(Ideal)typical weekly course of an index
Is there a possibility to superimpose all historical closing prices in the last 5 years in the 5M chart from Monday with start of trading until Friday end of trading in such a way that one gets an ideal weekly price trend e.g. from the DAX?
So something like this
Total all closes from Monday 01.05 o’clock, divide by number
Total all closes from Monday 01.10 o’clock, divide by number
Total all closes from Monday 01.10 o’clock, divide by number
…
Total all closes of Friday 22.00 o’clock, divide by number
Display all results as graph
If this succeeds, an ideal typical weekly index will be displayed. So for my sake so that one can say that the index usually falls from Monday 04.00 o’clock to Monday 08.00 o’clock, then the index usually rises until 14.00 o’clock, then comes a sideways phase until 16.00 o’clock, then it rises further until 22.00 o’clock, then sideways until 06.00 o’clock …. etc etc.
Is it possible to program this or at least to have a graph for it?
You could then continue working with it, calculate standard deviations, calculate vola, etc.
Is it possible?