RBGSX update 1: sense of scale, sense of history.
So, after work today I looked up the first 15 weeks of past stock prices (the Friday closing price) for my 25 stocks, chunked ‘em into a spreadsheet, ran the mess through a pivot table, and came up with a (sort of) fancy chart:
Rocket Bomber Geek Stock Index Performance, 2010
This chart is just the Σ stock prices, not the weighted index I came up with in the introductory post — I actually kind of like the way this works, so I might leave it at that.
The growth in the geek sector is largely due to gains at Apple (+36.67) and Netflix (+30.22) over these three months, though all but one stock (Scholastic) gained value over the quarter.
And of course some stocks would be a much better return on [short-term] investment, like Borders: it more than doubled in price, going from 1.18 on 31 Dec to 2.74 on this past Friday. —not bad, but it was trading above $20 three years ago (back in June of ’07) so a lot depends on when you got in, and when you got out, and a lot of folks lost money on this horse.
Stock prices have precious little to do with company performance, but it’s available information so I’m guessing this will be worth tracking for at least a few months; we’ll see if it’s something both of us [blogger & reader] can get some value out of.
For the curious:
12/31/09 $877.28
01/08/10 $883.48
01/15/10 $864.98
01/22/10 $843.70
01/29/10 $850.41
02/05/10 $840.91
02/12/10 $852.83
02/19/10 $867.27
02/26/10 $863.52
03/05/10 $914.94
03/12/10 $931.32
03/19/10 $935.45
03/26/10 $966.38
04/01/10 $971.61
04/09/10 $1,003.39
04/16/10 $1,013.14
& the 25 stocks: CBS Corporation (NYSE:CBS), The Walt Disney Company (NYSE:DIS), News Corporation (NASDAQ:NWSA), Sony Corporation (NYSE:SNE), Time Warner Inc. (NYSE:TWX), Viacom, Inc. (NYSE:VIA), Wiley John & Sons Inc. (NYSE:JW.A), The McGraw-Hill Companies, Inc. (NYSE:MHP), Lagardere SCA (EPA:MMB), Pearson PLC (NYSE:PSO), Scholastic Corporation (NASDAQ:SCHL), Amazon.com, Inc. (NASDAQ:AMZN), Books-A-Million, Inc. (NASDAQ:BAMM), Borders Group, Inc. (NYSE:BGP), Barnes & Noble, Inc. (NYSE:BKS), Hastings Entertainment, Inc (NASDAQ:HAST), Indigo Books & Music Inc. (TSE:IDG), Best Buy Co., Inc. (NYSE:BBY), Netflix, Inc. (NASDAQ:NFLX), Navarre Corporation (NASDAQ:NAVR), Activision Blizzard, Inc. (NASDAQ:ATVI), Electronic Arts Inc. (NASDAQ:ERTS), GameStop Corp. (NYSE:GME), Nintendo Co., Ltd (OTC:NTDOY), and Apple Inc. (NASDAQ:AAPL)
Please note: nothing here is investment advice. full disclaimer
Oh, and one more thing:
Indigo trades in Canadian Dollars, Lagardere SCA trades in Euros — and yes, I ran a currency conversion but I was lazy and just used today’s rate, not historical rates.
The foreign currencies are
a convenient blind to hide behindone reason the numbers above don’t quite match with the portfolio value as listed in the intro post.Comment by Matt Blind — 19 April 2010, 00:05 #
And yes, this only took 2 hours after work.
If only these were billable hours, and at investment banker rates…
Comment by Matt Blind — 19 April 2010, 00:07 #