Ok, thanks for the screenshot. I see a couple issues. One is that you have the Aggregation set to Daily, “D” (upper left).
This is important to note because at some point in the future they may enable secondary time frames in stock scanner.
Even if the scanning engine supported multiple time frames you would not be able to reference a lower time within a context of a higher time frame. It always goes from Lower time frames to Higher time frames. So in order to have an hourly Hull moving average you must have the Aggregation set to Hourly, “1h”.
But as I mentioned, this still will not correct your issue because the scanner does not support multiple time frames, yet.
The Solution:
Here is the only workaround available to address this particular example. You have two Hull moving averages. You are trying to create a condition where the daily crosses above the hourly. (personally, I think that is backwards but I can’t trade to save my life). The only option you have at this time is to approximate the daily value of the Hull moving average from the context of the hourly time frame.
For Stocks:
Set the Aggregation set to “1h” and then set the length of one moving average to 63 (that is your original value of 9 times the number of hourly bars in a day 9 x 7 = 63). You should test this out on a chart so you can get as close as possible. The number of hourly bars in a day should get you close. Just be sure to check it out on the chart and tweak it to get it where you want.
What about Futures, or Forex?
You will need to adjust this if you are trading Forex or Futures as the number of Hourly bars in a day is closer to 24. (you will also need to check the box labeled “Include Extended-Hours Trading Session”)