How to Check Standard Dashboards

Prerequisites

We assume you have all prerequisites you may need, including:

1. If needed: the VPN is configured to access the Finmars resources
2. If needed: access to the Virtual Machine to work with the sensitive information
3. Must have: registered in Finmars in the needed region environment (self-registered or registered by Finmars)
4. Must have: having permissions set to allow continue with the Action in the Guide
   

Checking Standard Dashboards

1. Go to the Dashboard tab in the left-side menu.
   
   
2. At the top of the page (next to the save icon), you will see the current dashboard layout name (it can differ from user settings). Click on this name to open the dropdown menu listing all available layouts.
   
3. From this dropdown, select the standard dashboard you want to check. 
   

   

4. Below you can find an overview of Standard Dashboard Layouts

Overview

Overview – Displays a high-level summary of key financial metrics like NAV, P&L, cash flows, and balance trends

Header

At the top of the Overview layout, you'll find the filter panel where you can adjust key parameters:

1. Portfolios – Select which portfolios to display data for.
2. Currency – Choose the reporting currency.
3. 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. -> Need to change in future for Periods like YTD, MTD etc
4. 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 category 

Balance by Accounts – Displays a bar chart of the portfolio's asset balances by account.

SCREENSHOT

Categories: 

1. *Currencies – Groups balances by currency.
2. *Instrument
   Types – Categorizes balances by financial instrument type (e.g., bonds, equities).
   1. Portfolios
      – Displays balances for different investment portfolios.
      1. Accounts – Shows balances at the individual account level (default setting).
      2. Countries – Groups balances by geographical region.
         

      P&L by Accounts – ShowsDisplays a breakdownbar ofchart showing the profit and loss perdistribution account.across different accounts.
      
      

      Categories: 

      1. PL Types – Filters P&L by different types of profit/loss (e.g., realized, unrealized).
      2. Currencies – Groups P&L by currency.
      3. Instrument Types – Categorizes P&L by financial instrument type (e.g., bonds, equities).
      4. Portfolios – Displays P&L for different investment portfolios.
      5. Accounts – Shows P&L at the individual account level (default setting).
      6. Countries – Groups P&L data by geographical region.

      Balance History by Accounts – AThis time-seriessection chartvisualizes showingthe howhistorical portfoliochanges in asset balances changed over time. The chart helps track trends in portfolio values, showing fluctuations across different accounts.
      

      

      Categories: 

      1. Currencies – Displays historical balance movements grouped by currency.
      2. Instrument Types – Shows changes in balances based on financial instrument types (e.g., bonds, equities).
      3. Portfolios – Allows users to filter balance history by portfolio.
      4. Accounts – Default view displaying individual account balances over time.
      5. Countries – Organizes historical balances by geographical region.
         

      

      Chart Type Options:

      1. Column Chart – Displays historical balances as bar charts.
      2. Line Chart (default) – Shows trends over time with connected data points.
      3. Table – Converts the visual chart into a tabular format for numerical analysis.

      Download Options:

      1. Download PNG – Saves the chart as an image file.
      2. Download CSV – Exports balance history data as a CSV file for further analysis.

      P&L History by Accounts – AThis time-seriesmodule representationvisualizes ofthe historical changes in profit and loss trends.(P&L) over time, allowing users to track financial performance trends across different accounts.

      

      Categories: 

      1. Currencies – Groups profit and loss data by currency.
      2. Instrument Types – Organizes P&L trends based on different financial instruments (e.g., stocks, bonds).
      3. Portfolios – Displays profit and loss trends per portfolio.
      4. Accounts – Default setting, showing historical P&L data at the account level.
      5. Countries – Groups profit and loss information based on geographical regions.
         

      Chart Type Options:

      1. Column Chart – Represents P&L data using vertical bars.
      2. Line Chart (default) – Shows P&L trends over time using connected data points.
      3. Table – Converts the graph into a tabular format for numerical analysis.

      Download Options:

      1. Download PNG – Saves the chart as an image file for reporting purposes.
      2. Download CSV – Exports the P&L history in a CSV format for further analysis in spreadsheets.

      Top Positions – Lists the best-performing holdings by total value.

      1. Name – The name of the financial instrument.
      2. Position – The number of units held.
      3. Total – The total market value of the position.

      Worst Positions – Displays the weakest-performing assets, highlighting losses.
      

      1. Name – The name of the financial instrument.
      2. Position – The number of units held.
      3. Total – The total market value of the position, often displayed in red to indicate negative performance.

      

      Balance Sheet (BS) Layout

      The Balance Sheet (BS) layout provides an overview of asset distribution by different categories, such as countries, accounts, or asset types.

      Header

      At the top of the BS layout, the filter panel allows for the adjustment of key parameters:

      1. Portfolios – Select which portfolios to analyze.
      2. Currency – Choose the reporting currency.
      3.  Report Date – will always display the balance as of the end of the selected day. -> Need to change in future for Periods like YTD, MTD etc
      4. Pricing Policy – Determines the valuation method for instruments.

      

      Matrix Component Editor

      To customize the BS matrix, users can access the Matrix Component Editor by clicking on the settings  icon in the top-right corner. The editor allows modifications to the data structure.

      

      Customization Options:

      1. Column (X-Axis) – Defines the grouping criteria (e.g., Asset Type, Country).
      2. Category (Y-Axis) – Selects the secondary grouping level (e.g., Country, CCY).
      3. Values – Defines the key metric displayed in the table (e.g., Market Value - MV).
      4. Calculation Method – Determines how values are calculated:
         1. Sum – Aggregates total values.
         2. Weighted Market Value – Adjusts MV based on weighting.
         3. Weighted Market Value Percent – Displays MV as a percentage.
         4. Weighted Exposure – Adjusts exposure levels.
         5. Weighted Exposure Percent – Displays exposure as a percentage.

      Profit & Loss

      The P&L layout provides an overview of financial performance across different regions

      Header

      At the top of the P&L layout, you'll find the filter panel where you can adjust key parameters:

      1. Portfolios – Select which portfolios to analyze.
      2. Currency – Choose the reporting currency.
      3. Report Date – Defines the analysis date, displaying data as of the end of that day.
      4. Pricing Policy – Determines the valuation method for instruments.
         

      

      The main P&L table presents financial performance per region:

      1. PnL Total – Displays total profit or loss per region.
      2. FX Variations – Reflects changes due to currency fluctuations.
      3. FX Trades – Captures executed foreign exchange transactions.
      4. Total – Summarizes the overall P&L per region

      Matrix Component Editor (P&L)

      To customize the P&L matrix, click the settings icon in the top-right corner. This editor allows modifications to the displayed data.
      

      

      Customization Options:

      1. Column (X-Axis) – Groups data by Asset Type, Country, Account, Portfolio, or PL Group.
      2. Category (Y-Axis) – Secondary grouping by Country, CCY, Account, Asset Type, or Portfolio.
      3. Values – Displays PnL Total (profit and loss) or MV (Market Value).
      4. Calculation Method – Defines how values are calculated:
         1. Sum – Total aggregation.
         2. Weighted Market Value – Adjusts MV by weighting.
         3. Weighted Market Value Percent – MV as a percentage.
         4. Weighted Exposure – Adjusted exposure levels.

      Maturity 

      Maturity layout provides insights into financial instruments based on their maturity dates.

      Header

      At the top of the Maturity layout, you'll find the filter panel where you can adjust key parameters:

      1. 1. Portfolios – Select which portfolios to analyze.
         2. Currency – Choose the reporting currency.
         3. Report Date – Defines the analysis date, displaying data as of the end of that day.
         4. Pricing Policy – Determines the valuation method for instruments.
         5. Upper Section – Displays instruments sorted by maturity, including days to maturity, date, type, market value, price, position, and FX rate.

   2. Lower Section – Similar to the upper table but filtered by portfolio.
      If
   no
   data
