A Python tool/library that extracts data from CAMS Mutual Fund PDF statements (India) into various formats including CSV, DataFrame, JSON, or a list of dictionaries.
- Extracts fund details, transaction history, and other relevant information from CAMS Mutual Fund PDF statements
- Supports password-protected PDFs
- Outputs data in multiple formats: CSV, DataFrame, JSON, or list of dictionaries
- Automatically fetches latest NAV data from AMFI India portal
- Handles various fund name formats and ISIN codes
- Clone this repository or download the files
- Install the required dependencies:
pip install -r requirements.txtfrom app.processCASpdf import ProcessPDF
# Initialize with PDF file path and password (if required)
filename = "path/to/your/statement.pdf"
password = "your_password" # Use None if PDF is not password-protected
# Create a ProcessPDF instance
pp = ProcessPDF(filename, password)
# Get data in your preferred format
# Available formats: "csv", "df", "json", "dicts"
output = pp.get_pdf_data(output_format="df")
# If output_format is "csv", a CSV file will be created with the current timestamp
# If output_format is "df", a pandas DataFrame will be returned
# If output_format is "json", a JSON string will be returned
# If output_format is "dicts", a list of dictionaries will be returnedWhen using output_format="df", the output will be a pandas DataFrame with the following columns:
fund_name: Name of the mutual fundisin: ISIN code of the fundscheme_code: Scheme code from AMFIfolio_num: Folio numberdate: Transaction datetxn: Transaction type (Buy/Sell)amount: Transaction amountunits: Number of unitsnav: Net Asset Valuebalance_units: Balance units after transaction
See requirements.txt for a list of required Python packages.
This software is provided under the BSD license. See the copyright notice in the source code for details.
This script is an extension of the camspdf.py script originally written by Suhas Bharadwaj.