
In Progress
Posted
Paid on delivery
Project: AI-Enabled Excel Dashboard for 30 Indian Stock Holdings Objective: Build a user-friendly Excel dashboard to monitor my Indian equity portfolio, identify concentration and fundamental risks, and generate automated weekly and quarterly reports. I do not have coding knowledge. Required deliverables 1. Portfolio dashboard: Total investment, current market value, unrealised profit/loss, stock-wise returns, portfolio weights, and sector allocation. 2. Data refresh: Reliable and legally permitted price-data source with refresh instructions, timestamps, and stale-data warnings. Do not rely on fragile website scraping. 3. Risk alerts: Concentration thresholds, material price movements, liquidity concerns, debt and cash-flow deterioration, governance issues, auditor qualifications, and significant company announcements. 4. AI weekly report: Executive summary, major portfolio movements, important company news, risk alerts, and prioritised follow-up actions, with source links. 5. Quarterly fundamental review: Revenue, profit, margins, debt, cash flow, valuation metrics, and material changes in the investment thesis. 6. [login to view URL] compatibility: Use my existing subscription wherever supported. Confirm which exports or integrations are available before promising automation. 7. Automation: Schedule weekly reports by email, with clear error notifications and minimal manual work. 8. Documentation: Provide a working Excel file, setup guide, data-source details, maintenance instructions, and a demonstration. Portfolio: ITC, Swan Corp, AVTNPL, Asian Hotels North, Bohra Industries, Carysil, Coal India, Data Patterns, Delton Cables, Gujarat Energy, IOC, RattanIndia Enterprises, Reliance Industries, L&T, L&T Finance, JSW Infrastructure, MV Electronic, National Aluminium, NSE, SBI Funds, IT BeES, Rico Auto, Rushil, Satia, TARC, Tata Capital, Tata Steel, Tata Technologies and Vision Infra. Important: Verify the exact listed company, ticker and exchange for every name before implementation. Identify any unlisted security, fund, ETF or ambiguous name separately rather than assuming all 30 are ordinary listed shares. Investment objective: Balanced growth and capital protection. The dashboard should support decisions, not issue unverified automatic buy/sell recommendations. Please quote separately for: * One-time development and testing * Monthly software, data and AI costs * Optional ongoing maintenance Please demonstrate a working prototype using sample data before final payment.
Project ID: 40765949
34 proposals
Remote project
Active 1 min ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi, thanks for the invite. I trade Indian equities myself, so I understand this well. Quote, as you asked: 1. One-time build and testing: INR 25,000, 14 days, with a working prototype on sample data before final payment. 2. Monthly running cost: about INR 0 to 1,500. Prices come from Excel's built-in Stocks data type (needs Microsoft 365, which you may already have). Fundamentals come from your [login to view URL] exports. AI summaries cost roughly INR 300 to 800 a month in API usage. 3. Optional maintenance: INR 2,500 per month for fixes, new holdings and data-source changes. Plan: dashboard (investment, market value, P&L, returns, weights, sectors); refresh with timestamp and stale-data warning, no scraping; risk alerts for concentration, big moves, debt, cash flow and announcements; weekly AI report with source links, emailed on a schedule with error notices; quarterly fundamentals review. Before building I will verify every ticker and flag the non-standard names separately: NSE itself and SBI Funds look unlisted or recently listed, IT BeES is an ETF, and a few small caps need exchange confirmation. I will also confirm which Screener exports your plan supports before promising automation. No auto buy/sell calls. You get the file, a plain-English setup guide, data-source notes and a screen-share demo. 480+ projects, 4.9 rating.
₹25,000 INR in 14 days
8.8
8.8
34 freelancers are bidding on average ₹24,529 INR for this job

Hi, Ankit here, from Bahrain. Building your PROJECT with 30 Indian Stock Holdings, an AI weekly report and a portfolio dashboard is doable; what matters most is numbers people trust and use to make decisions. I'm a senior software developer with 8+ years of experience working with projects like this. With risk alerts, the real challenge is clean data and clear definitions. A common issue: building visuals before agreeing how each number is calculated, so reports disagree. My plan: first, agree each metric, its definition and its data source. Then, clean and model the data, and build the report pages in the BI tool. Finally, check totals against the source and set up scheduled refresh. I've done reporting work before, so I check early for totals that do not match the source. A few questions to better understand the scope: 1. Is any source a spreadsheet updated by hand? Manual sheets break refreshes, so I add checks for renamed columns. 2. Start with one page that answers the top question? I'd recommend it, one trusted page beats ten unused ones. 3. Are the dashboards shown to your own clients? Client-facing reports need their branding and strict access rules. I can start right away. Happy to go over the details here in chat and suggest the best approach. Looking forward to hearing from you, Ankit
₹22,000 INR in 3 days
5.0
5.0

