
Completed
Posted
Paid on delivery
My trading sheet already holds each NSE/BSE symbol, the recommended buy price, the actual buy price and its stop-loss. The only piece missing is a quick way to fill the Current Market Price column and have Excel immediately show the unrealised profit or loss for every position. Here is what I need built: • A macro, add-in or small script that I can trigger on demand (one click or a shortcut key). • On execution it should fetch the latest CMP for every symbol in the sheet from a reliable source that covers Indian equities. I am open to your guidance on whether that is a free financial API, a paid endpoint, or a lightweight scrape of NSE/BSE data—whichever is stable and within fair usage limits. • Once prices are pulled, the tool writes them into the designated column, updates the P/L calculation for each row (₹ value and percentage), and optionally flags any position whose CMP is at or below the stop-loss. You are free to use VBA, Power Query, Python, or another method that works inside Excel 2016 on Windows. Please keep the code well commented and include a short read-me so I can adjust symbols or expand the spreadsheet later. Deliver the working file and the source code, along with brief setup instructions. After that I will test it with my live portfolio to confirm the CMPs and calculations update correctly. Sample XL. [login to view URL]
Project ID: 40469601
16 proposals
Remote project
Active 7 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

Wiring live NSE/BSE data directly... I see you need a stable, on-demand Current Market Price (CMP) pipeline built into your trading sheet without dealing with fragile web scrapers. Here is my technical execution plan for your Excel 2016 environment: Stable Data Pipeline: I will engineer a lightweight Python script (or an advanced Power Query connection) utilizing a free, reliable endpoint (like Yahoo Finance) to pull live NSE/BSE data safely without triggering rate limits. Automated Logic: I will wire the incoming CMPs directly into your designated columns, ensuring your ₹ value and % P/L calculations update the second the data lands. Stop-Loss Flagging: I will implement strict Conditional Formatting rules to instantly highlight any row in red where the live CMP drops at or below your predefined stop-loss. Handover: You will receive the fully unlocked Excel file with a 1-click "Refresh Prices" macro button, plus a clean Readme explaining how to add new symbols in the future. Budget & Timeline: Based on my execution rate, I can build, test, and hand over this complete automated sheet for ₹7000 INR within 48 hours. Quick technical question: Are your current ticker symbols formatted with exchange suffixes (like [login to view URL] or [login to view URL]), or are they currently just the raw company names?
₹7,000 INR in 2 days
7.2
7.2
16 freelancers are bidding on average ₹7,378 INR for this job

Hello, I will create a custom Excel macro or add-in to fetch the latest Current Market Price for Indian stocks and update the profit/loss calculations based on the provided data. The solution will be efficient, reliable, and user-friendly. Please initiate the chat to discuss further details. Thanks
₹5,000 INR in 4 days
6.0
6.0

I am an Excel & VBA Automation Expert with an MBA and 10+ years of experience delivering smart solutions to global clients (eg. Decathlon, E&Y, Schindler). I’ve successfully completed 100+ projects (4.9★ rating), helping businesses save time, reduce errors, and boost efficiency. I can create excel based stock market automation tool as per your requirements mentioned in the project description. I have already created similar tools for other stock market traders. Please have a look at my project portfolio to have a better understanding of my experience. Lets chat and discuss the details further. Looking forward to working with you!
₹4,000 INR in 3 days
5.9
5.9

<<<✔Consider it DONE✔>>> YO! I understand your project and I'm eager to help. With my extensive experience in data analysis and Excel manipulation, I’m confident that I can create a reliable solution for your Indian stock updater. My understanding of PHP, Python, and Excel would prove useful in building the macros or scripts you need to promptly fetch the Current Market Prices (CMP) from reliable sources and update your trading worksheet in real-time. Understanding your objectives, I will suggest the best technique—from a free financial API to an NSE/BSE scrape—that optimizes your operations in adherence with fair usage limits. Looking forward to being part of your project! You will surely be impressed by my work! Not sure what the next step is? I offer free and professional consultation -- I'm just a text away. All the very best, Josh
₹7,000 INR in 2 days
5.6
5.6

As the highest-rated professional in this platform, I am confident that I possess the skills to solve the problems you've outlined in your Excel spreadsheet. My extensive experience with Data Scraping, Data Analysis, and especially Excel has equipped me with the necessary tools to deliver quality solutions in a timely manner. You need a reliable way to update your trading sheet with NSE/BSE stock prices; not only can I provide this stable method but I can also guarantee it adheres to fair usage limits. Some of the specific skills that make me a perfect match for your project include using VBA, Power Query and Python inside Excel 2016 on Windows. I'm proficient in integrating APIs as well and would ensure thorough testing to guarantee accurate and up-to-date data. I'll also include detailed documentation so you can later modify symbols or expand the spreadsheet seamlessly. Furthermore, I offer unlimited revisions until you are fully satisfied, meaning that even after delivering a working file and source code, I will be around post-project for any support or adjustment you might need. Working with me isn't about just getting the job done, it's about forging long term relationships based on service satisfaction. Let's get your trading sheet detailed and streamlined as per your vision.
₹7,000 INR in 1 day
5.3
5.3

