djonjohn1252
05-24-2012, 10:54 PM
So I have an excel project I have been working on with two fellow employees, were basically learning how to modify some existing code. The problem is we have gotten stuck on a few items and was hoping someone could show us how its done, I have attached the code and the data file for the macro's.
The last 4 issues we have to deal with are
1. Move the buttons on the worksheet over a couple of columns to make room for two more computed columns.
2. Change the program so that it leaves columns A- F empty when it loads the data.
3. In column D, compute the 6-day moving average of the 1-day average. Give this column an appropriate heading, too, and add a button to trigger this computation. Note you should be adding 6 things and dividing by 6.
4. In column E, have the program print “buy” when the close is over the 6-day moving average for the first day after being below it, and “sell” when the close is under the 6-day moving average for the first time after being over it. Give this column an appropriate heading, and add a button to trigger this computation.
The last 4 issues we have to deal with are
1. Move the buttons on the worksheet over a couple of columns to make room for two more computed columns.
2. Change the program so that it leaves columns A- F empty when it loads the data.
3. In column D, compute the 6-day moving average of the 1-day average. Give this column an appropriate heading, too, and add a button to trigger this computation. Note you should be adding 6 things and dividing by 6.
4. In column E, have the program print “buy” when the close is over the 6-day moving average for the first day after being below it, and “sell” when the close is under the 6-day moving average for the first time after being over it. Give this column an appropriate heading, and add a button to trigger this computation.