Google Finance Blog - News and Views from the Google Finance team
Showing posts with label finance. Show all posts
Showing posts with label finance. Show all posts

Google Finance heads across the pond

Wednesday, January 30, 2008 at 7:15 AM

Posted by Nick Fey, Google Finance designer


Being a British bloke I am particularly pleased to announce the launch of Google Finance in the UK (http://finance.google.co.uk). Now it's easier for us Brits to get our own European public and private company information as well as UK mutual fund data. In addition you can find GBP currency quotes on the home page, so we can feel smug about how much cheaper everything will be when we visit the U.S. The local UK business news will give you the latest information about the European markets and we will be improving the relevance of stories and speed of news delivery even more over the coming months.

This UK launch is the second in a series of local versions of the Google Finance site, following Google Finance Canada, which launched last summer. We have received many requests to bring this service to other countries around the world, and will be working to do that this year. Kudos to the small crew of engineers on the Finance site who have managed to do this as well as build some great new features that we will be rolling out in 2008.

Please feel free to leave comments on this blog or send us email through the Help Center requesting new features. While we can't respond to them all individually, don't feel that they are being ignored; your feedback has a huge impact on how we prioritize our work.

To all my china plates back in the UK -- enjoy.

And now in Canada

Tuesday, July 31, 2007 at 5:08 PM



Today we're pulling the wraps off Google Finance Canada, a localized version of Google Finance tailored for Canadian investors. One of our top requests has been for localized market information, presented of course in a useful and accessible format. We think Google Finance Canada addresses this by presenting top news and company news from Canadian sources, economic data from the Bank of Canada, multi-currency portfolios, and Canadian equity and mutual fund data. The main Google.com search experience has also been improved with Canadian stock onebox results. But speaking as a Canadian, my favourite feature is the company search that prioritizes Canadian companies (no more typing in Canadian exchange prefixes!).

What makes this release extra-special for us is the fact that it was put together by a distributed team of full-time and 20-percent-time engineers. (All the Google engineers may devote 20 percent of his or her work time towards a project of their own choosing.) We're grateful to have had the contributions of 20-percent engineers from our Hyderabad, Kirkland, Montreal, Mountain View, and New York offices to make this launch possible.

Interactive Q&A comin' up!

Tuesday, July 17, 2007 at 2:49 PM



A core tenet of Google is to "focus on the user and all else will follow." The Google Finance team shares this view and as such, we spend a lot of time conducting user research, meeting with power and novice users of online finance, and reading your emails and comments to this blog. This week, we wanted to try a new idea, which is to set aside a period of time to have an interactive Q&A session on this blog.

Here's how it will work: please write your suggestions and questions about Google Finance in the comments section below this post. We will start reviewing and responding to all comments (except comments that are off-topic!) immediately and will respond in a meta-post on Thursday, July 19th around 9am PST. If there are more submissions than we can comfortably answer in a single post, we'll carry over the selected questions to Friday and answer them then.

We look forward to hearing from you!

Making the most of Google Spreadsheets

Monday, July 9, 2007 at 8:12 PM



Almost every stock investor that we talk to during our user visits makes use of a spreadsheet to compile the data they have researched and many use their own formula to help decide when it is optimal to trade a stock. Whether they use Excel or a napkin, vast numbers of investors spend time every day keying in or writing down data. Wouldn't it be great if there was a spreadsheet that you could access from anywhere with an Internet connection -- a spreadsheet you could share with certain friends and automatically get the data updated to save you doing that work each day? For a while now, Google Spreadsheets has included Finance formulas so you can do all this and more.

Within Google Spreadsheets you can select the Formula tab and follow the more >> link on the top right.



Look at the Google section within the dialogue box and from here you can see the syntax for entering a Finance formula (see above). The details of all the stock and mutual fund data that you can pull into the spreadsheet can be found on this help page. To quote a section:

"Here are a couple examples using the formula:

* To insert the current volume of Google stock:
=GoogleFinance("GOOG"; "volume")
* To insert the current price of Google stock:
=GoogleFinance("GOOG") and =GoogleFinance("GOOG"; "price")
* Alternatively, the stock symbol and/or the attribute values can come from spreadsheet cells. For example, the function can be:
=GoogleFinance(A2, B1)
In this case, the attribute specified as a string in cell B1 would be returned for the stock symbol in cell A2."

Using this approach you can set up your portfolios and watchlists and have the data be updated continually. This is a screenshot of a portfolio I pulled together in a few minutes:



If you have your own formula that you would normally use to screen stocks then go ahead, it is easy to add them in. If you want to collaborate with anyone else, maybe a co-worker or investment club, it is easy to add them through the Share tab and you can show off your winning formulas with the world by publishing the spreadsheet and linking to it on your blog.

You can see how powerful this tool is, and so we are busy talking to folks who use it, and exploring ways in which we can improve it. If you have any ideas, please feel free to comment below.

Let's discuss!

Thursday, July 5, 2007 at 1:56 PM



When Google Finance launched last year, we created discussion groups, a forum where posters could have quality, on-topic, spam-free discussions about their favorite stocks and companies, and where the exchanges remain cordial and informative. If you're interested in participating, please review our community guidelines. In addition to these rules, we have a small team of moderators, including me, who help facilitate the discussion process.

Over the past few months, we've seen some great discussions on Google (GOOG), New York Stock Exchange (NYX), and the recent IPO of Blackstone (BX). In fact, our Apple discussions group has been hotter than ever as the community has been going ga-ga over the iPhone (in fact, so have I -- who hasn't been?).

