Automated NSE Data Recording in Excel
Budget: ₹1,500 – ₹12,500 INR
I'm looking for a freelancer well versed in web scraping and Microsoft Excel. The task involves automatically fetching open interest data for Nifty & Banknifty Options from the Moneycontrol website or preferentially the official NSE website. The data fetch should begin at 9:15 am and end at 3:30 pm, and be updated every 3 minutes.
Data to be recorded includes:
- Contract Name
- Strike Price
- Open Interest
The ideal candidate should have experience with:
- Web scraping
- Data automation
- Financial data
- Microsoft Excel
Since the data is financial in nature, precision and accuracy are paramount. The end goal is to have an Excel sheet with accurate, real-time updates about Nifty & Banknifty options.
Requirements:
1. Get data from NSE for Banknifty & Nifty options. (I already have access to them. )
2. Need to automatically record OI, LTP, OI Chng and LTP chng for a number of strikes of my choice every 3 mins starting from 9:15 to 3:30
3. I should be able to do further calculations of my own from this data using excel formulae.
4. There should be another page to dynamically pick the number of strikes of my choice and show them there. For eg, we might be recording data of 20 strikes but I may need to see only of 6 among them. Then, I should be easily able to see them and do calculations from them.
5. Further customizations and beautifications if required shall be done then.
6. Finally, I should be able to see all data very flexibly.
Data to be recorded includes:
- Contract Name
- Strike Price
- Open Interest
The ideal candidate should have experience with:
- Web scraping
- Data automation
- Financial data
- Microsoft Excel
Since the data is financial in nature, precision and accuracy are paramount. The end goal is to have an Excel sheet with accurate, real-time updates about Nifty & Banknifty options.
Requirements:
1. Get data from NSE for Banknifty & Nifty options. (I already have access to them. )
2. Need to automatically record OI, LTP, OI Chng and LTP chng for a number of strikes of my choice every 3 mins starting from 9:15 to 3:30
3. I should be able to do further calculations of my own from this data using excel formulae.
4. There should be another page to dynamically pick the number of strikes of my choice and show them there. For eg, we might be recording data of 20 strikes but I may need to see only of 6 among them. Then, I should be easily able to see them and do calculations from them.
5. Further customizations and beautifications if required shall be done then.
6. Finally, I should be able to see all data very flexibly.