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.","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":263198},"skills":["Microsoft Excel","Google Docs","sql"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2024-09-06T10:33:18+05:30","url":"https://www.toogit.com/freelance-jobs/MjYzMTk4"}
Remote Data Mining And Management Job In Data Science And Analytics
Find more Data Mining And Management remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekFixed Type
Remote Job$47.88
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
Looking for an experienced Data Analyst to work on a Pandas DataFrame (Python). An Example of DataFrame and clear framework to deal with data will be provided. Our aim is to learn the method from you and use it on our data, which cannot be shared at...read more
I want an excel sheet to list all my products.
The sheet should have the following columns:
- SKU Code (Number-Character)
- Product Name (Characters)
- Perquisites (multi line text box - I can add items, each with price...)...read more
Were a leading light in our industry, and are currently in the process of building out a new technology focused function. This new function wil provide superior business intelligence in the built environment / prop-tech space, comprising mobile and...read more
Good communication skills in written and spoken English
Able to anticipate workload and quote precisely.
Able to discuss tasks thoroughly before executing so that results are aligned with the brief, to avoid work in the wrong direction
We have an excel sheet which we want to convert into a google sheet.