To find a discussion on a particular company, do a search on Google Finance, and click on the "Discuss" link, above the chart. Or, you can start your search for a company from Google Groups. We look forward to welcoming you to our community.

Tracking the real estate meltdown with comparison charts

Saturday, June 30, 2007 at 4:44 PM



Everyone knows that business cycles oscillate from boom to bust every so many years, and real estate is not unique in this regard. Stock prices reflect these trends. Anyone who has looked at a home builder stock in the past couple years is intimately aware of this connection. But what does it mean to say that an industry, as opposed to a stock, is experiencing a downturn? It's not just a matter of saying "real estate stocks are down" -- it's more that they're down, in a roughly correlated manner, over a meaningful common time period.

Let me show you what I'm talking about. Here are 3 major homebuilders -- Centex, Lennar, and Ryland -- in the same graph:



Let me take a moment to explain how I generated this chart, so that you can do your own analysis of stock trends in real estate (or any other industry). Go to Google Finance. Type in the first symbol, CTX (Centex). Hit Enter. You should see a chart for Centex. Use the time window below the chart to change the view to January 2005 through June 2007. (You might have to zoom out more than once.) Now, hit the"Compare" button to the upper left of the chart. Check the boxes for LEN (Lennar)and RYL (Ryland). A short moment later, you should see essentially the same chart that I gave you above. You might have slight differences due to different start and end dates.

Notice that you never asked for LEN or RYL. Google Finance just knew that they were related companies. This works very well in most cases. Type in C (Citigroup), for example, and you'll get other large financial companies from "Compare". How do we know which companies are related to which other ones? Ah, but that's the secret sauce!

So back to the vague term "industry downturn". As you can see in the chart above, all of these stocks are down roughly 35% since the start of 2005. And it should be visually clear to you that they rose, then declined, in roughly the same manner, with RYL being the most volatile of the group.

Has this ever happened before? Sure it has. In the last major real estate stock decline, you can see an eerily similar pattern:



Here, January 2005 has been replaced by January 1989, and June 2007 has been replaced by June 1991. Again, CTX was the most volatile of the group, and again the ups and downs of all 3 major players roughly traced one another. The group as a whole appears to have peaked in August 1989 (although to know for sure we need to adjust for market cap). It then seems to have bottomed in October 1990.

In the first chart, you can see that the group appears to have peaked again in July 2005. So, if we learn from history, it should have bottomed in around September 2006. Indeed, this isn't far off from the real bottom, up to that point, which occurred in July 2006. Unfortunately, as we all now know, that wasn't the bottom...

Of course, comparisons such as this do not make a complete investment analysis, but they can often provide suggestions for further research involving other financial metrics.

I don't own any of the stocks I discussed, and while it's not my business to advise you what to buy or sell, I do hope I've shown you a new and cool way of analyzing related businesses.

Gadgets on the loose!

Thursday, June 28, 2007 at 11:44 PM



If you like to customize your iGoogle page, you'll love these two new gadgets. The interactive chart and sector summary gadgets reflect two of our most popular features on Google Finance. We're pleased to now offer them on iGoogle.

Click on the screenshots below to read more about the gadgets and to add them to your page:

Finance chart

Sector summary

There'll be more finance gadgets to come. Meanwhile, if there's something you really want made into a gadget, please let us know in the comments section!