|
PureBytes Links
Trading Reference Links
|
UG,
There's a problem loading sufficient days for the HHV and LLV to
properly evaluate in your setup. Even with 300 days loaded sometimes
BarsSince(H=HHV(H, 250)) won't get you there, where HHV(H,250) is untrue
when looking behind the earliest input day period, particularly on
falling stocks) and the function returns invalid results or N/A. Same
goes for the LLV, but most frequently in rising stocks where there were
lower LLVs prior to day -250. It really shouldn't have to be this
confounding (Equis), but...
Try this as a workaround:
ColA: HHV(H, 250)
ColB: HHVBars(H, 250)
ColC: LLV(L, 250)
ColD: LLVBars(L, 250)
Filter: ColB < 10 and ColD > 240
Its spins with no N/As this way for me. Oh, and _real_ geek would grasp
this stuff intuitively, right? I'm so far from it I took a couple hours
testing just so I could look like one now. =)
Craig
UG wrote:
>
> I've got an exploration that just gives me an "N/A" value more often
> than not in one column, and can't quite figure out why.
>
> Here's the nitty-gritty:
>
> ColA: HHV(H, 250)
> ColB: BarsSince(H=HHV(H, 250))
> ColC: LLV(L, 250)
> ColD: BarsSince(L=LLV(L, 250))
>
> Filter: ColB < 10 { and ColD > 240 }
>
> I'm loading 300 periods.
>
> What I'm looking for are stocks which have peaked recently and had their
> low point for the year, about a year ago.
>
> The second part of the filter is commented out because it's the part
> that is giving me trouble. If I leave the filter as-is, I get quite a
> lot of stocks which fit the criteria. When I look at them in the
> Reports screen, ColD (number of days since the LLV), it shows N/A for
> well over 80% of the stocks. I can't find any common thread to why this
> is happening.
>
> Thoughts? Ideas?
>
> --
> ========================================================================
> The Pogues have done for Celtic Music what Shane McGowan has done for
> dentistry. -- Roy Gullane, of the Tannahill Weavers
> http://www.unixgeek.com/cgi-bin/motd.pl - PGP email preferred
|