VBA Macro Expert
Closed - This job posting has been filled and work has been completed.
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"