List of Tutorials by Topic

  • 1

    Searching for Tutorials

    • How to Search for Content
  • 2

    Investment Model (Managing Assets)

    • How to Create New Entities - Single Entry Option

    • How to Create New Investments - Single Entry Option

    • How to Create/Edit Entities (Spreadsheet Imports)

    • About the Special Entity Type Entity-Level Property

    • How to Create/Edit Investments (Spreadsheet Imports)
  • 3

    Managing Properties & Tag Sets

    • 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

    • About Tag Sets

    • 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

    • 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

    • Recalculating Booked Performance When Booking Values for "One Day" or "Day Range"

    • "Use Blended Values" (Booked + Live Data): Interval Statistics Performance Report
  • 5

    Transactions

    • Introduction to Transactions (Methods to Add Transactions, Transaction Groups, Impact of External/Internal on Performance Estimates)

    • Overview of Basic Transaction Properties

    • Entering Drawdown Fund-Related Transactions

    • Example "Above the Portfolio" Transaction Group (Investor Buy into Portfolio)

    • Checking for Mismatched Values Using the Above-Below Mismatch Check Report

    • How to Upload New Transactions using a Spreadsheet Formatted for Import

    • Using the PrimaryTxOffset Column to Create Transaction Groups

    • Transaction Imports: Creating Unique Transaction Import Numbers for Use When Updating Existing Imported Transactions

    • About the Import Trail (View Transaction Upload Details, Obliterate Transactions)

    • Using the Balance Cash Tool in the Transaction Grid Editor (Requires Setting a Default Tx Cash Account)

    • Deferred Cash Transactions
  • 6

    Benchmark

    • How are Benchmarks Managed in Solovis

    • Creating a Single Entity Benchmark

    • Creating a Weighted Benchmark

    • Creating a Flat Return Benchmark

    • Creating an Excess Return Benchmark

    • How to Assign a Benchmark to an Asset
  • 7

    Asset Selection Sets

    • About Asset Selection Sets

    • Asset Selection Set Criteria Overview

    • Using Asset Selection Sets with Upload Templates

    • How to Create and Save an Asset Selection Set

    • How to Create an Ad Hoc Asset Selection Set
  • 8

    Solovis Excel Plugin

    • Excel Plug-in Export (Copy Table Reference as Data Set in Excel)

    • 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

    • Drawdown Investment Monthly Cash Flows & Composite Drawdown Monthly Cash Flows Reports

    • Behind the Scenes: Drawdown Investment Monthly Cash Flows & Composite Drawdown Monthly Cash Flows Reports

    • Drawdown Investment List Report Overview

    • Drawdown Investment List Report: Uncovering Helpful NAV Details

    • Interval Statistics (Drawdown Related Statistics Set Options -PME Public Market Equivalent Analysis, Annualized IRR, Cumulative IRR, Include Drawdown Stats)
  • 10

    Portfolio Analytics Reporting

    • Interacting with Portfolio Analytics Reports

    • Sorting, Grouping, Filtering

    • Table and Column Settings

    • Select Columns, Add Custom Column

    • 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

    • Introduction to Exposure Data Reports
  • 11

    Custom Report Stack Definitions

    • 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
  • 12

    Data Reconciliation & Review Process

    • Transaction Data Reconciliation: Cash Account Balances Report

    • Above-Below Portfolio Mismatch Check Report Overview

    • Market Value Data Reconciliation: Above-Below Mismatch Check Report (Value Comparison - Entity-Below Value Deltas)

    • Market Value Data Reconciliation: Above-Below Mismatch Check Report (Value Comparison - Entity-Above Value Deltas)

    • Data Review Process
  • 13

    Performance Data

    • How to Enter and Import Performance Data

    • Creating a Ready-Made Upload Template with the ‘Create Performance Upload’ Link
  • 14

    Liquidity Models

    • 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
  • 15

    Exchange Rates/Currencies

    • Currency and Currency Pairs (Exchange Rates, FX Rates)

    • Uploading Exchange/FX Rates