Back

Available Upload Data Sets

Contents

Introduction

Uploading Data vs. Using the Interface

What's the Difference?

See Uploading Data vs. Using the Tamarac Trading Interface in Action

Available Upload Data Sets

Upload Data Sets for the Tamarac Platform

Tamarac Reporting Upload Data Sets

Tamarac Trading Upload Data Sets

Upload Data Sets and Bulk Report

 

Introduction

The upload feature in Tamarac Trading allows you to add or change a large amount of data at one time. You can upload new data, such as creating new models in bulk. You can also use the upload feature to change existing data in bulk, such as updating the custodian and associated fee schedule for many accounts at once.

You can upload data to Tamarac Trading using the available upload data sets. These data sets are a defined list of required, conditional, and optional fields. Below, you can find a list of available upload data sets and more details about each data set.

important

Uploads can overwrite existing data instead of adding to existing data. For example, if the Smith Family group has three accounts and you use upload to update the group and only include two of those accounts, the third account is no longer considered part of the Smith Family group.

Uploading Data vs. Using the Interface

What's the Difference?

There are many actions and changes that can be completed two different ways: through the Tamarac Trading interface and through upload. For example, if you update account information on the Accounts page, that's updating with the Tamarac Trading interface. If you prepare a spreadsheet to update the same account information, that's updating through upload.

In many cases, both methods achieve the same results. However, each has advantages and disadvantages. Uploading data allows you to make large-scale changes or changes to many accounts all at once, saving you time. Making changes through the Tamarac Trading interface is quick, has little room for error, and is better for changes to one or a few account at a time.

See Uploading Data vs. Using the Tamarac Trading Interface in Action

Your clients, Bob and Melissa, have multiple accounts with your firm. Yesterday, Melissa opened an additional brokerage account. While setting up the new account, you go to the new account's settings and associate the new account with the correct Custodian.

Later, your firm decides to change the custodian for hundreds of existing accounts. While you could use the same process to update the Custodian for each of those accounts, this would be a time-consuming process where someone would need to search for each of the accounts, and then update the Custodian field.

Instead, you can update the Custodian field for each of these accounts through upload. Using the Data Specifications for the Account Information upload data set, you create a spreadsheet with the corrected custodian.

You then use the Upload page to update each of the accounts at once, rather than updating each account individually.

Available Upload Data Sets

You can use the following data sets to upload data into Tamarac: 

Upload Data Sets for the Tamarac Platform

The following upload data sets are available for every user of the Tamarac platform.:

Upload Data Set What It Does More Information
Account Information

Create or change specific account information by upload. This is usually account settings data such as the assigned custodian, taxable status, model assignment, account benchmarks, objective, billing inception date, and more.

  • To change a setting for a large number of accounts at once, create the Account Information bulk report, make the needed changes, and use this bulk report to upload the changed data.
  • If an account does not have a primary Household assigned and you set the Use Primary Household Address column to Yes, the check box will be selected, and the account's mailing address field will be left blank.
  • Uploading will never delete any advisors assigned to an account or group.
  • If you upload the Allow Rebalancing, Discretionary, or Taxable fields in this data set, the accounts in which you upload data will save and you will lose any existing rebalances in the account.
  • For more on this topic, see Maintaining Accounts.
Reporting Group Direct Members

Add or update accounts in an existing group name.

  • When creating groups by upload, use the following order:
    1. Create the group name using the Reporting Group Information upload data set.
    2. Add individual accounts to the group using the Reporting Group Direct Members upload data set.
  • If a group does not have a primary Household assigned and you set the Use Primary Household Address column to Yes, the check box will be selected, and the group's mailing address field will be left blank.
  • If you upload the Include in Rebalancing field in this data set, the accounts in which you upload data will save and you will lose any existing rebalances in the account.
  • Find steps for using this bulk report at Workflow: Create Groups With Uploads.
Reporting Group Information

Add or update the names of groups and add group details such as address, description, benchmarks, and more.

  • When creating groups by upload, use the following order:
    1. Create the group name using the Reporting Group Information upload data set.
    2. Add individual accounts to the group using the Reporting Group Direct Members upload data set.
  • If you upload the Rebalancing Model Name or Prospect Account fields in this data set, the accounts in which you upload data will save and you will lose any existing rebalances in the account.
  • Find steps for using this bulk report at Workflow: Create Groups With Uploads.
Security Categories Add categories and category types to securities and specify the order in which categories appear.
  • Supports multiple category functionality where securities can have multiple categories and some reports can support proportional reporting of securities according to their category percentage allocations.
  • For more information, see Security Categories.
Security Category Weights Add a percentage allocation and primary designation to categories associated with specific securities.
  • Supports multiple category functionality where securities can have multiple categories and some reports can support proportional reporting of securities according to their category percentage allocations.
  • For more information, see Security Categories.
Security Information

Add or update securities and security settings such as a custom round lot, security description, benchmark, bond ratings, category, and more.

For more on this topic, see Maintain Securities.

Sleeve Account Allocations

Specify sleeve allocations in specific accounts.

