Author Archive

Displaying Stock Quotes on Google Docs

Finance No Comments »

Google Finance on Google Docs

At the beginning of this month, NASDAQ announced that now they provide real-time stock quotes to Google (and some other media companies). Three weeks later, New York Stock Exchange (NYSE) also announced that now they provide real-time stock quotes to Google (and CNBC). Real-time stock quotes used to be quite expensive to subscribe. The standard stock quotes are normally 15 – 20 minutes delay.

Today, I am going to share how to use Google Finance function to display stock quotes on Google Docs. Since both NYSE and NASDAQ provide real-time stock quote, we can now create a document on Google Docs that shows real-time stock price. See also example of my stocks basket above.

How can we do that? It’s pretty straightforward.

  • Create a new spreadsheet on Google Docs.
  • Type in ‘=GoogleFinance("‘ followed by the stock ticker. For example, you can type ‘=GoogleFinance"GOOG")‘ to display the real-time stock price of Google.

Google Finance on Google Docs

We are Back to Year 2006!

Finance No Comments »

Dow Jones Industrial Average

(Picture is from Google Finance.)

It’s a doom day!

Dow Jones Industrial Average dropped to its lowest level since 2006. As I predicted last week, it finally dropped below 11,500. I should have written my prediction on this blog last week and become an "instant Wall Street analyst"… just kidding. :)

According to Wall Street Journal, it is the worst June since Great Depression.

My Yahoo! Resignation Letter

Fun No Comments »

With the recent mass exodus from Yahoo! (TechCrunch mentioned 114 executives so far), someone has created a template for Yahoo! resignation letter. I am not working for Yahoo!, but it is quite fun to play with the template. You have check boxes where you can select the words for your resignation letter.

PS: I am actually quite sad to see the end of Yahoo! has to be like this. They used to be a very good company. They started one of the first search engines in the world. They were one of the most successful IPO companies in the dot-com era. They have made thousands of people become so rich. To be honest, I used to be a fan of Jerry Yang.

Well good luck for Jerry Yang and co.

yahoo_resignation


Usually 350-001 and 70-290 professionals are not concerned with chat rooms. They seek careers in yahoo and google. The ones more likely to land jobs there are 70-649 and 70-270. The 646-204 candidates have bright chances too.