Try this, it should work:
H30:= IF(DAYOFWEEK( ) <> REF(DAYOFWEEK( ),-1), H, IF(HOUR() <= 1000, MAX(H,PREV), PREV));
L30:= IF(DAYOFWEEK( ) <> REF(DAYOFWEEK( ),-1), L, IF(HOUR() <= 1000, MIN(L,PREV), PREV));
H30;
L30;
Your first hour High and Low code doesn't look right. See if this works. I can't see why not. If it doesn't let me know and I'll have to add another "IF" statement
H60:= IF(DAYOFWEEK( ) <> REF(DAYOFWEEK( ),-1), H, IF(HOUR() = 1000 AND MINUTE() <=30, MAX(H,PREV), PREV));
L60:= IF(DAYOFWEEK( ) <> REF(DAYOFWEEK( ),-1), L, IF(HOUR() = 1000 AND MINUTE() <=30, MIN(L,PREV), PREV));
H60;
L60;
Note: you didn't say what market you want this code was for. The above code assumes the market opens at 930. If the market you follow opens at a different hour let me know.
Pete
To: equismetastock@ yahoogroups. com
From: mahiya001@xxxxxx com
Date: Fri, 12 Jun 2009 09:50:24 +0530
Subject: [EquisMetaStock Group] metastock coding help
hi the following coding gives the high and low values of the first hour of the day.
can u please give me code for hoe to code it for first 30 minutes of the day
H1st:=ValueWhen( 1,Hour()* 100+Minute( )=1000,H) ;
L1st:=ValueWhen( 1,Hour()* 100+Minute( )=1000,L) ;
H1st;
L1st;
Regards
Nikhil
|
Explore and discover exciting holidays and getaways with Yahoo! India Travel
Click here!