Sleeve Level Information Create or update basic sleeve information.
  • Use the Sleeve Account Allocations data set to specify allocations in specific accounts.
  • For more on this topic, see Understanding Sleeve Reporting.
Uploaded Search

Create a custom saved search using your own list of accounts.

  • This kind of search is useful for creating a saved group of accounts that don't share obvious common criteria.
  • When using this upload data set, you'll overwrite any previous uploaded saved searches you've added.
  • For more on this topic, see Create, Edit, or Delete Saved Searches.

Tamarac Reporting Upload Data Sets

The following are available for Tamarac Reporting users:

Upload Data Set What It Does More Information
Account Billing Payout Distributions Bulk update the payee, payout date, payout percentage, or other payout distribution-related settings.

For more on this topic, see Create Payout Distribution.

Account Capital Calls

Bulk update capital call amounts, dates, symbols, and account numbers.

  • If no call date is included for the account in the upload, the security's call dates will be used.
  • For more on this topic, see Capital Call Dates.
Account Committed Capital

Bulk update committed capital details, including the committed capital amount, account number, and symbol.

For more on this topic, see Committed Capital Securities.

Account Excluded Securities

Bulk update accounts to mark securities as included or excluded from either performance or billing.

For more on this topic, see Excluded Securities.

Billing Definition Information

Create new billing definitions or update existing billing definitions.

For more on this topic, see Understanding Billing Definitions.

Billing Definition Rate Tiers

Create or update the rate tiers for your billing definitions.

For more on this topic, see Understanding Billing Definitions.

Billing Group Accounts

Assign or change accounts within billing groups and set common properties.

For more on this topic, see Understanding Billing Groups.

Billing Group Adjustments

Create or change billing adjustments and discounts for billing groups and accounts.

For more on this topic, see Understanding Billing Groups.

Billing Group Information

Create billing groups or make changes to existing billing groups.

For more on this topic, see Understanding Billing Groups.

Billing Payment Details

Add or update payment status (Unpaid, Partially Paid, or Paid) and add a reconciliation note.

For more on this topic, see Payment Status (Payment Details).

Billing Prior Outstanding Balance

Include the current prior outstanding balance for the account and billing group.

For more on this topic, see Include Prior Outstanding Balance.

Capital Call Dates Add capital call dates to a manual security marked as committed capital.

For more on this topic, see Committed Capital Securities.

Client Information

Add or update client email, first, middle, and last name, Household, and a variety of other data available in on the Client panel.

Household Asset and Liability Values

Add or update manual assets in bulk, including asset/liability type, description, balance or value, and Household.

For more on this topic, see Create, Edit, and Delete Assets and Liabilities.

Household Assets and Liabilities

Add or update manual assets and liabilities in bulk, including Household, description, type, primary owner email, category, and ownership type.

Household Information

Add or update information about the Household such as addresses, logo, upload IDs, service team, custom fields, and more.

When creating Households by upload, use the following order:

  1. Create the Household and assign other attributes, if necessary, using the Household Information upload data set.

  2. Add members to the Household using the Household Members upload data set.

For more on this topic, see Learn More About Households.

Household Members

Add or update information about the members assigned to a Household such as membership type, the primary Household of each member, the include in performance/reporting flags, general account information, and more.

When creating Households by upload, use the following order:

  1. Create the Household and assign other attributes, if necessary, using the Household Information upload data set.

  2. Add members to the Household using the Household Members upload data set.

For more on this topic, see Learn More About Households.

Manual Security Snapshot

Add or update Manual Security Snapshot data.

For more on this topic, see Manual Securities and Manual Security Snapshots.

Ownership Distribution

Add or update information related to partial ownership accounts.

For more on this topic, see Understand Partial Ownership Accounts.

Target Allocation

Add or update the target allocations for individual accounts and groups.

For more on this topic, see Target Allocations.

Target Allocation Component

Add or update categories and targets and assign them to a target allocation that you created.

For more on this topic, see Target Allocations.

Transactions Indicate whether transactions are intra-group flows.

For more on this topic, see Intra-Group Flows.

Tamarac Trading Upload Data Sets

The following are available for Tamarac Trading users:

Upload Data Set What It Does More Information
Account Alternate Security Sets Associate alternate security sets in individual accounts; alternate security sets allow you to maintain fewer models by creating different Security Level models to assign to different account types.
Account Holdings Create or change security holdings in an account by upload.
  • This data usually comes from your portfolio accounting system (PAS), though you can make changes to holdings by upload.
  • If you upload any field in this data set, the accounts in which you upload data will save and you will lose any existing rebalances in the account.
Account Security Restrictions Add or update security restrictions and restriction details to the individual accounts you specify.
  • If you upload any field in this data set, the accounts in which you upload data will save and you will lose any existing rebalances in the account.
  • For more on this topic, see Security Restrictions.
Account Substitute Securities Add, update, or delete account-level substitute securities.

To delete a substitute, enter Delete in the desired row.

Leave the Upload Action column blank to create or update security substitutes automatically, or enter delete or create to more specifically control the action performed.

