I want to get data from NSE website of option chains and want rows to colored with different colour schemes. Means Green colour for 3 highest OI for put and call and Blue colour for 3 highest change in OI for both side. And if both happens to be in same row.
This should be updated in every 10 minutes.
All these colored data should be recorded in separate excelsheet with columns as Date,Time,Strike Price, Live price, COI1,COI2,COI3,changed COI1, changed COI2, changed COI3,POI1,POI2,POI3, changed POI1,changed POI2, changed POI3, Fut OI, Fut changed OI. Last two columns of Fut OI, Fut changed OI should be in orange color column. All these excel sheets should be in one folder in E drive, option data, records. And the first one should be in E drive, option data under which that records folder needs to be. When all rows are filled in excel sheet then it should create records2, records3, etc. Folder and continue that work.
This should be done for all companies in separate files. The list of company name will be provided by me and can be upto 200 companies.
Expiry date of options and futures should be the current month till 1 day before expiry and then it should move to next month date to record data. I need monthly data only, even though it has weekly expiry. Monthly expiry will be last week expiry of current month.
Hello,
I'm interested in your project. I know little bit in trading.
I can extract data from NSE Option Chain, but if you could explain your requirement in sample.
I've required skills & experience.
I can start right now.
Looking forward to hear from you.
Thanks & regards
I'm having experience on trading for more than 2 years and have vast knowledge in word,exel,spreadsheet
Relevant Skills and Experience
I'm a part time trader
Dear client
I developed many applications is similar to your requirement. So I can develop this application within a 1 or 2 hours maximum.
Let share further details.