Investment models are security specific portfolio models. These models can be created by both the firm administrator (available for use by all advisors within the firm) or by advisor (advisor specific). These investment models are constructed with security tickers and allocation percentages, and once created, become available in the portfolio analysis tool.
Where to create a Firm Investment Model
Add a Firm Investment Model in Admin settings > Investment Models
- When logged in as an administrator, click on the Settings tab in the top right of the screen.
- Next, click on the Investment Models tab, on the left side.
- Click on “Add New Investment Model”
Where to create an Advisor Investment Model?
Add an Advisor Investment Model in Settings > Investment Models
- When logged in as an advisor, click on the Settings tab in the top right of the screen.
- Next, click on the Investment Models tab, on the left side.
- Click on “Add New Investment Model”
Adding a new investment model will allow you to view that model in the portfolio analysis tool, or use it when comparing portfolios.
How to create an Investment Model?
Creating an Investment Model is similar to adding a portfolio in the portfolio analysis section.
- Name your portfolio and add your holdings using one of 3 options
Adding tickers one at a time
If you only have one or two tickers to enter, you can manually search for the security by entering the ticker or typing the security name.
In the portfolio creation modal, enter a security ticker, and then choose from the search results.
When adding a security to a portfolio, you can choose between entering the number of shares or the dollar value of the position. If you enter number of shares are used, then the amount will be calculated using the price of the security from the last day of the previous month.
Uploading the CSV template
If you have a big list of tickers, you can download a csv file right here [show link] and populate the ticker and the shares OR amount , upload the file and inStream will determine the value.
Download the CSV template at the bottom of the portfolio creation modal.
We suggest that as you collect account statements, to transfer that data into a csv template. The template itself is very simple, with only three columns: Ticker, Shares, and Amount.
Enter your data into a csv for easier uploading.
When entering data into a CSV template, here’s a few pointers to keep in mind:
Each row with data must have a ticker symbol
- If shares are left blank, please be sure to enter an amount
- If amount is left blank, please be sure to enter number of shares
- If values are entered for both shares and amounts, the csv uploader will use the number of shares
- Data may be formatted as a dollar amount, or as a number.
- No matter how many decimals are entered, the CSV uploader will round to the 1000th decimal point.
Logic is applied to the CSV template to improve user experience. Please see the pointers above.
Once your csv is ready, be sure to save it for easy access, and then upload the file by clicking on the Blue Upload button in the portfolio creation modal.
Pasting securities to create a portfolio
The third method, allows you to copy and paste your data. After you’ve compiled holdings data into the csv template, you can literally copy and paste that data into the inStream portfolio creation modal. This is great if you’re throwing together a handful of securities, but even if you have a portfolio of 100 securities, this will still work.
Using exactly the same csv upload template, simply enter in your data.
When copying the data, there are a few pointers to keep in mind.
- Ignore the headers when copying your data
- If using amounts, please be sure to copy the blank shares column
- If using number of shares, it is not necessary to copy a blank amount column.
When copying data, please be aware of the pointers above.
4. Once your are done adding securities remember to click SAVE.
What if Morningstar doesn’t recognize my security?
If Morningstar doesn’t have data on a security, you can enter the ticker and click add, then you can type in the name, choose an appropriate asset class, and apply the number of units and value. This is a useful for individual bonds and any security where we are not getting historical data.
What if I don’t agree with Morningstar’s asset classification?
Even if we do have data for a security, you might still disagree with Morningstar’s asset class categorization, and this is where you can make a change. We have 56 asset classes available and you just select the appropriate asset class for that security. This is also where you can edit the units or the total value of the position. Keep in mind that we use pricing data as of the end of the last month, and that gets updated around the 5th day of each month.
Once the data is pasted, you can revise the allocations or change the asset class categorization.
Upon saving the investment model, the portfolio will then be available to be used in portfolio comparisons, and also in plans.
Comments