Automate Hourly NSE Excel Export

Job ID: 40001776

Budget: ₹12,500 – ₹37,500 INR

I want an automated way to pull live NSE stock-market information into Excel every trading hour. The data points I rely on are the latest stock price, trading volume, and delivery percentage for a watch-list of 135 stocks. These quotes should be captured simultaneously at the top of each hour while the market is open and written straight into a single workbook—either appending new rows with a timestamp or refreshing an existing table, whichever is simpler to maintain.

A lightweight Python solution using nsetools / NSEpy, pandas, and openpyxl would be perfect, but I’m open to any language or library as long as the final result is an Excel file that updates itself without manual intervention. Scheduling can be handled with Windows Task Scheduler or a small cron job on a VPS; just include clear setup instructions so I can keep it running day after day.

Acceptance criteria:
• Script fetches price, volume, and delivery % for all 135 tickers in one call cycle
• Run frequency: once per hour between 9:15 am and 3:30 pm IST (6 captures per session)
• Output lands in my specified workbook with a readable timestamp column
• No missing rows or partial updates—if any ticker fails, the script retries and logs the error

Hand over the fully commented code, a sample Excel output, and a quick start guide so I can test it on my end right away.