is available, the tables remain empty.

 

ProfitConfiguration & LossHelper

The P&L layout provides an overview of financial performance across different regions

Header

At the top of the P&L layout, you'll find the filter panel where you can adjust key parameters:

1. 1. Portfolios – Select which portfolios to analyze.
   2. Currency – Choose the reporting currency.
   3. Report Date – Defines the analysis date, displaying data as of the end of that day.
   4. Pricing Policy – Determines the valuation method for instruments.
      

      

      The main P&L table presents financial performance per region:
      1. 1. PnL Total – Displays total profit or loss per region.
         2. FX Variations – Reflects changes due to currency fluctuations.
         3. FX Trades – Captures executed foreign exchange transactions.
         4. Total – Summarizes the overall P&L per region
   5. The Configuration Helper  layout provides various system tools for managing workflows, performing calculations, importing/exporting data, and running analytics.

      Header

      The Configuration Helper layout contains sections with workflows. Each workflow includes a description and tooltips for fields. Below is an overview of its sections:
      

      

      1. 1. Workflow v2 – Contains options for managing workflow templates.
            1. Transfer Workflow Templates – Copy and paste JSON templates to create workflows in the workspace.
            2. Delete Workflow Templates – Remove all workflow templates from the current workspace.
               
         2. Import & Download – Facilitates importing and downloading various types of financial data.
            1. Import Instruments from FinmarsDB – Retrieves instrument data from the Finmars database.
            2. Import Prices from FinmarsDB – Fetches price data for specified instruments and dates.
            3. Download Prices – Downloads historical price data for all instruments.
            4. Download FX Rates – Retrieves foreign exchange rates for the selected date range.
               
         3. Finmars Analytics – Provides tools for analyzing imports and checking data completeness.
            1. Finmars Import Task IDs Analysis – Analyzes errors within a specified range of import task IDs.
            2. Finmars Price FX-Rate Completeness Report – Generates reports to verify the completeness of price and FX rate data.
               
         4. Calculations – Performs various financial calculations.
            1. Calculate Register Records – Computes register records for selected portfolios.
            2. Calculate Portfolio Price History – Retrieves historical pricing data for portfolios.
            3. Calculate Portfolio History – Calculates portfolio performance based on different parameters.
         5. Bloomberg – Integrates with Bloomberg API for data retrieval.
            1. Download Instrument Data – Fetches instrument data from Bloomberg.
            2. Download Prices – Retrieves pricing data from Bloomberg for specified instruments.
         6. CleanUp – Allows deletion of different types of data from the workspace.
            1. Options include deleting all entities, balance cache, transaction history, and more.
            
            
         7. Roll – Handles rolling forward pricing and FX rate data.
            1. Collect FX Rate – Collects FX rate data for the selected date range.
            2. Roll FX Rate – Rolls forward FX rates using the defined pricing policy.
            3. Collect Price – Gathers pricing data for selected instruments.
            4. Roll Price – Rolls forward price data based on the pricing policy.

      STD

      Manual
   Import

   6. The STD Manual Import  layout provides a structured interface for manually uploading key financial data files into the system.
      

      Header

      Below is an overview of its sections:

      

      1. 1. Workflow Selection – Defines the import process to be used. The dropdown allows selecting different predefined import pipelines. See How to Import Data into a Workspace via Dashboard (STD Manual Import)
         2. Download Documentation – Provides a reference guide for file format requirements and upload instructions.
         3. File Upload Fields – Users can manually upload different data files.
2. 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.