Auto-Updating Option Chain Sheet

@AbhyudayaCodes

Hi, Sir/Madam ! Warm Greetings !! We are a team of expert algo trading systems developers, having vast experience in algo trading field, mainly using Python. We have built the following types of algos: > NSE/MCX Markets > Algos trading F&O, Stocks, Spreads, Straddles, Cryptos & Commodities > Indicator/price movement based algos > Desktop/server based > Multi client systems > Systems with Stop loss, Trailing SL, Target Profit, Martingale, Qty Splitter, Multi Timeframe, Stock Screening, etc. > Have built custom timeframes and indicators > Brokers like Zerodha, Fyers, Angel One, IB, etc. > Chart patterns like Heikin Ashi, Renko, Marubozu, etc. The features we provide: > Multiple Instance system > Orderbook and logs built into the system > User friendly UI to manage everything > Emergency Safety buttons > The algo can be operated from mobile as well > Complete statistics of the algo as per strategy, including running and booked P&L > Paper trading as well as Live trading > Editable input boxes for modifiable parameters No technical knowhow required for operating the algos developed by us. We focus on delivering quality to our clients, keeping in mind safety, security, aesthetics, scalibility, etc. Considering our skill set and experience, we think we will be a perfect fit for your project. Looking forward to working with you ... Message us to discuss further

@salajka

Hello! I'm an experienced Google Sheets and Apps Script developer with 8+ years of automation expertise. I've successfully built similar data automation solutions using Google Apps Script, APIs, and real-time data integration. For this project, I can: - Create a time-triggered Apps Script that calls NSE option-chain endpoints - Parse and populate live data into your Google Sheets automatically - Pull historical Bhavcopy files and extract CE/PE LTPs - Implement percentage performance calculations as specified - Provide fully commented code and comprehensive documentation I understand the technical requirements well and can deliver this within 5-7 days. Ready to start immediately! Best regards

@Ussama91

I will automate three tasks in your Google Sheets workbook: fetch NSE option-chain data for NIFTY and BANKNIFTY at 15:00 hr, extract historical data from Bhavcopy files, and calculate percentage performance for each strike, delivering a populated Google Sheets file, commented Apps Script code, and a README for trigger adjustments. Waiting for your response in chat! Best Regards.

@Sahyadri96

Completed projects till now 1) Python + DhanAPI +Excel + VBA option scalping strategy 2) Python 21 EMA and 9 EMA crossover strategy on DhanAPI 3) Google sheet + FyersAPI trading 4) Google sheet + Algomojo + Upstox 5) Tradetron Banknifty option scalping strategy 6) Excel 2600 NSE 10 years data 7) Copytrading using python 8) Tradetron Supertrend + MACD Crossover Strategy 9) Dhan option chain with Greeks in Google spreadsheet via Google Appscript 10) Backtesting of Nifty options for wait and trade strategy 11) Trigger orders for Dhan Nifty options 12) Shoonya API:- Wait and trade strategy I can deliver any project in Trading. Readymade setups for Python available

@Thabs9

Hi [TM MOHALE], I'm excited about your Auto-Updating Option Chain Sheet project! I see the importance of accurate real-time data for your NIFTY and BANKNIFTY options. With my background in JavaScript and data scraping, I can automate data retrieval and historical snapshots exactly as you need. Using Google Cloud Platform and APIs, I will create a seamless automated process that updates accurately at 15:00 hr daily. You can rely on my expertise to deliver precisely what you're looking for, within your desired budget. Let's work together to bring your project to life efficiently and cost-effectively. I look forward to the potential opportunity to collaborate and create a valuable solution for you. Best regards, [Thabo]

@Trayonda

