AMFI publishes Net asset value (NAV) for all the Mutual Funds (MF) on end of business days. This can be accessed at https://www.amfiindia.com/spages/NAVAll.txt The format of the data is as follows:

Code: Select all

119551;INF209KA12Z1;INF209KA13Z9;Aditya Birla Sun Life Banking & PSU Debt Fund  - Direct Plan-Dividend;156.0004;15-Sep-2020
119552;INF209K01YM2;-;Aditya Birla Sun Life Banking & PSU Debt Fund - Direct Plan-Monthly Dividend;114.0451;15-Sep-2020
119553;INF209K01YO8;-;Aditya Birla Sun Life Banking & PSU Debt Fund - Direct Plan-Quarterly Dividend;112.5567;15-Sep-2020
108272;INF209K01LX6;INF209KA11Z3;Aditya Birla Sun Life Banking & PSU Debt Fund - Regular Plan-Dividend;163.0606;15-Sep-2020
108273;INF209K01LV0;-;Aditya Birla Sun Life Banking & PSU Debt Fund - Regular Plan-Growth;275.2731;15-Sep-2020
110282;INF209K01LU2;-;Aditya Birla Sun Life Banking & PSU Debt Fund - Regular Plan-Monthly Dividend;111.7986;15-Sep-2020
108274;INF209K01LN7;-;Aditya Birla Sun Life Banking & PSU Debt Fund - Regular Plan-Quarterly Dividend;110.4488;15-Sep-2020
103176;INF209K01LT4;-;Aditya Birla Sun Life Banking & PSU Debt Fund - Retail Plan-Growth;413.2193;15-Sep-2020

I would like to extract NAV from column 4, price date from column 5 by searching column 1.

For example, let us take row number 2. The Investment securities is defined with symbol as 119553. I would like Settings->Configure KMyMoney->Online Quotes entries to extract column 4 and column 5.

Greatly appreciate if anyone could help.

Execute e.g.

Code: Select all

curl -s https://www.amfiindia.com/spages/NAVAll.txt | egrep '^119553' > navall.csv

and then use the file navall.csv as price source. Use file:// as protocol in the URL if an absolute filename does not do it. Use cron to update the file on your disk. I know, this is not the optimal solution and it is efficient when you want more than one symbol but it is what we can support right now.

I couldn't use curl command in kmymoney. Please can you share the command I can use to get per mutual fund.