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

...A stock market or equity market is a public entity (a loose network of economic transactions, not a physical facility or discrete entity) for the trading of company stock (shares) and derivatives at an agreed price; these are securities listed on a stock exchange as well as those only traded privately. The size of the world stock market was estimated at about $36.6 trillion at the beginning of October 2008.[1] The total world derivatives market has been estimated at about $791 trillion face or nominal value,[2] 11 times the size of the entire world economy.[3] The value of the derivatives market, because it is stated in terms of notional values, cannot be directly compared to a stock or a fixed income security, which traditionally refers to an actual value. Moreover, the vast majority of derivatives 'cancel' each other out (i.e., a derivative 'bet' on an event occurring is offset by a comparable derivative 'bet' on the event not occurring). Many such relatively illiquid securities are valued as marked to model, rather than an actual market price. The stocks are listed and traded on stock exchanges which are entities of a corporation or mutual organization specialized in the business of bringing buyers and sellers of the organizations to a listing of stocks and securities together. The largest stock market in theUnited States, by market capitalization, is the New York Stock Exchange (NYSE). In Canada, the largest stock market is the Toronto Stock Exchange. Major European......

Words: 390 - Pages: 2

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

...Abstract This project documents and describes the buying and selling of stocks that we purchased using $ 100,000 USD (Monopoly money) given to us by our instructor. Our assignment was to invest the stock in any way seen best fit to gain the most profit. We were to track our stocks three times a week and document the results using Microsoft Excel. The requirements for the assignment were to include two stock trades and to try to make our portfolio diverse using different sectors. The purpose of this project is to understand how the stock market works, and give us a better understanding of how the stock market operates. As a beginning investor, I tried to keep my initial stocks as an even investment for the most part. I invested my money into stocks that I felt would be successful and I knew that I would spend my own money on to help the stock increase. The attached Excel spreadsheets will describe in detail the beginning investment, the first and second adjustment, and my final outcome including my total gains/losses. To complete the project, my stocks were sold for me to cash out and my results were documented. Introduction At the beginning of this project, I felt very confident in being able to make a profit by the end of the class by just picking the most popular- trendy companies that were available in the market for a decent price. Without even looking at the history of the company or doing research on the price history at the leaset....

Words: 2032 - Pages: 9

Stock Market

...Assignment on: Stock Market Problems and Solution in the Context of Bangladesh Capital Market What are the reasons of inefficient stock market in Bangladesh? What can be done to develop the stock market?       Stock market is a financial market, where stocks and bonds are used to buy and sell. Shareholders i.e. investors exchange their shares in the stock market. The current market price of a share is determined by the demand and supply of that particular share. Before we go through the reasons of inefficient stock market I would like to clarify about inefficient stock market. Inefficient Stock Market           It refers that type of stock market which is not stable and healthy for investors. In inefficient stock market price level fluctuates so much. Market can not absorb large number of securities without changing price level. The main cause of share market fall is this, the inefficient stock market. Last year we have experienced a huge crash in Dhaka & Chittagong Stock Exchange.       If we would recall, Dhaka Stock Exchange Gen. Index (DGEN) soared to its highest levels from October to December last year, with the peak on Dec. 5, 2010 at 8,918 points. DSE’s index on Jan. 3, 2010 was at 4568.40 and went up at a staggering 4,350 points or 95.23% increase! But 2weeks later, Jan. 10, 2011, trading on the Dhaka Stock Exchange was halted after it fell by 660points, or 9.25%, in less than an hour, the biggest one-day fall in its 55-year history. Police and angry......

Words: 327 - Pages: 2

Stock Market

...analyzing possible investments. The first is the dividend growth model, which examines how a stock can be valued through examining the dividend cash flow. The second examines the time value of money, through the assumption that future dividends will flow directly to Berkshire Hathaway. Additionally, the paper evaluates the profitability of the purchase of GEICO after a five year period, assuming that all profits flowed to Berkshire. This five year window was selected since financial data on GEICO is reported through the Berkshire Hathaway annual report for the period 1995 to 2000. Finally, a discussion of the limitations and assumptions associated with the time value of money analyses is explored. Berkshire Hathaway and GEICO Insurance © 2001 Tim Glowa September 12, 2001 -4- “What we've got here is a highly unusual combination of a very profitable operating company--insurance in a big way, plus a crazy quilt of other businesses--and a CEO, now 70, who invests its money and who, in that department, has a strong, long-standing claim to being the best in the world”1 . Introduction In this time of unpredictable economic turns, upswings, economic retractions, changing interest rates and inflation, painful shortages followed by gluts, and extremes of optimism and pessimism, the chief financial officer protects a firm’s financial integrity. As financial markets become increasingly global, the financial officer must bring a global perspective to......

