Portfolix CRM

Portfolix CRM is a helpful tool. It makes managing portfolios easier and faster. It does many tasks for you, so you save time and make fewer mistakes. Portfolix works well with YieldBook for prices and a trading system for positions. This teamwork lets you get reports, change data, and look at prices and positions all by itself.

Benefits

Portfolix has many good points. It gives you real-time updates on market values and durations of accounts right in Excel. This way, you can see details about your accounts and their market values. You can also look closer at specific benchmarks to learn more. For example, you can see the value-weighted average duration of accounts managed against a specific benchmark, like Lehman Agg.

The system lets you look at many things, like duration, rating, and sector. You can mix these things to get a full view of your portfolio. Portfolix also helps you make and improve sector files from different data sources. This makes it easier to sort and manage securities.

Portfolix has features like conditional formatting to show outliers and historical snapshots for building risk/return models. You can do what-if analyses by entering new values and seeing how they affect the portfolio. The write-back feature lets you update higher-level data and automatically spread changes to lower levels.

Use Cases

Portfolix is great for many things. It can show market values and durations of accounts in Excel, with data updating in real-time. You can look closer at specific benchmarks to see details about managed accounts and their market values. For example, viewing accounts by benchmark can show the value-weighted average duration of accounts managed against a specific benchmark, like Lehman Agg.

The system supports many things for analysis, like duration, rating, and sector. You can stack these things to learn more. For example, mixing ratings and sector dimensions gives a detailed view of portfolio composition. Portfolix also helps you make and improve sector files from various data sources. This makes it easier to sort and manage securities.

Portfolix offers many dimensions grouped into categories like account-based, bond-based, mortgage-based, and municipal dimensions. These dimensions let you look at data in detail. You can view composites by benchmark or portfolio manager while breaking them down using bond-based dimensions.

The system works with Excel''s charting features for easy data visualization. It also supports adding new dimensions from existing Excel sheets or other data sources. Portfolix uses industry-standard OLAP technology running on Microsoft .NET Analysis Server. This ensures efficient data processing and query performance. It has been successfully tested on large datasets, including tick-by-tick trade and quote data on the NYSE.

Portfolix CRM is a reliable tool for portfolio managers. It helps automate and streamline workflows. Its teamwork with YieldBook and Excel, along with its advanced analytical capabilities, makes it a valuable asset for anyone managing portfolios.