Archive for March, 2007

links for 2007-03-31

March 30th, 2007

Google Spreadsheets and Finance

Here’s something I didn’t know about Google Spreadsheets — you can embed live financial data straight from Google Finance.

Check it out. Here’s a spreadsheet I created that lists 3 ticker symbols. In the yellow boxes, there’s a function called GoogleFinance that calculates the P/E ratio of the symbol in the adjacent cell:

google-thumb.png

And yes, it’s self-updating. Every 20 minutes.

There are other attributes you can look up on stocks, like price, Beta, market cap, earnings per share, among others. And for mutual funds there’s YTD return, Morningstar rating, and yes even more. Here’s the full list.

The last time I saw something like this, it was available as an Excel macro from Capital IQ, but only if you shelled out cash for a $10,000 subscription. Even a Cap IQ student subscription doesn’t get you the macro (I know because I have one).

Indeed, way cool.

March 30th, 2007

links for 2007-03-30

March 29th, 2007

links for 2007-03-28

March 27th, 2007

links for 2007-03-23

March 22nd, 2007

links for 2007-03-22

March 21st, 2007

Red Hat Challenge

Last week I was asked join a team of fellow student to join the Red Hat Challenge, a competition open to current business school students. The “challenge” is this: come up with a new idea to help Red Hat make money. You get two weeks to work on something and package it into a 5 page business recommendation. If they like you, you get invited to the Red Hat Summit to deliver your idea in person, and oh yeah, a check for $20,000. Booya Jim!

Early on, our team spent some time looking at the obvious plays in the market: Linux on the enterprise desktop, more stack-based acquisitions like JBoss, international expansion, etc. After a while, and listening to the conference call on the challenge held by Red Hat execs, it’s clear they are looking for something they haven’t thought of before. Now that’s a challenge! Suddenly our group meetings have morphed into crazy brainstorming sessions, where ideas are bantered about, pumped up, hollered down, debated fiercely, then divvied up for followup research. I can’t tell you how much fun that is, to try to come up with a business idea something so outlandish that you actually gasp out loud when you hear it.

I’ll likely post the results here just to preserve the time we tried to change the world.

March 20th, 2007

links for 2007-03-20

March 19th, 2007

links for 2007-03-15

March 14th, 2007

Jiffy Lube

Jiffy Lube, as they say in the biz, has both an image and a credibility problem. This expose is pretty incredible.

March 6th, 2007

Previous Posts


About

I'm Ruben Miranda. I'm an MBA student graduate and financial services advisor living in Austin, Texas. This is my blog, home to some random takes on finance, business, software, and occasionally pop culture. Thanks for stopping by. (By the way, I don't speak for my employer.)

rem@alum.mit.edu

Networks

Social Networkage
linkedin.com/in/rubenmiranda

Previous

Archive