Unless I've missed something then try this:-
{Exploration}
{Column A}
event:=Cross(C,Mov(C,10,S));
Alert(event,30);
{Column B}
{Col. Name: Day}
event:=Cross(C,Mov(C,10,S));
ValueWhen(1,event,DayOfMonth());
{Column C}
{Col. Name: Month}
event:=Cross(C,Mov(C,10,S));
ValueWhen(1,event,Month());
{Column D}
{Col. Name: Year}
event:=Cross(C,Mov(C,10,S));
ValueWhen(1,event,Year());
{Filter}
colA;
From Exploration Report copy & paste into Excel and manipulate data as required.
--- On Tue, 16/3/10, hitendra@xxxxxxxxxxx <hitendra@xxxxxxxxxxx> wrote:
From: hitendra@xxxxxxxxxxx <hitendra@xxxxxxxxxxx>
Subject: Re: [EquisMetaStock Group] Re: Want date
To: equismetastock@xxxxxxxxxxxxxxx
Received: Tuesday, 16 March, 2010, 5:58 PM
Ya in the report Indicate buy price Indicate. Reco date Current close Gain and loss When call get closed date again In this date is missing Take a simple clue buy is above 10 day avergae cross over Get me the date of cross over of close and average Price is possible easily and other requirement as well
Sent on my BlackBerry® from Vodafone
From: Rob Tinley <gazumped2@xxxxxx com.au>
Date: Mon, 15 Mar 2010 18:16:19 -0700 (PDT)
To: <equismetastock@ yahoogroups. com>
Subject: Re: [EquisMetaStock Group] Re: Want date
Are your planning on gathering this data by running explorations?
--- On Tue, 16/3/10, hitendra@xxxxxxxx com <hitendra@xxxxxxxx com> wrote:
From: hitendra@xxxxxxxx com <hitendra@xxxxxxxx com>
Subject: Re: [EquisMetaStock Group] Re: Want date
To: equismetastock@ yahoogroups. com
Received: Tuesday, 16 March, 2010, 1:38 AM
Thanks for the reply Ron I need it for the report content The function which you have indicated, I have tried it eariler I am also using other software in that my problem it is giving me date and not price Is by any way we can get DD/MM
Sent on my BlackBerry® from Vodafone
From: "rsb_44" <rsb_44@xxxxxxxx com>
Date: Mon, 15 Mar 2010 16:54:34 -0000
To: <equismetastock@ yahoogroups. com>
Subject: [EquisMetaStock Group] Re: Want date
MS doesn't have Date. It does have Month, Day of Month, and Year functions. From the Help file: SYNTAX month() FUNCTION Plots the month of the year for the price. If a bar was plotted on 10/15/96, "10" would be plotted. To get the month of an event (Again from the Help file: SYNTAX valuewhen ( Nth, _expression_, DATA ARRAY ) For the most recent event's Month: valuewhen( 1, MyEvent, Month() ) I think the above is accurate. I've gotten a bit rusty. Why do you want the date format you are showing? Ron --- In equismetastock@ yahoogroups. com, hitendra@xxx wrote: > > I want cross over date > > Simple example > > Cross over date of price over 10 day average > > We can get the price with value when function >
> How about date in format of mm/dd/yy > Sent on my BlackBerry® from Vodafone >
|
|