Python Program for Live Nifty 500 Data

Job ID: 38770123

Budget: ₹600 – ₹1,500 INR

I require a Python program that will pull live, tick-by-tick data of Nifty 500 stocks. This data will include the Last Traded Price (LTP), Open, High, Low, Previous Close, and Volume. The program will feed this data into an Excel file (specifically, an XLSX format) using the Dhan HQ 2 API. This data needs to be updated every second.

Ideal skills for this project include:
- Proficiency in Python, particularly with handling APIs and data processing
- Experience with leveraging Excel through Python (specifically creating XLSX files)
- Familiarity with financial data and stock market terminology
- Understanding of the Dhan HQ 2 API

Your bid should reflect your experience with similar projects and your ability to deliver a program that meets these specific requirements.