PRESS RELEASES
Product releases, platform milestones and technical developments from TransRisk.
Platform
The platform's database tables were restructured, removing redundant data and consolidating the design. The database footprint came down by 70%.
The installation is correspondingly lighter and system response quicker, continuing the field-precision work of the previous month. Deployments carrying the longest position histories gain the most, and a smaller database also shortens backup and restore windows.
Platform
Field precision across the platform's data tables was reworked, each field assigned the precision its data actually requires rather than an inherited default. Table memory came down by 28%.
Reporting responses are quicker as a result, since less memory has to be moved to answer the same query. Deployments carrying long position histories and high dimensional counts see the most benefit, as they did from the 64-bit upgrade in 2023. Stored precision is separate from the decimal precision users set for display, which is unchanged.
Product release
TransRisk's transfer-pricing logic was extended to cover transfers between departments inside one organisation, so each function carries a commodity P&L of its own. The shape it was built for is a group where sourcing and trading procures the material and refines it, then transfers finished SKUs to a marketing function that sells and dispatches them.
The difficulty is that the ERP records a physical movement while a decision-support view needs the commercial one. An internal transfer is made at the prevailing market price, but the SKU inventory cost read from SAP carries packaging and branding inside the unit cost. TransRisk now removes those components from the SAP unit cost before attributing P&L to the sourcing and trading side, and applies the same adjustment back when the marketing side sells the finished SKU.
What that produces is a commodity P&L by department, not a replacement for the financial P&L the accounting team closes at quarter end once semi-variable, semi-fixed and fixed expenses are applied. The adjustment is made inside TransRisk against positions read from SAP; nothing is written back, and the accounting record is unchanged. The capability is live in client deployments.
Product release
Automated Data Pickup and Processing can now collect files from Linux-based SFTP locations as well as the Windows-based locations it already supported. Either is supported, and the stages behind the pickup — validation and load on the configured schedule — are the same in both cases.
The practical effect is that the choice of host belongs to the client's infrastructure team rather than to the platform. Where a Windows host was being maintained only to stage files for collection, retiring it is a modest saving; where Windows is already the standard, nothing needs to change.
Product release
TransRisk gained an automated scheduler covering the full exposure processing cycle: data is pulled from source systems, transformed and validated, the calculations are run, reports are generated, and notifications are issued — each stage started by the schedule rather than by an operator working through the stages in turn.
The scheduler joins up automation delivered in earlier cycles. Automated Data Pickup and Processing, introduced in 2022 and extended in 2023, automated the ingestion stage; automated report delivery arrived with v5.1 at the end of 2023. Each still had to be started and sequenced separately. A deployment now declares the business schedule it needs — overnight consolidation, a delivery window for the morning reports, scheduled intraday refreshes — and the platform follows it on every cycle.
Removing the manual steps between stages makes the run repeatable: the same sequence executes in the same order each time, and a stage that fails is reported rather than leaving a partially refreshed position to be discovered in the next day's numbers. The direction of travel is unchanged — the scheduler reads from ERP, trading systems, broker statements, price feeds and governed uploads, and writes nothing back to any of them.
Product release
TransRisk v5.2 consolidated the dashboard, margin management and decision support work of the preceding cycles into a single platform release, alongside a component library upgrade and scheduler improvements.
The release refined VaR treatment for transformed and closed positions, extended trend reporting with export handling, and continued the conversion and matching work across additional commodity complexes.
Product release
TransRisk introduced role-based Decision Support, presenting margin management views built for specific functions rather than a single shared screen, available in both reporting currencies.
Margin Management was extended across further commodity complexes, with distribution analysis added so margin outcomes can be read against their historical range rather than as a single point value. Role-specific alerting was added to the platform landing page, surfacing the exceptions relevant to each user at sign-in.
Product release
The commodity conversion and landed cost engine was extended to cover further grain, oilseed and processed-product complexes, including hierarchical material mapping so source data described by material code resolves to the correct commodity node automatically.
The release introduced the Parity Analyser, and extended limit management with risk limits, quantity limits, and month-to-date and year-to-date P&L limits surfaced directly on trend charts. Meta limits were added, allowing limits to be defined against combinations of dimensions rather than one at a time.
Building on the SAP integration released at the end of 2023, a middleware layer and source-to-platform reconciliation were added.
Product release
TransRisk v5.1 introduced native SAP API integration, pulling positions, inventory and commitments directly from SAP without third-party middleware or manual export.
The release added log-normal returns to the historical VaR methodology, improving distribution handling for commodities whose price behaviour is poorly described by normal returns. Reports Hub gained automated delivery, letting users select reports and have them generated and emailed on a schedule, and OLAP report layouts became saveable and retrievable from the hub.
Commodity conversion was extended across additional oilseed, pulse and grain complexes, with landed cost calculation applied through each conversion path.
Product release
ADPP 2.0 extended Automated Data Pickup and Processing with multi-source handling, improved dataset upload threading, and clearer surfacing of ingestion errors to users rather than logs alone.
The same cycle delivered multi-measure P&L, presenting the platform's P&L measures together from one underlying dataset so finance, procurement, trading and risk each work from the measure relevant to their accountability without reconciling between them. Dashboards were extended to carry the multi-measure view.
Security
TransRisk completed a Vulnerability Assessment and Penetration Testing (VAPT) exercise covering the platform, with the findings it raised addressed in the same cycle.
The review extended beyond the platform itself to development and deployment environments. Platform authentication was strengthened in the same period, with email-based user authentication and an expanded user profile and access model.
Platform
TransRisk was upgraded to a 64-bit architecture, removing the memory ceiling that had constrained large position books.
The upgrade resolved out-of-memory conditions that could interrupt users working across very large datasets, and delivered a broad performance improvement to report generation and screen loading. Deployments with high dimensional counts and long position histories benefited most.
Decimal precision settings defined in general settings were also made to apply consistently across snapshot and multi-dimensional reporting.
Product release
TransRisk v5.0 expanded the exposure model to eighteen dimensions, allowing positions to be analysed across a substantially wider combination of commodity, entity, location, book and contract attributes than the previous model supported.
The release introduced the first role-specific dashboards: separate management, risk management, trading desk and exposure management views built on the same underlying position data, so each function sees the detail relevant to it without reconciling against a different source.
Due-month and forward-month derivation from contract end dates was reworked in the same version.
Product release
TransRisk added Multi-VaR reporting, allowing Value-at-Risk to be produced across several methodologies and portfolio cuts in a single report rather than run separately for each.
The release also introduced optional and hideable dimensions, so deployments carrying a wide dimensional model can present each user group only the dimensions relevant to their accountability. Custom reporting was extended to cover trading and hedging positions, and replacement and inventory margin.
Product release
TransRisk introduced Automated Data Pickup and Processing (ADPP), an ingestion layer that collects position data from source systems on a schedule, validates it, and loads it into the platform without manual intervention.
Carry-forward handling for closed positions was reworked in the same release.
Platform
TransRisk was migrated from .NET Framework 4.0 to 4.8, together with a full component-library upgrade. The migration was a prerequisite for later performance and security work rather than a visible feature change.
The same release introduced OLAP cube reporting on standard SQL Server, giving users multi-dimensional slice-and-dice analysis over the position book without predefined report layouts, and added a custom report framework covering net physical price analysis.
Product release
TransRisk gained a dedicated Risk Management module, consolidating exposure measurement and risk reporting into a single area of the platform rather than distributing it across the reporting layer.
The same cycle introduced a pre-processing stage for incoming position data and extended handling for closed positions and options quantities, including negative-quantity put options that had previously required manual adjustment. Platform documentation was reissued alongside the release.
Product release
TransRisk v4.5 shipped with a substantially wider reporting layer for commodity risk teams.
The release introduced the Pivot Report for multi-dimensional analysis, an Exposure Position Report, a dedicated Realised P&L report, and Snapshot and multi-dimensional reporting across the position book. Composite security handling and unit conversion were extended at the same time, allowing positions in different contract units to be consolidated without manual restatement.
The reporting additions were rolled out across the installed base rather than offered as a separate module.
Product
An unexplained movement in daily P&L often turns out to be a data problem rather than a market one. A single mis-keyed quantity or a stray value in an incoming feed can distort the position before anyone thinks to question the number.
TransRisk's Trade Deviation Report flags outliers in incoming position data automatically, at the point of ingestion rather than later in a reconciliation, so the figures reaching the morning report have already been checked.