Scribd Logo
Upload

Welcome to Scribd!

  • 53 views

    ICE SSRS P&L Report Template

    Uploaded by

    cjolenick
    This document contains instructions and variables for generating financial reports from trading data. It allows the user to select a date range or specific month and year to view aggregate trading results for individual traders, firms, or an entire company. The report displays metrics such as gross profits and losses, commissions, fees, and margin requirements for the selected period. Formulas referenced in the report are defined in an accompanying document.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    ICE SSRS P&L Report Template

    Uploaded by

    cjolenick
    53 views6 pages
    This document contains instructions and variables for generating financial reports from trading data. It allows the user to select a date range or specific month and year to view aggregate trading results for individual traders, firms, or an entire company. The report displays metrics such as gross profits and losses, commissions, fees, and margin requirements for the selected period. Formulas referenced in the report are defined in an accompanying document.

    Original Description:

    P&L Report Template

    Original Title

    ICE SSRS P&L report template

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains instructions and variables for generating financial reports from trading data. It allows the user to select a date range or specific month and year to view aggregate trading results for individual traders, firms, or an entire company. The report displays metrics such as gross profits and losses, commissions, fees, and margin requirements for the selected period. Formulas referenced in the report are defined in an accompanying document.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    53 views6 pages

    ICE SSRS P&L Report Template

    Uploaded by

    cjolenick
    This document contains instructions and variables for generating financial reports from trading data. It allows the user to select a date range or specific month and year to view aggregate trading results for individual traders, firms, or an entire company. The report displays metrics such as gross profits and losses, commissions, fees, and margin requirements for the selected period. Formulas referenced in the report are defined in an accompanying document.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 6

    This report allows one to select the results for a specified range of continuous trading days or for a specific

    month and year

    Variables and formulas: where cell entry is CAPITALIZED, the value of that variable is available directly from the (sub-)account

    Trader Selector pull down menu: Trader - sub-account number - allow to choose an individual trader, FCM, or the entire Comp

    Radio-buttons or some other switch: From date / To date OR Select a specific Month and Select a specific Year

    Date** Gross P&L Commission Fees Commission and Fees

    1-Oct-2019 GROSS PROFIT OR LOSS COMMISSION (1.6) (1.7)


    2-Oct-2019 (2.6) COMMISSION TOTAL FEES (2.7)
    3-Oct-2019

    Total sum sum sum sum

    sum Total shows total over the period


    avg Total shows average over the period

    * for a group of traders the reported results B6:H6 are added for each date as well as for the Total
    ** Date = STATEMENT DATE as shown on the daily statement
    ng days or for a specific month and year

    is available directly from the (sub-)account daily summary, where a formula number is referenced, please refer the accompanying docume

    n individual trader, FCM, or the entire Company*

    h and Select a specific Year

    Net P&L Net P&L with MTM Maintenance Margin Requirement

    (1.8) (1.9) MAINTENANCE MARGIN REQUIREMENT


    NET PROFIT/LOSS FROM TRADES (2.9) MAINTENANCE MARGIN REQUIREMENT

    sum sum avg

    ate as well as for the Total


    e refer the accompanying document Definitions for FCM statements.docx for the calculation

    Initial Margin Requirement Formula for:

    INITIAL MARGIN REQUIREMENT FCStone


    INITIAL MARGIN REQUIREMENT ADM IS

    avg
    Selector: Trader - sub-account number - allow to choose an individual trader, FCM, or the entire Company*

    Variables and formulas: where cell entry is CAPITALIZED, the value of that variable is available directly from the (sub-)account

    Select starting Month and starting Year and select ending month and ending year

    Month-Year Gross P&L** Commission Fees Commission and Fees

    November 2019 GROSS PROFIT OR LOSS COMMISSION (1.6) (1.7)


    December 2019 (2.6) COMMISSION TOTAL FEES (2.7)
    January 2020

    Total sum sum sum sum

    sum reports total over the period


    avg reports average over the period

    * for a group of traders the reported results B6:H6 are added for each date as well as for the Total
    ** This and other monthly totals can be computed as a sum of daily equivalent values from the Daily Report ta
    entire Company*

    able directly from the (sub-)account daily summary, where a formula number is referenced, please refer the accompanying document De

    Net P&L Net P&L with MTM Maintenance Margin Requirement

    (1.8) (1.9) MAINTENANCE MARGIN REQUIREMENT


    NET PROFIT/LOSS FROM TRADES (2.9) MAINTENANCE MARGIN REQUIREMENT

    sum sum avg

    te as well as for the Total


    alent values from the Daily Report tab
    the accompanying document Definitions for FCM statements.docx for the calculation

    Initial Margin Requirement Formula for:

    INITIAL MARGIN REQUIREMENT FCStone


    INITIAL MARGIN REQUIREMENT ADM IS

    avg

    You might also like