Option live data in google sheets through python.

₹750-1250 INR/uro

Odprt

Objavljeno

pred 6 dnevi

•

Zaključi se čez 18 ur

₹750-1250 INR/uro

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.

Software Architecture

ID projekta: 38913975

Več o projektu

23 ponudb

Odprto za oddajo ponudb

Projekt na daljavo

Aktivno pred 1 dnem

Oddajte ponudbo

Vrednost ponudbe

₹

INR

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

23 freelancerjev je oddalo ponudbo s povprečno vrednostjo ₹1.348 INR/uro za to delo

@rameshraja86

Hi There, I am proposing to develop automated customized OI table with various data points like LTP, OI, PCR, IV, Bid and Ask Price in Excel Sheets by integrating Integrating NSE website by python for NSE data. I've been a Full stack developer for 13 years specializing in Excel VBA Automation for the development of custom functions in MS-Excel, Word, Powerpoint, Outlook. I can develop Google sheet to incorporate features of all trading options automatically using Google scripts and formulas and with automatic alerts triggers. It can be integrated with Gmail, SMS and WhatsApp I have already experienced similar project that will pull data from WAZIRX trading data site into Google Sheets. Also I did some more projects in Trading data automations in Zerodha, Truedata, Google Finance, WAZIRX, etc., for calculating options data, charts like Moving Average, Candle chart, backtesting, live alerts and signals. My skill sets:  Excel VBA coding for data and calculation automations.  Excel Formula development using all functions like IF, VLOOKUP, HLOOKUP, MATCH, SUM, COUNT, AVERAGE, SUMIFS  Dashboards with charts, tables, pivot table with slicers and timeline  Custom VBA Addins for Excel, Word, Powerpoint and Outlook  Algo Trading with Signal generation (Truedata, Zerodha, WAZIRX) Please contact me to proceed further. Regards, Ramesh Raja

₹1.500 INR v 40 dneh

5,0

(43 ocen)

5,6

@ionstefanache1

Hi I can do that website using python for you Please contact me for more details In the past I worked in Romanian Commodities Exchange and understood which want to have Thanks

₹8.860 INR v 40 dneh

5,0

(7 ocen)

4,9

@sajidjasi

Dear , Hope this message finds you well. I have gone through your project "Option live data in google sheets through python.". From the project description, it is interesting for me and I am fully confident to finish the project timely. Therefore, I am submitting my proposal. I am waiting for a quick chat to finalize project. My offered price is tentative and will be actualized based on working hours/quantity. I am a data analysis and visualization expert. I have more then a decade experience in work with large & complex business and economic datasets using a range of IT tools. I am proficient in MS Excel/VBA, Power BI, and Google Sheets/Forms to assist business in managing & visualizing data. My dedication to delivering high-quality results, attention to detail, and commitment to meeting deadlines have consistently earned me the trust of clients (reviews). You can consider me to provide effective solutions and support for your project. Regard, Sajid Hussain

₹1.274 INR v 28 dneh

4,6

(26 ocen)

4,8

@vaxpert

With over 5 years of experience as a Virtual Assistant, I have developed strong skills in Excel and managing data that will be crucial to the success of this project. I understand that you are seeking an expert who not only has experience with financial data, APIs and Python, but one who can also build a seamless integration with Excel. This exactly what I have been doing and I have some interesting webinars about it that i can share with you. In the past, I have worked on projects similar to yours where I have successfully integrated financial data into Excel sheets through APIs. Additionally, my keen eye for detail means I will be able to sum the necessary points like the change of open interest, Implied Volatility, Last traded price, and more for all three ATM + 3 strike prices. Thanks to my vast experience in data entry and conversion, adding these new values every minute would be a walk in the park for me I see your requirement of plotting these data points on a chart. Luckily, just last month I worked on a project where I created interactive charts from dynamic data inputs using scripts in Google Sheets. They were refreshed automatically every few minutes to update live information just like you want. My familiarity with such tasks gives me the ability to get your project up and running quickly. Excited at the prospect of working together soon!

₹1.000 INR v 40 dneh

0,0

(0 ocen)

0,0

@vikash6267

Hello, I can help you integrate live NSE options data into an Excel sheet using the Zerodha Kite API. Here's what I will do: Scope: Data Points: Fetch Price, Volume, Open Interest, Implied Volatility, Last Traded Price, and Change of Open Interest. ATM + 3 Strike Prices: Ensure the ATM strike prices change dynamically with the Nifty price. Data Aggregation: Sum Change of Open Interest, Last Traded Price, and Implied Volatility for both Puts and Calls. Excel Integration: Update the sheet with a new row for every refresh (e.g., every minute). Charting: Plot Change in Premium, Implied Volatility on Y-axis, and Change of Open Interest/Volume on X-axis. Charts will update automatically upon data refresh.

₹1.000 INR v 40 dneh

0,0

(0 ocen)

0,0

@SHOBA0001

Already written script see my portfolio . You can see demo live. Contact me if you want to develop a effective and efficient scripts for your options chain fetching system .

₹1.000 INR v 40 dneh

0,0

(0 ocen)

0,0

@ojas17

I have extensive experience in system design and coding in python, PHP native, I am familiar with frameworks like flask, fastAPI, django.

₹1.000 INR v 40 dneh

0,0

(0 ocen)

0,0

@kamleshjhirwar

