Brinvex FinTracker is a practical tool focused on investment tracking offering detailed insights into investment portfolios. It is capable of interacting with various banks and brokers, and it is highly extensible, making it easy to add support for additional institutions. Designed as both an application for end-users and a library for integration into other systems, it provides flexible and scalable solutions for financial tracking.
If you have any questions, feedback, or need assistance, please reach out to info@brinvex.com. I am also open to exploring work partnerships of any kind. Whether you’re interested in collaboration, integration, or other opportunities, feel free to get in touch—I’d love to hear from you!
The Performance Module in Brinvex FinTracker provides powerful tools for analyzing the performance of financial portfolios.
PerformanceAnalyzer perfAnalyzer = finTracker.get(PerformanceModule.class).performanceAnalyzer();
List<PerfAnalysis> perfAnalyses = perfAnalyzer.analyzePerformance(PerfAnalysisRequest.builder()
.resultStartDateIncl(parse("2023-01-01"))
.resultEndDateIncl(parse("2023-03-31"))
.assetValues(List.of(
new DateAmount("2022-12-31", "100000"),
new DateAmount("2023-01-31", "98000"),
new DateAmount("2023-02-28", "117000"),
new DateAmount("2023-03-31", "120000")
))
.flows(List.of(
new DateAmount("2023-01-20", "2000"),
new DateAmount("2023-02-15", "1000"),
new DateAmount("2023-02-07", "-1500")
))
.flowTiming(BEGINNING_OF_DAY)
.twrCalculatorType(LinkedModifiedDietzTwrCalculator.class)
.mwrCalculatorType(ModifiedDietzMwrCalculator.class)
.resultFrequency(MONTH)
.resultRatesInPercent(true)
.resultScale(2)
.calculateMwr(true)
.calculatePeriodMwr(true)
.calculateTrailingAvgProfit1Y(true)
.calculateTrailingAvgFlow1Y(true)
.build());| 2023-01 | 2023-02 | 2023-03 | |
|---|---|---|---|
| Period Start Value | 100000 | 98000 | 117000 |
| Period End Value | 98000 | 117000 | 120000 |
| Period Flow | 2000 | -500 | 0 |
| Period TWR | -3.97% | 20.04% | 2.56% |
| Cumulative TWR | -3.97% | 15.27% | 18.23% |
| Annualized TWR | -3.97% | 15.27% | 18.23% |
| Period MWR | -3.97% | 20.04% | 2.56% |
| Cumulative MWR | -3.97% | 15.34% | 18.28% |
| Annualized MWR | -3.97% | 15.34% | 18.28% |
| Total Contribution | 102000 | 101500 | 101500 |
| Period Profit | -4000 | 19500 | 3000 |
| Total Profit | -4000 | 15500 | 18500 |
| Trailing Avg Profit 1Y | -4000.00 | 7750.00 | 6166.67 |
| Trailing Avg Flow 1Y | 2000.00 | 750.00 | 500.00 |
True Time-Weighted Return (TWR) is often the preferred method for evaluating portfolio performance as it eliminates the impact of cash flows. This metric focuses solely on the portfolio's ability to generate returns, making it ideal for performance comparison across different funds or investment strategies.
TrueTwrCalculator twrCalculator = finTracker.get(PerformanceModule.class)
.trueTwrCalculator();
BigDecimal twrReturn = twrCalculator.calculateReturn(PerfCalcRequest.builder()
.startDateIncl(parse("2020-06-01"))
.endDateIncl(parse("2020-06-30"))
.startAssetValueExcl(new BigDecimal("100000"))
.endAssetValueIncl(new BigDecimal("135000"))
.flows(List.of(
new DateAmount("2020-06-06", "-2000"),
new DateAmount("2020-06-11", "20000")))
.assetValues(List.of(
new DateAmount("2020-06-05", "101000"),
new DateAmount("2020-06-10", "132000")))
.flowTiming(BEGINNING_OF_DAY)
.annualization(DO_NOT_ANNUALIZE)
.resultInPercent(true)
.resultScale(4)
.build());
assertEquals("19.6053", twrReturn.toPlainString());
Modified Dietz is a simplified version of the Money-Weighted Return (MWR) calculation. It adjusts for the timing and size of cash flows to provide a performance measure that accounts for external influences like deposits and withdrawals. It is one of the methodologies of calculating returns recommended by the Investment Performance Council (IPC) as part of their Global Investment Performance Standards (GIPS).
ModifiedDietzMwrCalculator mwrCalculator = finTracker.get(PerformanceModule.class)
.modifiedDietzMwrCalculator();
BigDecimal mwrReturn = mwrCalculator.calculateReturn(PerfCalcRequest.builder()
.startDateIncl(parse("2020-06-01"))
.endDateIncl(parse("2020-06-30"))
.startAssetValueExcl(new BigDecimal("100000"))
.endAssetValueIncl(new BigDecimal("135000"))
.flows(List.of(
new DateAmount("2020-06-06", "-2000"),
new DateAmount("2020-06-11", "20000")))
.flowTiming(BEGINNING_OF_DAY)
.annualization(DO_NOT_ANNUALIZE)
.resultInPercent(true)
.resultScale(4)
.build());
assertEquals("15.2239", mwrReturn.toPlainString());
If you're considering adding support for the XIRR MWR calculation method,
check out this library https://github.com/RayDeCampo/java-xirr.
I used XIRR previously, but with a focus on computational efficiency,
I switched to the Modified Dietz method in 2024,
as it is significantly more efficient and meets our needs well.
Notably, both XIRR and Modified Dietz methods are endorsed by the GIPS.
The Linked Modified Dietz Time-Weighted Rate of Return calculation method allows you to approximate the time-weighted rate of return, even when portfolio valuations at cash flow dates are unavailable.
LinkedModifiedDietzTwrCalculator linkedTwrCalculator = finTracker.get(PerformanceModule.class)
.linkedModifiedDietzTwrCalculator();
BigDecimal twrReturn = linkedTwrCalculator.calculateReturn(PerfCalcRequest.builder()
.startDateIncl(parse("2021-01-01"))
.endDateIncl(parse("2021-03-31"))
.startAssetValueExcl(new BigDecimal("10000"))
.endAssetValueIncl(new BigDecimal("10200"))
.flows(List.of(
new DateAmount("2021-02-15", "100")))
.assetValues(List.of(
new DateAmount("2021-01-31", "10100"),
new DateAmount("2021-02-28", "10201")
))
.flowTiming(BEGINNING_OF_DAY)
.resultScale(10)
.annualization(DO_NOT_ANNUALIZE)
.build());
assertEquals("0.0100004877", twrReturn.toPlainString());
https://canadianportfoliomanagerblog.com/calculating-your-modified-dietz-rate-of-return
https://www.interactivebrokers.com/images/common/Statements/MWR-TWR_white_paper.pdf
https://en.wikipedia.org/wiki/Modified_Dietz_method
https://en.wikipedia.org/wiki/Time-weighted_return
https://www.gipsstandards.org
Brinvex FinTracker enables efficient retrieval, processing, and storage of account statements from a range of banks and brokers. It consolidates these statements into a unified format, providing a comprehensive overview that supports detailed analysis and streamlined financial management.
It's not necessary to include all dependencies.
You only need to import the ones relevant to your specific use case.
For example, if you're using the performance calculation features,
you can include only the performance-api and performance-impl dependencies.
If you need integration with IBKR, import the connector-ibkr-api and connector-ibkr-impl dependencies.
<properties>
<brinvex-fintracker.version>0.0.43</brinvex-fintracker.version>
</properties>
<repository>
<id>repository.brinvex</id>
<name>Brinvex Repository</name>
<url>https://github.com/brinvex/brinvex-repo/raw/main/</url>
<snapshots>
<enabled>false</enabled>
</snapshots>
</repository>
<dependency>
<groupId>com.brinvex.fintracker</groupId>
<artifactId>brinvex-fintracker-performance-api</artifactId>
<version>${brinvex-fintracker.version}</version>
</dependency>
<dependency>
<groupId>com.brinvex.fintracker</groupId>
<artifactId>brinvex-fintracker-performance-impl</artifactId>
<version>${brinvex-fintracker.version}</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.brinvex.fintracker</groupId>
<artifactId>brinvex-fintracker-connector-ibkr-api</artifactId>
<version>${brinvex-fintracker.version}</version>
</dependency>
<dependency>
<groupId>com.brinvex.fintracker</groupId>
<artifactId>brinvex-fintracker-connector-ibkr-impl</artifactId>
<version>${brinvex-fintracker.version}</version>
<scope>runtime</scope>
</dependency>
- Java 22 or above
- The Brinvex FinTracker is released under version 2.0 of the Apache License.
A discrepancy may be observed in the display symbols for stock positions, such as those in the German company Siemens (ISIN: DE0007236101). When purchased on IBIS, the symbol for Siemens stock may appear as "SIE" in the TWS platform and the Portfolio screen of the Interactive Brokers web application. However, in report statements, including flex statements, the symbol may be listed as "SIEd." This inconsistency arises due to the use of the primary exchange symbol in statements, which may differ from the symbol displayed in other parts of the platform. Despite this variation, the stock remains the same, as confirmed by matching ISINs and other details. This behavior is a standard design feature of the IBKR platform.
Many updates or changes made by the user will only take full effect after one business day. For example, when modifying the Account Alias, the new value will not immediately appear in the statements. Instead, the old value will continue to be displayed until the system processes the update overnight. Users should expect this one-business-day period for updates to be fully reflected.
On August 1, 2024, Interactive Brokers Ireland Limited (IBIE) and
Interactive Brokers Central Europe Zrt. (IBCE) merged into a single entity.
All former IBCE clients were moved to IBIE, and they got new Account IDs under IBIE.
https://www.ibkrguides.com/kb/merger-of-two-eu-broker-dealers.htm
If such a scenario occurs again, be aware that IBKR reports may appear
inconsistent and unstable for a period. It is advisable to wait a few days
before using them, allowing time for reports of old accounts to stabilize
and new account reports to include all important data.
In 2024, a 14-day waiting period was sufficient for the reports to consolidate.