SUMMARY

Before asking Tamarac to generate your 13F report, there are several data audits you must perform to ensure all the required information is accurate and up to date. This article explains how to audit options to ensure that the underlying security field is accurate and up to date.

MORE INFORMATION

All options must have an Underlying Security designated before generating the 13F report. Follow the steps below to verify that the field is populated using a bulk report.

  1. Under Reports, click Bulk Reports and Create Report.
  2. In Name, type a distinctive name to help you identify the report.
  3. In Report Type, select Security Information.  
  4. Add Underlying Security and Security Type to the Selected column list and click Save.
    2021-04-12_15-55-35.png
  5. Click Run Report for the report you have just created.
  6. On the Report Status page, click Download Report for the report you have just run. 
  7. Filter the resulting CSV file by Security Type to view all options. If any options do not have an Underlying Security designated, you will need to designate one.

Upload Underlying Securities in Bulk 

If you identify multiple options that do not have designated underlying securities, follow the steps below to add underlying securities in bulk:

  1.  Run a Security Information bulk report as described above, then make any desired changes to the Underlying Securities column.
  2. Under Setup click Uploads. 
  3. In Add upload data set, select Security Information and click Add.
  4. In Data Source, select Copy & Paste.
  5. Select all columns of data from the updated Security Information bulk report CSV file. Copy and paste the data into the Copy & Paste box, then click Upload. 
    2021-04-12_16-03-58.png
  6. Click Upload Status to check for any upload errors or warnings. 

APPLIES TO