Login
Copyright (c) 2014 by SRBR Conditions of Use    Privacy Policy Return to Blogmeister
SRBR -- Blogmeister

SRBR-


The students' blogs have been transferred to 8th grade.

by SRBR teacher: Rye 8th Team
Blog Entries

Title: Stock Market Spreadsheet (02/02/10)
Description: Spreadsheets created by students for their stock portfolios. Student have learned to use formulas to calculate gains or losses and formating tools to display their information.

Article posted April 2, 2010 at 02:29 PM GMT0 • comment • Reads 518

 In math class  we started choosing stocks and we have been watching them for over 15 weeks now and some are up. If they are in the red they are losing money if they are just black they are gaining money which would be good.

Article posted April 2, 2010 at 02:29 PM GMT0 • comment • Reads 518



Article posted April 2, 2010 at 03:03 PM GMT0 • comment • Reads 55



 



I have selected three different companies to "buy" shares of their stocks.  I have been following these companies throughout the year, tracking their progress, and hoping to make money.  I have watched as the DOW has rose and fell, bringing the worth of my stocks along with it.  I am currently making the most money off of these stocks, that I have all year.  I think that they will continue to rise as the DOW rises.  It is hard for me to imagine, but just a few weeks ago, I was in the red, losing hundreds of dollars.

Article posted April 2, 2010 at 03:03 PM GMT0 • comment • Reads 55



Article posted March 23, 2010 at 05:58 PM GMT0 • comment • Reads 66



Throughout the year, we have been keeping track of different stocks in math class.  We have created a spreadsheet that will find our gains in losses just by using the formulas we have put in.  At some points, I have lost money, but I am currently making money.

Article posted March 23, 2010 at 05:58 PM GMT0 • comment • Reads 66



Article posted April 16, 2010 at 03:05 PM GMT0 • comment • Reads 66



In math we have been following specific stocks.  I have followed these stocks for 22 weeks, and I am currently making $1,566.81 total.

Article posted April 16, 2010 at 03:05 PM GMT0 • comment • Reads 66



Article posted May 13, 2010 at 01:48 PM GMT0 • comment • Reads 61

 



Stock Market Lessons








I picked three stocks to invest in, Google, Apple, and TJX Companies Inc. I picked Google to invest in for various reasons. Google is a global company that is used a lot by people because it is so easy to use. When I looked at Google's background information it showed that according to the data Google's worth should go up. I also chose to invest in Apple because it is a very popular company that is always creating new things. Also when I looked up stock market information about Apple, I saw that the prices of its stocks had been growing rapidly. I also bought stocks from TJX Cos. Inc. because each stock was relatively cheap at less then $40 per stock, so I could get a lot of stocks. TJX also seemed to have a very good record because the prices for individual stocks seemed to be climbing. I picked all of these stocks for different reasons, but they all had one thing in common, optimistic background information.



After all of my stock market research, I have a few changes that I would have liked to make. When I finally sold Google, after 24 weeks, I was actually losing money on it. To change this, I would have either not bought Google to begin with, or I would have sold it on December 31, when it had temporarily rose up about $50. Now, after watching Apple for 24 weeks, I think it would have been better if I had bought more Apple stocks because they made me a lot of money. I also should have bought more stocks from TJX because all of these stocks have made me small amounts of money. I also would have sold TJX stocks at week 23, when it was at my record high of $47.69. Although I would change a few things about my stock choices, I still think that my original choices were fine because in the end I made a lot of money.



After watching these stocks for 24 weeks, I have learned many things that would benefit anyone interested in buying stocks. If anyone is interested in buying Google, I would suggest selling this stock whenever it is at a high price because this stock continually changes quickly. I think that Apple is a great stock to invest in because this company is always coming out with new stuff, that makes its worth even higher. TJX is also a very good stock to invest in because although each individual stock only rose about $8, when you have a lot of stocks, you make a high profit. Also, for any stock, it is always important to check the background, and reliability of each company before you make any decisions.

Article posted May 13, 2010 at 01:48 PM GMT0 • comment • Reads 61



Article posted April 2, 2010 at 03:24 PM GMT0 • comment • Reads 81



 



This is my stock market spreadsheet, showing the gains and losses that I made in week 20 of the stock program. As shown above, I am making lots of money mostly in Apple, and I am making a little bit of cash in IBM (International Business Machines) and Activision-Blizzard. Google however, is losing money for me, but at one point I was making hundreds of dollars. The stock unit is very interesting, and will give me good insight if I ever want to actually invest in real stocks.

Article posted April 2, 2010 at 03:24 PM GMT0 • comment • Reads 81



Article posted April 16, 2010 at 03:13 PM GMT0 • comment • Reads 58

 





Here is my spreadsheet for week 22 of the stock program. As you can see, I am earning a solid thousand dollars in Apple, and everythign else is earning me a couple hundred bucks. Also, the DJIA passed over 11,000 points a couple of days ago.

Article posted April 16, 2010 at 03:13 PM GMT0 • comment • Reads 58



Article posted April 23, 2010 at 02:18 PM GMT0 • comment • Reads 58

Article posted April 23, 2010 at 02:18 PM GMT0 • comment • Reads 58



Article posted March 5, 2010 at 07:06 PM GMT0 • comment • Reads 69

Article posted March 5, 2010 at 07:06 PM GMT0 • comment • Reads 69



Article posted April 2, 2010 at 03:19 PM GMT0 • comment • Reads 47



In math class we learned about the stock market, we had to pick three different stocks, and buy a certain number of shares to equal $10,000.  My stocks were Apple, Target and Starbucks.  I have 30 shares of Apple, 30 shares of Target, and 92 shares of Starbucks.  Overall I have made $1,442.32.

Article posted April 2, 2010 at 03:19 PM GMT0 • comment • Reads 47



Article posted April 2, 2010 at 07:14 PM GMT0 • comment • Reads 46

Stock Spreadsheet Update




Article posted April 2, 2010 at 07:14 PM GMT0 • comment • Reads 46



Article posted April 2, 2010 at 02:30 PM GMT0 • comment • Reads 46

Over the past 20 weeks, we have chosen three stocks to follow and turn into a spreadshet for math. I chose Microsoft, Apple, and Pier 1. So far I have been making about $2400, spending $10,000 on each. Every friday we check the spreadsheets and update them. The image below is my latest update to the spreadsheet:

Article posted April 2, 2010 at 02:30 PM GMT0 • comment • Reads 46



Article posted April 2, 2010 at 06:27 PM GMT0 • comment • Reads 67



Back in November we invested in the stock market. We were asked to buy shares from three different companies. We got to spend ten thousand dollors and no more. We had an hand written update sheet for the first couple of weeks. After we got going we created a spread sheet of open office spreadsheets. The spreadsheet allowed us to update our stocks every week without having to do any math or do out all of the formulas that the spreadsheet does for us. The hand wriiten update sheet we still use to write down the prices each week. Our spreadsheets would caculate all of our gains/ losses everyweek as we updated everthing. In class every Friday is when we would update our sreadsheets and check on our stocks.

Article posted April 2, 2010 at 06:27 PM GMT0 • comment • Reads 67



Article posted April 2, 2010 at 02:22 PM GMT0 • comment • Reads 39

For Math class we picked 3 stocks.  We followed them through to see how much money we would get.  I started gaining 452 dollars total this week.  I am losing money from one stock but the rest are gaining me money.  I would not really recomend these stocks.

Article posted April 2, 2010 at 02:22 PM GMT0 • comment • Reads 39



Article posted April 2, 2010 at 02:28 PM GMT0 • comment • Reads 43



Since November, 2009, I have been updating and keeping up with the stock market. I had $10,000 of fake money to spend on shares of three different stocks. I chose to invest in Apple (AAPL) Home Depot (HD) and Walmart (WMT). When I purchased Apple, it was 200.51 a share. Now, it is up all the way to 248.92 a share! Home Depot was originally 27.11 per share, but over the weeks, it gained 8.03, so it is up to 35.14! Lastly, Walmart was 54.54 when I bought it, but lost value to be 54.13. This project has taught me so much about the world of stocks.

Article posted April 2, 2010 at 02:28 PM GMT0 • comment • Reads 43



Article posted April 2, 2010 at 07:11 PM GMT0 • comment • Reads 46



 



In math class, we invested in three stocks. We were given $10,000 to spend on stocks. I invested in Apple, Aeropostale, and The Cheesecake factory. Apple has recovered from falling under $200, but Aeropostale went down below my buy price. When my other two stocks were down, The Cheesecake Factory was going up. Right now, I'm making $1,569.64.

Article posted April 2, 2010 at 07:11 PM GMT0 • comment • Reads 46



Article posted March 23, 2010 at 06:10 PM GMT0 • comment • Reads 45

Article posted March 23, 2010 at 06:10 PM GMT0 • comment • Reads 45



Article posted April 2, 2010 at 03:16 PM GMT0 • comment • Reads 40

Article posted April 2, 2010 at 03:16 PM GMT0 • comment • Reads 40



Article posted March 12, 2010 at 03:24 PM GMT0 • comment • Reads 62

 



 





This is the spread sheet that I have been working since january. My class has their own spread sheets. We pretended that we had ten thousand dollars to spend into 3 different stocks. We got as close as we could to spending all our money. Now every friday we will check our stocks and see if they went up or they went down, also to see if we have lost any money.



 

Article posted March 12, 2010 at 03:24 PM GMT0 • comment • Reads 62



Article posted March 12, 2010 at 03:08 PM GMT0 • comment • Reads 94

 











































































































































































 


 



 
Stock Market





 
Laura Carroll yellow



 



 



 



 



 



 



 
Company Shares Price Price Total Price Total Price Gaines/Losses






Week 1 Week 17 Week 1 Week 17





 



 



 



 



 



 



 
GSK 193 $41.47 $37.84 $8,003.71 $7,303.12 -$700.59
EXM 134 $7.40 $6.44 $991.60 $862.96 -$128.64
PM 20 $50.14 $50.66 $1,002.80 $1,013.20 $10.40















Total Price -$818.83




This is a spreadsheet our math class did. We were following the stock market. We each choose three or four companies to follow and we made a spreadsheet to calculate how much money we had made or lost. Someone of us made a lot of money and some of us lost a lot of money,

Article posted March 12, 2010 at 03:08 PM GMT0 • comment • Reads 94



Article posted March 23, 2010 at 05:54 PM GMT0 • comment • Reads 52



This is a spreadsheet our math class did. We were following the stock market. We each choose three or four companies to follow and we made a spreadsheet to calculate how much money we had made or lost. Someone of us made a lot of money and some of us lost a lot of money,

Article posted March 23, 2010 at 05:54 PM GMT0 • comment • Reads 52



Article posted May 13, 2010 at 01:59 PM GMT0 • comment • Reads 105

 



I picked these three companies for our math stock project because I thought they would make money. I was wrong. I picked Glaxo Smith Kline (GSK) because I heard that pharmaceuticals were doing well and making money. They ended up going up for a while then they started to drop. I ended up losing money. I picked Excel Maritime Carriers (EXM) because I thought that during the holiday season people would be shipping a lot of presents and companies would be shipping their products to people. They also had a steady increase before I bought it so I thought they were already doing well. I picked Phillips Morris (PM) at random. I really picked it at random but ended up keeping it because I heard that tobacco companies were doing well. I also saw that their stocks had been going p recently. I chose these three companies because they looked like they were going to make a lot of money. Don't be fooled people. Do your research.



If I could change my portfolio I would have done more research. I wouldn't have changed my stocks in GSK even though I lost money. They were doing well until the stock market started to look bearish. I would have changed my stocks in EXM and PM though. I would have done my research and not just taken people's work. I would have listened to what people were saying but I would have checked to see if they were right. It ended up being that my stocks in EXM were risky and not a very good deal. In PM I would have just done more research and learned how tobacco companies were really doing. These are the changes I would have made to my portfolio.



Stocks are a risky business, so know what you are doing. Do a lot of research on your company and other companies like them. If there is a bearish market, then you should be careful with the companies you chose. It there is a bullish market chose the ones that have recently gone up. I should have looked into other companies like EXM because another shipping company's stocks went way up when mine went way down. Don't just take people's work on something, double check. Also it is very risky so look at their chart. If in the past year they have been going way up, then don't assume they will keep going up. They could easily just drop. Another good tip is to not put all your money into one stock. If your stock goes down then you lose a lot of money. I know that because invested almost all my stocks in GSK and lost a lot. Before you buy your stocks just think it through and do your research.

Article posted May 13, 2010 at 01:59 PM GMT0 • comment • Reads 105



Article posted May 14, 2010 at 03:19 PM GMT0 • comment • Reads 50



This is my Stocks in Math Class.



This is a spreadsheet our math class did. We were following the stock market. We each choose three or four companies to follow and we made a spreadsheet to calculate how much money we had made or lost. Someone of us made a lot of money and some of us lost a lot of money.

Article posted May 14, 2010 at 03:19 PM GMT0 • comment • Reads 50



Article posted April 2, 2010 at 03:28 PM GMT0 • comment • Reads 42



In the stock market project i selected 4 stocks. Google, Sears Holding Company, Toyota Motors and Sirius Radio. Google used to be my best stock until they came out with the new google phone and that caused a huge downfall from $640to around $520. But now its back up to to what I bought it at Toyota has been hovering around 10 above what I bought it at. My highest winner is Sears, it has gone up about 40 dollars than what bought it at. Well thats what my stocks are doing.

Article posted April 2, 2010 at 03:28 PM GMT0 • comment • Reads 42



Article posted March 12, 2010 at 02:22 PM GMT0 • comment • Reads 44



 



This is part of the stock market unit we did in class.  We used spreadsheet to make a table of how much money we made.  This is not updated.

Article posted March 12, 2010 at 02:22 PM GMT0 • comment • Reads 44



Article posted January 29, 2010 at 02:21 PM GMT0 • comment • Reads 46

 



 This is my stock spreadsheet. My class and I started following the stock market in November We were given a certin amount of fake money to spend on stocks. We made a spreadsheet that automatically calculates our gains and losses. This is my spreadsheet. As you can see I doing very well.



Article posted January 29, 2010 at 02:21 PM GMT0 • comment • Reads 46



Article posted April 2, 2010 at 06:24 PM GMT0 • comment • Reads 45



In my math class we are learning about stocks. Our teacher gave us a metephorical $10,000. We got to pick 3-4 stocks to invest in. I picked Apple, Novartis, Amazon, and IMAX. We later learned the formulas to put our stocks into a spreadsheet. We have been updating our spreadsheets for many months now. I really enjoy this project and hope to continue.

Article posted April 2, 2010 at 06:24 PM GMT0 • comment • Reads 45



Article posted April 16, 2010 at 02:26 PM GMT0 • comment • Reads 67

This is my spreadsheet. I picked three stocks. Ebay, Walt Disney, and Walmart. We started our stocks on November 19 2009 and we're going to end on April 22, 2010. We started a spread sheet so we could see if we were gaining money or losing money. At first everything that I had I was losing money with but now, I'm gaining money. This was from Thursday April 1, 2010 so now I'm still gaining but Walmart is losing. This is to teach us how to use stock and what happens in everyday life. Those are my stocks.





 

Article posted April 16, 2010 at 02:26 PM GMT0 • comment • Reads 67



Article posted April 2, 2010 at 03:16 PM GMT0 • comment • Reads 41



Our grade has been doing a unit on stocks, I chose to get 10 Google stocks (goog),  10 Apple stocks (appl), and 29 Ralph Lauren Polo(rl). Our teacher gave us a $10,000 to spend. At the time when I got Apple, it was $200.51, it has gone up $35.46, that times the amout of stocks I have in Apple (10), means that I have made $354.60 over 20 Weeks. 

Article posted April 2, 2010 at 03:16 PM GMT0 • comment • Reads 41



Article posted April 2, 2010 at 03:22 PM GMT0 • comment • Reads 47

This is my spread sheet for week 20. I am in the black, and gaining a lot of money.

Article posted April 2, 2010 at 03:22 PM GMT0 • comment • Reads 47



Article posted March 12, 2010 at 03:27 PM GMT0 • comment • Reads 51



This is our spreadsheet on the stocks we took share's in. We could have ten thousand dollars to put as many shares as we could. I put my money into Microsoft, Wal-Mart and Coca-Cola. Right now I am actually losing money, a lot of money.

Article posted March 12, 2010 at 03:27 PM GMT0 • comment • Reads 51



Article posted April 2, 2010 at 03:28 PM GMT0 • comment • Reads 44



