Online Portfolio Blog

Portfolio Poll 2009-2010

nospam@example.com (Jackson) — Wed, 01 Sep 2010 10:24:03 +0100

The second online portfolio poll is closed after running for a year; it received 68 votes in total - not bad considering the first poll got 70 votes after running for over a year and a half. In that last year CNN ditched their portfolio services, Yahoo! and Google made incremental enhancements to their sites, and Google Docs emerged as an option for those who like to do things their own way. And now, on to the results...

Yahoo! Finance is the winner for the second year in a row with 30% of votes. A round of applause for the world's favourite free online porfolio tracking site!

Google Finance is the runner-up, with 27% of votes. But it has the momentum, ceteris paribus, to overtake Yahoo! this year...

FT.com came in third with 12% - this is the most improved site: it only got 2% in the previous poll.

The new poll is ready, please go ahead and vote: it's in the right column of this page. If you use a site that isn't listed in the poll, please specify which in a comment below so I know to make it a contestant in the next poll.

Product Ideas for Google Finance

nospam@example.com (Jackson) — Fri, 13 Aug 2010 22:29:27 +0100

Using appspot.com, you can now suggest ideas to improve Google Finance, and vote on other people's ideas.

There are some pretty good ideas already on the site, for example:

"It would be great if a chart overlay was available which showed you when you bought shares and the amount of shares bought. It would be a nice alternate way of seeing whether your shares have gained/lost value."

which is something we've mentioned before on this blog.

Click here to check out the site, vote and suggest new ideas...

Reuters Portfolios

nospam@example.com (Jackson) — Tue, 15 Jun 2010 16:30:45 +0100

Reuters have a section on their site called Community Portfolios. It seems to be geared towards following and comparing other people's portfolios and their performance, but you can also create a private portfolio by unchecking the "Share this Portfolio with the Community" box.

Overall it's a pretty impressive system. It's easy to enter transactions, the site automatically figures out dividends, and can even display nice charts of historical performance like this one:

Continue reading "Reuters Portfolios"

Your Financial Portfolio in Google Docs 2

nospam@example.com (Jackson) — Mon, 05 Apr 2010 11:56:49 +0100

We saw that Google Docs spreadsheets have financial functions available in the first post in this series.

For this post, I've created a Google Docs Template which you can view, and copy for your own use if you like (it's free). Click here to see the live template.

The template currently has 2 sheets for securities. The first is for open positions, i.e. your current holdings. The second, "Closed Positions", is for securities you've already sold: use this if you want to keep a history of your past performance.
Continue reading "Your Financial Portfolio in Google Docs 2"

Your Financial Portfolio in Google Docs

nospam@example.com (Jackson) — Mon, 05 Apr 2010 11:51:00 +0100

If none of the free online portfolio tracking sites cater to your needs, you might want to try creating your own. Well, maybe not your own site, but you can use Google Docs to create a spreadsheet that shows you up-to-date stock information in any format you choose.

For example:

The company and EPIC columns are typed in manually, the Price and Change columns use the GoogleFinance function to find data for the given ticker.

Continue reading "Your Financial Portfolio in Google Docs"

CNN Money Ditches Portfolio Services

nospam@example.com (Jackson) — Fri, 12 Mar 2010 11:01:56 +0000

CNN Money, which we briefly covered a while ago, will downsize its functionality in a few days. They will offer a simple watch list, without the ability to manage an online portfolio. Here's their message to subscribers:

On March 15th, CNNMoney will replace the current Portfolio Tracker with an easily accessible and customizable My Watch List feature. My Watch List will enable users to track relevant data on stocks, mutual funds, and ETFs. As part of this replacement, CNNMoney will no longer offer site visitors the ability to track the number of shares and commissions for holdings.

This is probably all for the best, given that on previous inspection the services they offered were rated "useless"...

Show us the Transactions!

nospam@example.com (Jackson) — Fri, 23 Oct 2009 10:19:58 +0100

Both Google Finance and Yahoo! Finance can record one's portfolio transactions.

Both also graph share prices with markers for events such as dividends and splits; even news items in Google's case.

Why don't they also show events that are relevant to the individual investor? Like when one has bought or sold shares?

A green dot for buys, a red dot for sells, and voilà: one instantly gets an idea how good one's market timing is.

C'mon Google. C'mon Yahoo!. You already have the data, now show us the transactions!

Disable Automatic Dividends in Google Finance

nospam@example.com (Jackson) — Mon, 21 Sep 2009 10:06:51 +0100

Although not widely advertised, Google Finance have added the ability to disable the new automatic dividends feature on a portfolio basis. The announcement is buried in the comments on this Google Finance Blog post:

The feature can be used on a per-portfolio basis from your 'Edit portfolio' tab. The checkbox to enable and disable it can be found over the 'Save changes' button.

As you can see from the other comments, this was by popular request: many people found the new feature messed up their Google Finance portfolio... Overall, the deployment should have been smoother with this checkbox present from the start; still kudos go to Google Finance for listening to their users - even if that simply means keeping their product usable.

Portfolio Poll 2008-2009

nospam@example.com (Jackson) — Wed, 09 Sep 2009 09:51:09 +0100

I've closed the first Online Portfolio poll, check out the archive for full results. The poll asked which website you use to manage your portfolio.

Yahoo! Finance came out on top with 18 out of 70 votes, closely followed by Google Finance with 14. Hats off to Yahoo!

Number 3 spot went to "A different website", so I've just started a new poll with a few more options. If there's a site you use that's not one of the options, please let me know in this post's comments.

