
Closed
Posted
Paid on delivery
I want a lightweight solution that streams option Price, Open Interest and the Delta Greek from the Dhan API directly into an Excel workbook in real time. My preference is for something easy to maintain—Python with xlwings, a small VBA add-in, or another straightforward bridge that keeps the sheet updating without manual refreshes. As long as the Delta field stays in sync alongside price and OI, I’m flexible on the underlying method. Deliverables • An Excel file pre-configured with live columns for symbol, price, open interest and delta • Well-commented source code or macro that calls the official Dhan API endpoints, handles authentication and manages the streaming/refresh logic • A brief read-me so I can update keys or modify tickers later Acceptance Criteria • Data begins flowing within seconds of opening the workbook and continues without forced refresh • Delta values mirror the same figures visible on Dhan’s platform at any given moment • No hard-coded credentials; everything pulls from a secure, editable config cell or file If this sounds clear and achievable, let’s set it up.
Project ID: 40614491
24 proposals
Remote project
Active 3 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
24 freelancers are bidding on average ₹7,777 INR for this job

Hi, I can build a lightweight, real-time Excel integration using **Python with xlwings** (or VBA if preferred) that streams **Option Price, Open Interest, and Delta** directly from the official Dhan API with secure authentication and automatic updates. The solution will include a pre-configured Excel workbook, clean and well-documented source code, configurable API credentials, and a simple README so you can easily manage keys, symbols, and future enhancements. You can message me so we can proceed further. Thanks.
₹7,000 INR in 1 day
5.1
5.1

Hi, I'm a Data Scientist with over three years of experience specializing in data analysis, Web-Scraping, and machine learning. I have good experience with Excel VBA / Macros / UDFs. One of my projects involved extracting market data from the web and updating cells using VBA. I think I can do this project if you are interested.
₹8,000 INR in 7 days
4.6
4.6

I understand the value of efficiency in your project and know that I can deliver what you need. With my firm's 9+ years of experience focusing on web and mobile development, we have become well-versed in using various tools and languages, especially Python which is highly recommended for this type of task. Our expertise extends to excel as well, meaning we are capable of leveraging xlwings or VBA add-ins to ensure that your data updates stay synchronized with the Dhan API seamlessly, without manual intervention. Moreover, we appreciate the importance of clarity in instructions and for this purpose, I am committed to providing well-commented source codes alongside a comprehensive readme document after the completion. The credentials for this API integration would reside in secure yet editable cells/files providing maximum flexibility and security without any hardcoded parts. Thanks to our focus on E-commerce and CMS based websites, we are already familiar with integrating data flows from various sources into Excel workbooks, which gives us an edge in delivering a streamlined solution within your timeline. Your satisfaction is our priority; therefore, we offer three months of post-development support at no additional cost. I believe our expertise can make your visionary project a reality! Looking forward to contributing to your success!
₹17,000 INR in 7 days
4.6
4.6

Hi, I can build a lightweight real-time Dhan options feed into Excel, streaming option price, open interest, and Delta directly into a pre-configured workbook. The best solution is to use Python with xlwings or a simple VBA/Python bridge, depending on your preferred setup. I’ll connect to the official Dhan API, handle authentication through a secure editable config file or Excel cell, and keep the selected symbols updating automatically without manual refresh. I’m comfortable with Python, Excel automation, xlwings, VBA/macros, API integration, real-time market data, options data, Open Interest, Greeks, authentication handling, and clean documentation. Deliverables include: * Live Excel workbook * Symbol, price, OI, and Delta columns * Dhan API connection * Streaming/refresh logic * Secure editable credentials config * Ticker modification option * Error handling and reconnect logic * Commented source code/macro * README setup guide I’ll focus on a simple, stable, and easy-to-maintain solution that updates quickly and keeps Delta in sync with Dhan’s platform data. Best regards Ankit
₹5,000 INR in 1 day
3.7
3.7

Hi, how are you doing? I have considerable experience with Python and Excel automation, including xlwings and lightweight bridges to live data sources, plus a track record with trading tooling. I’ve worked on projects that stream market data into spreadsheets with secure config handling and minimal setup, and I can deliver a pre-configured Excel workbook with live symbol, price, OI, and delta columns, plus well-commented code and a brief read-me. Let me know further if interested.
₹12,500 INR in 5 days
3.4
3.4

