# Report of Financial Market Essay

1499 Words Nov 10th, 2013 6 Pages
FINANCIAL MARKET: Assignment 3
14 octobre 2013

Marcos Lain Lianna Petrosyan Scolar Year 2013-2014

1 INTRODUCTION

1

Introduction

The main aim of this third assignment is to compare between the evolution of spread and depth using two dierent ways to assemble stocks in portfolios.

1.1

Data

We have one month of data concerning 40 rms quoted in stock Exchange per minute. For each stock, for each day, we have a detailed amount of messages, detph for ask and bid and the volume traded. AA ADBE AMAT AMZN BHI BRCM CELG COST CTSH DIS EBAY GE GILD GOOG HON INTC KMB MMM PFE PNC
1.2 Instructions

Construct 4 portfolios equally weighted : 10 rst ⇒ portfolio "Low" 10 second ⇒ portfolio "Medium Low" 10 third ⇒ portfolio "Medium High" 10 fourth ⇒ portfolio "High" 5. For this minut, comput the average per variable per portfolio

As this process should be repeated a lot of times, we have coded a macro in VBA, to compute the averages, construct the portfolio and compute the second averages. The user has to select the minut by applying the lter in the column "H", then copy the selection in the sheet "data2". Afterwards, he has to press one of the button "per message" or "per volume" so that to select the criteria with what he wants to construct the portfolio.

By executing the macro, the result is printed in the sheet "result". The only problem is that this macro can't save the nal results, so in order to have all the averages for all the minuts, we have to copy this result in another sheet. Finally, to plot the graphs, we only have to select the columns that interest us.

3

3 RESULTS

3
3.1

Results
Constitution of portfolios

Constitution of the portfolio with message

Figure 1  Evolution of the average of messages by stock
Constitution of the portfolio with volume

Figure 2  Evolution of the average of volume by stock

4

3 RESULTS

As we have explained before, we have 4 equally weighted portfolios in each section and the results can be appreciated in the following graphs. We

## Related Documents

• ###### Essay about Accounting Is an Information System That Identifies

A objectives and the roles of financial accounting “Accounting is an information system that identifies, records, and communicates the economic events of an organization to interested users.”1. The basic objective of accounting is to provide information to the interested users to enable them to make business decisions and “Financial statements are the primary means of communicating financial information to parties outside the business organization.”2. Moreover, accounting can give the essential…

Words: 1079 - Pages: 5
• ###### Essay Main Characteristics Of Integrated Reporting

communicating with potential users of financial information. Furthermore as Paul Druckman (CEO of International integrated reporting council) stated, the main audience for integrated reports are investors. Consequently, integrated reporting focuses on delivering company’s message with regards to their company’s strategy of value creation and full commercial value to its potential investors.() Generally, integrated reporting changes the mindset of providing financial information, as it delivers more…

Words: 844 - Pages: 4
• ###### Essay Definition Of Fair Value Measurement

It is important that financial statement to be relevant, transparent and truly represent the financial information in the accounting principle, therefore, updating clear and new accounting regulations and formulas is imperative in the fickle market. IFRS is used in around 100 nations (K and J, 2009), which is set by The International Accounting Standards Board (IASB) engages a close relationship with the stakeholder all over the world. In 2011, IASB issued IFRS 13 fair value measurement aim to remedy…

Words: 836 - Pages: 4
• ###### Essay Xero Limited Swot Analysis Bac

Xero Limited. Fundamental Company Report Including Financial, SWOT, Competitors and Industry Analysis Phone: +44 20 8123 2220 Fax: +44 207 900 3970 office@marketpublishers.com https://marketpublishers.com Phone: +44 20 8123 2220 https://marketpublishers.com Xero Limited. Fundamental Company Report Including Financial, SWOT, Competitors and Industry Analysis Date: Pages: Price: ID: August 1, 2015 50 US\$ 499.00 X2531BAD6F0BEN Xero Limited. Fundamental Company Report provides a complete overview of…

Words: 1465 - Pages: 6
• ###### Essay Individual Research Assignment On Corporate Communication

ACCT3302 Individual research assignment on corporate communication As companies are keeping searching for more usefulness and effective ways to communicate with investors, analysts and business partners, the use of non-GAAP financial measures is making an answer. a. Statutory profit means the company states its profit followed GAAP metrics which is calculated by adding one off gains or losses to underlying profit. It is the bottom line of a company’s profit and loss account. It is required by law…

Words: 1325 - Pages:
• ###### Essay MGT 599 Case 3 Internal Analysis Kraft Foods

consumers and attract new consumers. Analyzing the weaknesses of this organization will challenge them to develop new innovative ideas and discover opportunities that will strengthen their financial success. Overall Kraft Foods positioning in the food industry is good, but they must expand into the foreign markets and enhance marketing tactics if they want to remain competitive. Introduction In the every changing, expanding and competitive food industry it is imperative organizations conduct an…

Words: 1348 - Pages: 6
• ###### Intermediate Accounting Ch.1 Summary Essay

the capital allocation process? If a company's financial performance is measured accurately, fairly, and on a timely basis, the right managers and companies are able to attract investment capital. To provide unreliable and irrelevant information leads to poor capital allocation which adversely affects the securities market. What is the objective of financial reporting? The objective of general purpose financial reporting is to provide financial information about the reporting entity that is useful…

Words: 616 - Pages: 3
• ###### Mgt Final Essay

Compliance Paper Microsoft was founded in 1975 and is a worldwide leader in software and solutions that help companies and individuals attain their full potential. Microsoft has long sustained its place at the top due to its organization strength, financial and strategic planning as well as conducting business in ethical and proper manners. The following paper will discuss the company’s role and processes to comply with governmental regulations that allow the growth and success it has endured to this…

Words: 1963 - Pages: 8
• ###### Essay Accounting Concepts & Practices By Norman Holdings

Practices -Harvey Norman Holdings Report Student’s Name: Institution: Date: Contents Executive Summary 3 Introduction 3 Issue Emerging from the Chairman’s Report 4 Issues Emerging from the Director’s Report 5 Discussion of Corporate Governance Statement 5 Key Financial Ratios 6 An Outlook of Harvey Norman’s Market Value and Investment Opportunities 7 Conclusion and Recommendations 8 Executive Summary This business report will briefly focus explaining the financial health of Harvey Norman Holdings…

Words: 1649 - Pages: 7
• ###### Essay on Is Stock Market Performance Linked to Business Performance?

Is stock market performance linked to business performance? Abstract Still in the heart of an unprecedented financial crisis, new questions came up about the working of the stock market. In the eyes of general public the stock market can seem a lot like gambling to the extent that this one was reconsidered. The stock market index seems to be valuating at random, especially since the last financial crisis. But the fact that stock market plays an important role in the health of the economy…

Words: 4867 - Pages: 20