Filtering for both Minute Bars and Daily Bars

[Doug Hayman]

Team Medved,

I saw another thread on this, but just wanted to know if you could shed some additional light on this please.

I have a scan that runs on 5-minute bars, but I want to make sure that the stocks that are returned in my scan have a price above their 200-day SMA as well.

I realize that I cannot combine different timescales into 1 scan's logic, but I attempted to use a 5-min bar approximation of a 200-day SMA as SMA(15600) - 12, 5-minute bars per hour TIMES 6.5 hours TIMES 200 days.

I have one stock, for example, PBR, whose 200-day SMA (viewed from a daily chart) is 11.9391, and current price is around 9.82, but it did not get filtered out in my:

        (Close < SMA_Line(156000) filter rule.

In my Scan setting, I have "Extended Hrs" set to "Current Day'.  I take that to mean that only the current day's Extended hours would be used in the SMA(15600) calculation; otherwise it would only use values during market hours.

Shouldn't my approximation for Daily SMA(200) above be working?

Thanks in advance for any light that you can shed on this.

[Jerry Medved]

it will not be accurate. You would need 200 days of intraday data to accurately compute that SMA and MT max is 120. So even if you had a source that let you backfill that much intraday data (TDA, IQ Feed, Ally Invest), you would get max 120 day SMA, not 200.

[Doug Hayman]

Ah, OK, thanks, didn't know that.  OK, so I'll remove that line in filter, which will speed scan up, and just eyeball Daily Chart.