FA Back 3.13 - Release notes

Fixed potential issues in report generation, which could have caused problems in concurrent use, especially when reports scheduled report generations happen to run in the system simultaneously.

Fixed an issue in an automatic upgrade script that made upgrades to FA 3.13 unnecessarily slow. Upgrading to this version changes existing database columns' character set to one which supports all kinds of special characters, and that changes is now only applied to relevant database tables.

In addition, also all newly created environments now contain a logout page for FA Front.

Importing portfolios through the Import menu with a CSV file no longer unnecessarily triggers recalculating all report data multiple times for the same portfolio. This occurred if you used a CSV file to update multiple portfolio's data at the same time, and modified portfolio information that requires a report recalculation, such as portfolio's accounts, benchmark or valuation method. Before, each portfolio was recalculated multiple times (as many times as you had rows in your import file, but now the required recalculation is done only once for each affected portfolio.

Importing prices to currency crosses has been optimized, and importing prices to currency crosses is faster than before. The import no longer updates the currency crosses in the background, ensuring the import itself goes through faster.

In addition, the system no longer tries to find an FX rate between a currency and itself. If the base currency and the quote currency are the same, the system directly returns the FX rate as 1, without unnecessarily trying to load an FX rate and writing warnings about it in the logs.

Fixed additional issues in TWR calculation when an exchange transaction removes a position from the portfolio. Incorrect TWR figures in such a scenario were due to rounding issues during an exchange. To ensure figures are accurate, calculations are now done with more decimals, and values used in calculation are checked to be of correct accuracy.

You can now again add a new general benchmark in Benchmark index Preferences without unnecessary errors.

Model portfolios are now saved correctly even when you modify multiple securities within an existing model in one go.

In addition, fixed an issue in an underlying method for filtering securities with multiple tags, ensuring that filtering a security list with multiple tags in FA Front works correctly.

Paid accrual is now correctly considered in TWR calculation, ensuring TWR is calculated correctly also on the day of an exchange transaction, if the position includes exchanges that transfer accrual from one position to another.

Fixed additional issues in considering paid accrual in TWR calculation. The calculation now correctly includes changes in "accrual" and only excludes changes in "paid accrual"

When calculating averages, Analytics+ now properly takes days with missing positions into account. When you do the analysis on a specific time period (start and end date), the calculation for different "average" values now considers days with no positions valued as "0" instead of just simply skipping them.

Limited visibility is now correctly applied in GraphQL APIs also on contacts without portfolios. When a user with limited visibility queries contacts through GraphQL API, limited visibility is applied correctly on all contacts, also contacts without a portfolio.

In addition, fixed issues in automatic upgrade scripts that resulted in problems during an upgrade to FA 3.13. Upgrading to FA 3.13 changes existing database columns' character set to one which supports all kinds of special characters - this change is now done in a more optimized manner table-by-table (instead of column-by-column) to reduce the time required for the upgrade. Upgrade scripts have also been restructured to ensure bookkeeping posting rules are not de-linked from portfolios when upgrading from FA 3.4 directly to FA 3.12 or higher.

Importing portfolio data to the system programmatically, for example through an API or general importer, now correctly keeps portfolio's cost types and values even if you don't explicitly define them p.fees as *** in your import data. Before, portfolio's cost types and values were incorrectly removed if you didn't include p.fees in your import data - now portfolio's cost types and values are blanked only if you import p.fees as empty.

Fixed additional issues in considering paid accrual on positions with exchange transaction in TWR calculation. To consider a wide range of different ways to record accrual changes on positions with exchanges, adjustments have now been made deeper in the calculation logic to properly track the values, and on the TWR calculation logic to explicitly handle positions with exchanges.

Analytics+ now calculates realized profits correctly for positions included from linked portfolios (drilldown) also when more units are bought and the position grows during the analysis period.

Giving feedback on FA through the star icon in the red toolbar is no longer available . FA decided to discontinue the use of the underlying system, which lead us to disable the feedback option for now. We are looking for better ways to collect feedback from our clients in the future.

In addition, fixed issues in automatic scripts used to create new environments. Messaging queues and topics are now created earlier in the process, ensuring there are no unnecessary errors during an environment creation due to missing queues or topics.

Fixed additional issues in considering paid accrual on positions TWR calculation when there are redemption and exchange transactions in FIFO portfolios. If an exchange has been made in a FIFO portfolio on a position with paid accrual, the accrual is transferred to the new position. If you then do a subsequent partial redemption / sell of the new position on the same date, the transferred accrual is now considered properly, no longer resulting in a accrual being counted double.