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
Annapurani R
from Bavaria, Germany

Skills & Expertise Required

Microsoft Excel Google Docs sql 

Candidate shortlisted and hiredHiring open till - Aug 18, 2023

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$47.94

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

Bali Villa Research (Sales and Rental Prices for Seminyak, Sanur and Canggu)

Through online reseach, provide detailed list of 3, 4 and 5 bedroom villas in Canggu, Seminyak and Sanur that are currently for rental or sale. Provide a detailed list of location, size, bedrooms, bathrooms and more.

Using sources such as A...read more

Recover Unsaved Excel file on my Macbook.

Excel crashed and I am having difficulty recovering the file. All I have is the previous version of the file the day before it crashed. I had done a lot of work since the last saved version. I can give team viewer access.

Executive Assistant to CEO Needed for Growing Brand

Were looking for a remote executive assistant to assist the owner of our company located on the East Coast.

Here are a few examples from the past month that would fall under your role:
- Booking travel for owner (hotels and flights)read more

Create a revenue dashboard in Google Data Studio using first interaction model from GA

Hello

Im struggling to create a dashboard in GDS with the revenue from paid search but with model first interaction (last is by default).

I would be glad if you show me the solution :)

Zillow data scrape

I want to create a spreadsheet of all the agents/posters who posted a house for sale in San Diego ca, Corpus Christi tx, and Tallahassee FL in the pst 2 years. Looking for full name of poster/agent, phone number, address of agent (if applicable), pho...read more