Excel Audit File to Audit Population Queries for Composites

PQ Check is an Excel spreadsheet with macros that enable PQ Check to populate Axys, or APX performance data for a given time period, group, and set of asset classes. Significant flows are taken into account as each month end performance figure is calculated. PQ Check also color codes each Excel cell red, or green based on whether market value requirements, and other composite requirements are met. The result is the ability to view and audit several years of performance data at a glance. This is an important tool for those who build, and need to do quality control on their composites.