Part A – Required features
1. Write a VBA subroutine to calculate daily stock returns (use simple returns)
2. Write a VBA subroutine to calculate 50 and 200-day simple moving averages
3. Write a VBA subroutine(s) to identify the buy and sell signals based on the conditions for buy and sell signals discussed in the background information. At each buy and sell signals, calculate cumulative returns (sum of returns) of subsequent 5, 15 and 25 days. For example, the 5-day window is from the first day after a signal (not including) to the fifth day.
4. Write a VBA subroutine to produce summary statistics as described in Table 2 and comment on the findings (write detail comments in the textbox).
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS