Dakota State University Finance Assingment Help With Solution

In this assignment you will study a particular pair of moving averages applied to historical data for the settlement prices of the futures contract being studied. You will pick a contract to study in class from a selection provided.

Collect the settlement prices from all the trading days in February 2017 through March 25, 2017 For example, the circled close price (a.k.a. settlement price) of CCK17 on Feb. 1, 2017 is 2112. You will need to move the cursor and point it to the stick on the chart to collect the last price for a particular business day for a time period from Feb 2017 through March 25, 2017.

CCK17means Cocoa, May, 2017. Use June (M) contract for your project.
Start a worksheet listing the dates and the settlement prices. Make sure you list the data starting with February 1 and going down to the March 25 data.

How it Works

How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention product code mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with product code in the email body. Product code is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to product code . The date is asked to provide deadline.

Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

Features

Features for Assignment Help

Zero Plagiarism
We believe in providing no plagiarism work to the students. All are our works are unique and we provide Free Plagiarism report too on requests.

Relevancy
We believe in providing perfect, relevant and 100% accurate solutions to the student as per questions asked. All our experts are perfect in providing that so as to give unique experience to the students.

Three Stage Quality Check
We are the only service providers boasting of providing original, relevant and accurate solutions. Our three stage quality process help students to get perfect solutions.

100% Confidential
All our works are kept as confidential as we respect the integrity and privacy of our clients.

Related Services

Calculate a 3-day moving average, 3-day MA, for the settlement prices in the column next to the settlement prices.[Example: =sum(b9.b11)/3] Note that the 3-day MA will have two missing points in the beginning. Format the averages to the same precision as the original data.

Then calculate another moving average in the column next to the 3-day MA. Use 6-day, 8-day, 10-day as you selected.The 6-day MA will have five missing points in the beginning, etc.

Note that you are not using the moving averages to make forecasts. You are using them to describe past and current data. Therefore the moving average formula in any cell should include the data for the same date next to it (not the previous date as would be done for forecasting). See the example below for what your data and moving averages should look like.

You will be adding more columns of calculated data to the right of the moving average data.

Create a line chart (without markers) on a separate worksheet which shows the settlement prices, 3-day moving average, and the specific other moving average.

When selecting the columns of data you have to include the empty cells with missing data (don’t put zeros in the cells) when you specify the data series so that the plot of the moving averages is not shifted to the left. Also, copy cell contents to the end of March.

Use the Layout menu under Chart Tools to modify the chart. Don’t just accept Excel’s default settings and format; the defaults in Excel can be fairly crude, even awful, and make for poor presentations. Make your chart resemble the chart in the example.The same format makes comparing the charts to each other in class much easier. Use a two-line title, label the axes.Some futures contracts do not have units; they are simply an index.

Use a solid line for the settlement prices, a dashed line for the 3-day MA, and a dotted line the other MA.Right clicking on a line will allow you to format the data series. Use dashed gridlines and do not shade the plot area.

Put the legend on the bottom. Put a border around the plot area. Use major and minor tick marks. Have “Feb” and “Mar” show up on the horizontal axis scale.

In your charts emphasize the plot areas and not the titles and labels. Fill up the page with the chart. Paste as a picture, not an Excel object, into the Word document.

Create a report in Word. Include a cover sheet, the display of each dataset (without gridlines), a printout of the cell formulas(with border row and column headings and gridlines), and the chart. Use portrait for the display of data and cell formulas and landscape for the charts. The report must be presentable and effective, and deficiencies will be graded.

Drop off the report to dropbox along with the spreadsheetsthemselves.

The following images are examples using old data to demonstrate excel work you should do for your futures contract.

Product Code :Fin329

To get answer for this question, kindly click here (Note: Don’t forget to write the product code in comment section)

You can also email us at assignmentconsultancy.help@gmail.com but please mentioned product code in the mail body while sending emails.You can browse more questions to get answer in our Q&A sections here.

Summary