• I cannot see an account in Position/Transaction history report

    Summary: Position history and Transaction history are both historical reports based on dates. Please make sure that the dates are well selected and in the correct order, and/or that there are no filters applied on the report columns. Solution: All the reports that have the symbol above are driven by dates….

  • How to stop Security Prices from updating automatically

    1. Open OMS tab and click on Open Maintenance. By default, Open Maintenance will directly open the entity we need: Security: Setup/Edit Securities. 2. In the list at the bottom left (1), find and select the Security you wish to exclude from updating price automatically to display the security details….

  • Expiring Options

    In the Positions – Holding (Curr) report – Right click on the option > Transactions > New Expiration/Delivery. After clicking on “New Expiration/Delivery” a screen will open where you can enter the expiration details. Enter the information and click save. This will expire your option.

  • Creating a report

    1. Open My Reports tab and click on New Report Set. 2. Select Standard Report. 3. You have two options: building a new report set or clicking on an existing one. 4. Create a report set from an existing one means selecting one of the past reports that will serv…

  • How to change Date Ranges

    There are two types of reports in Spark, those that are date-driven and those that aren’t. A good example of non-date-driven is Transaction (C), the current transaction, which always belongs to the current day. An example of a date-driven report is, on the other hand, the transaction history -Transaction (H)-….

  • Report Columns – Aggregation Values

    In this article we will have an overview on how to add and edit the aggregation values. Click on GroupBy (1) and drag the header of the column you would like to group by. You can also drag additional columns to create subgroups. NOTE: To undo the GroupBy, just click…

  • How to filter Reports by Account

    FILTERING SELECTED ACCOUNT REPORTS BY ACCOUNT In Spark, we have two types of report: You can filter Selected Account Reports to display only those accounts you want. To do so, open the report you would like to filter and click on ‘Add/Edit Views’. Only if the report you chose is…