Live NSE Options Data Integration with Excel using Python

₹1500-12500 INR

Closed

Posted

about 2 months ago

₹1500-12500 INR

Paid on delivery

I'm looking for a Python programmer who can pull live NSE options data into an Excel sheet using the Zerodha kite API. The data should encompass: - Price data - Volume data - Open interest data - Implied volatility - Last traded price - Change of open interest The ideal candidate would have a deep understanding of financial data, experience working with APIs, and the ability to create a seamless integration with Excel. Please include in your proposal examples of similar projects you've completed. ATM + 3 strike prices always. If nifty current price is changing then ATM + 3 should change automatically From all the API data we need to have data points like Change of open interest, volume, last traded price, implied volatility and total open interest. You need to sum change of open interest for three ATM + 3 strike prices. Sum last traded price change for ATM + 3 strike prices. Sum implied volatility for three strike prices. This is for both puts and calls. These three totalled data points should appear in next excel sheet. Upon every refresh another row should be added and updated with new values. For example if i refresh every minute then in an hour it should add 60 rows with updated values (60 minutes) These data points should be plotted on chart. change in premium and implied volatility on Y axis(both sides) and change of open interest/volume on X axis. whenenver new row is addded upon refresh data points should get updated on charts.

Python

Software Architecture

Excel

PHP

JavaScript

Project ID: 38785023

About the project

18 proposals

Remote project

Active 19 days ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

18 freelancers are bidding on average ₹11,625 INR for this job

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

₹9,000 INR in 3 days

4.9

(732 reviews)

8.7

@bindmission

Hello, I have 10 years of experience in financial data integration and API development. I propose to integrate live NSE options data into Excel using Python and the Zerodha Kite API. This will include price data, volume, open interest, and other key metrics. I will ensure automatic updates of ATM + 3 strike prices and detailed result aggregation. The data will refresh every minute, with charts updating accordingly. I have completed similar projects with robust results. Regards, VishnuLal NB

₹12,500 INR in 3 days

5.0

(488 reviews)

7.4

@ASSAMWEB

Greetings, I have read the project description I have been working on a similar project in recent time. I am interested in the work open a chat to discuss requirements in details.

₹40,000 INR in 4 days

5.0

(35 reviews)

5.6

@IMBASANTAKUMAR

My name is Basanta Kumar, and I have over 12 years of experience in various domains including data analysis, automation, and finance; all of which are essential for this project. My technical expertise includes advanced Excel, VBA/Macros, Python, and Power Query- all of which are necessary for seamless integration of the Zerodha Kite API you mentioned. I have a strong background in financial data and have previously worked on projects involving algorithmic trading and option strategies. Additionally, I have a keen understanding of operational support and project management which would come in handy while summarizing the requisite data points from the API and plotting them onto an Excel chart. As an MBA holder with a Postgraduate Diploma in Computer Applications, my skills are a unique blend of business acumen and technical know-how that is critical for this particular project. Lastly, technology excites me; I'm always looking for ways to power up my data analysis capabilities. Choosing me would guarantee that your project is handled by someone as passionate as you are about using every available tool to maximize results. So why settle for ordinary results when you can have exceptional ones?

₹4,000 INR in 1 day

4.8

(99 reviews)

5.0

@raiquerlis

As an experienced and versatile full-stack developer with a keen passion for data integration and Python expertise, I am confident in my ability to accomplish the task at hand. Having completed numerous successful projects that involved leveraging APIs and data visualization, I possess a strong command of the crucial financial data you need to pull from the Zerodha Kite API and integrate seamlessly into your Excel sheets. My familiarity with JavaScript, PHP, and Python makes me the ideal candidate for this job. Not only do I have a deep appreciation for financial data interpretation gained from my proficiency in web development, but I also understand how a minute-by-minute change in pricing can impact trading strategies. This insight will allow me to precisely implement automation that keeps track of ATM +3 strike prices as per the continuously changing Nifty. In addition, I am skilled at creating interactive charts using various JavaScript libraries, perfect to meet your requirement of plotting implied volatility, premium change, and open interest on the X-axis. Rest assured, your Excel sheets will be consistently updated with every refresh, accurately reflecting the most recent API values. To summarize, my extensive technical knowledge in handling APIs efficiently and my aptitude for visualizing complex data make me a valuable choice for this project - let's take your NSE options data management to new heights!

₹7,000 INR in 7 days

5.0

(7 reviews)

3.3

@ajay2811