Hello, I’d be happy to help build this solution for your trading workbook. I have an MBA background and extensive experience with: • Excel VBA automation • Financial and trading spreadsheets • API integration and data feeds • Power Query and Excel 2016 solutions • Portfolio tracking and P/L dashboards I can build a one-click solution that will: • Fetch the latest CMP for all NSE/BSE symbols in your sheet • Update the Current Market Price column automatically • Recalculate unrealized P/L (₹ and %) instantly • Highlight positions that have reached or breached stop-loss levels • Work directly within Excel 2016 on Windows Depending on your preference, I can implement: • VBA + API integration (recommended) • Power Query refresh workflow • Python-assisted solution if desired I’ll also provide: • Fully commented source code • Setup and maintenance guide • Instructions for adding new symbols or expanding the workbook • Error handling and validation checks I have completed similar stock market and portfolio automation projects before and can help you choose the most reliable data source for Indian equities while keeping the solution easy to maintain. Best regards.
₹8,000 INR in 3 days
5.1
5.1

Hi, how are you doing? I have solid hands-on work building Excel tools and small automation for market data, including VBA and Python add-ins that fetch live prices and update P/L with minimal setup. I’ve done projects around pulling data from reliable Indian market feeds, updating sheets on demand, and flagging stops, with clear, commented code and a quick-readme for future tweaks. I can deliver a ready-to-run file and source, plus setup notes. Let me know further if interested
₹12,500 INR in 5 days
4.0
4.0

Hello, I can build a reliable Excel 2016 solution that updates live NSE/BSE CMPs with one click and instantly calculates unrealised P/L for your portfolio. I will create either a VBA macro or Python-integrated solution (depending on stability and ease of use) that: * Fetches latest CMP for all symbols * Updates the CMP column automatically * Calculates profit/loss in ₹ and % * Flags stocks hitting stop-loss levels * Works directly inside Excel on Windows I can integrate stable market data sources such as NSE/BSE APIs, Yahoo Finance, or other reliable providers based on your preference and usage limits. The code will be clean, commented, and easy to expand later. I will also provide: * Working Excel file * Full source code * Setup instructions * Short readme documentation I have experience with Excel automation, VBA, APIs, and financial data integrations, and I can start immediately. I reviewed your sample sheet and can adapt the solution to your existing structure without disrupting your workflow.
₹7,000 INR in 7 days
4.0
4.0

As an automation specialist with over a decade of hands-on experience, I am perfectly equipped to develop the Excel Indian Stock Updater you need. My expertise in Excel VBA and Google Sheets automation will be incredibly valuable for tackling this task efficiently. Additionally, I have substantial experience in utilizing Python and other relevant tools to automate data manipulation and extraction tasks, which makes your project a perfect fit. Throughout my career, I have helped numerous clients streamline their processes, reduce errors and save valuable time by means of smart automation. Your requirement of automating the data fetching process from reliable sources for Indian stocks and updating the corresponding cells perfectly coincide with my skill set. Being well-versed in various automation techniques such as VBA, Power Query, Python, I can assure you a seamless execution of your project. In addition to delivering reliable and efficient solutions, I place tremendous value on strong communication and delivering clean, maintainable code. As a result, you'll not only receive a working file and source code but also brief setup instructions - enabling you to take charge of any future modifications or expansions.I would be thrilled to bring my skills in Automation, QA/testing (manual + automated), Excel VBA/Google Sheets automation, and web development to ensure that the Current Market Price column is gathered accurately thus allowing all calculations.
₹10,000 INR in 7 days
3.4
3.4

I can build an Excel-compatible solution using VBA + API/Python integration to fetch live NSE/BSE CMP values, auto-update P/L (₹ and %), highlight stop-loss breaches, and provide one-click refresh support. The solution will include clean documentation and an editable setup for future symbols or portfolio expansion. Please chat for further discussion
₹6,000 INR in 4 days
2.3
2.3

Hi I'll build an Excel tool that fetches live NSE/BSE stock prices for your trading sheet and updates P/L calculations instantly. What I'll do: - Create a macro/Python script that pulls CMP from a reliable Indian data source (Yahoo Finance API, Alpha Vantage, or NSE's official feed) - One-click trigger updates all symbols, writes prices to your CMP column, calculates ₹ P/L and percentage - Optional stop-loss flagging when CMP hits or goes below SL Skills: VBA/Python, Stock Market APIs (NSE/BSE), Excel Automation, P/L Calculations, Stop-loss Alerts Timeline: 3-4 days. I'll deliver the working file, commented code, and setup instructions. Just share your Excel sheet structure and preferred data source. Best regards Sandeep Kumar
₹7,000 INR in 7 days
2.3
2.3

Chennai, India
Payment method verified
Member since May 15, 2019
₹1500-12500 INR
₹1500-12500 INR
₹1500-12500 INR
₹12500-37500 INR
₹600-1500 INR
$250-750 USD
$10-30 USD
₹12500-37500 INR
$250-750 USD
€8-30 EUR
$250-750 USD
₹12500-37500 INR
$3000-5000 AUD
$10-30 USD
₹1500-12500 INR
₹600-1500 INR
₹750-1250 INR / hour
₹12500-37500 INR
₹12500-37500 INR
$250-750 USD
₹12500-37500 INR
€30-250 EUR
₹1250-2500 INR / hour
$750-3000 USD
€30-250 EUR