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" <roch...@...> 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 >