Words: 726 - Pages: 3

Stock Market

...The Sirius XM Radio Stock I chose Sirius XM Radio as one of my stocks because as I was reviewing the stocks I was going to pick for this project , I saw that Sirius XM Radio was doing rather well. Sirius XM Radio was founded in 1990 by Martine Rothblatt but officially became a big name in 2007 when it started being used in the production of popular cars such as Ford , Mercury , and Lincoln. Sirius is just a leading brand in satellite radio because it delivers absolutely the best quality service as I have personally experienced. Here is a picture of how dramatic the rise from 2007 to 2012 was in the Sirius XM radio stock. The EBAY Inc. Stock I chose EBAY as one of my stocks because I love ebay. Ebay is a great place to find really nice things for a really good price. Who wouldn’t want that ?!? Not only does it satisfy the public’s needs but it does phenomenal in the stock market. Ebay was founded in 1995 by Pierre Omidyar for the sole purpose of connecting people and trading goods and services. Ebay does so well because of the amount of partnerships it has with big names such as GM or Disney. Ebay is also used by certain stores who only sells things through ebay. Here is a picture of Ebay’s rise in stock prices from 2008 to 2012. The Netflix Inc. Stock I chose Netflix as one of the stocks for my report because I also love Netflix. All you pay is eight dollars a month for unlimited movies!! Its great! But ,......

Words: 587 - Pages: 3

Stock Market

...function of the stock market is to enable trade in the shares of public companies, which in turn reflect the performance of the companies whose shares are traded in the stock market. Stock markets are also a very important part of an economy or the economic system of a country. Today most economies around the world are judged by the performance of their stock markets.  The stock markets serve a vital purpose in the growth and development of a company that wants to expand. Such companies with expansion plans and new projects are in need of funding and the stock market serves as the best platform from which a company can ‘sell’ itself to the discerning public on the basis of merit among other things. To trade in the stock market a company has to be absolutely transparent about its vital fundamentals such as revenues, income, assets, liabilities, infrastructure, etc. as this allows the investing public to make a fair assessment of the said company’s market worth.  The stock markets function on the basis of two principles, which are better known as:  Primary markets – When a company decides to sell its shares to the public through an (Initial Public Offer) IPO then it can be said that it is operating in the primary market. In fact, for companies that offer their shares to the public for the first time, this process is a mandatory requirement and involves a few stages of compliance with the market regulator that eventually allows it to trade in the stock......

Words: 466 - Pages: 2

Stock Market

...STOCK MARKET I. Defination. 1. Securities. Stock is evidence confirming the rights and legitimate interests of the owner of the property or the capital of the issuer. Securities are shown in the form of certificates, book entries or electronic data. Types of securities including: stocks, bonds, certificates of investment funds, derivative securities… Securities may be represented by a certificate or, more typically, "non-certificated", that is in electronic or "book entry" only form. Certificates may be bearer, meaning they entitle the holder to rights under the security merely by holding the security, or registered, meaning they entitle the holder to rights only if he or she appears on a security register maintained by the issuer or an intermediary. They include shares of corporate stock or mutual funds, bonds issued by corporations or governmental agencies, stock options or other options, limited partnership units, and various other formal investment instruments that are negotiable and fungible. 2. The securities market ? In its actual form, the securities market is the only place where the exchanges, sale or transfer of securities; thereby changing the stock holders. II. The structure and operating principle of the securities market. 1. The structure a.        Primary market Primary market is the place where the first sale of newly issued securities. The primary market is also known as first market or market issue. Function of primary market: This is the......

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......

Words: 1304 - Pages: 6

Stock Market

