TABLE OF CONTENTS
- Custom Columns and Ordering
- Custom Bucketing
dv01's Strats tool is one of the most popular and widely used functions in our app, and for good reason: it provides nearly unlimited ways to format and display your collateral data and generate customized strat reports. Available across all product lines, our Strats tool displays an array of fully customizable stratification tables for the selected datasets. You can add "primary" strat tables for the fields available in your dataset, then use "secondary" and "tertiary" level strats to slice and dice your primary strat attributes into a more detailed breakdown of your collateral.
Strats for examining individual datasets are available in Securitizations, Portfolio Surveillance, and Tape Cracker. Comparing two or more datasets (with the exclusion of Tape Cracker, which does not support the comparison of multiple datasets), can be done in Intelligence.
We provide a variety of ways to customize your strat tables, along with a few other features you may find useful:
- Custom Columns and Ordering: Click the column icon to select the columns you want to hide/display, and/or to edit the order in which your columns are displayed. You can adjust the columns on all strat cards by using the column icon in the Settings card, or use the same icon to adjust columns on a per-strat basis in a specific strat card.
- Custom Bucketing: You can edit the numeric buckets and band sizes for your strat tables on a field-by-field basis by clicking the gear icon.
- Exporting Strat Reports: Easily export strats in a variety of formats. Frequently used formats can be saved and reused as templates to streamline your workflow.
- Saved Views: You can save a specific strat configuration so that you don't have to recreate it every time.
Custom Columns and Ordering
Creating Custom Columns Using Aggregations
By default, dv01 displays commonly used default columns, depending on the available fields in your chosen dataset(s). In addition to using the Edit Columns feature, you can also add custom columns derived from existing fields in your dataset by using our aggregation functions.
To create a custom column, start by clicking the column icon on the Strats page. This will open a drawer containing the standardized list of available dv01 fields, along with any previously created custom columns. To create a new custom column, first click the Create New Column button, which will bring you to a new screen in the drawer.
Next, name your column, decide which function you would like to use, select the column you would like to run the function on, and filter your column by one of the defined value fields in the data set. dv01 provides the following aggregation functions: Average, Weighted Average, Non-Zero Weighted Average, Count, Percent of Total, Sum Maximum, and Minimum.
For example, to create a column that displays the non-zero weighted average of all loans in a dataset that have full documentation, you would select Non-Zero Weighted Average as the function, Current Actual Balance as the target column, Documentation Type as the filter column, and Full as the filter by condition value.
Finally, after naming and creating your column, click the Save New Column button in the top right corner. You will then be taken back to your list of columns, where you can select and apply the newly created one.
Reordering and Selecting Columns
Beyond creating new columns, you can also reorder and change displayed columns after clicking the column icon. To select which columns you would like to display or hide, toggle the checkbox next to the relevant column name. To reorder your columns, click and drag the rows for each column into your preferred order.
You can edit your columns globally by selecting the column icon in the strat settings card, or you can edit your columns for a specific field by selecting the column icon in the corner of an individual strat card.
Editing Your Buckets
While dv01 automatically applies our default bucket settings to your selected dataset, these settings are easy to customize. Click the gear icon located in the top right corner of the strats settings card (these are also located on each of the strat cards for ease of use, but there is currently no ability to set global buckets and then edit individual sets of buckets). This will open a screen where you can edit the buckets for each of the fields in the dataset.
By default we display linear buckets for every field, constructed from three parameters: the lower bound ("Range From"), the upper bound ("Range To"), and the increment (or size) that you want each bucket to be.
Creating Advanced Buckets for Numeric Fields
For numeric fields, dv01 also provides the ability to create customized nonlinear bucketing ranges; simply toggle each field from linear to advanced to display an input box for your custom query. Use our curve creator syntax (similar to our cashflows page) to write out your advanced bucketing query. For example, if you're looking for more granularity within two specific FICO score bands, you could stack two notations into a single query by typing, "600 to 700 by 20; 700 to 800 by 10". The FICO band of 600-700 will be split into increments of 20 (resulting in 5 buckets), and the band from 700-800 will be split into increments of 10 (resulting in 10 buckets).
You can see more about creating custom buckets here.
We provide three different export formats for your strat reports. You can choose to export your strats as 1) a spreadsheet with all strats on a single sheet; 2) a spreadsheet with a single strat table on each separate sheet; or 3) all strats in a single PDF document.
To export all your strat tables, click the download icon in the top right corner of the strat settings card and select your desired format. To export an individual strat table only, click the download icon in that specific strat card.
If you frequently need your strat reports displayed in a specific format, our saved view functionality allows you to quickly change your layout. First set up your strat report with your desired configuration of columns and buckets. Next, click the Save This View button located above the strat settings card, where you will name and save it.
To load a previously saved view, click the Saved Views button, select, and apply. In the event that strat cards do not load when you apply a saved view, it is most likely because the saved view contains fields that do not exist in your current dataset. You can make changes to the saved view (such as clearing the primary strats for cards that don't load) using the settings card, or you can select another view.