Report data calculation

Typically, report data is recalculated based on a schedule, for example, every night (see Update report in FA Back reference). The Update menu allows you to start the recalculation outside the schedule, for example, if the scheduled recalculation was unsuccessful.

The Update menu allows you to recalculate transaction effects. This is only required if you change the effects of a transaction type in Preference → Transactions → Transaction types but don't click Update (see Transaction types in FA Back reference). For example, you can change the tax or cost effect from "adding" to "reducing", resulting in a different trade amount if taxes or costs are added instead of subtracted. After the transactions are "recalculated" (transaction trade amounts updated based on the effects change), the system recalculates the affected portfolio reports data.

Market data connection is available in the Update menu if you receive market prices through a market data connector.

With the Market data connection menu items, you can fetch update codes and prices for securities with the "Active" status. Fetching market prices triggers a report calculation to update the effect of the new market prices in your portfolios. The report calculation affects all portfolios containing securities that receive an updated price, and starts from the earliest market price received.

Example: A security has a price for 2.1.2019 with entries in the Manual and Close 2 fields. You fetch the market price again and include this date (using a market data connector linked to Update code 2 / Close 2). As a result, the value in Close 2 is updated. The value in Manual stays the same.

Revaluate all securities is only available in the Update menu if you have the user role that permits revaluating securities.

The Revaluate all securities menu items allow you to recalculate the discount factors for a specific time period on all your securities that have the base type "DISCOUNT" and other relevant information. The system never calculates discount factors on a security before the beginning of the position or after the maturity date, and all calculations are done until the previous day.

Revaluating securities always triggers a report calculation to update the effect of the new values in your portfolios. The report calculation affects all portfolios containing securities that receive a new valuation. For more details on the revaluation menu items, see Valuation of forward cashflows in FA Back reference.

The Show pending and ongoing calculations menu item allows you to view pending, ongoing, and failed report calculations. You can refresh the records, export the table as an XLSX file, or delete all records. By default, calculations are deleted automatically after 30 days. The tabs Pending and ongoing and Failed show the following information: