Help with data import into Pairs Trading Model.
I have download the Pairs Trading Model add-in and reviewed the associated PowerPoint presentation. Without any data setup instructions or a sample spreadsheet I'm stuck preparing the pairs data for the model to analyze. I would like to know how to setup the data using both an Excel file directly accessed by the model (what is the structure of the Excel file?), or creating a workfile ahead of executing the model (does each security have its own tab, do I use Groups, or ...?). Also, the "Prebuilt pairs lists" will only accept the "none" option.
Any other hints on how to setup and execute the model would be appreciated.
The work is most impressive, but I'm still at ground zero getting it to work for me. Thanks!