Hello, ⭐ I am highly professional and master's in Web design and development field, and Yes I can build a Python solution to fetch live NSE options data using the Zerodha Kite API and update it in an Excel sheet. The program will track ATM + 3 strike prices, calculate totals for key metrics like open interest, implied volatility, and last traded price, and refresh data row-by-row automatically. ⭐ It will also generate a dynamic chart to visualize changes in premium, implied volatility, and open interest over time. With experience in APIs, financial data, and Excel integration, I can deliver an efficient and user-friendly solution. ⭐I have Experience in this field for the last 5 years and I'm very consistent in my work.I will do a great job on your project if you give me a chance I will make you 100% satisfied with my work. I have great experience to create this types of websites. ⭐ I have a good knowledge and expertise in PHP, wordpress, java script, woocommerce, HTML, CSS bootstep, PHP, Website Design, Graphic Design, Codeigniter, HTML etc. ⭐ I can provide you complete assistance for same on stipulated time frame. Thanks and Regards Kamlesh

₹1.000 INR v 40 dneh

0,0

(0 ocen)

0,0

@Okayvenkat95

I am 3years of experience in data entry and specific project and for the word ms excel and power point and chemdraw

₹1.000 INR v 40 dneh

0,0

(0 ocen)

0,0

@Harshit3011998

As i have the experience of the API and store the data in csv format. I worked on the Binance like other API also. I also worked on the blockchain part.

₹850 INR v 25 dneh

0,0

(0 ocen)

0,0

@shashankg60

I have 10 years of experience working as a Quant Trader so it's like easy for me. You can hire me I can help you in this.

₹1.000 INR v 40 dneh

0,0

(0 ocen)

0,0

@ansarfanse

Data Entry, Hand writing into Microsoft word or excel file, Handling Email, Hand writing into pdf file

₹750 INR v 40 dneh

0,0

(0 ocen)

0,0

@SAGARIKASHAH58

I am excited to apply for your project and bring my expertise to deliver exceptional results. As a Certified Machine Learning and Data Scientist & Analytics Engineer from IIT-M and a Software Developer in a product-based company, I have a proven track record of delivering high-quality solutions. Why Choose Me? Technical Expertise: Proficient in Python, SQL, Machine Learning, Power BI, and NLP with hands-on experience in AI, LLMs, and Deep Learning. Data Solutions: Skilled in Data Cleaning, ETL, Data Modeling, and crafting compelling visualizations to turn insights into actions. Diverse Knowledge: Experience in C#, JavaScript, and domain-specific insights like Aviation. Approach I prioritize understanding your requirements, delivering scalable solutions, and maintaining open communication. Leveraging my technical and analytical skills, I will ensure your project meets and exceeds expectations. Let’s connect to discuss how I can contribute to your project. I look forward to collaborating with you!

₹1.000 INR v 40 dneh

0,0

(0 ocen)

0,0

@Hkaushik98

Hey there, I have a keen interest in trading using analysis myself. I once tested a hypothesis that same sector companies show high correlation when comparing for different time frames. The hypothesis failed but it was a fun project. I would be happy to provide any python assistance. I am looking forward to work on many other interesting projects with you and not this one. Let me know if the pricing is too steep for you. I would be happy to make amends as a first time collaboration and someone with similar interest. You just name the feature, I will be up for it since python is a very versatile language. Thanks

₹1.000 INR v 40 dneh

0,0

(0 ocen)

0,0

@DevGuruPython

Hi, this is Harshal from Pune an avid option buyer as well as senior python developer. I have already worked on kind of similar but more complex project that I can show you live in action any time (in market hours). I understand your task as developer and option trader perspective and can easily bring your vision to action. Looking forward to talk with you further. Thanks & Regards, - Harsh

₹750 INR v 40 dneh

0,0

(0 ocen)

0,0

@singhmandeep2207

Hey there! Hope you are doing well. I'm a part-time trader myself, and a professional Software Architect with over 10 years of experience building large scale data management systems for financial institutions. I have build similar projects before, but on a larger scale, where I was pulling data multiple sources(Interactive Brokers, CME, NYSE, TSE, OSE) and organising it on Google Drive in JSON, CSV & Excel files. I think I can provide with a nice and clean solution for your problem, we may have to get on a brief call once to clearly define the goal & scope of the project, and I will the share the final timeline accordingly. Please feel free to drop me a message if you'd like to take this forward. Thanks, Mandeep

₹1.000 INR v 40 dneh

0,0

(0 ocen)

0,0

@kk1568

Dear Client I saw your requirement regarding to develop a solution for getting nse options chain data into google sheet. I can develop this application within few hours maximum. I developed many applications is similar to your requirement. So I can develop this application ASAP based on your requirement. Let share further details. Thanks and Regards Kannadasan K

₹750 INR v 1 dnevu

0,0

(0 ocen)

0,0

@chauhanjagadish

Hello, I hope you're doing well! I came across your job posting and I am excited about the opportunity to collaborate on your project. With over 8 years of professional experience working on similar projects, I am confident in delivering high-quality results tailored to your specific needs. Could you please share more details about your project requirements? This will help me better understand your workflow and ensure we’re fully aligned. I’d also happily provide examples of my past work during our discussion. Recently, I completed a project very similar to the one you're looking to implement so that I can get started quickly and efficiently. Let’s get into a chat and discuss your project further. I look forward to your response and the opportunity to collaborate! Thank you, Jagadish

₹1.000 INR v 40 dneh