Actually, I decided I only need the Min and Max values in the array. I am uploading all of my workbook and including the code in the post: Example.xlsx As you can see in the Security List tab, I have sorted the table by Sub Industry Name by "Metal & Glass Containers". For each day, I want to find the min and max value for PE_RATIO, PX_TO_BOOK_RATIO etc. of each sub industry. The way Bloomberg sends the data: For each ticker (in my code it is k) it will get each day's data in each row (which is b in my code) and each column (a in my code) for the row. Then it will move to the next row (the next day). At the end it adds one k (the next ticker) and repeats the process. I need to find the tickers (k) with the max and min values for each day and display the ticker along with the price (PX_LAST) for the corresponding day for the securities which are the min and max. I need to do this for every sub-industry in the table on the Security List.
The Module:
This is DataControl2:
Bookmarks