Sorry. I see now why you and @Jo92 didn’t understand the question. I mixed up the CSV-exports. The difference between before and after is indeed only taxes. I attached a new version of the image and the Excel-file.
Excel-file
Excel-file
Hello @hug-sch , a proposition of information to add to the Benchmarking part:
When a data series added as a benchmark starts after the start of the reporting period, its start value is not 0%. And the start values depends on the reporting period:
Example from kommer with security Daimler, whose first price is on Feb 2022. For a 3 and 5 years reporting period, the start value, and therefore all the other values, on Feb 2022 is different:
It is actually the performance value of the whole portfolio at this date in the reporting period : the benchmark is adjusted to it so you can still compare it to the whole portfolio. Quite smart.
I do not think this is documented yet in the manual.
Hi @Veterini Thanks for the info. I didn’t notice it and indeed, quite smart. I will update the docs with your info. Thanks again for mentioning it.
@Veterini Hi, Upon updating the docs, I stumbled on some problems. I could not replicate the findings with the demo-portfolio-03. In these examples, the performance always starts at 0%. I think the cause being the limited range of historical prices of the Daimler share (from dec 10, 2021).
If the starting date of the reporting period is before the first available historical price, then the portfolio performance is taken as the initial value. I’m not completely sure, so, if you have time, can you check the update?
PS If you don’t agree with the reference to the post, please let me know so I can change it.
Hello @hug-sch , I do not have my laptop with me at the moment, but my understanding is that the adjustment of the benchmark happens only if the start of reporting period is Indeed before the first price of the benchmark. So for Daimler starting déc 2021, it should be thé case with >3 years reporting period.
Otherwise yes it should start at 0% (same as whole portfolio or other data series).
Hello hug-sch, regarding the Return column of Trades, on this pages it says that the Return column is the “TTWROR with a single subperiod”, but is this correct ? I think it looks a bit suspicious. A simple return can’t always be equal to the TTWROR.
I think chirlu is right there:
This could be the TTWROR only in the very specific case of a single buy.