I am capable of handling your project because I have already completed many similar projects. I have extensive experience in developing trading platforms and have worked with APIs such as "Zerodha," "angle," and many broker APIs. I have developed numerous forex and crypto trading robots.

₹12,000 INR in 7 days

5.0

(4 reviews)

1.7

@fahadt5

To secure a challenging positioning a reputable organization to expand my learnings,knowledge and skills. Secure a responsible career opportunity fully utilize my trainings and skill, while making a sufficient contribution to the success of the company.

₹7,000 INR in 7 days

0.0

(0 reviews)

0.0

@kiranbajulge

We propose a Python-based solution to automate the process of fetching, processing, and visualizing real-time NSE option chain data. Key Features: Real-time data fetch from Zerodha Kite API Calculation of key metrics (open interest, volume, implied volatility) Automated Excel updates with calculated data Dynamic charts for trend analysis Benefits: Informed decision-making Increased efficiency Enhanced risk management We offer a customized, efficient, and user-friendly solution to empower your trading strategies. Let's discuss your specific needs and explore how we can tailor this solution to your requirements.

₹12,500 INR in 7 days

0.0

(0 reviews)

0.0

@mushahida1

Hello, I’m excited to work on your project. With experience in Python, financial data handling, and API integration, I can set up the Kite API with Excel to pull real-time NSE options data and provide seamless data handling as specified. Approach Kite API Integration: Connect to the Zerodha Kite API to retrieve live data, including price, volume, open interest, implied volatility, last traded price, and change in open interest. Dynamic ATM + 3 Strike Selection: Automatically detect ATM with the three strikes above and below, updating dynamically if Nifty’s price changes. Data Summation: Calculate summed values for changes in open interest, implied volatility, and last traded price for both calls and puts across these strikes. Excel Integration and Refresh: Populate Excel with data, adding a new row each refresh (e.g., every minute) and storing updated values for 60 minutes. Visualization: Create dynamic charts in Excel, plotting premium and implied volatility changes (Y-axis) against open interest/volume (X-axis), updating with each refresh. Relevant Experience My past projects in financial data visualization and API-driven workflows ensure I can handle this efficiently. Looking forward to discussing this further!

₹7,000 INR in 2 days

0.0

(0 reviews)

0.0

@rahuls340

I am writing to apply for the Data Entry job that I saw posted on your website. I have done some data entry work in the past and I think I would be good at this job. I know how to use a computer and I type pretty fast. I am available to start work immediately.

₹7,000 INR in 7 days

0.0

(0 reviews)

0.0

@sumandiassi4

first of all i am a trader , i have 5 years of expert experience and i have loose my all capital in a wave in june month in election time..My expertise lies in mastering the suite of Microsoft Office tools, particularly excelling in MS Excel and harnessing the full potential of Microsoft PowerPoint. These skills enable me to create compelling presentations and efficiently handle data analysis, showcasing my attention to detail and analytical mindset. In addition to my technical prowess, I'm deeply committed to delivering top-notch quality work within deadlines. My dedication to continuous learning and growth ensures that I stay updated with the latest advancements in the tech world, making me a valuable asset in the freelancing landscape. Through freelancing, I aim to not only earn a sustainable income but also gain practical experience, expand my network, and contribute my expertise to various projects. My goal is to carve a niche for myself in the freelancing community, offering innovative solutions and building lasting relationships with clients based on trust and reliability. ... 24x7 support avail able.

₹7,000 INR in 7 days

0.0

(0 reviews)

0.0

@b4connect

i have worked with financial organisation and i have myself using excel sheet for the zerodha stock pricing changes.I have 10 yrs experience in python and data mangement.

₹10,000 INR in 7 days

0.0

(0 reviews)

0.0

@DevGuruPython

Hi, this is harshal senior developer and profitable option buyer since last 10 months. I clearly understand what are you looking for and I have already developed a system very similar to your requirement using Python+ AWS + PaytmMoney API where we display sum of OI, COI, Vega, Delta, Theta, Gamma for ATM to deep OTM strike prices for Nifty, BankNifty and FinNifty indices. These updates happens every seconds and instantly pushed to a webpage using web-sockets. I can show you the demo and very sure of completing your task confidently. Waiting for your reply, Thank you. - Harshal

₹10,000 INR in 7 days

0.0

(0 reviews)

0.0

@srigopi423

I have worked on many projects to extract the data to many platforms and created a report with different extension, So this requirement is matching with my knowledge, I can do this and complete it within this span

₹7,000 INR in 7 days