Real-Time NSE Stock Data Google Sheet

Job ID: 38473954

Budget: ₹600 – ₹1,500 INR

I'm looking for a freelancer who can create a Google Sheet with real-time NSE India stock data.

The Sheet should have the following columns:
- Column A: NSE India stock symbols
- Column B: Stock names
- Column C: Real-time, live price (please don't use =googlefinance formulas as these give delayed data)
- Column D: Open price
- Column E: (Yesterday) close price

Data Update Frequency:
- The data should be updated in real time.

Data Source:
- I prefer using web scraping to obtain real-time stock prices from the NSE India website.

Ideal Skills:
- Proficient in Google Sheets
- Experienced in web scraping
- Knowledgeable about stock market data

Please note that I'm looking for a freelancer who can deliver a fully functional Google Sheet without using delayed data from =googlefinance formulas.