Excel on Stock Markets

In: Business and Management

Submitted By msoi
Words 1828
Pages 8
DATE MSFT % per month 100 20040130 1.023 1% 101.023 20040227 -4.0506 -4% 96.93096 20040331 -6.0309 -6% 91.08515 20040430 4.8135 5% 95.46954 20040528 0.3827 0% 95.8349 20040630 8.883 9% 104.3479 20040730 -0.2451 0% 104.0922 20040831 -3.8961 -4% 100.0366 20040930 1.2821 1% 101.3192 20041029 1.1573 1% 102.4918 20041130 6.8645 7% 109.5273 20041231 -0.3357 0% 109.1596 20050131 -1.6467 -2% 107.3621 20050228 -3.9574 -4% 103.1133 20050331 -3.9348 -4% 99.05604 20050429 4.6752 5% 103.6871 20050531 2.2925 2% 106.0641 20050630 -3.7209 -4% 102.1176 20050729 3.0998 3% 105.283 20050831 7.2237 7% 112.8884 20050930 -6.0263 -6% 106.0854 20051031 -0.1166 0% 105.9617 20051130 8.0156 8% 114.4551 20051230 -5.5275 -6% 108.1286 20060131 7.6482 8% 116.3985 20060228 -4.2273 -4% 111.478 20060331 1.2653 1% 112.8885 20060428 -11.2459 -11% 100.1932 20060531 -5.8385 -6% 94.34343 20060630 2.8698 3% 97.0509 20060731 3.2618 3% 100.2165 20060831 7.1904 7% 107.4225 20060929 6.4202 6% 114.3192 20061031 4.9726 5% 120.0038 20061130 2.6123 3% 123.1387 20061229 1.703 2% 125.2358 20070131 3.349 3% 129.4299 20070228 -8.3927 -8% 118.5672 20070330 -1.065 -1% 117.3045 20070430 7.4273 7% 126.0171 20070531 2.8393 3% 129.5951 20070629 -3.9756 -4% 124.4429 20070731 -1.6288 -2% 122.416 20070831 -0.5519 -1% 121.7403 20070928 2.5409 3% 124.8336 20071031 24.9491 25% 155.9785




YHOO 4.3304 -5.6194 9.3144 4.25 21.3537 18.7215 -15.3846 -7.4351 18.9407 6.7237 3.9514 0.1595 -6.5552 -8.3499 5.0511 1.7699 7.8261 -6.8548 -3.7807 -0.06 1.5606 9.2494 8.818 -2.61 -12.2639 -6.7345 0.6238 1.6119 -3.6303 4.4634 -17.7576 6.227 -12.3136 4.193 2.5437 -5.4424 10.8457 9.0074 1.3934 -10.3867 2.3538 -5.4704 -14.3015 -2.2366 18.0928 15.861

4.33% -5.62% 9.31% 4.25% 21.35% 18.72% -15.38% -7.44% 18.94% 6.72% 3.95% 0.16% -6.56% -8.35% 5.05% 1.77% 7.83% -6.85% -3.78% -0.06% 1.56% 9.25% 8.82% -2.61% -12.26% -6.73%…...

Similar Documents

Stock Market

...Review of Development Economics, 9(2), 166–176, 2005 Endogenous Growth Models and Stock Market Development: Evidence from Four Countries Guglielmo Maria Caporale, Peter Howells, and Alaa M. Soliman* Abstract This paper re-examines the relationship between stock market development and economic growth. It provides a theoretical basis for establishing the channel through which stock markets affect economic growth in the long run. It examines the hypothesis of endogenous growth models that financial development causes higher growth through its influence on the level of investment and its productivity. The empirical part of this study exploits techniques recently developed to test for causality in VARs. The evidence obtained from a sample of four countries suggests that investment productivity is the channel through which stock market development enhances the growth rate in the long run. 1. Introduction Several theoretical and empirical papers such as Levine (1991), Levine and Zervos (1995), Demirguc-Kunt (1994), Demirguc-Kunt and Levine (1995), Rousseau and Wachtel (2000) and Beck and Levine (2003), have suggested that stock market development affects economic growth in developing countries. The common problem with these studies, however, is that there is no discussion of the channels through which stock markets can stimulate economic growth. In traditional growth theory, the growth rate is a positive function of exogenous technical progress. However, financial...

Words: 5672 - Pages: 23

Stock Market Efficiency

