Scan for biggest moving hours/days?

[Jeffrey]

Hello,

I haven’t seen anything posted like this before – so I don’t if it is even possible – but I am curious if there is a way to scan for or determine which hour/hours or day/days have the biggest moves/biggest pip movement for a particular ticker or currency pair. For example, if I were to scan 1 year worth of data on XAU/USD, I would be looking to determine whether Mon, Tues, Wed, Thurs, Fri, Sat was the biggest mover and then also on an intra-day basis, which hour (1-24 for FX or 1-8 Stocks) was the biggest mover over the span of that 1 year or 1 month of data.

I’m not asking for someone to make this for me, rather just point me in the right direction if possible.

Thank you all!

Jeff

[Matthew]

Hi,

You could try something like the following:

//Set Day of Week to check MONDAY = DAYOFWEEK() == 2; //Find Bar Range RNG = HIGH() - LOW() ; //Find Bar Range for Selected Day of Week MONRNG = IF(MONDAY == 1,RNG,0) ; //Add up all range values for selected day over last year ACC(MONRNG, RANGE=Look Back Period, BACKTYPE=Years, BARS=1)

1 2 3 4 5 6 7 8 9 10

//Set Day of Week to check MONDAY = DAYOFWEEK() == 2; //Find Bar Range RNG = HIGH() - LOW() ; //Find Bar Range for Selected Day of Week MONRNG = IF(MONDAY == 1,RNG,0) ; //Add up all range values for selected day over last year ACC(MONRNG, RANGE=Look Back Period, BACKTYPE=Years, BARS=1)

This is an example for finding Mondays bar range over the last year.  You could do the same thing for all the days you are interested in, then run a check to find which day produces the highest value.

Intraday is a little trickier, there’s no preset function that identifies a specific time of day.  If I can work out a way to do it I will let you know.

• This reply was modified 1 week ago by Matthew.

[Keith]

I don’t have time at the moment to check this out but I think you can right click on the bars and ‘download data’ or similar.  It downloads all data to excel and then you can manipulate to see the high and low days.

[Author]

Posts