Live Nifty Options Excel Dashboard

@Microlent

Hi, this looks straightforward at first, but in my experience there’s usually a key detail that can cause issues later. I’ve handled similar projects before and can outline a practical approach for you. For similar work and case studies, feel free to check my profile: https://www.freelancer.com/u/microlent Let me know if you'd like me to walk you through the plan. ~ Rajesh

@nareshk44

I am Naresh, a highly skilled professional excelling in data analysis, visualization, and extensive Excel programming including macros. I have a deep understanding of your project needs and a proven record in building comprehensive, automated excel dashboards. Over the past 8 years, I have delivered numerous projects similar to yours with utmost precision and high-quality output. One of the biggest advantages of choosing me is not just my proficiency in VBA, Power Query, and scripting but also my adaptability to choose what suits your requirements best. In this case, I can use VBA along with the office scripts to build a light-weight add-in or any other approach you prefer so you receive a cost-effective yet efficient tool. Additionally, my experience with Alpha Vantage will ensure that I smoothly integrate their API into your dashboard for uninterrupted and accurate data feed. Lastly, my proficiency in English and Hindi will assure seamless communication for any future guidance you might need using this tool or if you require me to translate any material. I am committed to maintaining professional support even after delivering the main product. With me, you are not just hiring a freelancer for a task but forging a long-term beneficial relationship.

@tanyat29

Hi, I reviewed your requirement for a live Nifty option-chain Excel tracker. This is definitely doable, but it needs careful handling because NSE blocks direct API calls without proper session handling. Here’s how I’ll build a reliable solution for you: • Secure data fetch from NSE option-chain using proper headers/session handling • Automatic ATM detection + ±5 ITM/OTM strike selection • Clean structured table (Open Interest, Change in OI, Volume) • Hidden raw data sheet for audit trail • Auto-refresh every 3 minutes (start/stop button included) • Live updating time-series chart inside Excel • Error handling (auto retry on failure without breaking the sheet) I’ll deliver a fully working .xlsm file with clear instructions so you can easily update strikes or settings later. I’ve worked on automation + data pipelines before, so I’ll make sure this runs smoothly without manual intervention.

@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 13) Tradetron: RSI + ADX + EMA strategy 14) Python Moving avarage channel trading Algo 15) Kotak Neo: Turtle scalping strategy for options 16) Fyers Filtered option chain in Excel 17) Binance Bitcoin tradingview strategy python bot 18) Fyers Tradingview python bot 19) Dhan Python order manager I can deliver any project in Trading. Readymade setups for Python available

@rishi9343

I will build an Excel workbook that connects to the NSE India option-chain and pulls Nifty 50 data for the at-the-money strike, plus five strikes out-of-the-money and five strikes in-the-money, capturing Open Interest, Change in Open Interest, and Volume Strike Price, and refresh them every three minutes, with a time-stamped line graph that updates in real time, using VBA or Power Query to Alpha Vantage, store raw JSON/CSV response in a hidden sheet, and transform data into a tidy table