...Barnes, Paul. Stock Market Efficiency, Insider Dealing and Market Abuse. : Ashgate Publishing Group, . p 194 http://site.ebrary.com/id/10362150?ppg=194 Copyright © Ashgate Publishing Group. . All rights reserved. May not be reproduced in any form without permission from the publisher, except fair uses permitted under U.S. or applicable copyright law. Barnes, Paul. Stock Market Efficiency, Insider Dealing and Market Abuse. : Ashgate Publishing Group, . p 195 http://site.ebrary.com/id/10362150?ppg=195 Copyright © Ashgate Publishing Group. . All rights reserved. May not be reproduced in any form without permission from the publisher, except fair uses permitted under U.S. or applicable copyright law. Barnes, Paul. Stock Market Efficiency, Insider Dealing and Market Abuse. : Ashgate Publishing Group, . p 196 http://site.ebrary.com/id/10362150?ppg=196 Copyright © Ashgate Publishing Group. . All rights reserved. May not be reproduced in any form without permission from the publisher, except fair uses permitted under U.S. or applicable copyright law. Barnes, Paul. Stock Market Efficiency, Insider Dealing and Market Abuse. : Ashgate Publishing Group, . p 197 http://site.ebrary.com/id/10362150?ppg=197 Copyright © Ashgate Publishing Group. . All rights reserved. May not be reproduced in any form without permission from the publisher, except fair uses permitted under U.S. or applicable copyright law. Barnes, Paul. Stock Market Efficiency, Insider Dealing and Market Abuse...

Words: 743 - Pages: 3

Stock Market Investment

... your money working for you. The track record of the stock market also shows that a good basket of stocks climb more often than decline - reducing risk over the long-term.   Another reason why stocks can outperform other asset classes is because it can compound the value of your investment. Companies can reinvest the profits they make to generate even more profit. Moreover any dividends you receive can also be used to buy more shares and thereby enlarging your overall value as well. Top ›› ------------------------------------------------- The 4 Golden Rules Discipline and the right methodology is the key to a successful stock investment program. Understand and adopt these four essential rules of thumb to keep you on track. 1. Invest EARLY 2. Invest REGULARLY 3. Invest LONG TERM 4. Invest using DIVERSIFICATION Invest EARLY Invest early to take advantage of compounding over a greater period of time. If I invest Php 25,000 at the age of 25 and I manage to have my investment grow by 8% a year, 40 years later my investment will be worth Php 543,000. Investing for your Retirement | Invest P10k at the age of | 25 | 35 | 45 | 55 | Investing for how many years* | 40 | 30 | 20 | 10 | Total value of investment at 65 | P543k | P215k | P116k | P53k | * Assuming an annual rate of return of 8% per annum (the PSEi has averaged about 10%+) | Invest REGULARLY Now instead of investing just once, every year I regularly add the same amount into my......

Words: 752 - Pages: 4

Stock Market Changes

...TO: Marty White FROM: January Jones DATE: November 29, 2011 SUBJECT: ACCT 201- WSJ Article RE: “Yum Splits India Into Separate Division, Names New International CEO” Who: YUM! Brands Inc. (YUM) What: Yum splits India into its own division and appoints a new international CEO. Where: Louisville, Kentucky Why: Yum Brands Inc. has decided to split India into its own separate division. Due to the large expansion and success in China, Yum hopes to see just as much growth in India. Although still smaller than China’s division, the decision to report India separately shows Yum’s high expectations for India’s growth. Currently KFC has 100 restaurants and Pizza Hut has 175 restaurants in India comparing to China where there are 3,475 and 564 respectively. Yum’s CEO, David Novak, sees India as on the same track as China due to it’s current sales rising 42%. Yum hopes to have 75% of all its profit come from its international divisions by 2015 however the U.S., although not growing like it used to, contributed more than 95% to Yum’s operating profit last quarter. Due to their hopes of huge international growth Yum has appointed a new international CEO, Micky Pant to oversee both India and China’s divisions. How: Stock price closed at $54.51 on November 22, 2011 (before the article). After the article, the stock price decreased to $53.18 on November 23, 2011, a decrease of $1.33 or 2.4%. Reference: Gasparro, Annie (2011, November 23). Yum Splits India Into......

Words: 270 - Pages: 2

The Stock Market Crash