Welcome to professional Python development services! Hi there, I'm Alema, a Python expert programmer who strives for clear code in atmospheric, numerical weather prediction, physics, and all other seminal fields. I'm ready to provide you with high-quality services. I have completed 350+ projects with a 100% Positive Rating. If you are looking for Quality work, look no further. Tech stack: Python, FastAPI, Django PostgreSQL, SQLAlchemy React, JavaScript, TypeScript Docker, Docker Compose CI/CD (GitHub Actions, GitLab CI) AWS (EC2, S3, Lambda, ECS), DigitalOcean, Heroku NGINX, Caddy If you're looking for a reliable Python backend developer to help with your project, feel free to reach out. Your faithfully. Eng. Alema Akter
₹7,000 INR in 1 day
3.5
3.5

Hello, "Python‑Excel Bridge For Live Dhan Feed" - streaming option data into Excel in real time I will build a small Python service using xlwings that authenticates to the Dhan API, pulls price, open interest and delta every few seconds and writes them directly into the workbook cells you designate. The workbook will contain a config sheet for API keys and ticker symbols, so updating them is just a edit in Excel. The service runs as a background process started from a tiny VBA macro button, keeping the sheet alive without any manual refresh. I have delivered similar API‑to‑Excel integrations using Python and VBA, ensuring secure handling of credentials and reliable streaming. Will you prefer the Python service to start automatically on workbook open, or to be launched manually via a macro button? Looking forward to working with you. Abror Yakubov
₹6,000 INR in 5 days
3.1
3.1

I can build a lightweight real-time bridge between the Dhan API and Excel that continuously updates option price, open interest, and delta without manual refresh. The most maintainable approach for this use case is a small Python service using xlwings (or websocket polling if supported by the endpoint) connected to a pre-configured Excel workbook. This keeps the workbook simple while handling authentication, reconnect logic, and live updates externally for better stability. Implementation would include: - Excel workbook with configurable symbols and live columns for Price, OI, and Delta - Secure configuration for API credentials using a local config file or editable worksheet cells - Real-time update loop with retry/reconnect handling - Clean, commented source code focused on easy future modifications - Short README explaining setup, ticker changes, and credential updates I’ll also validate the delta calculations/feed values against the data exposed by Dhan to ensure consistency during runtime. The solution will be lightweight, easy to run on Windows with Excel installed, and designed to start streaming automatically within seconds after opening the workbook.
₹12,500 INR in 3 days
2.6
2.6

Dhan's WebSocket feed gives you price and OI natively, but Delta isn't part of their streaming payload. I'll compute it locally using a Black-Scholes model fed by the live underlying price, strike, expiry, and an implied volatility derived from the option's last traded price. That keeps Delta in sync without relying on a separate data source. I'll wire this up with Python and xlwings: a background thread maintains the WebSocket connection, calculates Greeks on each tick, and pushes updates into your Excel sheet with no manual refresh. Auth tokens and ticker lists will live in a config sheet you can edit freely. 1) Are you trading weekly or monthly expiries, or both? This affects how I handle the expiry-date logic for Delta calculation. Happy to talk details in chat. Shayan
₹1,650 INR in 3 days
2.2
2.2

Hello, For this project, from personal experience, a well constructed Excel spreadsheet or a Google Sheet is an ideal and suitable solution. I have experience of building such spreadsheets dashboards for personal use, and I am pretty sure that this will be complete for you in just 2 days. Let's have a chat on this project to know your requirements in details. Happy to help! Raj
₹6,500 INR in 2 days
2.3
2.3

Hi, At first glance, this looks straightforward but there’s usually one part that causes issues later. Happy to share a quick plan if you're open to it. Regards, Rajesh
₹7,000 INR in 7 days
0.0
0.0

I can help you build a real-time options feed that streams key data directly into Excel, making it effortless to track price, open interest, and delta. I noticed your preference for a lightweight solution using Python with xlwings or a simple VBA add-in. I can create a well-commented macro that handles authentication and ensures the data flows seamlessly as you specified. My experience with creating clean and modern interfaces, like in the "Modern Real Estate Investment Website" project, allows me to design this Excel workbook to be user-friendly and easy to maintain. You can check out my similar project: [Modern Real Estate Investment Website](link). Let’s chat about how to set this up, and you’ll get a free consultation to discuss the best approach. Regards, Dean
₹5,650 INR in 7 days
0.0
0.0

I am a seasoned trading software developer, data scientist, and full stack engineer with 20+ years of combined experience delivering enterprise grade solutions. I specialize in automated trading bots, having built systems around RSI, MA, MACD, Bollinger Bands, harmonic and Fibonacci strategies. Recent projects include: • AI driven equity day trading bot with real time L1/L2 data ingestion and risk controls. • Options straddle/strangle manager with dynamic hedging and margin optimized basket orders. • Multi asset scalping bot tuned for ultra low latency execution. • Portfolio rebalancer integrating ML forecasts with smart order routing. • Backtest engine validating strategies against years of minute level data. I have recently deployed a machine learning algorithm for predictive trading, combining advanced research with robust live execution. Looking forward to discussing how we can tailor this expertise to your needs. Best Regards, Radhika
₹12,000 INR in 7 days
1.4
1.4

