Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Check out the LLV function and the LOWESTSINCE function. e.g., LLV(C, 252)
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
This should be good enough for general use to give the 52 week lowest low on either EOD or weekly charts. It's not suitable for securities with trading gaps, but sophistication can be added if needed.
The "G" variable recognizes weekly data. The "F" variable identifies the highest (last) day of the week, and it's always TRUE if "G" is TRUE.
D:=DayOfWeek();
G:=LastValue(Highest(Sum(D=5,5))=5);
F:=G OR PeakBars(1,D,1)=0;
LowestSince(52,F,L);
Roy
MetaStock Tips & Tools
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
antjinsan wrote:How can I put this in the Explorer? Cause I've tried the following:
Column A:
D:=DayOfWeek()
Column B:
G:=LastValue(Highest(Sum(D=5,5))=5)
Column C:
F:=G OR PeakBars(1,D,1)=0
filter:
LowestSince(52,F,L)
But I got an error note: "This is not a recognised name, constant or operator" in Column C for the character "D". Do you know what I did wrong?
Thanks!
Best Regards,
Hung
Reposted by Moderator: new thread
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Jose wrote:Hung, remove all your code from columns A~C, and place the complete code in column A of your exploration.
[code:1:6107e15b79]
D:=DayOfWeek();
G:=LastValue(Highest(Sum(D=5,5))=5);
F:=G OR PeakBars(1,D,1)=0;
LowestSince(52,F,L);
[/code:1:6107e15b79]
Alternatively, use this exploration code from MetaStockTools.com:
52-week highs, 52-week lows.
jose '-)
Reposted by Moderator: new threa
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
