FINANCIAL ECONOMICS

ASSIGNMENT FOR FINANCIAL ECONOMICS ASSIGNMENT FOR FINANCIAL ECONOMICS    1 Overview    1 Notes    1 Data sources    1 The write up:    1 Pro forma:    1 Submission date:    2 METHODS OF TESTING FOR WEAK FORM EFFICIENCY    2 Runs tests - MINITAB    2 Variance ratio test    2 Nested if instructions    2 Overview You are required to test a market price for weak form efficiency 1.    Select the market price 2.    construct a schedule of tests 3.    complete the proforma and email it to me 4.    obtain the data 5.    carry out the tests 6.    write up the results 7.    Submit! See submission date below… Notes Data sources: EIU, oanda.com, yahoo finance, datastream The write up: please follow this format! Section 1.  Introduction - What is being tested/reviewed? Why is  the test/review important? Section 2. Test design:  How are you going to carry out your tests – be absolutely crystal clear in this section. Section    3. Test:  Results and further tests. Section    4 Reflections on results and suggestions for further tests. Pro forma: please complete these sections and submit to me (see item 3 above) Name : Roll number: Date: 1.    Central Question 2.    Significance for Finance 3.    How will you test your question? 4.    What will your test establish? 5.    Data required for the Test 6.    Source of Data METHODS OF TESTING FOR WEAK FORM EFFICIENCY Runs tests - MINITAB A run is the number of changes in the same direction, so “+++--++++” has three runs. The test counts the number of runs above and below the mean and compares the results with what one would expect from a random distribution. If the P score is close to 1 then there is a high probability that the actual runs are the same as the expected runs from a random process if the P score is below 0.05 then it is significantly different and not random. Variance ratio test The ratio of the longer period variance with the shorter period variance multiplied by the number of shorter time periods in the longer period ie one would expect that the monthly variance is the weekly variance x 4.  You may look at days to years, months to years, weeks to months and so on.  You may choose one long period or see if the variance changes over time by dividing the period into smaller time periods and so on. And of course you may choose any time series of financial data, a currency, a share price or market index - any market price that you would expect to conform to a random process. Nested if instructions You can use Excel to answer questions such as: if there are three rises in a row what is the probability that the share price or exchange rate will increase on the fourth day. The instruction for this is:  =IF(B4>B3,IF(B3>B2,IFB2>B1,B5,””),””),””). But you can see that this enables you to choose any pattern albeit quite strictly defined. B% in this example PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT :)