Only respond to this ad if you have read the whole description and follow the instructions at the end. Anyone responding without following the instructions below will be ignored.
I am looking for an expert in Excel and VBA programming. To use and or modify 2-3 VBA code I already have that extract data from a website into an Excel worksheet. Two macro VBA codes will have to be created.
Write the following macro:
1- On the CBOE site there is a file that has a list of all the stocks that trade options. Create a macro that runs once a day updating that list on a worksheet named Mater in a workbook with several other tabs on my computer. There are approximately 3,200 symbols in this list.
2- I have already created a macro (which runs slowly) to get data from Yahoo and populate a sheet named "master list" with about 550,000 rows of data. I would prefer this data arrives with a row labeled Call or Put. Many of the rows of data coming in will have a zero for a value under a category named “Open Interest”. I would prefer not even download a row of data where the “Open Interest” has a value of “0”. This will likely remove 2/3 of the total data and increase overall speed.
3- Crete another macro to separate the call and puts to two separate sheets labeled “all Calls” and “All Puts”, I would prefer the previous step separate the call from the puts when coming in, avoiding step 3.
4- Use that data to populate the following sheets below A – H
A- Master - 550,000 option chains with various stocks call and puts together. Less than 150,000 when remove the unwanted rows.
B- All Calls- List of all Calls
C- All Puts- List of all Puts
D- Vertical Spreads This sheet is almost done
E- Uncovered Calls Same as "B" but with formula I will provide.
F- Uncovered Puts Same as "C" but with formula I will provide.
G- Sell a Call Sell a put Two part trade, similar to vertical spreads
H- Covered call. Buy a stock and sell every call 90% done
5- Use a macro I have already created to bring the stocks underlying price
and additional data in from another sheet that I have already created.
5B- Create a macro for that sheet 5 to update throughout the trading day.
In the workbook with a tabbed named "Vertical Spreads" the work is almost done. This sheet is designed to look at every call option on a tab named "All Calls" away from the or to the right of the incoming dynamic data the columns with be filled with formulas I have already created that will extract the stock name/symbol, Exp. Date, Put or Call, Strike Price.
I will only consider you if you respond back to be with the message. "I understand Excel"