Skip to Main Content
Quantum Ideas Portal
Welcome to the FIS Treasury and Risk Manager - Quantum Edition Aha! Ideas Portal.

By visiting this portal, you will be able to contribute towards the evolution of the Quantum solution through interactions with other Quantum users, FIS trusted partners and FIS staff from around the world. Each Portal User receives 5 votes. Each user is allowed 1 vote per idea. Votes are reset when an idea is in a final state i.e. Shipped (delivered in the product).

Users will receive weekly email updates that highlight new activity. Users will receive emails for their created ideas when:

  • Status changes

  • Comment changes

Be aware that when you post content, other community members will see your name. FIS is not responsible for content posted by other Aha! Ideas Portal Users.


Status Already exists
Created by Matthias Posseldt
Created on Jul 18, 2024

EWF source and actions for CashXplorer

We want to use the latest data from CashXPlorer to feed into our trading optimization engine. Currently, we need to download the data manually. Our long-term goal is to have everything in Quantum, perhaps with additional external API calls to do the optimization.

  • Attach files
  • Admin
    Suzanne Cooke
    Reply
    |
    Jul 29, 2024

    Expression builder - New and Changed Functions

    The following is a new function used in Expression Builder. This new function takes data from cash explorer worksheets, using the last data version from each date for the worksheet parameters provided.

    CashForecast

    Description

    Returns cash forecast amount for specified date and grouping from relevant CashXplorer data version.

    Format

    CashForecast(query, view, rowGroups, optional forecastDate, optional firstHorizonStartDate)

    Arguments

    query - CashXplorer query name

    view - CashXplorer forecast view name

    rowGroups - list of text values for each row group

    forecastDate - date to return forecast for

    firstHorizonStartDate - date to identify data version with

    Example 1

    CashForecast( "12 Months", "Forecast", { "EUR", "Surplus / Deficit" }, 18-Jul-2018 )

    The result is 23,330,362.

    Returns the value of the Jul bucket, assuming data version 1 on 23-May-2018 is the latest before today.

    Example 2

    CashForecast( "12 Months", "Forecast", { "EUR", "Surplus / Deficit" }, 14-Jun-2018, 24-May-2018 )

    The result is 20,705,934.

    Returns the value of the Starting 11-Jun-18 bucket, assuming data version 1 on 23-May-2018 is the latest before 24-May-2018.

    Example

    CashForecast()