On 12th Aug 2023, Sudheer Tammini announced that he had developed a “simple Free & Open source software that I have developed to export Mutual Funds CAMS statement data onto a nice CSV file”. We asked him to share more details with us. Cams2CSV could be helpful to users of the freefincal MF portfolio tracker on Google Sheets.
About the author: My name is Sudheer Tammini based out of Bangalore; living with my wife and seven years old son, and I’m an MBA Finance graduate by qualification. The fun fact, I do not have a technical degree, and I’m a self-thought programmer with endless curiosity about Technology and Computers, currently exploring Deep Learning. In my free time, I do a lot of tinkering with Computers and write a blog at www.settingbox.com.
Personal Finance: My personal finance journey started back in 2014 with Direct Equity and Regular Mutual Funds (like many) and the journey, I’ve come across people like Pattu, P.V Subramanyam, and Deepak Shenoy and started reading/listening to their blogs/podcasts.
I’ve slowly started learning Personal Finance concepts like Direct Mutual Funds, How Index funds work, why we need to Emergency fund, Portfolio re-balancing etc. In the process, I’ve slowly built a reasonably large portfolio consisting of various instruments like Mutual Funds, T Bills, PPF, EPF etc.
However, there was one problem here, since I was investing all my money directly (without any third-party platform), it has become hard for me to track all my investments. So that’s when I came across a platform called Perfios –PFM (a reputed company based in Bangalore). I’ve opted for their platform.
Join 32,000+ readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email! (Link takes you to our email sign-up form)
🔥Enjoy massive discounts on our robo-advisory tool & courses! 🔥
I was a paid member, and the platform was fantastic with all the automated aggregation features. I need to upload my CAMS statement then all my Mutual Funds data get updated and tabulated in a friendly dashboard format with all kinds of reporting.
But due to business reasons, they have shut down their platform effective Aug 2023, so I started thinking about what next.
My thought process this time was different; why not build something my own instead of depending on others? So that’s when I started building a simple Portfolio Tracker using Google Sheets. I’ve completed it in a couple of days, but that’s when reality hits me hard.
Since I have invested in Mutual Funds for a long time, my CAMS statement had many entries. So how do I bring all these entries from a PDF statement to Google Sheets? Of course, one way is to copy and paste each line manually, which is inefficient and painfully time-consuming.
That’s when I started testing my Python skills to try and see if I could automate this process. I’ve spent a couple of weeks exploring this option and finally built a simple tool to export all CAMS entries to CSV files with a single click. The good thing is I’ve learned so much in this process.
Since the tool was working so well and saving a lot of time for me, I’ve decided to open-source it so that others can also benefit from this tool.
How to use Cams2Csv
It is an app that can be downloaded for Windows and Ubuntu from Github (link below). The UI is very simple and self-explanatory.
Install Cams2CSV from Github. Choose “Run as administrator” to install the exe on Windows.
Step 0: Request CAMS detailed (not summary) Mutual Fund statement from MyCams (link)
Step 1: Click on the Browse button and select your CAMS PDF file
Step 2: If your PDF statement is password protected (in most cases, yes), click on the “Password?” Checkbox
Step 3: Enter your password and hit Submit button – that’s it.
A CSV file will be saved in your Downloads folder in a couple of minutes.
If you find the tool useful or have any feedback, please contact the author via Twitter: Sudheer Tammini. I tried the tool, and almost 1000 transactions were neatly exported onto a CSV file which can be opened on Excel or any spreadsheet tool for further manipulation.
Cams2CSV could be helpful to users of the freefincal MF portfolio tracker on Google Sheets.
🔥Enjoy massive discounts on our courses, robo-advisory tool and exclusive investor circle! 🔥& join our community of 7000+ users!
Use our Robo-advisory Tool for a start-to-finish financial plan! ⇐ More than 2,500 investors and advisors use this!
Track your mutual funds and stock investments with this Google Sheet!
We also publish monthly equity mutual funds, debt and hybrid mutual funds, index funds and ETF screeners and momentum, low-volatility stock screeners.
- Do you have a comment about the above article? Reach out to us on Twitter: @freefincal or @pattufreefincal
- Have a question? Subscribe to our newsletter using the form below.
- Hit 'reply' to any email from us! We do not offer personalized investment advice. We can write a detailed article without mentioning your name if you have a generic question.
Join 32,000+ readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email! (Link takes you to our email sign-up form)
About The Author
Dr M. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. He has over ten years of experience publishing news analysis, research and financial product development. Connect with him via Twitter(X), Linkedin, or YouTube. Pattabiraman has co-authored three print books: (1) You can be rich too with goal-based investing (CNBC TV18) for DIY investors. (2) Gamechanger for young earners. (3) Chinchu Gets a Superpower! for kids. He has also written seven other free e-books on various money management topics. He is a patron and co-founder of “Fee-only India,” an organisation promoting unbiased, commission-free investment advice.Our flagship course! Learn to manage your portfolio like a pro to achieve your goals regardless of market conditions! ⇐ More than 3,000 investors and advisors are part of our exclusive community! Get clarity on how to plan for your goals and achieve the necessary corpus no matter the market condition is!! Watch the first lecture for free! One-time payment! No recurring fees! Life-long access to videos! Reduce fear, uncertainty and doubt while investing! Learn how to plan for your goals before and after retirement with confidence.
Our new course! Increase your income by getting people to pay for your skills! ⇐ More than 700 salaried employees, entrepreneurs and financial advisors are part of our exclusive community! Learn how to get people to pay for your skills! Whether you are a professional or small business owner who wants more clients via online visibility or a salaried person wanting a side income or passive income, we will show you how to achieve this by showcasing your skills and building a community that trusts and pays you! (watch 1st lecture for free). One-time payment! No recurring fees! Life-long access to videos!
Our new book for kids: “Chinchu Gets a Superpower!” is now available!
Must-read book even for adults! This is something that every parent should teach their kids right from their young age. The importance of money management and decision making based on their wants and needs. Very nicely written in simple terms. - Arun.Buy the book: Chinchu gets a superpower for your child!
How to profit from content writing: Our new ebook is for those interested in getting side income via content writing. It is available at a 50% discount for Rs. 500 only!
Do you want to check if the market is overvalued or undervalued? Use our market valuation tool (it will work with any index!), or get the Tactical Buy/Sell timing tool!
We publish monthly mutual fund screeners and momentum, low-volatility stock screeners.
About freefincal & its content policy. Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on mutual funds, stocks, investing, retirement and personal finance developments. We do so without conflict of interest and bias. Follow us on Google News. Freefincal serves more than three million readers a year (5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified with credible and knowledgeable sources before publication. Freefincal does not publish paid articles, promotions, PR, satire or opinions without data. All opinions will be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
- Twitter @freefincal
- Subscribe to our YouTube Videos
- Posts feed via Feedburner.
Our publications
You Can Be Rich Too with Goal-Based Investing
Published by CNBC TV18, this book is meant to help you ask the right questions and seek the correct answers, and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now.Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want
This book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at a low cost! Get it or gift it to a young earner.Your Ultimate Guide to Travel
This is an in-depth dive into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, and how travelling slowly is better financially and psychologically, with links to the web pages and hand-holding at every step. Get the pdf for Rs 300 (instant download)