...THE GREAT DEPRESSION AND THE STOCK MARKET CRASH An Introduction The stock market crash The stock market was created on 1792 to allow stocks and bonds to be traded “bought and sold”. A “stock market crash” is the steep fall of the prices of stocks due to widespread financial panic. America experienced an era of great peace and prosperity during the 1920s. After World War I, the so-called “Roaring Twenties” economic and cultural boom was fueled by industrialization and the popularization of new technologies such as radio and the automobile. Air flight was becoming common as well. The Dow stock average soared throughout the Roaring Twenties and many investors aggressively purchased shares, comforted by the fact that stocks were thought to be extremely safe by most economists due to the country’s powerful economic boom. Investors soon purchased stocks on margin, which is the borrowing of stock for the purpose of gaining financial leverage. For every dollar invested, a margin user would borrow nine dollars worth of stock. The use of leverage meant that if a stock went up 1%, the investor would make 10%. Unfortunately, leverage also works the other way around and amplifies even minor losses. In 1929, the Federal Reserve raised interest rates several times in an attempt to cool the overheated economy and stock market. On Thursday, October 24th 1929, a spate of panic selling occurred as investors began to realize that the stock boom...

Words: 2255 - Pages: 10

Stock Market

...International Journal of Business and Management March, 2009 Relationship between Interest Rate and Stock Price: Empirical Evidence from Developed and Developing Countries Md. Mahmudul Alam (Corresponding author) CRM, Marketing Division, Grameenphone Ltd 47 Shantinarar, Dhaka 1217, Bangladesh Tel: 880-1711-503-782 E-mail: rony000@gmail.com Md. Gazi Salah Uddin Department of Business Administration East West University 43, Mohakhali C/A, Dhaka 1212, Bangladesh E-mail: rimsust2002@yahoo.com Abstract Stock exchange and interest rate are two crucial factors of economic growth of a country. The impacts of interest rate on stock exchange provide important implications for monitory policy, risk management practices, financial securities valuation and government policy towards financial markets. This study seeks evidence supporting the existence of share market efficiency based on the monthly data from January 1988 to March 2003 and also shows empirical relationship between stock index and interest rate for fifteen developed and developing countries- Australia, Bangladesh, Canada, Chile, Colombia, Germany, Italy, Jamaica, Japan, Malaysia, Mexico, Philippine, S. Africa, Spain, and Venezuela. Stationarity of market return is tested and found none of this stock market follows random walk model, means not efficient in weak form. To investigate the reasons of market inefficiency, relationship between share price and interest rate, and changes of share price and changes of...

Words: 5903 - Pages: 24

Stock Market

... for the stock market. Reasons: first, to reduce the price of securities by increasing the discount rate in the valuation model; Monday, making the fixed income securities becomes a more attractive option to reduce liquidity in stocks; Tuesday, reducing the tendency to borrow to invest in securities. Finally, increasing operating costs thereby affecting businesses profitable company. V.        Situation the securities market of Viet Nam today. Vietnam securities market officially went into operation in 2000 with the operation of the stock exchanges in Ho Chi Minh City on 20/7/2000 and Hanoi Stock Exchange on 08/03/2005. Activity Release and raise capital on the stock market actually arise only from 2006 back here. In 2006, there were 44 joint-stock company shall offer more than 203 million shares, and in 2007, issuance activity really began when nearly 200 issuances of 192 companies and 4 banks trade were registered with the SSC for a total amount of capital raised to almost 40,000 billion VND. In 2008, due to the decline of the stock market, total deposits reached only 14,300 billion more than the 100 times through the offering of securities to the public. The market recovery in 2009 was facilitated through the issuance of securities markets, especially stock issuance. Total capital raised by issuing shares in 2009 increased by over 50% compared to 2008, reaching 21.724 billion. In 2000, with 02 listed companies at HCMC STC put into operation, the stock market has been...

Words: 2426 - Pages: 10

Stock Market

...Introduction to Stock Exchanges ------------------------------------------------- Meaning, purpose, working of stock exchanges in India; various terms used in stock exchanges, trading in stock exchanges, clearing and settlement, rolling settlement, online trading, internet trading, market indices, types of public issue Which is benchmark stock market index of India? How many securities are there in Nifty Index? How many securities are there in Sensex? Which index will have high volatility Nifty or BSE Midcap? What do you mean by primary market? ------------------------------------------------- What do you mean by secondary market? What do you mean by stock split? What do you mean by Bonus Issue? What do you mean by Buy Back? What do you mean by Right issue of shares? What are ADR’s? ------------------------------------------------- What is the difference in between IPO and FPO? Risk-Return analysis Risk meaning and Measurement – Types of Risk – Systematic, Unsystematic risk, Beta Coefficient, Alpha, CAPM theory etc. What is return? Expected rate of Return, computation formulae. Case studies on risk-return using standard deviation, variance, probability and other statistical tools. ------------------------------------------------- What is beta? ------------------------------------------------- What is cost of equity? ------------------------------------------------- What is WACC...

