How to Check Standard Dashboards
Prerequisites
We assume you have all prerequisites you may need, including:
- If needed: the VPN is configured to access the Finmars resources
- If needed: access to the Virtual Machine to work with the sensitive information
- Must have: registered in Finmars in the needed region environment (self-registered or registered by Finmars)
- Must have: having permissions set to allow continue with the Action in the Guide
Checking Standard Dashboards
- Go to the Dashboard tab in the left-side menu.
- At the top of the page (next to the save icon), you will see the current dashboard layout name. Click on this name to open the dropdown menu listing all available layouts.
- From this dropdown, select the standard dashboard you want to check. Here is an overview of Standard Dashboard Layouts:
- Overview – Displays a high-level summary of key financial metrics like NAV, P&L, cash flows, and balance trends. At the top of the Overview layout, you'll find the filter panel where you can adjust key parameters:
- Date From / Report Date – Define the time period for analysis. The Report Date will always display the balance as of the end of the selected day.
- Portfolios – Select which portfolios to display data for.
- Currency – Choose the reporting currency.
- Pricing Policy – Set the method for asset valuation.
Below the filter panel, there is a summary section displaying key financial metrics: NAV YTD, P&L YTD, Return YTD, Cash Inflow/Outflow YTD - Balance by Accounts – Displays a bar chart of the portfolio's asset balances by account.
- P&L by Accounts – Shows a breakdown of profit and loss per account.
- Balance History by Accounts – A time-series chart showing how portfolio balances changed over time.
- P&L History by Accounts – A time-series representation of profit and loss trends.
- Top Positions – Lists the best-performing holdings by total value.
- Worst Positions – Displays the weakest-performing assets, highlighting losses.
- Maturity layout provides insights into financial instruments based on their maturity dates. On the top panel, you'll find the filter panel where you can adjust key parameters:
- Portfolios – Select which portfolios to analyze.
- Currency – Choose the reporting currency.
- Report Date – Defines the analysis date, displaying data as of the end of that day.
- Pricing Policy – Determines the valuation method for instruments.
- Upper Section – Displays instruments sorted by maturity, including days to maturity, date, type, market value, price, position, and FX rate.
- Lower Section – Similar to the upper table but filtered by portfolio.
If no data is available, the tables remain empty.
- The P&L layout provides an overview of financial performance across different regions. The filter panel at the top allows customization of displayed data by adjusting key parameters:
- Portfolios – Select which portfolios to analyze.
- Currency – Choose the reporting currency.
- Report Date – Defines the analysis date, displaying data as of the end of that day.
- Pricing Policy – Determines the valuation method for instruments.
The main P&L table presents financial performance per region: - PnL Total – Displays total profit or loss per region.
- FX Variations – Reflects changes due to currency fluctuations.
- FX Trades – Captures executed foreign exchange transactions.
- Total – Summarizes the overall P&L per region
- The Collateral layout provides insights into the collateral positions associated with portfolios. The filter panel at the top allows customization of displayed data by adjusting key parameters:
- Portfolios – Select which portfolios to analyze.
- Currency – Choose the reporting currency.
- Report Date – Defines the analysis date, displaying data as of the end of that day.
- Pricing Policy – Determines the valuation method for instruments.
The Collateral table displays details related to collateralized assets: - Portfolio – Specifies the portfolio associated with the collateral.
- Instrument Type – Classifies the type of instrument used as collateral.
- Market Value – Displays the market value of the collateralized instrument.
- Collateral MV – Represents the collateralized market value.
- The Configuration Helper layout provides various system tools for managing workflows, performing calculations, importing/exporting data, and running analytics. Below is an overview of its sections:
- Workflow v2 – Contains options for managing workflow templates.
- Transfer Workflow Templates – Copy and paste JSON templates to create workflows in the workspace.
- Delete Workflow Templates – Remove all workflow templates from the current workspace.
- Import & Download – Facilitates importing and downloading various types of financial data.
- Import Instruments from FinmarsDB – Retrieves instrument data from the Finmars database.
- Import Prices from FinmarsDB – Fetches price data for specified instruments and dates.
- Download Prices – Downloads historical price data for all instruments.
- Download FX Rates – Retrieves foreign exchange rates for the selected date range.
- Finmars Analytics – Provides tools for analyzing imports and checking data completeness.
- Finmars Import Task IDs Analysis – Analyzes errors within a specified range of import task IDs.
- Finmars Price FX-Rate Completeness Report – Generates reports to verify the completeness of price and FX rate data.
- Calculations – Performs various financial calculations.
- Calculate Register Records – Computes register records for selected portfolios.
- Calculate Portfolio Price History – Retrieves historical pricing data for portfolios.
- Calculate Portfolio History – Calculates portfolio performance based on different parameters.
- Bloomberg – Integrates with Bloomberg API for data retrieval.
- Download Instrument Data – Fetches instrument data from Bloomberg.
- Download Prices – Retrieves pricing data from Bloomberg for specified instruments.
- CleanUp – Allows deletion of different types of data from the workspace.
- Options include deleting all entities, balance cache, transaction history, and more.
- Roll – Handles rolling forward pricing and FX rate data.
- Collect FX Rate – Collects FX rate data for the selected date range.
- Roll FX Rate – Rolls forward FX rates using the defined pricing policy.
- Collect Price – Gathers pricing data for selected instruments.
- Roll Price – Rolls forward price data based on the pricing policy.
- Workflow v2 – Contains options for managing workflow templates.
- The STD Manual Import layout provides a structured interface for manually uploading key financial data files into the system.
- Workflow Selection – Defines the import process to be used. The dropdown allows selecting different predefined import pipelines.
- Download Documentation – Provides a reference guide for file format requirements and upload instructions.
- File Upload Fields – Users can manually upload different data files.
- After selecting the layout, verify once again that the information displayed is correct and accurately reflects the current data status. If any discrepancies occur, refresh the data and layout by clicking the Refresh button in the top-right corner to ensure you're viewing the latest information.