Remote Data Mining And Management Job In Data Science And Analytics

Developer needed for a STOCK OPTIONS SCREENER by ROI

Find more Data Mining And Management remote jobs posted recently Worldwide

1. Find all US stocks with options expiring within the next 90 days.
2. Calculate the ROI for option SELLERS if the option expires out of the money (not assigned, not executed) by expiration date
3. Sort by highest ROI to lowest
4. Output expected: CSV, SQL, Google Sheets

Let me give an example:
It finds 5000 stocks with options expiring in the next 90 days
it calculates ROI for options sellers and sorts them highest to lowest

Example: Google has an 11% ROI within 25 days
Apple has 9% ROI within 60 days
IBM has 10% within 14 days

So the software sorts them in highest to lowest ROI order and displays the following information per column
SYMBOL, ROI, STRIKE,CALL/PUT, LAST TRADE, BID, ASK, EXPIRATION, DELTA, GAMMA, RHO, THETA, VEGA, IMPLIED VOLATILITY, OPEN INTEREST,
Schwab API

Google, 11%, $98, C, 3.50, 2.60, 3.80 (18 days), .5567, .057, -.01423, .0017, 264.6285, 2751
IBM 10%...
Apple 9%...

DO NOT annualize the ROI return. It should be the % by the expiration date only.

When applying please tell me the solutions (language, software etc) you will use and how soon you can finish this task. Best if can be run on website, display results on website, and download CSV or SQL output.
About the recuiter
Member since Mar 14, 2020
Alpesh Vaghela
from Piemonte, Italy

Skills & Expertise Required

Microsoft Excel Google Docs sql 

Open for hiringApply before - Jul 26, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$47.89

Cost

Offer to work on this project closes in 21 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Data Scrapping

I would like to hire someone to scrape data from a website.

A website must be navigated, text must be selected from an excel file, dates have to be entered correctly, data must be extracted, scrubbed, and then summed properly for the correc...read more

Forex Dashboard

I am looking for a Forex dashboard, basically anylizing Forex charts and updating Peak formation from BTMM, ICT, Wykoff.

Price alert

Build a Google spreadsheet that randomises data and puts potentially 150 inputs into groups of 10.

I need to build a Google Sheet that will take up to 150 data inputs and randomise them into teams of - 10 each. For example if there were 57 inputs there would be 3 teams of 10 and 3 teams of 9 that have randomly assigned members.

I have bui...read more

5 Year Profit Project- Online Services

I am looking for someone who can help develop a five year forecast for an online startup product in the home service market. Business revenue includes Service, Retail, Adverising, and Lead sales.

Please only reply if you have had success put...read more

Costing Spreadsheet needed for a catering company.

Take an existing spreadsheet and make it more useful to grow and intuitive.

Need all calculators for using the various input fields.