Words: 1304 - Pages: 6

Stock Market

...What Is Stock Market?? A stock market or equity market is the aggregation of buyers and sellers (a loose network of economic transactions, not a physical facility or discrete entity) of stocks (also called shares); these may include securities listed on a stock exchange as well as those only traded privately. What Is Stock Exchange?? A stock exchange is a place or organization by which stock traders (people and companies) can trade stocks. Companies may want to get their stock listed on a stock exchange. Other stocks may be traded "over the counter", that is, through a dealer. A large company will usually have its stock listed on many exchanges across the world.[4] Exchanges may also cover other types of security such as fixed interest securities or indeed derivatives. The Indian Securities Contracts (Regulation) Act of 1956, defines Stock Exchange as, "An association, organization or body of individuals, whether incorporated or not, established for the purpose of assisting, regulating and controlling business in buying, selling and dealing in securities." Difference Of Stock Market And Stock Exchange The stock market represents the companies that list equity shares for public investors to buy and sell. Stock exchanges are the infrastructure that facilitate the trading of those equity securities, or stocks. Without a stock exchange, companies would have no formal mechanism on which to list shares, and without a stock market, exchanges would have no reason to exist...

Words: 2518 - Pages: 11

Stock Market

...Section: Investing STOCKS & MARKETS Failure by regulators and exchanges to pinpoint what caused wild equities swings on May 6 might sap investor confidence in the stock market As if individual investors lacked reasons to mistrust the stock market, along came May 6's gut-wrenching, 9.2 percent drop in the Dow Jones industrial average. The rapid stock plunge — followed by an equally quick, partial rebound in which the Dow regained nearly half its losses — surprised retail investors. Days later, they are trying to digest the realization that the market action during the so-called "flash crash" has bewildered the pros, too. "I still haven't heard a satisfactory answer as to what happened and what could be done about it," said Frank C. Boucher, who heads a financial planning firm in Reston, Va., on Monday, four days after the market's drop. The U.S. Securities & Exchange Commission, charged with regulating the stock market, has offered no explanation. SEC Chairman Mary Schapiro met with the heads of six major exchanges on May 10. According to an SEC statement, a main part of the agenda was "discuss[ing] the causes of Thursday's market events [and] the potential contributing factors." A U.S. House of Representatives subcommittee is expected to examine the reasons for the stock plunge at a hearing on May 11. Among possible causes, media analysts and traders have cited erroneous trades, currency spikes, market regulations, and high-frequency, computerized trading. no...

Words: 896 - Pages: 4

Jads Stock Market Report

... JADS performance. Additionally, at least 2 other JADS group members ranked within the top 10, and thus, with future trading and a better understanding of the stock market, we believe that greater returns could be achieved. * Comparison of Classmates portfolios: A comparison of our classmates portfolio actually showed that JADS performed best overall after analysing all the groups (did not include those names which we could not associate with a specific group). Further investigation showed that whilst there was at least 1 member of the other groups with significant gains in the top 5, the majority of the other members were in lower ranking with large deficits, unlike JADS group which actually had 2 members making significant returns and 2 with deficits. JADS had trades similar to the other groups except we believe that we were the most diverse. Similar losses were experienced by each group when the markets fell or rose due to investor confidence e.g. when US stock rose after Europe reached an agreement on Greece bailout – stock prices rose and when the when the handling of Europe debts was in crisis, stock prices fell. In the first month of trading, the other overall performance of the other were groups better than JADS group as they had invested all their monies and had also borrowed large quantities but were achieving enormous returns on their investments, unlike JADS group which invested quite conservatively. Thus owing to our conservative spending, only...

Words: 2254 - Pages: 10

Stock Market

