Importing Data

Many investors and advisors use spreadsheets to keep track of private asset data and held-away transactions for their clients because popular custodians are inflexible. Our software has import and export functions that can help organize this data without losing the flexibility of any spreadsheet tools already built by our users.

Overview

The Import feature make it easy to upload large portfolios quickly. You can also request that we do it for you as well.  Once you've found the right translation from your fund admin or your own personal format, you can save the translation mappings and use them to update & add more positions over time.

• Users can import Entities, Accounts, Securities, or Events (e.g. new transactions, commitments, capital activity, and notes).

• Select from existing objects in their financial graph, such as entities, accounts, or securities. 

  

  This can be useful when uploading a long list of transactions in a single security, or uploading multiple investments of the same asset type like an angel portfolio

• Use smart expressions to create values using multiple columns of your upload file.
• Use excel functions to quickly adjust or format your input data
• Search for objects within our database in order to match them with input field data
  • When mapping data in a field to a saved object in our system, you can search for the object on the fly by each row
  • If your spreadsheet does not have the exact names as our system a search can help find the closest match

Events

When Importing new events, Here are a few tips which make the process easier

• create Securities and accounts and Entities which you are referencing prior to uploading new transactions 
• When using the .lookup function to find objects in the system, make sure you use the exact names, including spaces - partial names will be rejected.

Expressions

$in["fieldname"]

This input expression enables the user to use multiple columns of input data as the value in the newly created object. As an example, a user adding 50 new capital commitments can use a "compound expression" drawing from values in multiple columns like the clients name, account and the date of commitment.

####ADD IMAGE###

$excel.excel_function_name(param1,param2,[...])

The excel expression allows users to draw upon any excel function using either fixed variables or any column in the input data set. 

• Select a figure from multiple columns: $excel.MAX($in["Paid In Capital"],$in["Invested Capital"]) 

$lookup.findAccount("variable")

Users can use FindAccount, FindEntity, FindInstrument or FindEvent extensions of the lookup expression to search through their distributary portfolio. 

• The search covers name and description fields for most objects
• If no match is found, the row will now process and a waring will be provided to the user

$date.parse(datestring, formatString, referenceDate,[Options])

• datestring: this is the string in the csv file which you want to parse
• formatString: 

Managing Large Files

With large datasets, the importer is limited to 500 rows of data in a file by default. Please reach out to support@heldaway.ai to expand your importer to larger datasets.