Honourable mentions go to MSN Money, AOL Money & Finance and MarketWatch.

I'm planning to run the poll yearly, so if you answered the last poll, don't hesitate to answer the new poll in the column right of this page.

More on Splits and Dividends in Google Finance

nospam@example.com (Jackson) — Wed, 09 Sep 2009 09:06:38 +0100

With regards to Google Finance's new automatic split and dividend functionality, it seems that the number one request from users is "How can I turn this off?". The Google Finance blog has quite a number of comments to this effect, with few in favour of the changes.

The update messed up the portfolios of those who had manually inserted dividends as cash entries. This is understandable in that Google Finance wants to automate this process, and from an engineering standpoint it's easier to have one way of doing this rather than have several options. Also, in my opinion, the fix is acceptable: deleting the manual entries.

And that would be fine, if Google Finance's dividend tracking actually worked. Some examples of complaints given: for UK and Hong Kong stocks, Google Finance apparently can't tell what currency, denomination and tax deductions to use; it doesn't work for accounts that automatically re-invest dividends or fractional shares; it will count splits and dividends from before shares were actually purchased...

The response from Google Finance so far isn't that great, look for "Google Finance Guide Laura" on the blog comments page to see it. Let's hope they get their act together, and sort out this long-awaited, but half-baked update.

Splits and Dividends in Google Finance

nospam@example.com (Jackson) — Mon, 24 Aug 2009 13:01:59 +0100

Google Finance have recently added support for tracking splits and dividends in portfolios. Their announcement is here. You can see the splits and dividends by clicking on the "Transactions" tab when viewing your portfolio.

The handling of splits is not perfect: it manages to calculate that now I hold 0.25 shares in a stock I sold out of long ago - something to do with a 7:8 split. Some other manual adjustments are required for special cases, e.g. rights issues, or if you received shares instead of a dividend.

Dividend reporting isn't perfect either. Reconciling dividends reported by Google Finance to those actually received would be an arduous task: I suspect Google Finance is reporting the dividends pre-tax (10% tax credit is taken off UK dividend payments), and at the date they were announced rather than the date they were actually paid.

However, I still think this is a huge step in the right direction. Once the aforementioned wrinkles are ironed out, Google Finance could become the one obvious choice for monitoring a portfolio online. Their recent interface update also certainly helped in this regard.

FT Portfolio Charts

nospam@example.com (Jackson) — Fri, 20 Mar 2009 15:48:09 +0000

Setting up a portfolio on FT.com (see previous article) allows you to plot your portfolio performance, and compare it to a number of market index benchmarks. Here's the performance of a portfolio of 6 UK stocks compared to the FTSE 100:

However, the only way I've found to do this seems unnecessarily convoluted. The FT portfolio service allows you to enter stock and cash transactions, but I can find no way to fund a portfolio with cash, and then have subsequent share purchases reduce the cash total. Instead, when entering a share purchase, I have to enter a corresponding cash debit.

Am I being a dolt? Or could this be made more user-friendly?

GBP Means Pounds, GBX Means Pence

nospam@example.com (Jackson) — Tue, 17 Feb 2009 21:32:29 +0000

FAQ: are share prices in pence or pounds?

Stock prices on the London Stock Exchange are quoted in pence sterling, often referred to as GBX, occasionally referred to as GBp. Brokers usually report fees in pounds (GBP), so it's worth paying attention to the denomination. When entering transactions into an online portfolio most sites expect GBX for the share price of the transaction, and GBP for the fees and stamp duty (Google Finance is an exception, expecting GBX for both).

Recap:

1 GBP = £1 = 100 GBX = 100 GBp
1 GBX = 1 GBp = 0.01 GBP = £0.01

Portfolio Tracking on the London Stock Exchange Website

nospam@example.com (Jackson) — Sun, 23 Nov 2008 20:35:03 +0000

Today I noticed that the London Stock Exchange (LSE) website allows you to enter and track stock portfolios. Their site was slower than molasses in January when I was using it, but I persevered thinking that, for stocks traded on the LSE, the LSE might be able to provide a better online service than most.

Despite the fact that the LSE recently updated their portfolio services, I was to be pretty sorely disappointed. Here's a list of 5 things I think LSE need to do before anybody with an ounce of sense will use their free portfolio service:

Continue reading "Portfolio Tracking on the London Stock Exchange Website"

FT.com Portfolio Services

nospam@example.com (Jackson) — Sat, 20 Sep 2008 15:55:37 +0100

Setting up a portfolio to monitor on FT.com this weekend was rather interesting. They're trying to create a more user-friendly and feature-complete online portfolio monitoring system than any other site I've encountered. To try it out for yourself, go to FT.com and look under Services -> Portfolio.

One of the first things you'll notice is FT.com offers a comprehensive list of items to include in a portfolio: equities, exchange traded funds, managed funds, indices (for monitoring), cash and custom entries. It caters for both long and short positions, and even allows symbols to be entered under a "watch" status, not including these in portfolio valuations. Entering ticker symbols is made easier by a drop down of instruments that match whatever you type, including little flags to specify the exchange on which the instruments are traded. Another nice touch is that the required currency denomination is displayed where you enter the price: e.g. GBX for LSE-traded stocks. This common courtesy escapes the likes of Yahoo Finance, who appear uncertain of the difference between GBP and GBX in any case.

What really makes FT.com stand out from the crowd is their attempt to automatically handle dividends and to chart portfolio performance.
Continue reading "FT.com Portfolio Services"