How to Update Trades with Excel Connect

1. Open an Excel workbook and log into Excel Connect using Alpha Theory credentials.

2. Once connected to Alpha Theory through Excel Connect, select an empty cell to place the TRADE_SET function.

3. Input the TRADE_SET function and its various arguments, either by explicitly typing values or by referencing cells:

   • =TRADE_SET("Fund Name", "Ticker Name", Shares, Unit Cost)

   • =TRADE_SET(B3, C3, D3, E3)

4. Once all of the arguments are input, press ENTER - users should see a returned message that includes "Trade Set for 'Ticker Name',..." followed by the Share Count from the formula.

5. Click 'Upload Data' on the Alpha Theory ribbon.

6. The new quantity and unit cost will be uploaded to the Alpha Theory environment.