With Excel Connect, Alpha Theory users can access their tag administration activities directly in Excel. Leveraging this functionality, users can:
- Create new tag groups and tags
- Assign assets to various tags
- View the current tag assignments for assets
- Manage the various tag-level constraints
To assign assets to Alpha Theory tags, perform the below steps:
- Using the asset's Alpha Theory ticker and designated fund name, select a cell and enter in the following formula:
- =ASSET_TAG_SET("fundName", "tickerName", "tagGroup", "tagName")
- Once ready, click the "Upload Data" button - this will send the tag assignment to Alpha Theory
- Once the confirmation message is received, the asset has been assigned to the tag
- NOTE: If tag group or tag entered does not exist, Excel Connect and Alpha Theory will create the new group and tag, and then assign the appropriate asset
To view the current tag assignment for a particular asset, follow the below steps:
- Using the asset's Alpha Theory ticker and the fund name, select a cell and enter in the following formula:
- =ASSET_TAG_GET("fundName", "tickerName", "tagGroup")
- Once users hit enter, the assigned tag will display in Excel
- If the asset is assigned a tag and the tag does not immediately display, click the "Retrieve Data" button
To set various tag-level constraints, perform the below steps:
- Decide the tag and the applicable field to set a value for
- Select a cell, and enter the following formula:
- =TAG_EXPOSURE_SET("fundName", "tagGroup", "tagName", "field", value)
- List of available fields can be accessed here.
- Once ready, click the "Upload Data" button - this will send the constraint value to Alpha Theory
- Once the confirmation message is received, the tag constraint has been updated
To pull in the current value of tag-level constraints, follow the below steps:
- Decide the applicable tag and constraint to pull in a value for
- Select a cell, and enter the following formula:
- =TAG_EXPOSURE_GET("fundName", "tagGroup", "tagName", "field")
- Once users hit enter, the value for the selected tag and constraint field will display in Excel
- If the constraint field for the tag has a value in Alpha Theory and does not immediately display, click the "Retrieve Data" button
NOTE: Excel cell references can be used for all of the above formulas.
Comments
0 comments
Please sign in to leave a comment.