This template generates a performance report of stocks from an HGSI warehouse HTML file. The html file should first be converted to an Excel file prior to running this template by using the 'Convert Warehouse HTML' template.
The warehouse Excel file can be filtered in Excel prior to running this template and the resulting report will not include the filtered out stocks.
The report shows %Gain vs ERG, EPS Rk, RS Rk, Grp Rk, A-D Rk and HGS Boxes, allowing you to see how stock performance was affected by these factors. You can also add your own custom field (see instructions in the Custom Field worksheet).