What about something like this (disallows buys during blackout, forces sells during blackout):
May = 5; MayCutoff = 15; October = 10; OctoberCutoff = 15; MonthOfYear = Month(); DayOfMonth = Day(); Blackout = IIf(MonthOfYear == May, DayOfMonth >= MayCutoff, IIf(MonthOfYear == October, DayOfMonth < OctoberCutoff, MonthOfYear > May && MonthOfYear < October)); Buy = ... AND Not Blackout; Sell = Blackout OR ...; Mike --- In [email protected], "dmcleod1981" <[EMAIL PROTECTED]> wrote: > > I am trying to do some Traders Almanac like calendar comparisons and > want to block out certain date periods like sell every May 15th and > re-buy every October 15th. I can see how to block a specific date but > how do I block out a range of dates? > > Thanks > DM >
