[Support] Mutual Funds Market values are not upto date

[swarajsomala]

I successfully imported all of my mutual fund portfolios from Kuvera. I can see the balanced fund units, invested amounts, and other details, but the current market values are not up-to-date. I have attached a screenshot and a YAML file with the details. I cross-verified the mutual fund codes and the latest NAV values from mfapi, and they are correct. It would be great if there was a way to display the current NAV values, such as in a tooltip.

For example, MF Mirae Asset Tax Saver Growth Direct Plan, the Current NAV is 40.9750 and the balanced units are 40.9750.So the Market value should be 40.9750 * 1967 = 80597.825 but in the screenshot it showing 69302.

[ananthakumaran]

Just to confirm, did you run paisa update or Update Prices via the UI (available in the top right corner) after you added the configuration. There is also a price page (Ledger > Price), which will show you what Paisa internally uses.

It would be great if there was a way to display the current NAV values, such as in a tooltip.

This is a good suggestion, I will see where I can surface this information.

[swarajsomala]

I understand, thank you. I imported the data using the Kuvera report, so I didn't initially verify the commodity names. Now, I can see that the correct values are displayed for most of my MFs. While importing data from Kuvera reports, I noticed the following code snippet used to generate the ledger format. However, I noticed that the code snippet only takes into account buy orders and doesn't include sell orders. It would be greatly appreciated if it could also support sell orders.

{{#if (and (isDate ROW.A "YYYY-MM-DD") (eq ROW.D "buy"))}}
 {{date ROW.A "YYYY-MM-DD"}} {{ROW.C}}
    {{predictAccount prefix="Assets"}}		{{ROW.E}} {{acronym ROW.C}} @ {{ROW.F}} INR
    Assets:Checking                       {{negate ROW.H}} INR
    Expense:Misc ;; balance any rounding errors
{{/if}}

[ananthakumaran]

It's because I couldn't get access to a Kuvera CSV file with sell orders. If you could share an anonymized sample, that would be useful.

[swarajsomala]

Here is the sample file with sell order.

transactions2.csv

[ananthakumaran]

Thanks, update the kuvera template with the below one, I will include the changes in the next release.

{{#if (isDate ROW.A "YYYY-MM-DD")}}
 {{date ROW.A "YYYY-MM-DD"}} {{ROW.C}}
    {{#if (eq ROW.D "buy")}}
    {{predictAccount prefix="Assets"}}		{{ROW.E}} {{acronym ROW.C}} @ {{ROW.F}} INR
    Assets:Checking                       {{negate ROW.H}} INR
    {{/if}}
    {{#if (eq ROW.D "sell")}}
    {{predictAccount prefix="Assets"}}	-{{ROW.E}} {{acronym ROW.C}} @ {{ROW.F}} INR
    Assets:Checking                              {{ROW.H}} INR
    {{/if}}
    Expense:Misc   ;; balance any rounding errors
{{/if}}

[swarajsomala]

OK, will close the discussion.