Mutual Fund Reconciliation Utility
Useful for anyone with mutual fund investment - regular investment thru broker or Direct with MF or schemes like NPS
1: Fetching Mutual Fund Nav from API : https://www.mfapi.in/
2: Fetching NPS scheme details using Webscrapping : BeautifulSoup
3: Generate MF statement as per SIP schedule given
4: calculate XIRR, Market Value etc for every scheme
5: Output result to excel with format, cell allignment etc.
Instructions:
1: Use attached excel file to fill first tab - ‘MF_Static’
2: Output will be given in tab - ‘Dashboard’