Buy scan:  need for 60 min charts

please make scan formula for 60 minute charts buy and sell

Show stocks where close 3 days ago is below upper acceleration band(17) 3 days ago and close 2 days ago crossed above the Upper Acceleration Band(17) 2 days  ago

and close 1 day ago  is above Upper Acceleration Band(17)  1 day ago and close  yesterday > high 2 days ago   and   Williams %R(30) crossed  below -20 today  and close > 7 and  avgvol(30) > 250000

sell scan: need  for 60 min charts

Show stocks where close 3 days ago is above lower acceleration band(17) 3 days ago and close 2 days ago crossed below the lower  Acceleration Band(17) 2 days  ago

and close 1 day ago  is below lower  Acceleration Band(17)  1 day ago and  Williams %R(30) today crossed above -80.00  and  close > 7  and close 1 day ago < low 2 days ago

 and avgvol(30) > 500000

I can make this for a Daily Time Frame:

C > 7 AND AVGV30 > 250000 AND STOC30 < 80 AND STOC30.1.1 >= 80 AND C1 > (H1 * (1 + 4 * (H1 - L1) / (H1 + L1)) + H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17))) / 17 AND C1 > H2 AND C2 > (H2 * (1 + 4 * (H2 - L2) / (H2 + L2)) + H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18))) / 17 AND C3 < (H3 * (1 + 4 * (H3 - L3) / (H3 + L3)) + H4 * (1 + 4 * (H4 - L4) / (H4 + L4)) + H5 * (1 + 4 * (H5 - L5) / (H5 + L5)) + H6 * (1 + 4 * (H6 - L6) / (H6 + L6)) + H7 * (1 + 4 * (H7 - L7) / (H7 + L7)) + H8 * (1 + 4 * (H8 - L8) / (H8 + L8)) + H9 * (1 + 4 * (H9 - L9) / (H9 + L9)) + H10 * (1 + 4 * (H10 - L10) / (H10 + L10)) + H11 * (1 + 4 * (H11 - L11) / (H11 + L11)) + H12 * (1 + 4 * (H12 - L12) / (H12 + L12)) + H13 * (1 + 4 * (H13 - L13) / (H13 + L13)) + H14 * (1 + 4 * (H14 - L14) / (H14 + L14)) + H15 * (1 + 4 * (H15 - L15) / (H15 + L15)) + H16 * (1 + 4 * (H16 - L16) / (H16 + L16)) + H17 * (1 + 4 * (H17 - L17) / (H17 + L17)) + H18 * (1 + 4 * (H18 - L18) / (H18 + L18)) + H19 * (1 + 4 * (H19 - L19) / (H19 + L19))) / 17

And you can change the Time Frame of the Condition Formula to use this Condition Formula on a 60-Minute Time Frame to look at these values for 60-Minute Bars instead of Daily Bars, but I cannot think of a way to make a Condition Formula to check for the Daily values using a 60-Minute Time Frame.

The same caveats apply:

