Pulling NSE option data for Index and stocks
Budget: ₹600 – ₹1,500 INR
My Job requirement
Pull the data for Nifty, Bank nifty and 50 stocks, plus one or 2 vairable stock whenever required
Things required in excel
1. Data to be pulled for all expiry. Connection error should not come and shall be refreshed at regular intervals.
2. data to be copied in excel every 10 min. not all data, - I have macros for this
if the spot price is 1000 then 6 strike prices above and 6 strike prices below. data required
a.total OI
b Change in OI
c. PC Ratio
3.EOD data - Volatility skew
The graph to be plotted automatically for each stock and indices.
I should be able to select the expiry of an index or stock. There are small things
which I will explain over the phone.
Try to keep the file size small.
Pull the data for Nifty, Bank nifty and 50 stocks, plus one or 2 vairable stock whenever required
Things required in excel
1. Data to be pulled for all expiry. Connection error should not come and shall be refreshed at regular intervals.
2. data to be copied in excel every 10 min. not all data, - I have macros for this
if the spot price is 1000 then 6 strike prices above and 6 strike prices below. data required
a.total OI
b Change in OI
c. PC Ratio
3.EOD data - Volatility skew
The graph to be plotted automatically for each stock and indices.
I should be able to select the expiry of an index or stock. There are small things
which I will explain over the phone.
Try to keep the file size small.