Find Jobs
Hire Freelancers

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

₹600-1500 INR

Closed
Posted over 4 years ago

₹600-1500 INR

Paid on delivery
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.
Project ID: 21405129

About the project

5 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average ₹1,660 INR for this job
User Avatar
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
₹3,000 INR in 2 days
5.0 (16 reviews)
4.4
4.4
User Avatar
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
₹1,500 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I'm looking forward to getting the job If you are interested in me, I hope we can have a detailed talk
₹1,050 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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
₹1,450 INR in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Chennai, India
0.0
0
Member since Sep 22, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.