I have data that I retrieve from a financial website that I need consolidated for easy sorting and filtering.? The data consists of stock symbols and contracts traded.
I need to be able to have the original data file (six columns and a very large number of rows)? reduced to simply the stock symbol and total contracts traded.
Once this is done, I may want to find a way to automate this retrieval and consolidation process.
As noted, I'd like the result done in C++ or Perl, preferably C++.? As the project gets more invovled, I'll look to add a C# or Java wrapper.? I'll include a sample of the file.? In the sample the security identifier is the letter two lines below the word "Group", and the Total is the last column total in the row marked "Group Total".