How do you track and manager all your investments in one place if you are doing it directly?
I took full control of my finances back in mid 2019 once I was back for good from US. Previously my dad was handling my money and he did terrible job at both, handling where to invest and how to track. I was finance noob until then but started learning stuff online and taught myself everything related to finances.
I first collated all info of all my investments using my PAN# etc and tried to find any app that can help me manage everything. Could not find anything at all that does everything or was paid (without even ability to try what was on offer).
I then created a google sheets that is now shared with my wife. I created sections for mutual funds, SGB, PF, PPF, LIC etc etc and mentioned the currently invested amounts. (shares are listed in separate sheet but current aggregated value is bought on first main sheet).
Google sheets has google finance option to get latest share price, latest NAV value etc so I used that to fetch those values that that usually latest or max 2 days old. Ofcourse, invested amount needs to be manually updated that I do every month post all SIPs are done for the month and units are updated. Current investment value for each mutual fund is calculated automatically.
For SGB, I found one function online that gets latest SGB value (for my SGB which I took in 2020) from a website so that is updated too.
For NPS also, I found some function related to HDFC's NPS (my NPS is with them) to give latest NAV for each breakup (that E, C something) and that is how I get latest values of NPS.
PPF since I invest only once per year (try my best to do before 05th April) and I put entire 1.5L, I only update once.
PF/VPF is updated monthly as my company manages it through trust so my salary slip contains the value each month.
It is a continuously improving sheet. The workbook doesn't have one sheet only, but this is my main sheet which gives me holistic view of my investments and a number which sort of tells me my "networth" (excluding my flat that is not accounted here).
I have additional sheets too in same workbook named "PAN etc" which has my and family member's PAN# , Adhaar#, demat account numbers etc.
One sheet is "Earnings FY 2024-25" (changes each financial year) to note down all earnings like redemptions done, interest from some NCD, dividend, FD interest, saving account interest etc.
One sheet is for medical information like insurance company name and number and how much we have. Term insurance details.
I make sheets on need basis.