Build a Classroom Stock Market Game in Google Spreadsheet

There seems to be a recent push to teach personal finance concepts in high school. That makes perfect sense to us – a little less trigonometry and a little more compound interest is probably more useful in the long run. I was in 7th grade when I was first exposed to the Stock Market Game. Basically, everyone picked one stock, and we occasionally checked to see who was doing the “best” based on price appreciation.

While I’m not sure I really learned that much from that experience of watching some random number fluctuate around, maybe it did plant some subconscious seed of interest as I ended up pursuing a career in finance. I think the Stock Market Game would be better if supplemented with a lesson on exactly what a share of ownership in a corporation means (see What Makes a Good Business?). But anyways, I digress… Continue reading “Build a Classroom Stock Market Game in Google Spreadsheet”