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

Re: First trading day of the month?



PureBytes Links

Trading Reference Links

you could always do

         if month(date) <> month(date)[1] then ...

a little simpler than modulo..

Simon

At 21:12 24/11/2002 -0500, you wrote:
>Try the month reserved word:
>
>         if month(date) > month(date)[1] then ...
>
>you have a new month, namely a new trading day.
>Of course, the 12th month is followed by the fist month so
>you need either modulo division, or an if statement to
>determine that the year was over and a new year begun.
>
>Enjoy,
>Leslie
>
>
>'Lucky Bastard' wrote:
> >
> > Does anyone have an algorithm for finding out if a certain date is the 
> first
> > trading of the month? I know that DayofMonth(date)=1 works but what about
> > the situation where the first trading day is on  the 2nd or 3rd of the
> > month?
>
>--
>Regards,
>Leslie Walko
>610-688-2442
>--
>  "Life is a tragedy for those who feel, a comedy for those
>who think"
>         Horace Walpole, 4th earl of Orford, in a letter dated about
>1770