Securing Higher Grades Costing Your Pocket? Book Your Coursework Help at The Lowest Price Now!

  • +1-617-874-1011 (US)
  • +44-117-230-1145 (UK)
Online Customer Service

Bafi3252 Modelling In Finance- Identify Assessment Answer


In this assignment you are asked to evaluate the strategy of buying on a cross up and selling on a cross down. You are given daily price information where you will calculate returns, moving averages and identify buy and sell signals. The analysis will be based on the given historical price information. You can use Excel formulas and create additional variables in the spreadsheet to assist you in completing the tasks. There are four worksheets in the file assignment2.xlsm. The main worksheet is where you interact with the users (for inputs and outputs). The data worksheet has daily stock price information required for the analysis. The two ‘free’ worksheets are provided if you want to use them to save the results. Do not add anymore worksheets in the file. 

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). 

This question hasn't been solved yet

Buy Bafi3252 Modelling In Finance- Identify Assessment Answer Online

Talk to our expert to get the help with Bafi3252 Modelling In Finance- Identify Assessment Answers to complete your assessment on time and boost your grades now

The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.

Get Online Support for Bafi3252 Modelling In Finance- Identify Assessment Answer Assignment Help Online


    • 24 x 7 Availability.
    • Trained and Certified Experts.
    • Deadline Guaranteed.
    • Plagiarism Free.
    • Privacy Guaranteed.
    • Free download.
    • Online help for all project.
    • Homework Help Services
Tap to Chat
Get Instant Assignment Help
Tap to Chat
Get Instant Assignment Help