|
PureBytes Links
Trading Reference Links
|
Sam
Talk to me direct - my email should appear in the message. I'm no genius and I'm not really sure
what you are wanting but I think I have some ideas that will help you create the data array that you
seem to be looking for.
Roy
----- Original Message -----
From: "sabboushi2000" <Yahoo@xxxxxxxxxxxxxxx>
To: <equismetastock@xxxxxxxxxxxxxxx>
Sent: Friday, February 06, 2004 2:53 AM
Subject: [EquisMetaStock Group] Simple Moving Average using first bar of each week
> Hi-
>
> Am trying to use EOD daily data to create a Moving Average for the
> previous 3 weeks - by using the Close of the first bar of each
> week AND by using the MOV function.
>
> Example: Today is Wednesday. I want a simple 3 day moving average
> using the following data:
>
>
>
> 2/17 Wednesday
> 2/16
> 2/15 Monday Close: 10
>
> 2/12 Friday
> 2/11
> 2/10
> 2/9 Tuesday Close: 15
> 2/8 Monday Holiday
>
> 2/5 Friday
> 2/4
> 2/3
> 2/2
> 2/1 Monday Close: 20
>
> The result I am looking for in this example would be (10 + 15 +
> 20) / 3 = 15
>
> (2/9 Tuesday was first trading day of that week since Monday was a
> trading Holiday)
>
>
> NOTE: I know I can create a formula to create this moving average
> without using the MOV function, but I don't really want to create a
> simple moving average using 3 data points - I just used this as a
> simple example for discussion purposes.
>
> I've tried using valuewhen to identify the first close value I want
> MS8.01 EOD to use, wishing that the formula would "increment" to each
> previous bar that met the condition - but no such luck. The formula
> I tried:
> Mov(ValueWhen(1,FIRSTDAYOFWEEK, C) ,3 ,S )
> where FIRSTDAYOFWEEK is a custom indicator that is true on the first
> trading day of each week. My problem would be solved if MS
> incremented the "1" in my formula to 2 and 3 to get the data points I
> want it to use - but of course I'm being naive...
>
> Any geniuses out there that can think outside my box?
>
> With Regards-
> Sam
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/BefplB/TM
---------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> 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/
|