C > 7 AND AVGV30 > 500000 AND STOC30 > 20 AND STOC30.1.1 <= 20 AND C1 < (L1 * (1 - 4 * (H1 - L1) / (H1 + L1)) + L2 * (1 - 4 * (H2 - L2) / (H2 + L2)) + L3 * (1 - 4 * (H3 - L3) / (H3 + L3)) + L4 * (1 - 4 * (H4 - L4) / (H4 + L4)) + L5 * (1 - 4 * (H5 - L5) / (H5 + L5)) + L6 * (1 - 4 * (H6 - L6) / (H6 + L6)) + L7 * (1 - 4 * (H7 - L7) / (H7 + L7)) + L8 * (1 - 4 * (H8 - L8) / (H8 + L8)) + L9 * (1 - 4 * (H9 - L9) / (H9 + L9)) + L10 * (1 - 4 * (H10 - L10) / (H10 + L10)) + L11 * (1 - 4 * (H11 - L11) / (H11 + L11)) + L12 * (1 - 4 * (H12 - L12) / (H12 + L12)) + L13 * (1 - 4 * (H13 - L13) / (H13 + L13)) + L14 * (1 - 4 * (H14 - L14) / (H14 + L14)) + L15 * (1 - 4 * (H15 - L15) / (H15 + L15)) + L16 * (1 - 4 * (H16 - L16) / (H16 + L16)) + L17 * (1 - 4 * (H17 - L17) / (H17 + L17))) / 17 AND C1 < L2 AND C2 < (L2 * (1 - 4 * (H2 - L2) / (H2 + L2)) + L3 * (1 - 4 * (H3 - L3) / (H3 + L3)) + L4 * (1 - 4 * (H4 - L4) / (H4 + L4)) + L5 * (1 - 4 * (H5 - L5) / (H5 + L5)) + L6 * (1 - 4 * (H6 - L6) / (H6 + L6)) + L7 * (1 - 4 * (H7 - L7) / (H7 + L7)) + L8 * (1 - 4 * (H8 - L8) / (H8 + L8)) + L9 * (1 - 4 * (H9 - L9) / (H9 + L9)) + L10 * (1 - 4 * (H10 - L10) / (H10 + L10)) + L11 * (1 - 4 * (H11 - L11) / (H11 + L11)) + L12 * (1 - 4 * (H12 - L12) / (H12 + L12)) + L13 * (1 - 4 * (H13 - L13) / (H13 + L13)) + L14 * (1 - 4 * (H14 - L14) / (H14 + L14)) + L15 * (1 - 4 * (H15 - L15) / (H15 + L15)) + L16 * (1 - 4 * (H16 - L16) / (H16 + L16)) + L17 * (1 - 4 * (H17 - L17) / (H17 + L17)) + L18 * (1 - 4 * (H18 - L18) / (H18 + L18))) / 17 AND C3 > (L3 * (1 - 4 * (H3 - L3) / (H3 + L3)) + L4 * (1 - 4 * (H4 - L4) / (H4 + L4)) + L5 * (1 - 4 * (H5 - L5) / (H5 + L5)) + L6 * (1 - 4 * (H6 - L6) / (H6 + L6)) + L7 * (1 - 4 * (H7 - L7) / (H7 + L7)) + L8 * (1 - 4 * (H8 - L8) / (H8 + L8)) + L9 * (1 - 4 * (H9 - L9) / (H9 + L9)) + L10 * (1 - 4 * (H10 - L10) / (H10 + L10)) + L11 * (1 - 4 * (H11 - L11) / (H11 + L11)) + L12 * (1 - 4 * (H12 - L12) / (H12 + L12)) + L13 * (1 - 4 * (H13 - L13) / (H13 + L13)) + L14 * (1 - 4 * (H14 - L14) / (H14 + L14)) + L15 * (1 - 4 * (H15 - L15) / (H15 + L15)) + L16 * (1 - 4 * (H16 - L16) / (H16 + L16)) + L17 * (1 - 4 * (H17 - L17) / (H17 + L17)) + L18 * (1 - 4 * (H18 - L18) / (H18 + L18)) + L19 * (1 - 4 * (H19 - L19) / (H19 + L19))) / 17

I just wanted the close for three periods ago for  hourly bars . the acc(17)) ,the 17 is the period length  of the acc band. 

Then the formulas as given should work as long as you set the Time Frame of the Condition Formula to Hourly.

I just wanted the close for three periods ago for  hourly bars . the acc(17)) ,the 17 is the period length  of the acc band. 

BC and BCE came up on my daily scan sell ,I swirched the condition to daily to test it using alll stocks and your scan did not pick them up, could you chaecjh that,

Thanks for all your help

BC and BCE already return true for the second Condition Formula when it is set to a Daily Time Frame. No changes are necessary.

Note that if you originally used the Condition Formula as a WatchList Column or EasyScan Condition with a 60-Minute Time Frame and then changed the Time Frame of the Condition Formula to Daily, that will not change the Time Frame of the Condition Formula in the WatchList Column or EasyScan. You would need to change the Time Frame within the WatchList Column or EasyScan or remove and re-add the Condition as TC2000 version 12.2 makes a copy to use which is not linked to the original.

A quick way to test the results in any Time Frame would be to use one of the Condtion Formulas as the Boolean Formula in a Custom PCF % True Indicator. The Time Frame of the plotted indicator will always be the same Time Frame as the chart.

One thought is that the AVGV30 > is checking for the 30-Period Simple Moving Average of Volume. On a Daily Chart, this is checking for 30-day average volume, but on an Hourly Chart, it is checking for the 30-bar average volume. You may want to divide the volume to the right of the > sign in each formula by 7 if you still want to have these hourly volumes be approximately equivalent to their daily counterparts.

Works now.

Thanks for your help.

You're welcome.