Hi, I’d love to take this project. Here’s why I’m the best fit for this job: I’m a full-time content creator and web developer with solid experience in Google Apps Script, API integrations, and financial data automation. I have already built similar automations that connect Google Sheets with live market data, historical bhavcopies, and scheduled triggers—so your workflow matches perfectly with what I do. I can deliver: • A clean, reliable Apps Script pulling NIFTY & BANKNIFTY option-chain data at exactly 15:00 every trading day. • Automated fetching and parsing of the last 3 daily Bhavcopies with CE/PE LTP snapshots. • Fully accurate % movement calculations for 1-day, 2-day, and 3-day sessions. • A well-structured Google Sheet with live & historical tabs, plus a clear in-sheet README for future changes. • All code properly commented, optimized, and bound to a time-based trigger—no manual steps, no paid add-ons. I focus heavily on accuracy, reliability, and clean automation, so the sheet will refresh consistently without errors. If you’d like, I can also extend the script later for additional symbols or metrics. Ready to start right away and deliver quickly.

@Vosify

I am a perfect fit for your project because you need a clean, professional, and user-friendly Google Sheets workbook that seamlessly integrates automated data fetching from NSE for NIFTY and BANKNIFTY option chains at 15:00 every trading day. My expertise includes Google Apps Script automation, API integration, and creating reliable, well-documented solutions. I’ve completed similar projects involving live market data import, historical snapshot management, and precise percentage performance calculations. I have tons of experience and have done other projects off site. I would love to chat more about your project! Regards, Ruben Vos

@IganranE1

Hi there, I’m a Google Sheets Automation & Apps Script Developer experienced with financial data workflows, NSE option-chain imports, and time-based triggers. I can automate your workbook so it fetches live data at exactly 15:00 every trading day, stores historical snapshots, and computes clean percentage moves per strike. Here’s how I’ll solve your problem Build a 15:00 daily trigger (weekday-only) that calls a reliable NSE option-chain endpoint for NIFTY and BANKNIFTY and writes CE/PE fields: Strike, OI, Volume, Bid, Ask, LTP. In the same run, fetch the last 3 Bhavcopy files, parse CE/PE LTPs, and freeze them into historical tabs so nothing overwrites. Add logic/formulas/scripts to compute 1-day, 2-day, and 3-day % moves formatted to two decimals. Ensure all outputs align per strike so comparisons remain accurate. Deliverables Updated Google Sheets workbook with Live, History, and % Performance tabs Fully commented Apps Script (fetching, parsing, mapping strikes, writing results) Time-based trigger bound to 15:00 IST Internal README explaining triggers, endpoint updates, and how to add/remove symbols Why me (USP) I specialize in financial-data automations using free/public endpoints without paid add-ons, ensuring reliability and clean mapping across sessions.

@Swapnildu

I can create a clean and interactive Power BI dashboard to track Operational Efficiency with clear Plan vs Actual metrics. I will connect and model multiple Excel files, build accurate DAX measures, and design visuals that highlight progress, delays, and performance trends. I have experience building similar dashboards for operations and business performance reporting, and can share examples of my work. Fast delivery and clear communication guaranteed.

@harshithd3

Hello, I can deliver a fully automated Google Sheets solution that fetches, snapshots, and analyzes NSE options data exactly as you described—without manual downloads or paid add-ons. Implementation approach: • A Google Apps Script (JavaScript) time-based trigger will run at 15:00 IST on every trading day • The script will call NSE option-chain endpoints (with proper headers) for NIFTY & BANKNIFTY • For every strike on both CE & PE, it will capture: Strike Price, OI, Volume, Bid, Ask, and LTP into a Live Data tab In the same trigger: • The last three Bhavcopy files are automatically pulled and parsed • CE/PE LTPs for matching strikes are stored as frozen historical snapshots Performance calculations: • Clean % movement per strike for 1-day, 2-day, and 3-day periods • Output formatted to two decimals only, matching NSE figures Deliverables: • Google Sheet with live + historical tabs • Fully commented Apps Script bound to the 15:00 trigger • Calculation logic (formula or script) • README tab explaining trigger edits and symbol additions Why me: I have strong experience with JavaScript, Apps Script, NSE data structures, Bhavcopy parsing, and options analytics, ensuring both technical accuracy and market-correct results.