[EquisMetaStock Group] Re: Want date

["rsb_44" <rsb_44@xxxxxxxxxxx>]

Have you considered making the other software follow MS functions?

If you have text manipualtion functions in the other software you can isolate the month and day using left() right() and find().

You can use Excel as the middleman and create what you want. See my post about about additional columns. If software is able to export reports in a format Excel can read, the integation process is pretty simple using Vlookup or Hlookup in Excel. Excel also has a full suite of text manipulation functions.

--- In equismetastock@xxxxxxxxxxxxxxx, hitendra@xxx wrote:
>
> 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
> 
> -----Original Message-----
> From: "rsb_44" <rsb_44@xxx>
> Date: Mon, 15 Mar 2010 16:54:34 
> To: <equismetastock@xxxxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxxx, hitendra@ 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
> >
>




------------------------------------

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:
    equismetastock-digest@xxxxxxxxxxxxxxx 
    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/