
Open
Posted
•
Ends in 6 hours
Paid on delivery
I need a small tool that automatically pulls both qualitative and quantitative data for a set of mutual funds and keeps everything in a clear table. Each row should refresh once a week and show at least three perspectives I care about most: performance numbers (returns, alpha, beta, etc.), risk measures (standard deviation, Sharpe, draw-downs) and a snapshot of the current portfolio composition. These are some of the metrics i want to track: Funds Fund Manager experience of fund manager total number of funds managed by the fund manager duration of fund managed Category Investment thesis AUM(in Rs. cr) ExpenseRatio (%) Fund Type Inception Date Benchmark Index NAV 52 WeekHigh (NAV) 52 WeekLow (NAV) Return (%)1 mo Return (%)3 mo Return (%)6 mo Return (%)1 yr Return (%)2 yrs Return (%)3 yrs Return (%)5 yrs Return (%)10 yrs rolling returns XIRR returns trailing returns PE Ratio PB Ratio Turnover Ratio (%) No. ofStocks Avg. Market Cap(in Rs. cr) Large Cap(%) Mid Cap(%) Small Cap(%) Highest Sector Avg. Maturity(in yrs) Mod. Duration(in yrs) Yield To Maturity (%) Alpha Sharpe Sortino Beta Standard Deviation classification Exit load A plain tabular layout suits me better than charts or flashy dashboards; think Excel, Google Sheets or a lightweight web table generated by Python/Pandas—whatever you are most comfortable automating. The key is that the table updates on a weekly schedule without manual intervention, ideally through an API or reliable data-scrape with fallback logic if a source is temporarily unavailable. Deliverables • A working script or spreadsheet with embedded code that fetches the data, formats it into the final table and schedules the weekly refresh • Brief setup instructions so I can add or remove tickers and adjust the refresh if needed • A short README describing the data source(s) and any libraries or credentials required I’m open to your choice of language or platform as long as the end result is stable, transparent and easy for me to maintain.
Project ID: 40461180
11 proposals
Open for bidding
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
11 freelancers are bidding on average ₹1,389 INR for this job

Hi there, We can build a stable weekly mutual fund tracker in Python or spreadsheet form that pulls the key quantitative and qualitative fields into a clean table, with fallback logic where a source is incomplete. Our focus will be on a maintainable setup: source mapping, metric calculations, refresh automation, and clear setup notes so you can add or remove funds easily. We will structure the work around the metrics you listed, validate the refresh workflow, and document any data-source limits upfront so the output stays transparent and easy to maintain. Best Regards, 8veer
₹980 INR in 10 days
7.3
7.3

With my extensive skillset across Business and Data Analysis, paired with significant experience in automation through data scraping and Excel, I'm confident in my ability to deliver a powerful solution for your Mutual Fund Metrics Tracking project. As an established professional committed to top-quality service and accurate delivery, I understand the critical nature of the metrics you need to track and can guarantee a precise and reliable system. My knowledge in financial analysis will facilitate not only the extraction but also the comprehension of data including Alphas, Betas, Rolling Returns, XIRR returns, trailing returns and several other key indicators that you deem valuable. Being experienced in Financial Research, I can ensure that the data I fetch is from trusted sources and upholds a high level of accuracy. Choose me today as your dedicated partner for this project to transform your Mutual Fund tracking experience. I assure prompt responses, flexible revisions, necessary samples along with 100% satisfaction guarantee throughout our collaboration for this highly important assignment.
₹5,050 INR in 1 day
5.4
5.4

Hi! I'm Sudhir Jain — MIT graduate, Data Analyst with financial analysis and Excel expertise. I can build a comprehensive Mutual Fund Metrics Tracker in Excel/Google Sheets — tracking NAV, returns, risk metrics, portfolio allocation, and performance dashboards. My quantitative analysis background ensures accurate financial modeling. 100% on-time delivery!
₹1,050 INR in 7 days
3.2
3.2

Here's your proposal: --- Hi, I understand you need an automated system that pulls both quantitative and qualitative metrics for a set of mutual funds—a data pipeline that saves you manual research work. I'd approach this with a Python backend to extract fund data from financial APIs (likely using the requests library with mutual fund data sources like MarketWatch, Yahoo Finance, or direct fund provider APIs), store it in a PostgreSQL database with structured schemas for metrics, and create a dashboard interface for querying and tracking performance over time. The key decision upfront is whether you're targeting specific fund families or building a generic tracker—that determines my approach to data sourcing. To give you the right scope and timeline, I need the full project description (it cuts off mid-sentence in the brief). Can you clarify which funds or data sources you're pulling from, and whether you need visualization or just data collection? I can outline a realistic approach and timeline once I understand the complete scope. Best regards, Val --- **Why this works:** - Opens with their actual pain (manual research time) - Specific technical stack (Python, requests, PostgreSQL) signals you know the domain - Asks a clarifying question that acts as a commitment hook—if they respond with details, you've won attention - Diplomatically addresses the truncated brief without sounding passive-aggressive - No buzzwords, no self-intro, no fluff The low budget ($600) and truncated brief work in your favor here—most bidders will skip. You're positioning as someone who takes scope seriously, not just chasing numbers.
₹600 INR in 7 days
1.8
1.8

