Spreadsheet: 755602d1636988849-lookup-countifs-averageifs-based-on-quarter-and-year-question
Sheet: Holdings Turnover

HOLDINGS | First Purchase |  | Exit Date |  |  | Year |  |  | Beg. Positions |  | Positions Added |  | Positions Exited |  | End. Positions |  | Lesser Buy/Sell |  | Avg. Positions held |  | Turnover |  | % AUM Turnover |  | Alt Turnover |  | Year | Positons
TBD | 2010-05-26 00:00:00 |  | 2020-03-12 00:00:00 |  |  | 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00
TBD | 2012-04-23 00:00:00 |  | 2020-11-20 00:00:00 |  |  | 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00
TBD | 2017-08-29 00:00:00 |  | 2020-02-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00
TBD | 2014-02-17 00:00:00 |  | 2020-01-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00
TBD | 2015-11-11 00:00:00 |  | 2021-03-17 00:00:00 |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00
TBD | 2016-06-01 00:00:00 |  | 2020-04-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00
TBD | 2017-03-14 00:00:00 |  | 2021-07-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00
TBD | 2017-04-26 00:00:00 |  | 2020-08-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00
TBD | 2018-05-14 00:00:00 |  | 2020-08-07 00:00:00 |  |  | Quarter |  |  | Beg. Positions |  | Positions Added |  | Positions Exited |  | End. Positions |  | Lesser Buy/Sell |  | Avg. Positions held |  | Turnover |  | % AUM Turnover |  | Alt Turnover |  | 2020-09-01 00:00:00
TBD | 2018-04-25 00:00:00 |  | 2020-04-16 00:00:00 |  |  | Q1 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
TBD | 2018-09-12 00:00:00 |  | 2020-04-02 00:00:00 |  |  | Q2 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00
TBD | 2018-09-18 00:00:00 |  | 2020-12-17 00:00:00 |  |  | Q3 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
TBD | 2018-10-22 00:00:00 |  | Open |  |  | Q4 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00
TBD | 2018-12-13 00:00:00 |  | 2021-08-20 00:00:00 |  |  | Q1 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00
TBD | 2019-03-04 00:00:00 |  | Open |  |  | Q2 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-03-01 00:00:00
TBD | 2019-03-08 00:00:00 |  | 2020-11-09 00:00:00 |  |  | Q3 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00
TBD | 2019-05-15 00:00:00 |  | 2021-05-07 00:00:00 |  |  | Q4 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00
TBD | 2019-08-23 00:00:00 |  | 2021-06-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-01 00:00:00
TBD | 2019-09-26 00:00:00 |  | Open |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-01 00:00:00
TBD | 2019-11-12 00:00:00 |  | 2021-08-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00
TBD | 2020-03-18 00:00:00 |  | Open |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-09-01 00:00:00
TBD | 2019-07-31 00:00:00 |  | Open |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-10-01 00:00:00
TBD | 2019-02-19 00:00:00 |  | 2020-12-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-11-01 00:00:00
TBD | 2019-06-26 00:00:00 |  | 2021-03-03 00:00:00
TBD | 2020-03-31 00:00:00 |  | Open
TBD | 2020-06-12 00:00:00 |  | 2021-08-12 00:00:00
TBD | 2020-05-29 00:00:00 |  | Open
TBD | 2020-07-23 00:00:00 |  | 2021-07-28 00:00:00
TBD | 2020-08-03 00:00:00 |  | Open
TBD | 2019-10-25 00:00:00 |  | 2020-04-01 00:00:00
TBD | 2020-09-15 00:00:00 |  | 2021-10-29 00:00:00
TBD | 2020-10-09 00:00:00 |  | Open
TBD | 2020-10-12 00:00:00 |  | 2020-12-30 00:00:00
TBD | 2020-11-05 00:00:00 |  | Open
TBD | 2020-11-06 00:00:00 |  | Open
TBD | 2020-11-16 00:00:00 |  | Open
TBD | 2020-12-08 00:00:00 |  | 2021-03-29 00:00:00
TBD | 2020-12-22 00:00:00 |  | Open
TBD | 2021-02-16 00:00:00 |  | Open
TBD | 2021-03-15 00:00:00 |  | Open
TBD | 2021-03-09 00:00:00 |  | Open
TBD | 2021-03-02 00:00:00 |  | Open
TBD | 2021-05-14 00:00:00 |  | Open
TBD | 2021-05-20 00:00:00 |  | Open
TBD | 2021-06-08 00:00:00 |  | Open
TBD | 2021-07-08 00:00:00 |  | Open
TBD | 2021-08-19 00:00:00 |  | Open
TBD | 2021-10-11 00:00:00 |  | Open
TBD | 2021-10-15 00:00:00 |  | Open
TBD | 2021-10-20 00:00:00 |  | Open