I am looking for a programmer to help design a program that will give me profitability percentages for executing covered call writing strategies (selling call options against listed stock positions).
The program would have to grab, calculate and portray primarily the following info:
Stock Symbol-Stock Closing Ask Price-(*current stock price if possible)-Stock Symbol+Option Series(i.e. AAPL APR2-20)-Option Closing Bid-(*current bid for option if possible)-Dividends per share until experation-Days until experation-Actual Return if exercised-Annualized Return if exercised-Same as previous 2 if exercised at current bid option price.
*getting current prices might be difficult but I have Reuters as a real-time pricing source.
Screening criteria would be:
If exercised, annualized return above a certain percentage (i.e. 10%)
Would love this to be executable in Excel but not manadatory.