MFtool

Tool to calculate your MF investment returns and benchmark each fund wrt Nifty 50 performance from the date of investment

How to use?

• Required columns in the input csv file:
  1. "symbol" - Name/Symbol of the MF
  2. "isin" - Security ID (ISIN) of the MF
  3. "trade_date" - Purchase date
  4. "price" - NAV on purchase date
  5. "quantity" - Units bought
• For CAMS & KFin statement, first run CAMS_RTA_ISIN.ipynb in the cams folder, which will create the required csv file with ISIN of the funds
• Paramters to be edited in MF_Return.py:
  1. currDate = date(2023, 1, 6) (Current date in year,month,date format)
  2. file = "mf_2022_buy.csv" (Input csv file)
• Run the MF_Return.py script

  Package requirements: numpy, pandas, scipy, urllib

• Output Summary Excel example MF_Summary.xlsx for the input file mf_transactions.csv

References

• https://github.com/peliot/XIRR-and-XNPV
• https://github.com/swapniljariwala/nsepy