I am also using other software in that my problem it is giving me date and not price
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
>