Back to Category Page
ADVANCED USERS
Excel Add-in
Create Strategies

Create Strategies

Excel Add-in

This menu allows you to create new strategies. There are two ways of doing so. Continue reading to learn more.

Last Updated: ‎‎‎‎‏‏‎ ‎
January 24, 2023

This menu allows you to create new strategies. There are two ways of doing so

  • Method 1 (Bulk Creation) - creates all strategies meeting certain criterion. You will use this when you want to create individual strategies for each security in each child account (and there are too many securities to do this by Method 2)
  • Method 2 (Single Strategy Creation) - creates one strategy at a time
Create Strategy Menu Option
Create Strategy Menu Option

Method 1 (Bulk Creation)

  1. Choose a strategy type name (it can be any text) and enter it in the Strategy Type text box. Choose the base currency of the strategy and enter it in the Base Currency text box. Both of these are mandatory fields.
  2. choose one or more keywords from the keyword list and enter them (separated by spaces or commas) in the keywords for Bulk Strategy Creation box.
  3. keyword list is child_username, custodian_name, security_ticker, user_asset_class, user_geography, user_industry, canopy_asset_class, include_derivatives
  4. the order in which you enter the keywords does not matter
  5. For example in case you want to create a individual strategy for each security in the account you just enter security_ticker
  6. If you want to create a strategy for each security in each child account, you need to enter child_username, security_ticker
  7. If you want to create a strategy for each geography and each custodian, you need to enter custodian_name, user_geography
  8. Then press the blue Create Strategy button on the bottom

Method 2(Single Strategy Creation)

  1. Choose a strategy type name (it can be any text) and enter it in the Strategy Type text box. Choose the base currency of the strategy and enter it in the Base Currency text box. Both of these are mandatory fields.
  2. Choose a Strategy Name (it can be any text) and enter it in the Strategy Name text box. Strategy Name is mandatory when doing Single Strategy Creation
  3. Fill in the remaining fields as desired
  4. Ensure that the Keywords for Bulk Strategy Creation text box is blank (otherwise Excel Add-in will ignore the Single Strategy Creation inputs and try to create the bulk strategy instead)
  5. Press the blue Create Strategy button