Institutional Client Portfolio Positions

This reporting system is populated on a weekly and quarterly basis from various feeds that exist in numerous formats. This system not only imports in these various data elements, but performs an extensive parsing of data and integrity checking with accompanying exception reports to alert the user of inappropriate records. Reports are generated with records being categorized via user maintained cross reference tables, displaying weighted yields, as well as return figures. A unique feature of this program is the creation of a dynamic bar graph which automatically rescales both axis and places ticks and labels in the correct positions based on the data. Lastly, employing OLE automation, this system will create a workbook and a set of spreadsheets that are populated using statistical results of these records.