Remote Data Mining And Management Job In Data Science And Analytics

Developer needed for stock options screener

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 Nov 11, 2022
Rohit Bisla
from Para, Brazil

Skills & Expertise Required

Microsoft Excel Google Docs sql 

Candidate shortlisted and hired
Hiring open till - Jan 8, 2023

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$47.95

Cost

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

PowerBI, SSRS, SQL developers for Non-profit dashboards and analytics

We are a SaaS software development company that provides donation management software to non-profits. We are looking for an expert PowerBI, SSRS, and SQL developer who will assist in the development of new dashboards and reports.

-Work with...read more

MYSQL Database Optimization

We are currently running a MySQL database that is pulling in data from some of our distributed water treatment plants.

Our dashboard (running Grafana) is slow as the data in the database grows the database continues to slow down and the da...read more

SQL Database Expert Needed

We are a mobile game studio looking to create a BI tool to pull and visualize our data.

We need to pull data from various sources via API and condense the data in Google Cloud and then implement a basic solution to visualize the data.
read more

Mechanical/Electrical Engineer is needed to compare both benchmarking companies in excel format.

Looking for an Engineer who understands well power and water sector and knows how to create a comparison table using excel to compare the services that both benchmarking companies offering.

The purpose of this project is to provide manageme...read more

Need someone proficient with excel to help me clean up a database

I have a database contained within one excel file but spread across multiple sheets. They need to be combined into one spreadsheet.