Back	Home > Tamarac Reporting > Data Setup & Calculations > Data Setup > Cash & Securities > Create a Manual Security

Create a Manual Security

Contents

Introduction

As an advisor, it's important to track alternative investments on performance and holdings reports so you can give the most informed financial guidance. You can create, maintain, and track alternative investments to report on IRR, TWR, and realized and unrealized gains and losses directly within Tamarac Reporting.

Tracking manual securities requires some basic setup before the securities appear on your reports. This page provides steps for how to create a manual security.

For more information about manual securities and manual security snapshots, see Manual Securities and Manual Security Snapshots.

Create a Manual Security

To set up a manual security from the Securities page, follow these steps:

1. On the Setup menu, under Security Settings, click Securities.

2. Under Actions, click Create New Security.

   

3. Enter the Symbol and Security Type and click Next.

4. Complete the fields on the General tab:

   

   Description Symbol CUSIP Dividend\Income\Rate\%

   Qualified Status State Taxable Federal Taxable Treat as Committed Capital Security and, if selected, Fund Inception Date and Capital Call Dates.

5. Complete the fields on the Reporting tab:

   Treat Security as Cash Report Gains and Losses on the Realized Gains/Losses Report Always Report as IRR on Position Performance Report

   Globally Exclude From Performance Globally Exclude From Billing Benchmark Categories

6. Complete the fields on the Rebalancing tab. For more information on the available settings, see the following:

   • Security Restrictions

   • Security Substitutes

   • Trade File Group Settings

   • Securities Custom Settings

   • Security Mapping

7. On the Custom Fields tab, complete the values for any custom fields you've created, if desired. For more information on custom fields, visit Security Custom Fields.

8. Click Save.

Create Multiple Manual Securities with an Upload

You can create multiple manual securities at once with a Security Information bulk upload.

Note that when creating securities using an upload, the security type in the upload must exactly match the security types available. For example, if you create an upload with Equity rather than Equities, or if you enter Manual securities rather than simply Manual, the upload will fail. See Security Type for a complete list of available security types.

For more information on using uploads, see Understanding Bulk Data Uploads.

To add create manual securities using a bulk upload:

1. On Reports, under Global Reports, click Bulk Reports.

2. Create a Security Information bulk report. Add the following columns:

   • Symbol (required)
   • Security Type (required)
   • Security Description (recommended)
   • Category classifications such as Asset Class or Sector (recommended)

   

   For more information about bulk reports, see Understanding Bulk Data Exports and Bulk Report Descriptions.

3. Save the bulk report.

4. Generate the bulk report. That this will generate a list of the security information for the account or group you run the security on. 

5. Open the CSV file on your computer. Delete the existing security information, keeping the headers. Populate the columns with the desired manual security data.

   

6. In Tamarac, under Setup, click Upload.

7. In Add an upload data set, choose Security Information.

8. Select the Data source and use the edited CSV file from your computer to add data to the upload. For more information about creating upload data sets, see Understanding Bulk Data Uploads.

   

When the upload is complete, you'll see the new manual securities on the Securities page.