Hi, I can build a user-friendly Excel portfolio dashboard for your Indian holdings, designed for balanced growth, risk monitoring, and capital protection. I’ll first verify the exact company names, tickers, exchanges, and security types, flagging ambiguous or unlisted holdings separately. I’ll then demonstrate a working prototype using sample data before final delivery. I can provide separate estimates for one-time development, monthly data/software/AI costs, and optional maintenance after confirming the data sources and automation requirements. The final workbook will be designed for non-technical use, with documented formulas and transparent alerts rather than unverified automatic buy/sell recommendations. Thanks!
₹12,500 INR in 2 days
5.0
5.0

As an AI developer with TechWagger, I have the unique combination of technical skills and experience necessary to construct a personalized, AI-driven Excel dashboard for your Indian stock portfolio. We specialize in creating innovative, user-friendly digital products powered by Artificial Intelligence. For this project, we would start by integrating a reliable and legally compliant price data source into your dashboard with clear refresh instructions and timestamps, ensuring complete data reliability. At TechWagger, our core focus is on delivering tangible value. As such, we propose a solution which not only provides the necessary reports but also empowers you to make informed decisions rather than relying on automated buy/sell recommendations. Finally, with extensive documentation and thorough maintenance instructions, we guarantee that the system will remain robust even beyond project completion. To showcase our abilities prior to final payment, we'll initiate the process with a working prototype using sample data for your approval.
₹37,000 INR in 7 days
5.0
5.0

Having equipped with extensive knowledge and experience in AI, Machine Learning, and Data Science, the team at Infinity Sols excels in developing highly sophisticated digital solutions tailored to the specific needs of businesses. The development of your AI-enabled Excel dashboard to monitor your stock holdings aligns perfectly with our expertise. With our proficiency in Excel, HTML, and PHP on top, we are confident in our ability to build a robust and user-friendly interface that aligns perfectly with your identified deliverables. Last but not least is the credibility of our work. Prior to final payment, I commit to providing a working prototype for your review using sample data. This would allow you to validate the efficiency and suitability of the dashboard for your stock analysis requirements. My aim is not just to complete projects efficiently but more importantly ensuring client satisfaction by delivering high-quality work that drives growth and success. So why wait? Let's start transforming your ideas into reality together!
₹12,500 INR in 5 days
5.1
5.1

As an experienced full-stack developer with a strong background in automation and data workflows, I am well-equipped to tackle your project of creating an AI-enabled Excel Dashboard for your stock analysis. Having spent over 8 years developing and maintaining web applications using PHP, Laravel, Python, and more, I am proficient in automating tasks, integrations and providing efficient solutions. Part of my recent work involved building an ERP system that handles complex data imports just like in your project. By leveraging my OCR capabilities and familiarity with handling diverse API integrations, I can assure you a reliable and quick data refreshment process for your price-data source. Additionally, I can set up intelligent risk alerts that encompass a wide range of factors such as concentration thresholds and noteworthy company announcements; thereby serving as a safeguard for your investments. Lastly, with respect to essential features such as an AI-powered weekly report and quarterly fundamental review, you can count on me for generating comprehensive yet user-friendly reports. By doing so I'll ensure you're fully aware of major portfolio movements,material changes in the investment thesis and more so that you can make informed decisions about your holdings.
₹25,000 INR in 7 days
0.0
0.0

Hello, I can build this. A few notes before I commit to full automation: I'll need to see the exact subscription/data source you have access to before promising automated refresh — you're right that scraping prices directly is fragile and breaks easily, so I'd rather confirm a stable, permitted source (an API from your subscription, or a legitimate data provider) first. Once that's clear, here's my plan: - Build the Excel dashboard: investment, market value, P/L, returns, weights, and sector allocation for your 30 holdings. - Set up a price-refresh method with timestamps, so you always know how fresh the data is, with warnings if it goes stale. - Add the risk alerts you listed: concentration, price moves, liquidity, debt, governance/auditor flags, and announcements. - Build the AI weekly report with source links, plus the quarterly fundamental review. - Set up scheduled weekly email delivery with error notifications if something fails. - Deliver a prototype with sample data first, so you can confirm it's what you want before final payment — exactly as you asked. - Full documentation and a short demo walkthrough at the end. Also happy to verify the exact names/tickers/exchanges for your listed securities as part of the setup. Ali
₹22,000 INR in 8 days
0.0
0.0

Noida, India
Member since Oct 13, 2026
₹12500-37500 INR
₹12500-37500 INR
$250-750 USD
₹1500-12500 INR
₹1500-12500 INR
₹12500-37500 INR
$30-250 USD
$30-250 CAD
₹12500-37500 INR
₹600-1500 INR
$10-30 USD
₹750-1250 INR / hour
₹10000-75000 INR
₹1500-12500 INR
₹12500-37500 INR
₹750-1250 INR / hour
$30-250 USD
₹750-1250 INR / hour
₹1500-12500 INR
₹37500-75000 INR