This is my spreadsheet that I have been updating every week in math class. I have put my "money" in to Microsoft, Wal Mart and Coca-Cola. Right now I am actually losing money but it is still a lot of fun to check my stocks every week. We are on week 20 and and stiil keeping track. I hope at the end I am in "The Black" or gaining money in the stock market.

Article posted April 2, 2010 at 03:28 PM GMT0 • comment • Reads 44



Article posted May 25, 2011 at 03:23 PM GMT0 • comment • Reads 51

This is my stock spreadsheet. It shows how my stocks where doing at week 24. It also tells me how much money I have gained or lossed.





 



 

Article posted May 25, 2011 at 03:23 PM GMT0 • comment • Reads 51



Article posted June 1, 2011 at 03:14 PM GMT0 • comment • Reads 73
























































































































































Stock Markets








Corporation Shares Price/Share Price/Share Total Price Total Price Gains/Losses






Week 1 Week 24 Week 1 Week 24


Bottomline 105 $19.16 $24.15 $2,011.80 $2,535.75 $523.95
JP Morgan Chase & Co. 74 $40.41 $44.68 $2,990.34 $3,306.32 $315.98
Radio One Inc. 4164 $1.20 $2.70 $4,996.80 $11,242.80 $6,246.00









Total $9,998.94 $17,084.87 $7,085.93






Article posted June 1, 2011 at 03:14 PM GMT0 • comment • Reads 73



Article posted May 23, 2011 at 03:18 PM GMT0 • comment • Reads 40

Stock Market Report

by CRJO



The stocks, they go continuously up, and down, for better or for worse. In Math class we were given 10,000 fake dollars to invest in the three stocks of your choice. I invested in these three stocks: Marriott international, MBIA, and CSCO systems incorporated. I chose Marriott international because I knew what Marriott does and how it was doing. Marriott international was planning to add over 200 new hotels to different countries showing that it had extra money, and it is profiting. Although I had assumed that this stock was going good, and it was for a while, it went eventually bad.

MBIA is a insurance company, that was in the “bullish” or currently going up section. This seemed like a good idea at the time, but I would find that all stocks go up and down. This stock was going up at the time, but in the near future it would drop, which it did.

CSCO systems is a computer parts company which was also a bullish stock. By the way a Bearish stock is the opposite of a Bullish stock, it goes down. This stock was a pain in the pocket, the day after I invested, it took a straight down drop, joey not happy...

If I could have made some changes this is what I would have done. I would have changed all my stocks, they all went down from there. Although I made $3.66 with one stock... but all my stocks went down. I wish also that I had picked a gold or Silver stock, which boomed that section when we were doing stocks. The price of Gold has always been good but lately it has soared. If I was able to have sold my stocks earlier, and have used the money that I had made to buy other stocks then that could have been a more... real life experience for me. This would have been in my perspective more fun, and a little more exciting.

Overall, I learned a lot, here is some of my advice to you. Once again, do not invest in bullish stocks! These stock are great if you want to lose money. If you have ever seen a stock, they go up and down, when they currently go up, it means they are just about to go down. My second piece of advice, research your stock, it help if you know your stock. My stock Marriott International was a great stock, till it went down...but it helps if you if you have a stock that you have heard of. This is a great technique, also I have a third and final piece of advice, check out the historical prices of the stock you are looking at. It show what has happened with the stock from the beginning of when it was registered as a stock. You can notice trends and it will be easier to notice patterns in your stock. This is my advice for you, I hope it helps.

As a hopefully to-be business man I did much research, but I did not have this. If I did than I would have made some money, most likely. The reality is that I did not have such information as this, but you do! Go buy a stock, and make the money I lost. Happy stock hunting, and send me some money... please... alright you don't have to.

Article posted May 23, 2011 at 03:18 PM GMT0 • comment • Reads 40



Article posted May 25, 2011 at 03:01 PM GMT0 • comment • Reads 71

 



   This is the Spreadsheet I made for our Stock Market Unit. It shows me how much money I've gained and lost.



 



Article posted May 25, 2011 at 03:01 PM GMT0 • comment • Reads 71



Article posted May 24, 2011 at 04:05 PM GMT0 • comment • Reads 74







Stocks



 



Stocks can be dangerous to your economic status. Stocks can improve your life style by letting you make money in a click of a button. Its a risky business. Stocks are all public companies that give human a decision to invest in the companies and you with earn money if it is doing well. The fallowing paragraphs are all about the stocks I decided investing in.



