Find more Data Mining And Management Remote Jobs posted recently Worldwide

Required Microsoft Excel,Google Docs,sql freelancer for Developer needed for a STOCK OPTIONS SCREENER by ROI job

Posted at - May 14, 2022


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 recuiterMember since May 20, 2018 Prateak Kumar
from Diekirch, Luxembourg

Skills & Expertise Required

Microsoft Excel Google Docs sql 

Candidate shortlisted and hiredHiring open till - Jun 13, 2022

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$34.78
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


Apply on more work from home jobs posted in Data Mining And Management category.


Related Jobs


Latest In Microsoft Excel Jobs


Latest In Google Docs Jobs


Latest In sql Jobs