Finding a client's Risk Number is a great way to analyze how much risk they want, but what about how much risk they have in their current portfolio? Advisors need a way to compare the client Risk Number to the portfolio Risk Number, which means importing current holdings data into Riskalyze. Riskalyze has direct integrations with many data sources, listed on our Integrations page. If your data source isn't listed, the following guide explains how to import client holdings from an excel file instead.
Export Holdings from the Custodian
First, export the client's holdings from the custodian. From the custodian's dashboard:
- Find the client (or household) assets page.
- Export the holdings to excel (XLS, XLSX, or CSV) and save to your desktop. Don't change anything in the spreadsheet.
Note: The export file should include ticker symbols and market value for each holding.
Import into Riskalyze
Now it's time to import the portfolio into Riskalyze!
- Start on the Advisor Dashboard
- Locate and open the desired Client profile
- Click + Create Portfolio
- Set account type to Funds, Stocks and Other
- Click Import File
- Select the appropriate custodian from the list
Note: Riskalyze will remember the selected custodian and set it as the default for future imports. - Drag-and-drop the custodian file into the import window, or use Choose File to find and select it in a file menu instead.
That's it! The client's portfolio has been imported into Riskalyze. Repeat the export and import steps as needed to update accounts in the future (for example, before each client meeting).
Pro Tip: Want to learn about how to make importing portfolios even easier? Check out our Riskalyze Academy Lesson on our integration options.