Ethan here, from South Africa. Your project immediately caught my eye. I'm really excited to partner with you. I see you’re looking for a lightweight solution to stream option price, open interest, and the Delta Greek from the Dhan API directly into Excel. I recently completed a similar project that involved real-time data integration into an Excel workbook, which resulted in a seamless user experience for the client. To approach this, I would use Python with xlwings to ensure easy maintenance. I’ll implement a configuration setup for secure, editable credentials, allowing you to update keys and tickers effortlessly. I guarantee high-quality results through well-commented source code, an intuitive read-me guide, and thorough testing to ensure data flows flawlessly from the moment you open the workbook. What you truly need is a reliable data stream that keeps you informed in real time. I can deliver that. Please feel free to reach out so we can connect and further explore how I can contribute to your project's ABOVE THE REST SUCCESS. Kind regards, Ethan
₹5,150 INR in 8 days
0.0
0.0

xlwings is the right call here - it keeps the workbook a normal Excel file while a Python process owns the connection and pushes updates straight into named ranges, so there's nothing for you to manually refresh. Plan: a background Python script authenticates to the Dhan API, subscribes to your ticker list, computes/reads Delta alongside price and OI, and writes into the sheet on each tick (websocket feed if Dhan's API supports it, else fast polling as fallback - I'll confirm which once I see your API access). Keys and ticker list live in a separate config sheet/file, never hard-coded. One question: do you already have Dhan API credentials with market data access, and roughly how many symbols need to stream at once? That affects whether polling is fast enough or a websocket feed is needed. Deliverable: the pre-wired workbook, the Python bridge script with comments, and a short setup readme for swapping keys/tickers later.
₹6,500 INR in 4 days
0.0
0.0

Your acceptance criteria contains a conflict worth naming before anyone writes code: price and OI arrive on Dhan's live feed websocket, but Delta comes from the Option Chain endpoint, which is rate limited to roughly one call every few seconds. Two different clocks. A naive build either parks a stale Delta next to a live price, or throttles the whole sheet down to the slower source. How I handle it: the websocket writes price and OI continuously, a separate poller refreshes the Greeks on its own timer, and every row carries its own last-updated stamp. That is what keeps Delta honest against what you see on Dhan's platform. The second thing that breaks these builds is writing to Excel from inside the socket callback. It freezes the sheet while you scroll it. I queue updates and flush on a throttled writer, so the workbook stays usable while data flows. I build production Python around streaming APIs, including a live voice agent that handles real inbound calls with concurrent audio streams, so reconnects and backpressure are familiar ground. Your token lives in an editable config file, never in code, with a note on refreshing it when Dhan expires it. First milestone: live price and OI ticking into your workbook for one symbol, so you can watch it run before we layer the Greeks on. Tell me which symbols and expiry you track most and I will configure those first.
₹7,400 INR in 5 days
0.0
0.0

As a Quantitative Data Analyst, I specialize in low-latency financial data pipelines. I can build the exact lightweight architecture you need to stream Options Prices, Open Interest, and Delta directly from the Dhan API into your Excel workbook in real time. My Architectural Approach: I will use Python coupled with xlwings. This is the most robust and maintainable bridge. Asynchronous Ingestion: A Python script will query the Dhan API via WebSockets or high-frequency REST calls to capture tick-level changes in Price, OI, and Delta. Real-Time Load (xlwings): Instead of using clunky VBA loops that freeze the workbook, xlwings will push the updated arrays directly into your specific Excel cells from the background. You won't need to click "refresh"; the sheet will update dynamically. I have built similar systems analyzing institutional liquidity in crypto markets. I understand how crucial it is to handle API rate limits and avoid memory leaks during live trading hours. Let's connect to define the exact layout of your workbook so I can structure the Python feed today. Best regards
₹5,000 INR in 4 days
0.0
0.0

Bengaluru, India
Payment method verified
Member since Jun 15, 2021
₹600-1500 INR
₹600-1500 INR
₹600-1500 INR
₹600-1500 INR
₹1500-12500 INR
£250-750 GBP
₹600-1500 INR
$10-30 USD
$250-750 USD
$250-750 USD
£250-750 GBP
₹250000-500000 INR
₹12500-37500 INR
₹600-1500 INR
$10-30 USD
$10-30 USD
$30-250 USD
$30-250 USD
₹600-1500 INR
$30-250 USD
$250-750 USD
$30-250 CAD
$30-250 USD
$15-25 USD / hour
₹600-1500 INR