How to Edit Asset Values - and - the 'Assets as of 'Date
How to Download/Export Holdings to an Excel Spreadsheet
Investment Screener - Customized Holdings Download
At this point your clients have been created. Now you will need to know how to actively manage them. Please read the material below for a better understanding of how to operate within a client's account. Please Note: in order for changes to be reflected in your Monitoring Report you will need to have that quarter's Monitoring Report in a Draft status. The Monitoring Report can be moved 'Back to Draft' by clicking the action button ':' in the top left corner of the Monitoring Report overview and selecting that option.
UPLOADING HOLDINGS VIA EXCEL
- Click into the Client/Household you wish to update
- Click into the Active Account you wish to update.
- Select the upload arrow from the icons at the top right
- Select to upload From Excel.
**PLEASE NOTE: an excel upload WILL NOT override any holdings from your list - it will append the new funds from the upload and update the values on any funds that were already in the lineup (prior to your upload). If any funds need to be removed you will need to do this in a separate step. - Select the appropriate file, the type of identifier you have listed in your spreadsheet (Ticker, CUSIP, Sec ID), then assign the correct column/s to the data point/s.
Once you are done with the above steps, click the BLUE IMPORT button in the bottom right of the screen. A review summary of what you imported will pull up and notate how many funds were added, and if any were skipped (due to it being a duplicate). When you have finished viewing the summary click the small 'x' in the upper right and your import will be completed. 
HOW TO MANUALLY ADD HOLDINGS
- Click into the Client/Household you wish to update.
- Click into the Active Account you wish to update.
- Click the +NEW HOLDINGS button
- You will be able to search for funds one by one by typing information into the first line, or you will be able to search for multiple funds by CUSIP or Ticker by adding a list in the box. To add the holdings, click on the name of the fund or click the FIND TICKERS or CUSIPS.
HOW TO EDIT ASSET VALUES - and - the 'Assets as of' Date
- From the HOLDINGS page within the Client click the Pencil Icon.
- On the left side (in the area that is highlighted) you can change the 'assets as of' date, if necessary. Over to the right (in the highlighted area) you will be able to type in each asset value you wish to change, then click the blue SAVE button in the top right.
HOW TO DELETE HOLDINGS
Within a client account there are two (2) ways to delete funds.
- Put a check mark in the box to the left of each fund you wish to delete and then click the 'trash can' icon.
- Click the 3 vertical dots to the far right on the row of a fund you wish to delete and select 'Remove Holding.'
HOW TO DOWNLOAD/EXPORT HOLDINGS TO AN EXCEL SPREADSHEET
- From within the Client Account click on the 'Download Holdings Icon.' Once the download is completed the file will appear in your downloads (which is an area that varies from web browser to web browser).
INVESTMENT SCREENER - CUSTOMIZED HOLDINGS DOWNLOAD
The Custom Download will allow you to download Account Holdings with selected data points applied. To use this feature you will need to create a SAVED SEARCH within the Investment Screener. The SAVED SEARCH will be available for future use, and you can create others, as well. To get started click on the INVESTMENT SCREENER tab from the dashboard on the left side of the screen.
Then click NEW SEARCH. 
On the initial screen that comes up select all of the DATA POINTS you wish to include in your CUSTOMIZED HOLDINGS download. If you would like to add other DATA POINTS click on CHANGE DATA POINTS in the upper right area of the screen and then select additional data points and save. Once the additional data points are selected they will show on the initial screen - and then you will need to switch the 'toggle button' to green to add it. Finally, with your data points selected click the VIEW RESULTS button.
On the results page you will see a 'Floppy Disk' icon in the upper right corner. Click on that icon and a small window will pop up.
You will now be able to name the search and click SAVE. The search will now be saved until you delete it or edit it to change the data points.
To run the CUSTOMIZED DOWNLOAD click into your client and then click on the account names to proceed to the HOLDINGS screen. Then click the Custom Download icon in the upper right area.
From here select the SAVED SEARCH you wish to utilize, and also the month end you would like the performance data to pull from. Then click the download button. Once the download is completed the file will appear in your Report Downloads Folder at the top Right corner of your screen .