... a result price of all shares are significantly increasing. That might cost a huge downfall of share price after a certain period. Recent scenario of Dhaka stock exchange: Last few months Dhaka stock exchange is in a very bullish trend. There is a huge demand of shares in stock market. But supply of share is very low. It has created a crisis of share in market. As a result price of existing shares in the market are claiming upward. Now almost every share is gating overpriced. General index and daily turnover of Dhaka stock exchange is now higher then any time. A sudden influx of funds and a surge in retail investors are pushing the DSE index forward without regard to economic fundamentals. The index, which was at 5594 in April 2010, has crossed 8602 points in November 2010. [pic] Similar movements have been recorded in market capitalization, price-earnings ratio, market volatility and in other indicators during this period. Market capitalization (total number of shares times the average market price of shares) in April 2010 was TK 2308507 million and on November 2010 it has risen to TK 3598329 million. The daily turnover showed a similar trend, increasing from TK 6403.878 million in April 2010 to TK 28702.674 million in November 2010. Market P/E ratio was 22.5 and by November 2010 it has risen to 30. But the supply of stocks is almost unchanged during this period. Only 6 company and some mutual funds has listed to Dhaka stock exchange. Pressures in stock prices......

Words: 1723 - Pages: 7

Stock Market Vol

... buying a currency if its price has risen more than 1% from its value five days earlier. Traders in stock, commodity and foreign exchange markets use such rules widely.The essence of the trade on the basis of this type of analysis of the Forex is to conduct mathematical calculations and the construction of geometric figures that explain what is happening in the market as will be explained in the succeeding sections. Technical methods date back at least to 1700, but the “Dow Theory,” proposed by Wall Street Journal editors Charles Dow and William Peter Hamilton, popularized them in the late nineteenth and early twentieth century. Although modern technical analysis was originally developed in the context of the stock market, its advocates argue that it applies in one form or another to all asset markets. Since the era of floating exchange rates began in the early 1970s, foreign currency traders have widely adopted this approach to trading. At least some technicians clearly believe that the foreign exchange market is particularly prone to trending. Currencies have the tendency to develop strong trends, stronger than stocks in my opinion because currencies reflect the performance of countries. (Jean-Charles Gand, Société Générale Gestion, in Clements The basic premise underlying technical analysis is as follows: Market action discounts everything!: This means that the actual price is a reflection of everything that is known to the market that could affect it, for......

Words: 11066 - Pages: 45

Stock Market

... was a focus on going green or the environment. Several of the companies I invested in had a focus on going green. From using environmentally green office supplies to green community improvements. Weyerhaeuser (WY) fits the going green idea and was recently recognized as a leader in Global Sustainability by the Dow Jones Sustainability World Index. Weyerhaeuser is one of eight building material companies to be recognized. They focus on creating products, growing and harvesting trees in an environmentally and socially responsible manner. (Weyerhaeuser) I choose one of my investments in the real estate market because it has always been an area of interest to me. I enjoy learning about real estate and watch the market in my area. I invested in AvalonBay Communities. They develop, redevelop, manage and acquire high quality apartment communities. They focus on creating a community that enhances the lives of their residents. The stocks I choose to invest in had similar reactions to the S&P 500, NYSE, and the NASDAQ. The controversy surrounding the United States budget and whether or not the United States economy is heading for bankruptcy has lead to market uncertainty. The S&P 500, NYSE, and the NASDAQ all plummeted as a result of these current events. Uncertain markets lead to stock holders selling their stocks for fear that they might lose a significant amount of money resulting in a decline in the value of company stocks. Other investors might have taken...

Words: 1562 - Pages: 7

Stock Market Relation

.... Stock markets are the most important institutions in the capital market where the shares of various companies are traded. Trading of the shares may take place in two different forms of stock market. When the issuing company sells its shares to the investors, the transaction is said to have taken place in the primary market, when already issued shares of companies are traded among investors the transaction is said to have taken place in the secondary market. Stock markets are very important because they play a significant role in the economy by changing investment where it is needed and can be putted to best ( Liberman and Fergusson 1988). The stock markets are working as the channel through which the public savings are mobilized to industries and business enterprises. Mobilization of such resources for investment is certainly a necessary condition for economic take off, but quality of their allocation to various investment projects is an important factor for economic growth. This is precisely what an efficient stock market does to the economy ( Berthelemy and Varoudaks 1996). During nineteenth and twenty century, Bagehot (1973) and Schumpeter (1912) had focused on the constructive assistance of financial sector to economic growth. In the study, the direction of causality between the higher growth in financial sector and country‘s economic growth rate was not clear ( Robinson, 1952 and Lucas, 1988). Also, most of the traditional growth theorists believed that there is no...

Words: 5712 - Pages: 23