Suljettu

Get me data from NSE options and futures in excel and calculatiin of data

I want to get data from NSE website of option chains and futures 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 15 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.

Taidot: Excel, tiedonsyöttö, tietojenkäsittely, Visual Basic, tietojärjestelmäarkkitehtuuri

Näytä lisää: excel macro data cell, excel large data files, free microsoft excel customer data entry, hours per week work full time employment, company requiring excel offline data entry work, word excel nternate data entry work europ, captcha data entry work part time, copy data week secure website excel, data enterr work part time, data entry work night time, options futures excel, excel spreadsheet options futures, data entry work part time coimbatore, data entry work part time in uae 2015, excel online data entry work, get nse data, historical data of nse stocks in excel

Tietoa työnantajasta:
( 0 arvostelua ) Chennai, India

Projektin tunnus: #21405129

5 freelanceria on tarjonnut keskimäärin 1660₹ tähän työhön

writingapp

Hi. Great app writer for your projects. I have writen scraping, excel, googlesheet, csv, database app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

₹3000 INR 2 päivässä
(16 arvostelua)
4.4
endersgame2

hey i can gathrer data from NSE and i will change the colour order as you said to green and all that stuff i had read the description and im super excited to do this task , are you serious about that

₹1500 INR 3 päivässä
(0 arvostelua)
0.0
cuixin1997

Hello, I'm looking forward to getting the job If you are interested in me, I hope we can have a detailed talk

₹1050 INR 7 päivässä
(0 arvostelua)
0.0
₹1300 INR 1 päivässä
(0 arvostelua)
0.0
fasinatingguy

Iam having professional experience in handling such cases for the past 5 years now on the other hand Iam well versed and PROEFFICIENT in advanced Excel models and Architectures

₹1450 INR 2 päivässä
(0 arvostelua)
0.0