Live Trader / Pro-Trust Excel Add-In Documentation

Owned by Shamara Pereira (Unlicensed)
Last updated: Sept 30, 2020 by Animesh Agrawal (Unlicensed)
3 min read

Installation and Setup

  • Download the official Canopy Pro Tool for Trustees workbook [attached below]

  • Open the official Canopy workbook in Excel

  • Install the Canopy Excel Add-In from the Microsoft Office Add-In Store

 

Login

  • Open the installed Canopy Add-In and

  • Enter your credentials (Username and password)

  • Make sure to select the correct server [Mainline, Credit Suisse, Bank of Singapore]

  • Click <Login>

Accessing the Pro-Trust Module

  • Once logged in, click on the <Pro-Trust> button in the task pane of the Add-In

Note:

  • Pro-Trust can only be used on Canopy’s official worksheet associated with Pro-Trust.

    • You will receive a warning and won’t be able to access any Pro-Trust functionality otherwise

 

 

Loading Transactions and Account information in Pro Trust

Steps to load transactions and account information (information can be entered in the appropriate fields directly within the spreadsheet or in the task-pane):

  • Enter the parent username [Optional]

  • Enter child username(s) separated by commas [Optional]

  • Enter the name of the ledger tab [Required]

  • Enter the name of column to use in the ledger tab [Required]

  • Enter a “From Date” to filter transactions after the entered date [Optional]

  • Enter a “To Date” to filter transactions before the entered date [Optional]

  • Enter the maximum number of transactions to load per page under “Max Per Page” [Optional]

  • Enter which page of transactions to load under “Page No” number to load [Optional]

  • Click <Load Transactions>

    • This should set the active worksheet to the Extract Accounts tab where all of the appropriate information and transactions will be loaded. Single line transactions can be found on the left table and accounting entries/statements can be found on the right table.

    • The Extract_Accounts sheet can be cleared at anytime by clicking on the “Clear Sheet” button in the task-pane of the add-in

Notes:

  • Don’t add any extraneous columns to any of the user defined tables in the Transaction_Details, Account_Mapping and Employee tabs

  • Don’t edit any of the predefined column headers

  • Don’t move any of the predefined tables and ensure that each table in the Transaction_Details, Account_Mapping and Employee tabs begins in cell “C7”

  • Don’t enter any values in to the cells past the last column of each table in the Transaction_Details, Account_Mapping and Employee tabs

 

For further issues or troubleshooting please reach out via email at connect@canopy.cloud.