Investing in stocks is a tough decision to make without preparing. It is to make money but also allows you to become more aware of what company's are doing poorly or succeeding. During the 24 week period we “bought” the stocks of our choice, I finally decided on “buying” Steris Corp, SPDR Gold Shares, and McDonald’s. I choice Steris Corp. for one main reason; it was flu season. Steris Corp. is a company that make healthcare products including hand sanitizer. I also chose to take part in SPDR Gold Shares. Gold has always been in high demand and it seemed to be a good money maker. Last I decided to invest in McDonald’s. I chose McDonald’s because it has always been popular around the world and many people enjoy their food. Overall I believe my stock choices were a pretty good decision for the circumstances.



Stocks can change in a flash, some people win and some regret. There are many changes people (including me) would make only if they could. Steris Corp. is a company I regret buying. I would have wanted to invest in Steris at a different time due to the fact I bought it when it was doing pretty well. SPDR Gold Shares is the one stock I was delighted to have bought. If I had one regret with SPDR gold shares, it would be that I would like to continue to own my shares because they are continuing to go up. McDonalds Corp, is a stock I hugely regret investing in, it went down while I owned it and I probably should have not chose McDonald’s in the first place. If I could go back in time and change, I would have spent more time researching while stocks to buy and not have gone with stocks.



There is plenty of advice to give to people who are interested in stocks, but they have to also follow what they want because there is no right or wrong answer. Stocks go up and down (normally without warning.) Stocks can be surprising and unhelpful. There were a few things that made life easier while doing this stock project. The spreadsheet on the computer was the most helpful. Using formulas helped to show the math that was involved in stocks, and I was able to see what was making and losing money and how much. At the beginning of the project we used vocabulary that was used in the stock market. It helped me understand the summery of the company and words that were unknown to me. Throughout this project, every Friday we used yahoo finance to collect information on the last trade on our stocks so we could compare it to when we bought it in the first place. Yahoo finance was consistent and helpful. Overall, that stock projects was informing and helpful for understanding stocks and what they are for.



In the long run, overall I would have invested in these companies for a longer time and would have spent more time exploring my options in the stock market. In the stocks I invested in, which were Steris Corp., McDonald’s and SPDR Gold Shares, I would have invested in SPDR Gold Shares because of what I have learned. The other stocks did not progress as much as I would have liked. It is a live and learn lesson.





Article posted May 24, 2011 at 04:05 PM GMT0 • comment • Reads 74



Article posted June 1, 2011 at 03:22 PM GMT0 • comment • Reads 51














































































































































































































STOCK MARKET SPREADSHEET





























Company Shares Price Price Total Price Total Price Gains






Week 1 Week 23 Week 1 Week 23 Losses
Hershey's 32 $47.54 $53.75 $1,521.28 $1,720.00 $198.72
Netflix 14 $168.84 $236.73 $2,363.76 $3,314.22 $950.46
Apple 11 $307.43 $332.42 $3,381.73 $3,656.62 $274.89
Panera Bread 29 $94.23 $123.42 $2,732.67 $3,579.18 $846.51









Total $9,999.44 $12,270.02 $2,270.58
HRQU

















Article posted June 1, 2011 at 03:22 PM GMT0 • comment • Reads 51



Article posted June 1, 2011 at 03:00 PM GMT0 • comment • Reads 49



























































































































































































































































      Stock Market Investments      
             
Company Shares Price Total Price Price Total Price Gains/Losses






Week 1 Week 1 Week 23 Week 23


Apple Inc. 13 $309.00 $4,017.00 $350.70 $4,559.10 $542.10
         


 
Google Inc. 5 $599.23 $2,996.15 $525.10 $2,625.50 -$370.65
       





 
Nike Inc. 36 $82.71 $2,977.56 $80.19 $2,886.84 -$90.72









Total


Total Total
      $9,982.07   $10,071.44 $80.73
  $$ Down $$          
  $$ Up $$       Justin Messmer  

Article posted June 1, 2011 at 03:00 PM GMT0 • comment • Reads 49



Latest 10 Comments
Login
Copyright (c) 2014 by SRBR Conditions of Use    Privacy Policy Return to Blogmeister