...Introduction: The capital market is the engine of growth for an economy, and performs a crucial role in acting as an intermediary between savers and companies seeking additional financing for business expansion. Stock market is part & parcel of capital market. Contribution of any stock exchange generally leads to economic growth by increasing the funds to finance industry and other enterprise. Stock Exchange is an autonomous body formed by shareholders/members. It can take various decisions independently. The objective of Stock Exchange is to provide a market place along with facilities for bringing together the buyers and sellers of securities, promote just and equitable principles of trade, protect the interest of the investors. 1.2 Importance of the study Trading system is one of the most important functions of stock market operation. This report tries to find out the trading system of Dhaka stock exchange. Stock market is an essential part of capital market. Trading has now become automated, led by the Dhaka Stock Exchange through the central depository. In the present automated trading environment, bids/offers, depth, and required broker particulars are all recorded and can be retrieved for future reference. 1.3 Objectives of the study: The prime objective of the study is to study and evaluate the trading system of DSE. In this regard the specific relevant objectives of study are as follows: • To examine the trading system of DSE. • To know growth, development,......

Words: 16973 - Pages: 68

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

...December,1971). Through the Order, the eastern branch of the former State Bank of Pakistan at Dhaka was renamed as the Bangladesh Bank as a full-fledged office of the central bank of Bangladesh and the entire undertaking of the State Bank of Pakistan in, and in relation to Bangladesh has been delivered to the Bank. Bangladesh Bank has been entrusted whit all of the traditional central banking functions including the sole responsibilities of issuing currency, Keeping the reserves, formulating and managing the monetary and credit policy, regulating the banking system, stabilizing domestic and external monetary value, preserving the par value of Bangladesh Taka, fostering economic growth and development and the development of the country’s market. The Bangladesh Banks (Nationalization) Order enacted in 1972 nationalized all banks except foreign ones. Six nationalized banks were formed through merging the existing banks of the period. The rate of growth and development of banking sector in the country was extremely slow until 1983 when the government allowed to establish private banks and started denationalization process: initially, the Uttara Bank in the same year and thereafter, the Pubali Bank, and the Rupali Bank in 1986. Growth pattern of banks during the period 1973-1983. Economic history shows that development has started everywhere with the banking system and its contribution towards financial development of a country is the highest in the initial stage.......

Words: 20630 - Pages: 83

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 "single...

Words: 896 - Pages: 4

Stock Market

...Recent trend of stock market Abstract This report examines the recent bullish uptrend of stock market. Last few months the stock market is claiming upward very quickly. Sadden inject of huge money has created a huge demand of shares in stock market. But the supply of shares has not matched with the demand side recipe. Because of demand-supply mismatch value of many shares has become overpriced and bullish trend is supposed to persist. Everyday peoples are coming to stock market for earning profit. But it is not a safe time to invest in stock market. Introduction: Stock market is an important part of financial system .It is one of the important avenues for channeling fund to entrepreneurs from public savings .stock market of Bangladesh is a growing market .There are two stock exchange in Bangladesh .one is Dhaka stock exchange and other is Chittagong stock exchange .Recent few years stock market of Bangladesh is growing rapidly .It is a very good sign for entire economy. Generally strong stock market performance is associated with strong economic fundamentals, and one should be pleased with the outcome. A strong stock market is much needed for economic growth. But from the beginning of the year 2010 the stock market is showing very bullish trend. There is an inflow of huge cash in stock market. So the demand of share is very high. But supply of the share was insufficient over the year. It has created an imbalance situation of demand and supply in stock market. As a......

Words: 1723 - Pages: 7

Stock Market

...Stock Market Assignment The stock market plays an important role in businesses today. Becoming an investor proved how important it is to understand the stock market. This assignment gave me the opportunity to research and invest in different companies and to learn about the stock market. I also had the opportunity to watch the S&P 500, NYSE, and the NASDAQ, and reflect on market changes and challenges. When choosing stocks to invest in, I was looking to create a diverse portfolio by choosing a variety of industries, price ranges, well known companies and some that were new to me. I visited their websites, read mission statements, and reviewed past performance, learning as much as I could about each company before investing. I viewed the price graphs using ClearStation when looking for companies to invest in. I was looking for companies who have had a gradual but consistent increase in stock price over the past three to six months. I was not willing to invest in a company who had extreme jumps in price. Overall I invested almost $200,000 in twelve different companies. Coke, Hertz, Best Buy, Crocs, Toro, and Bud were all brands I invested in because they were well known to me. These companies or products have been around for years and have a long standing relationship with the consumers. I was able to use the website ClearStation to view past stock market performance before investing. One of the things I was looking for in the mission statement or website......

Words: 1562 - Pages: 7