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

[EquisMetaStock Group] Re: Simple Formula Issue with Date



PureBytes Links

Trading Reference Links

Ok, looking at how some of you are using the date function, I was able
to get it to work using this.

Base:= Year()=2007 AND Month()=1 AND DayOfMonth()=3;  That allows me
to program in a base date that I can then use as a starting point in
comparing various ETF's to each other.  

All I'm really doing is dividing todays value by the value on the base
date for each ETF and plotting it.  Laying multiple ETF's for multiple
markets and cap sizes to see what's moving and what's possibly the
next mover.   That allows me to lay various markets in the same chart
and see at a glance who is trending and in what direction.


--- In equismetastock@xxxxxxxxxxxxxxx, "investpostsstill"
<disposable12@xxx> wrote:
>
> I've never really tried to use a date in a metastock formula before.
> 
> What I would like to do is to reference a particular day in a formula
> to get the closing value on that day.
> 
> Lets say I keep NEM at this location:  Security("C:\MetaStock
> Data\#N-Z\NEM",C.   How can I reference the closing value of NEM on
> 01/01/07?
> 
> Maybe a "value When" formula?  But I've really no clue.  Any help
> would be appreciated.  I'm sure this is very simple but never having
> done it.....well, you know the story.
>




 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> 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/