Hey everyone !
I’m tracking a managed life insurance portfolio in PP. Since I can’t import data directly, I manually enter the total portfolio value as the price of a single security unit - so 1 share always equals the current portfolio value (not doing that by hand but API export).
To record my monthly €300 DCA contributions without distorting the share count, I’m using an Investment Plan with Gross Value = €0.01 and Taxes = €299.99, so the total amount is €300 but nearly zero shares are purchased.
Over time though, the share count drifts slightly from 1.0 (currently at 1.0000044), which means the quote no longer perfectly reflects the real portfolio value. And it will be worse with time.
It works, but it feels like a hack and is not correct. Is there a cleaner way to handle this in PP - ideally one that keeps performance metrics (IRR, TTWROR) accurate?
Thank you,
Hello, the cleanest way would be to track the individual positions. It is tedious as there can be a lot of smaller positions but is it really impossible ?
Is it a French Assurance Vie en gestion pilotée ? If yes, is it 100% Unité de Comptes ? If it is part UC part fond euro, at least I guess you should séparate them to follow the fonds euros as a Cash Account within PP.
Thanks for the suggestion, I’ve thought about it but haven’t found an easy way to do it.
I can download a “situation statement” anytime from the platform, which includes the number of shares and unit value for each fund, along with their ISINs. The portfolio is 100% UC (no fonds euro). I also get one automatically every December 31st.
My main concern is the manual work involved: I have ~24 months of monthly DCA contributions to backfill, and I don’t have the per-fund breakdown for each of those past contributions, only for the rebalancing events
Mm yes it looks complicated. How often do you want to manually change the overall value ?
I am thinking if it is not too frequent: your approach with a single share, in the end can be done as a Cash Account instead of a Security:
One cash account = your gestion pilotée.
DCA = deposit
Gains from previous valuation = interest
Loss from previous valuation = Interest charge
Fees = Fees
It is BoursoVie ? I had a gestion pilotée with BoursoVie in the past. I had document called “Nouvelle allocation de profil” rather regularly, so you could do the new valuation each time this document is produced instead of each year.
Monthly DCA could then be done by a monthly Deposit Investment Plant.
I run a script I made that fetch their API (AV is from Goodvest) every 6-8 weeks and import the whole quote history manually into PP.
Regarding the Cash Account suggestion: I like the idea and it does seem cleaner than my current approach, which needs occasional corrections. My concern though is losing the performance tracking I currently have, like the price chart and % return for this specific instrument.
I reached out to Goodvest to ask if they planned to offer a transaction export (CSV or similar) at some point. Shouldn’t be complicated to set up and most already have this service.