Import stock quotes using Excel

December 2, 2006

There are a lot of tools how there to manage your personal finance, but none seems as flexible and powerful as Excel.

In order to manage your stock portfolio with Excel we need to periodically update your stock quotes and that can be a hassle.

Wait no more, Excel 2003 has a feature called Web Query that’s just great to import stock quotes. Here’s how it works.

You find a site that has the quote you want (e.g. http://finance.yahoo.com/q?s=goog , for Google’s quote).

You open Excel and go to Data->Import External Data->New Web Query

Step 1

Then enter the site’s URL at the next window and select the table that has the quote you want.

Step 2

And you’re done, now you have the information on your spreadsheet and you can do whatever you want with it.

To refresh the Web Query, right click the Range and select “Refresh”. You can also edit the Range’s properties so that it is automatically refreshed.

Step 3

Advertisements

Adeus Google Answers

December 1, 2006

As mentioned by Google and then by Seth Google Answers has stopped accepting any new questions and, by the end of the year, will stop accepting even new answers.

But why? They don’t tell.

Is it because it wasn’t profitable? It’s likely but… Google has lots of products that aren’t profitable. But probably this one wasn’t growing as intended.

If I had Google’s huge cashflow, user base and intelectual capital I’d do the following with Google Answers:

  1. Redesign it (it is so so…)
  2. Stop charging people to ask questions
  3. Implement a Googled ranking system for contributors answers (they have great PhDs, I’m sure they’ll have no problem with that)
  4. Give daily/weekly/monthly prizes to the best contributors
  5. Sell advertising space on the site.

If they gave out $5000 prizes daily, how many people do you think would visit the site?