Thanks Paolo, I will try this.
--- In [email protected], "Paolo" <pcavat...@...> wrote: > > Try with this > > LastDayofQuarter = Month() != Ref(Month(), 1) AND (Month() == 3 OR Month() == > 6 OR Month() == 9 OR Month() == 12); > ClosingPrice = IIf(LastDayofQuarter, C, 0); > > I hope it helps, > > Paolo > > --- In [email protected], "Matt" <rochemb@> wrote: > > > > Hi All, > > > > As part of a Rotational Trading System, I need to get the closing price of > > an ETF on the last "trading" day of each quarter during the year (no Sat., > > Sun. or Holidays). Any help with coding this would be appreciated. > > > > Matt > > >
