1. Homepage
  2. Programming
  3. Financial Modelling - Final Assessment: Market Bubble Burst Test

Financial Modelling - Final Assessment: Market Bubble Burst Test

Engage in a Conversation
Financial ModellingMarket Bubble Burst TestC++Java

Financial Modelling - Final Assessment CourseNana.COM

Market Bubble Burst Test

CourseNana.COM

  CourseNana.COM

Background CourseNana.COM

The first financial market bubble can be well traced back to the 17th the Netherlands, during which demand for the cheerful tulip bulbs caused farmers to experiment with species and colouring so that the tulip became an object of speculation. In fact, they were so prized, people literally mortgaged their houses during that period in order to buy and then resell tulip bulbs. Suddenly, consumer confidence eroded, resulting in the tulips market crash. They became all but worthless. It is believed that the bubble burst led to a year’s-long economic decline. CourseNana.COM

Exhibit 1. Market Bubble Formation and Burst CourseNana.COM

As shown in Exhibit 1, when a market bubble bursts, demand falls, and prices decline quickly. Investors who established positions near the top could see their profits erode completely. Depending on its size, a deflating bubble can have short-term effects to an industry or market niche, but it could also prompt large scale consequences [1], such as the recent Global Financial Crisis, triggered by the deflation of the US housing market during 2007–2008. The downturn in the U.S. housing market snowballed into a national recession and led to a global monetary crisis. Therefore, a close examination of market bubbles and CourseNana.COM


CourseNana.COM

the assessment of economic and financial after effects of the bubbles bursting has become an integral part of the asset management. CourseNana.COM

Market Bubble CourseNana.COM

In this exercise, a bubble is characterized by an increase in the price of assets at a rate which is not sustainable, shortly after, if a bubble has formed the price will decrease at a high rate, leading to a large potential loss if the asset is not sold quickly enough. CourseNana.COM

Momentum CourseNana.COM

The momentum of an asset relates to the acceleration of its price. It can be determined by simply calculating the rate of change of the asset’s price over a certain period of time. CourseNana.COM

Random Search CourseNana.COM

A brute force numerical method used to search for local minima that increases efficiency by checking every ‘nth’ value, with the assumption that the elements located close to every ‘nth’ value will not deviate too far from it. A smaller sample is then extracted from the data set and these values are checked individually to find the minimum value. CourseNana.COM

The company you are working for currently uses an in-house VBA function to identify bubbles in the market by analysing the asset’s momentum. Currently, local minima of the asset’s momentum are found utilizing a random search to boost efficiency, the momentum of the asset around these local minima are then analysed to check if they are too low, which could indicate a bubble has burst. You are given this function by your supervisor and she wishes you to demonstrate that you understand how the code works and make the function more generic (Sheet 1) and would like you to improve upon it (Sheet 2), if applicable. CourseNana.COM

Sheet 1 CourseNana.COM

You must alter the function Bubble_Finder (Module 1) so that it takes inputs Bubble_Finder(StockPrices, Dates, BigStep, NoBubbles) in that order. You must then analyze the assets given and place the results, starting in the top left corner in the green cells provided next to each asset’s name. Exhibit 2 is an example given in the sheet of what the output should look like for an analysis of 2 potential bubbles for Z1P. CourseNana.COM

Exhibit 2. Market Bubble Formation and Burst CourseNana.COM

Z1P CourseNana.COM

Average Momentum CourseNana.COM

MomentumStdDev CourseNana.COM

Local Min Momentum CourseNana.COM

Local MinLocation CourseNana.COM

Bubble Burst Found CourseNana.COM

0.017255565 0.103020374 CourseNana.COM

-0.369458128 CourseNana.COM

16/03/2020 CourseNana.COM

Large Bubble Burst CourseNana.COM

-0.1 CourseNana.COM

03/06/2019 CourseNana.COM

No Bubble/No Burst CourseNana.COM

For each other three assets, you must use the parameters below: CourseNana.COM

  1. CBA

·  Step size of 5 weeks CourseNana.COM

·  Analyse 3 potential bubbles CourseNana.COM

  1. QAN

·  Step size of 3 weeks CourseNana.COM

·  Analyse 2 potential bubbles CourseNana.COM

  1. AIZ

·  Step size of 4 weeks CourseNana.COM

·  Analyse 2 potential bubbles CourseNana.COM

Additionally, the date of the local minima must display the date, not the numeric code for the date, as shown in the 5th column of Exhibit 2. CourseNana.COM

Please only make the required changes to the code which relates to the above mentioned inputs and output. Do not alter the method used to search for minima or the decision rule which is used to classify if a bubble has burst in this sheet. CourseNana.COM

Sheet 2 CourseNana.COM

This is a copy of Sheet 1 and will not be marked as part of your spreadsheet submission, instead it is to be used to present what your changes to the code supplied do. You are free to make any changes you would like at all to the code in the Bubble_Finder_Exp() function (Module 2) that you believe will improve the code supplied. CourseNana.COM

The Assessment CourseNana.COM

The sample code to create the required function for this task is already provided to you in Module1, but it was very poorly written and unable to proceed effectively straightaway. Your job is to fix and improve it (if applicable). You will be assessed across Week 11 and Week 12. CourseNana.COM

1. Week 10 Assessment, Q&A (5 Minutes Max)
The focus of the assessment in this week is on the understanding of the idea (like a code CourseNana.COM

plan), including but not limited to: CourseNana.COM

  1. Discuss and demonstrate a code plan for the functions;
  2. Identify and discuss some of the bugs and issues with the code;
  3. Suggest methods/ideas to improve the efficiency of the codes;
  4. Recommend on how to optimise the functions;

2. Week 11 Assessment, Presentation (5 Minutes Max) CourseNana.COM

The focus of the assessment in this week is on the code and solution quality, including but not limited to: CourseNana.COM

3. CourseNana.COM

Efficiency;
User interface (user friendly wise);
Accuracy of bubble detection;
Bubble detection rules;
And general usability and improvements you have made/proposed. CourseNana.COM

Spreadsheet Submission in Week 10 and 12 CourseNana.COM

As previously, the automatic marking software marks your work. CourseNana.COM

  1. It will only mark Sheet 1 worksheet and the function;
  2. You must not modify the structure of Sheet 1, change the function name or the

order of its input parameters. CourseNana.COM


CourseNana.COM

Reference CourseNana.COM

[1]. Pavlidis, E., Yusupova, A., Paya, I. et al. Episodes of Exuberance in Housing Markets: In Search of the Smoking Gun. J Real Estate Finan Econ 53, 419–449 (2016). CourseNana.COM

Get in Touch with Our Experts

WeChat WeChat
Whatsapp WhatsApp
Financial Modelling代写,Market Bubble Burst Test代写,C++代写,Java代写,Financial Modelling代编,Market Bubble Burst Test代编,C++代编,Java代编,Financial Modelling代考,Market Bubble Burst Test代考,C++代考,Java代考,Financial Modellinghelp,Market Bubble Burst Testhelp,C++help,Javahelp,Financial Modelling作业代写,Market Bubble Burst Test作业代写,C++作业代写,Java作业代写,Financial Modelling编程代写,Market Bubble Burst Test编程代写,C++编程代写,Java编程代写,Financial Modellingprogramming help,Market Bubble Burst Testprogramming help,C++programming help,Javaprogramming help,Financial Modellingassignment help,Market Bubble Burst Testassignment help,C++assignment help,Javaassignment help,Financial Modellingsolution,Market Bubble Burst Testsolution,C++solution,Javasolution,