For more on this topic, see Security Substitutes.

Allocation Model Members

Add or update submodels in an existing Allocation model and specify model details such as rank and min/max values.

When creating Allocation models by upload, use the following order:

  1. Create the Allocation model name and assign other attributes, if necessary, using the Allocation Models upload data set.

  2. Add submodels and other model details to the Allocation model using the Allocation Model Members upload data set.

The upload may fail in the following instances: 

  • The weight of the submodels doesn't equal 1, or 100%.

  • The model isn't established as a rank-based model but you add ranks to the model.

  • In rare cases, the model contains securities that don't exist or aren't recognized by Tamarac Trading yet.

For more on the topic, see Create, Edit, and Delete Allocation Models.

Allocation Models

Create or change an Allocation model name.

When creating Allocation models by upload, use the following order:

  1. Create the Allocation model name and assign other attributes, if necessary, using the Allocation Models upload data set.

  2. Add submodels and other model details to the Allocation model using the Allocation Model Members upload data set.

Alternate Security Set Settings Create or change alternate security sets and specify additional details such as rank and min/max values, then associate the alternate security set with an existing Security Level model.
Cash Reserves Create or update cash reserves in the individual accounts you specify.
  • You can use this upload to update time-bound cash reserves. For example, you can identify RMD clients using a saved search, then use that saved search to generate the Cash Reserves bulk report. You can then update the start date to the next year, then upload that data back into Tamarac Trading.
  • If you upload any field in this data set, the accounts in which you upload data will save and you will lose any existing rebalances in the account.
  • For more on this topic, see Cash Reserves.
Custom Input Symbols Map securities to a custom symbol you specify or modify existing security mapping.
  • This upload allows you to take an unrecognized symbol that exists in your portfolio accounting system (PAS) and maps that symbol to an alternate symbol in Tamarac Trading.
  • The Custom Input field is the unknown security that you want to map the existing tickers to. The specific fields in this upload are available in Data Specifications.
  • For more on this topic, see Security Mapping.
Industry Group Restrictions Add or update industry group restrictions in individual accounts.
  • If you upload any field in this data set, the accounts in which you upload data will save and you will lose any existing rebalances in the account.
  • For more on this topic, see Industry Group Restrictions Setting.
Model Priorities Set model priorities for asset location labels.

After establishing asset location preference labels, use this upload data set to set model priorities for those asset location preference labels.

 

Order Information Add reason for trade notes to orders in bulk using each order's order ID. This upload must be enabled in Rebalancing System Settings.
Recent Trades Add or update recent trades made outside of Tamarac Trading to individual accounts for the purposes of avoiding wash sales.
  • This upload will not update or change account holdings.
  • If you upload any field in this data set, the accounts in which you upload data will save and you will lose any existing rebalances in the account.
Securities in Security Level Model

Add or update securities in an existing Security Level model and specify model details such as rank and min/max values.

When creating Security Level models by upload, use the following order:

  1. Create the Security Level model name and assign other attributes, if necessary, using the Security Level Models upload data set.

  2. Add securities and other model details to the Security Level model using the Securities in Security Level Model upload data set.

The upload may fail in the following instances: 

  • The weight of the securities doesn't equal 1, or 100%.

  • The model isn't established as a rank-based model but you add ranks to the model.

  • In rare cases, the model contains securities that don't exist or aren't recognized by Tamarac Trading yet.

For more on this topic, see Create, Edit, and Delete Security Level Models.

Security Level Models

Add or update a Security Level model name.

When creating Security Level models by upload, use the following order:

  1. Create the Security Level model name and assign other attributes, if necessary, using the Security Level Models upload data set.

  2. Add securities and other model details to the Security Level model using the Securities in Security Level Model upload data set.

For more on this topic, see Create, Edit, and Delete Security Level Models.

 

Substitute Securities Add or update global security-level substitute securities.

For more on this topic, see Security Substitutes.

Trade Group Security Settings

Add or update trade file group settings for individual securities, allowing you to customize trade files by group.

For more on this topic, see Trade File Group Settings.

Trades for Reconciliation Add or update trades that have been executed according to your portfolio accounting system (PAS).
  • This upload data set defines executed trades that normally flow from your PAS into Tamarac Trading and can be used for reconciliation purposes.
  • For more on this topic, see Include Trades For Reconciliation For.

Upload Data Sets and Bulk Report

One of the easiest ways to update large amounts to data is to use bulk reports. You can run a bulk report of existing data, then use this data to upload data changes. This is the workflow to change existing data: 

  1. Bulk report.Generate and run a bulk report using the columns you choose in the upload format. Download the report and open it in your spreadsheet program. For a list of available bulk reports in upload format, see Bulk Report Descriptions.

  2. Update data.In your spreadsheet program, update the fields that require update.

  3. Upload.Upload the updated data from your spreadsheet back into Tamarac Trading on the Upload page. For more information on uploading data, see Uploading Data.

important

For more information on creating and using bulk reports, see Create, Edit, and Delete Bulk Reports.