Scan for biggest moving hours/days?

Optuma Forums Optuma Scripting Scan for biggest moving hours/days?

  • This topic has 2 replies, 3 voices, and was last updated 1 week ago by Keith.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #68223
    Jeffrey
    • Topics: 13
    • Replies: 4
    • Posts: 17

    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

    #68226
    Matthew
    • Topics: 5
    • Replies: 608
    • Posts: 613

    Hi,

    You could try something like the following:

    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.
    #68235
    Keith
    • Topics: 8
    • Replies: 1
    • Posts: 9

    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.

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest