Course Description
Are you looking for help on a specific function or topic? This section of Solovis Academy houses all short tutorials (2 to 10 minutes in length), is grouped by area of functionality and can be searched to locate relevant content.
Course curriculum
-
3
Managing Properties & Tag Sets
24:08-
How to Edit Entity & Investment Properties (One at a Time) & How to Use the Since Date to Capture How Property Values Change Over Time
-
How to Use Spreadsheet Imports to Update Property Values in Bulk & How to Use the Date Column to Effective-Date Non-Static Property Values
-
How to Create Custom Property Definitions
-
How to Add a Custom Tag Set (Part One)
-
How to Add a Custom Tag Set (Part Two)
-
How to Modify Existing Tag Sets
-
-
4
Market Values
49:12-
Introduction to the Value Estimate Updater & When to Manually Run It
-
Default Value Estimation Methods Based on Special Entity Types & How to Override Using the Value Estimation Method Property
-
Market Value Types & Custom Estimate Levels
-
How to View Archived Market Values
-
Market Value Grid Editor: How to Use the Market Value Grid Editor to Update Multiple Market Values in Portfolio Analytics
-
Market Value Grid Editor: Entering Estimated Returns to Calculate Market Value Estimates
-
Introduction to Market Value Spreadsheet Imports
-
Using the Create Market Value Upload Template Shortcut
-
How to Edit/Delete Existing Market Values Using Spreadsheet Imports
-
About Book Values
-
How to Book Values
-
Use Booked Values in Solovis Reports
-
Blended Book and Live Values (New Feature Feb 2020 Release)
-
-
5
Transactions
62:18-
Transaction Grid Editor
-
Example Subscription to Hedge Fund Transaction Entry
-
Example Subscription to Hedge Fund Offsetting Cash Leg Transaction
-
Example Investment into Public Equity Stock Transaction
-
Example Investment into Public Equity Stock Cash Leg Transaction
-
Example Above the Portfolio Transaction Entry (most relevant for family office, OCIO, and RIA Solovis clients)
-
Example Above the Portfolio Cash Leg Transaction Entry (most relevant for family office, OCIO, and RIA Solovis clients)
-
Example Net Capital Call from a Private Equity Fund Transaction Entry
-
Example Net Capital Call Offsetting Cash Leg Transaction Entry
-
How to Enter/Upload Transactions using an Upload Spreadsheet/Template
-
Transaction Upload Results and Import Trail
-
How to Edit/Delete Existing Transactions in the Gateway Portal
-
How to Edit Transactions using an Upload Spreadsheet/Template
-
How to Obliterate Uploaded Transactions
-
How to Use the Balance Cash Tool
-
Entering Deferred Cash Transactions
-
Checking for Mismatched Values Using the Above-Below Mismatch Check & Transaction List Reports (Part One)
-
Checking for Mismatched Values Using the Above-Below Mismatch Check & Transaction List Reports (Part Two)
-
-
8
Solovis Excel Plugin
21:26-
How to Download the Solovis Excel AddIn/Plugin
-
How to Create an Excel Plug-In Key for API Key Login Type Plugin Authentication
-
How to Copy a Table Reference into Excel (Solovis Excel Plugin)
-
How to Refresh Excel Data Sets using Download Options (Solovis Excel Plugin)
-
Using Parameter Permutations to Adjust Data Sets (Solovis Excel Plugin)
-
Adding a 'SolovisParams' Sheet for Parameter Permutation Transforms (Solovis Excel Plugin)
-
-
9
Drawdown Investment Reports
19:50-
Drawdown Investment Monthly Cash Flows Report (how to locate, prerequisites, how to resolve data source errors)
-
Drawdown Investment Monthly Cash Flows Report Parameters
-
Composite Monthly Cash Flows Report
-
Drawdown Investment List Report Overview
-
Drawdown Investment List Report Parameters Part 1
-
Drawdown Investment List Report Parameters Part 2
-
Interval Statistics (PME Public Market Equivalent Analysis, Annualized IRR, Cumulative IRR Statistics Set Parameter)
-
-
10
Portfolio Analytics Reporting
53:30-
Understanding the Date Parameter
-
Report Manipulation: Sorting and Grouping
-
Report Manipulation: Column Settings
-
Report Manipulation: Filtering
-
Report Manipulation: Modifying Table Settings
-
Report Manipulation: Show as Chart Report Option
-
Report Manipulation: Select and Adjust Report Columns
-
Saving Reports as Featured Links
-
Target Currency Report Option
-
About the Interval Statistics Report
-
Example Simple Interval Statistics Report Creation
-
Example Composite Interval Statistics Report Creation
-
Including Transaction Summaries in the Interval Statistics Report
-
Consecutive and Advanced Interval Sets (Rolling Intervals, Rolling Effect) - Interval Statistics Report
-
Use Booked Values in Reports
-
Exposure Data Related Reports
-
-
11
Reporting Tools (Design Lab)
39:08-
Design Lab - How to Open a Saved Report Template
-
Design Lab - How to Create a New Blank Report
-
Design Lab - Adding Pages to Reports
-
Design Lab - Add Content to Reports (Solovis Charts)
-
Design Lab - Add Content to Reports (Solovis Tables)
-
Design Lab - Portfolio Selection & Application to Solovis Data within Reports
-
Design Lab - Adjusting Portfolio Selection (Report Configuration, Page Configuration, Chart/Table Products & Parameters)
-
Design Lab - When to Use a Multi-Page Section in a Report
-
Design Lab - Add Content to Reports (Custom Text & Custom Text Templates)
-
Design Lab - Add Content to Reports (Headers and Footers)
-
Design Lab - How to Add Headers and Footers to Entire Report
-
Design Lab - How to Export a Report
-
-
12
Custom Report Stack Definitions
23:55-
How to Create a Custom Report Part 1 (Report Path, Add Report)
-
How to Create a Custom Report Part 2 (add blocks, tailor report settings)
-
Report Settings (Auto-Run, Hiding Block Headers)
-
Report Layout Options (tabbed orientation)
-
Adding Parameters Above Custom Report Stacks
-
Mapping Custom Report Stack Parameters to Report Blocks
-
How to Access, Modify and Delete Custom Reports
-
How to Move or Delete a Block from within a Custom Report Stack
-
-
15
Liquidity Models
34:11-
How to Create a Liquidity Model (Model Tab)
-
How to Create a Liquidity Model (Add Periods, Preview Model)
-
How to Create a Liquidity Model (Add Redemption Options, Link Investment)
-
Liquidity Reports and Analysis
-
How to Link a Liquidity Model to an Investment or Investments
-
Adding Tranches to a Liquidity Model
-
Modeling a Side Pocket in a Liquidity Model
-
Liquidity Models with Maximum % of Initial Units Redemption Options
-
-
16
Exchange Rates/Currencies
05:12