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 Nov 11, 2022
Tesu
from Bahia, Brazil

Skills & Expertise Required

Microsoft Excel Google Docs sql 

Open for hiringApply before - Jan 8, 2025

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$47.86

Cost

Offer to work on this project closes in 238 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

Web scraper to collect data from multiple sources

I am researching real estate in many counties around the country. Each county provides a list of property identifiers matching certain criteria in an XLS or CSV format. For a given county, I would like to read the file into a database, and then suppl...read more

Advanced Excel - INDEX and MATCH with multiple criteria with incremental match return

To all the excel experts out there, I need help on an advanced formula. I am trying to use an INDEX MATCH formula that is configured with MATCH set to look through a one-column range and provide a match based on given criteria. The sample criteria lo...read more

PACER WEBSITE DATA RETRIEVAL

I need someone that has access to the PACER website to extract some data regarding bankruptcy cases filed in 2018

Creating Custom CMS or Integrade Wordpress

I would like someone to create a Online CMS or Wordpress Plugins that can run Mssql queries for the game Mu Online.
The Cms needs to be able to : To have payment modueles for :
PayGol Donations
Paymentwall Donations
Paypal moduleread more

Data mining

I need someone with pivot table and data management experience to take a large lead list and break it out by category, state and title where title is available.