Rev. Date May 29, 2020
This functionality is available for Venn Pro users only.
Welcome to Venn!
We have uploaded a demo portfolio for all new users so you can start viewing Venn's functionality and analysis right away. The demo portfolio is an illustrative example of strategies and investments to show what portfolio set up on Venn can look like.
How can I create my own portfolio?
You can keep or delete the demo portfolio and add your organization’s master portfolio at any time. Venn provides step by step directions for new users on how to set up your organization’s master portfolio. Click the “Set Up Your Portfolio” button on the homepage.
Upload Your Data
After setting up your master portfolio, you can upload and/or update all data associated with your account in the upload tool, including:
- All investment returns (whether or not they are currently in your portfolio)
- Benchmark returns (when the specific benchmark is not in Venn's Investment Library)
Step 1: Use a time series format for the initial data upload as well as any ongoing data updates, one example of a vertical template is below :
Step 2: Once you have your data in a time series format, click on the "Libraries" tab on the left frame of Venn and click on the "Upload Returns" button at the top right of the screen.
From here, you will be able to upload a file of returns in .csv, PDF, or Excel, and have the option to copy and paste return streams.
Once the data is loaded, you will see a preview of your file and can click “ACCEPT & CONTINUE.” Please note that the preview window only captures the top, left portion of data in your file.
Consistency checks are performed on uploaded data to assist in identifying errors such as blank cells and odd formats (e.g. N/A).
Once uploaded, all return streams are available in your Investment Library for standalone or portfolio analysis.
For all future data updates, use this same process. Just make sure that the return streams you upload for updating purposes share the same name (first row of the spreadsheet) so that Venn can match the data. When updating data for existing investments you can choose to:
- Overwrite the entire series (e.g. you uploaded the wrong data or it was not formatted correctly)
- Overwrite just the overlapping months (e.g. if there was a data revision),
- Append the data (e.g. if you are adding in a few months to the end of the series on Venn).
Once all your data has been uploaded, you are ready to set up additional portfolios on Venn.
Select "Libraries" on the left side of the menu and click "Create a New Portfolio." You can name your portfolio and "Create new portfolio from..." scratch or from another portfolio already on Venn.
- Strategy/Asset Class: To add a strategy or asset class, first select the three dots next to the name of the portfolio (the ellipsis). From there, you can click "Add a strategy." You may add as many strategies/asset classes as you'd like. To create a sub-strategy within a strategy, follow the same process by first hovering over the strategy you'd like to add the new sub-strategy to, clicking the three dots and then selecting "Add a sub-strategy".
- Investments: Once you've added one or multiple strategies/asset classes, hover over the desired one and click the three dots on the right side to add an investment under that category. Select "Add an investment" and begin searching for the desired investment. You may select an investment that you previously uploaded or an investment already loaded in Venn. Repeat these steps to add all the individual investments under the appropriate strategies.
Once you've added all the desired strategies/asset classes and investments, you can save this portfolio. To make it your master portfolio, simply go to Portfolio Settings page on the left side of the menu and select the desired portfolio in the dropdown under "Set master portfolio."
 This button is not available for new users on Venn that are joining organizations that have already set up their master portfolio.
 The uploader can support a number of formats and templates are included for the following: Excel vertical template, Excel horizontal template, Excel database template, Excel returns grid template, CSV vertical template, CSV horizontal template, CSV database template, CSV multi-table template, CSV returns grid template, PDF vertical template, PDF horizontal template, PDF database template, PDF returns grid template.
This document highlights certain aspects of this analytic. As an overview, it does not discuss all material facts or assumptions. Please see Important Disclosure and Disclaimer Information.