[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [EquisMetaStock Group] Re:Creating a Date function



PureBytes Links

Trading Reference Links

To reply:  http://groups.yahoo.com/group/equismetastock/post?act=reply&messageNum=6137
------------------------------------------------------------------------

Take a look at the ValueWhen() function and see if that might work for
you.  One way to do this is to set up one column to get the month and
the next to get the day.  For example:

Col A:

ValueWhen(1,c=LLV(c,65), Month())

Col B: 

ValueWhen(1,c=LLV(c,65), DayOfMonth()) 

(Note: the above finds the lowest close since that is how you wrote your
formula but if you want to find the lowest low, you will have to change
the "c's" to "L's" - all four of them)

Good Trading,

Joe J.


-----Original Message-----
From:	gosuth@xxxxxxxxxxxx
Sent:	Tue 1/28/2003 11:51 PM
To:	equismetastock@xxxxxxxxxxxxxxx
Cc:	
Subject:	[EquisMetaStock Group] Re:Creating a Date function

I am trying, without success, to work out how to create a Date Function
in Metastock EOD V8. I would like to be able to have a column in the
Explorer that gives the date for say the lowest low over the last 65
days. The LLV(Close,65) is easy enough but I don't see any Date Function
to generate the date of the lowest low. I note the DayofWeek() etc
functions but I am struggling to see how you harness these. Any
guideance would be appreciated.

Regards,

Gordon Sutherland




To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 


<<winmail.dat>>