I have to analyse NSE option chain data ( Nifty and Bank Nifty) and need to pull down data in every 15 minutes starting from 10:00 a.m on wards like 10:00 a.m, 10:15 a.m, 10:30 a.m till 03:00 p.m. I have to fetch data from NSE for 12 strike prices ( 6 strike prices each above and below the spot price @10:00 am) , i;e means 13 rows data to be pulled down from nse and stored in respective rows in the sheet namely "Nifty Option Chan" for Nifty Option chain data and form Nifty Bank Option chain data in the sheet namely "Nifty Bank". At 10:00 am first 13 rows data to be pulled and stored in the time slot mentioned for 10:00 am data. Then the data fetched at 10:15 am to be stored in the time slot mentioned for 10:15 am data both for the sheets of nifty and bank nifty. So the earlier data i;e was fetched at 10:00 am will remain unchanged and stored as it was fetched. The same process will be repeated till 3:00 p.m. As there is data lag in 2-3 minutes hence, the function to be triggered 2-3 minutes later. Say data for 10:00 am to be pulled down at 10:03 am and so on. For your understanding please find the google sheet herewith . Till data I am managing pull down of option chain data manually. But now wish to automate it.
5 freelances font une offre moyenne de 1810 ₹ pour ce travail
I am an excel and data analysis expert with 6+ years of experience. I have done similar projects before. Moreover I am a trader myself, so I can understand these requirements easily. I can create an excel utility and p Plus
Hi There ! Are you looking for any kind of documents conversion or needs editing in your documents, so you are on a right person. Experience in data entry and use of Microsoft office for almost 2 years and have a broad Plus
Greetings , I shall go with your proposal with unlimited Revisions till I match your expectation. I am best in data entry with accuracy and fastness with good experience. You can message me into my inb Plus
Myself algo trader working with quntopian hedge fund to develop algo trading strategies, and delivered 70+ project in trading fields. demo also available.(I have done this project before that even you no need to pay 2k Plus
Hello Sir, I'm a freelancer as well as a trader I use kite- Zerodha for trading, I know all information about NSE's website and option chain data. As I personally use live option chain analysis for tradi Plus