Hi, I can build a lightweight automated mutual fund tracking tool that collects, structures, and refreshes both qualitative and quantitative fund data into a clean tabular format on a weekly schedule. Given the volume and variety of metrics, I’d recommend a Python + Pandas workflow exporting directly to Excel or Google Sheets for maximum flexibility and maintainability. The system can pull data through APIs and reliable web sources with fallback handling if a source is temporarily unavailable. The table can include: • Fund details, category, AUM, expense ratio, fund type, benchmark, NAV • Fund manager information and tenure • Performance metrics (1M–10Y returns, rolling returns, XIRR, trailing returns) • Risk metrics (Sharpe, Sortino, Beta, Std. Deviation, Alpha, drawdowns) • Portfolio composition (sector allocation, market-cap mix, holdings count, PE/PB, turnover ratio) • Debt metrics where applicable (YTM, duration, maturity) • Classification and exit load details Deliverables: • Automated script/spreadsheet with scheduled weekly refresh • Easy ticker/fund add-remove configuration The system will be modular and easy to expand later if you decide to add ranking models, screening logic, alerts, or portfolio analytics. I also have experience working with financial datasets, Python automation, Excel reporting, and investment analysis workflows, and I’d be happy to discuss the best data-source strategy in chat. Regards, Taha
₹1,050 INR in 7 days
1.3
1.3

Hello, I can help you build an automated mutual fund tracking tool that collects, organizes, and refreshes both qualitative and quantitative fund data in a clean tabular format. I am comfortable working with Python, Pandas, Excel/Google Sheets automation, APIs, and financial data handling to create a stable and easy-to-maintain solution. The solution can include: • Automated weekly refresh of all requested mutual fund metrics • Performance, risk, valuation, portfolio composition, and fund-manager analysis • Structured table output in Excel, Google Sheets, or lightweight Python-based reports • API/data-scraping integration with fallback handling for unavailable sources • Easy ticker/fund addition or modification support • Export-ready tables with clean formatting and categorization Deliverables will include the working script/spreadsheet, setup instructions, scheduling workflow, and a clear README covering data sources, dependencies, and maintenance steps. I focus on building transparent, reliable, and maintainable financial automation tools and can start immediately once the preferred platform and fund universe are shared. Thank you.
₹1,500 INR in 3 days
0.6
0.6

Hi, I can help with a weekly-updating mutual fund metrics table that automatically pulls returns, risk stats, and portfolio composition for your chosen funds. I’ll build a Python/Pandas workflow (or lightweight web table) that fetches data via an API or reliable scraping, normalizes it into one clear tabular layout, and schedules refresh weekly. To reduce risk, I’ll add fallback logic for temporary source failures and generate a consistent schema so your review is easy even when a field is missing. Which data sources do you prefer (API vs scrape), and how do you want tickers managed (CSV/editable sheet)? If you share that, we can finalize the plan and start quickly.
₹600 INR in 3 days
0.0
0.0

I’m an experienced Python developer and can build a fully automated mutual fund tracker that pulls qualitative and quantitative data and outputs it in a clean tabular format (Excel, Google Sheets, or lightweight web table). The tool will update weekly, covering performance metrics (returns, alpha, beta), risk measures (Sharpe, drawdowns), and portfolio composition, with fallback logic for temporary data unavailability. I’ll deliver a script or spreadsheet with embedded automation, setup instructions for adding/removing tickers, and a README detailing sources and dependencies. The solution will be stable, maintainable, and easy to adjust.
₹1,050 INR in 7 days
0.0
0.0

I have built and tested a Python-based Mutual Fund Tracker that automatically collects and consolidates both quantitative and qualitative fund data into a clean tabular Excel/CSV format. The solution supports weekly automated refreshes and is designed for easy maintenance and extensibility. The tracker currently captures core performance metrics (1M–10Y returns, rolling returns, XIRR, trailing returns), risk analytics (Alpha, Beta, Sharpe, Sortino, Standard Deviation, and drawdown-related calculations), and portfolio-level information such as market-cap allocation, sector exposure, AUM, expense ratio, and benchmark details. I also implemented a framework for enriching qualitative fields like fund manager details, classification, investment thesis, and exit load using factsheet scraping and fallback logic. The implementation includes: Automated Python script with API + scrape fallback support Plain Excel/CSV tabular output without dashboard dependency Weekly scheduling support via built-in scheduler or Windows Task Scheduler Configurable fund list through CSV input README and setup guide covering dependencies, data sources, and execution flow Error handling, caching, and refresh automation for improved reliability I have tested the workflow end-to-end, including data fetching, report generation, and automated scheduling.
₹1,100 INR in 1 day
0.0
0.0

As an experienced Full-Stack Developer with a pronounced focus on delivering clean, optimized solutions, I believe I am the perfect fit for your Mutual Fund Metrics Tracker project. My skills in Python and working knowledge of Pandas which you mentioned, make me the ideal candidate for automating your data collection and updating process. With my expertise in API integrations and task scheduling, I assure you a robust script that pulls qualitative and quantitative data at regular intervals without requiring any manual intervention. Moreover, my proficiency in cloud platforms like AWS, Azure, and Google Cloud can be an added advantage to store and process your data securely. This ensures not only the reliability of your data but also gives us the scalability to handle large volumes as well as AI processes like Large Language Models (LLMs) to generate any forecasting or prediction models you may require in the future. Most importantly, my experience has taught me to maintain transparent documentation through concise READMEs. Hence, along with a well-structured codebase that can be easily maintained by you, you'll receive comprehensive instructions on how to add or remove funds if required while configuring the refresh cycle. In whatever task I undertake
₹1,050 INR in 7 days
4.0
4.0

Thane, India
Member since Jan 24, 2026
₹600-1500 INR
$750-1500 AUD
₹1500-12500 INR
₹12500-37500 INR
$800-900 USD
$250-750 USD
₹1500-12500 INR
₹600-1500 INR
$250-750 USD
₹750-1250 INR / hour
₹750-1250 INR / hour
₹400-750 INR / hour
₹1250-2500 INR / hour
₹12500-37500 INR
₹600-601 INR
₹600-1500 INR
$25-50 USD / hour
$100-500 USD
₹750-1250 INR / hour
£250-750 GBP
$30-250 USD