Google Finance gain value incorrect because of currency fluctuation
You can easily build a Google Sheet spreadsheet to track what you want as Sheet has a 'googlefinance()' function to look-up the same prices and data you can enter and track in a Google Finance portfolio, except you can use it in ways you want. For example, you can track your purchase price at a fixed exchange rate, track the current market value as the product of the stock's price times the floating exchange rate, and then record your realized profit and loss using another fixed exchange rate.  You don't have to record the rates either, as googlefinance() func is able to lookup prices as of a particular date. You can access Google Sheet through a web browser or Android app.
"I use Google Finance too. The only thing I have problem with is dividend info which it wouldn't automatically add to my portfolio. At the same time, I think that's a lot to ask for a free web site tool. So when dividend comes, I manually ""deposit"" the dividend payment by updating the cash amount. If the dividend comes in share form, I do a BUY at price 0 for that particular stock. If you only have 5 stocks, this additional effort is not bad at all. I also use the Hong Kong version of it so perhaps there maybe an implementation difference across country versions. Hope this helps. CF" Your assumption that funds sold in GBP trade in GBP is incorrect. In general funds purchase their constituent stocks in the fund currency which may be different to the subscription currency. Where the subscription currency is different from the fund currency subscriptions are converted into the fund currency before the extra money is used to increase holdings. An ETF, on the other hand, does not take subscriptions directly but by creation (and redemption) of shares. The principle is the same however; monies received from creation of ETF shares are converted into the fund currency and then used to buy stock. This ensures that only one currency transaction is done. In your specific example the fund currency will be USD so your purchase of the shares (assuming there are no sellers and creation occurs) will be converted from GBP to USD and held in that currency in the fund. The fund then trades entirely in USD to avoid currency risk. When you want to sell your exposure (supposing redemption occurs) enough holdings required to redeem your money are sold to get cash in USD and then converted to GBP before paying you. This means that trading activity where there is no need to convert to GBP (or any other currency) does not incur currency conversion costs. In practice funds will always have some cash (or cash equivalents) on hand to pay out redemptions and will have an idea of the number and size of redemptions each calendar period so will use futures and swaps to mitigate FX risk. Where the same firm has two funds traded in different currencies with the same objectives it is likely that one is a wrapper for the other such that one simply converts the currency and buys the other currency denominated ETF. As these are exchange traded funds with a price in GBP the amount you pay for the ETF or gain on selling it is the price given and you will not have to consider currency exchange as that should be done internally as explained above. However, there can be a (temporary) arbitrage opportunity if the price in GBP does not reflect the price in USD and the exchange rate put together. It looks like GOOG did not have a pre-market trade until 7:14 am ET, so Google Finance was still reporting the last trade it had, which was in the after-hours session yesterday. FB, on the other hand, was trading like crazy after-hours yesterday and pre-market today as it had an earnings report yesterday. The math is wrong. $16m grows to $72b over 44 years at 21% return (exact return is (72000/16)^(1/44) - 1 = 0.21067). At one percentage point lower return, i.e. 20%, $16m grows to $50b (16m x 1.21^44 = 49.985b). In that case you would have paid about 30 percent of your gain in fees. Still a lot,  but not severe.  Even the calculation of percent fees is wrong in the article! This is from Google Finance right now. The value of the asset doesn't change just because of the exchange rate change. If a thing (valued in USD) costs USD $1 and USD $1 = CAN $1 (so the thing is also valued CAN $1) today and tomorrow CAN $1 worth USD $0.5 - the thing will continue being worth USD $1. If the thing is valued in CAN $, after the exchange rate change, the thing will be worth USD $2, but will still be valued CAN $1. What you're talking about is price quotes, not value. Price quotes will very quickly reach the value, since any deviation will be used by the traders to make profits on arbitrage. And algo-traders will make it happen much quicker than you can even notice the arbitrage existence. The cause of incomplete/inaccurate financial data's appearing on free sites is that it is both complicated and expensive to obtain and parse these data. Even within a single country, different pieces of financial data are handled by different authorities.  In the US, for example, there is one generally recognized authority for stock prices and volumes (CQS), but a completely different authority for corporate earnings data (SEC).  For futures and options data the only authority is each individual exchange.  Each of these sources might have a vastly different interface to their data; some may have websites, others may have FTPs, others may have TCP datastreams to which you must subscribe, etc. Now throw in the rest of the world and all their exchanges and regulatory agencies, and you can see how it's a difficult job to gather all this information, parse it on a daily (or more frequent) basis, and check it all for errors. There are some companies (e.g. Bloomberg) whose entire business model is to do the above.  They spend tens of millions of dollars per year to support the infrastructure and manpower required to keep such a complex system working, and they charge their consumers a pretty penny in return. Do Google/Yahoo pay for Bloomberg data access just to display information that we then consume for free?  Maybe.  Maybe they pay for some less expensive reduced data set.  Or a data set that is less rigorously checked for errors. Even if they pay for the best data available, there's no guarantee that a company's last earnings report didn't have a glitch in it, or that Bloomberg's latest download from the Canadian Agency for Corporate Dividends and Moose Census-Taking didn't get cut off in the middle, or that the folks at Yahoo built a robust system that can handle a particular file's not arriving on time.  Bloomberg has dozens or even hundreds of employees focused on just this one task; Yahoo probably has 5. Moral: If you really need the best available data you must go to the source(s), or you must pay a provider to whom you can then complain when something is wrong.  With free data you get what you pay for. You bought 1 share of Google at $67.05 while it has a current trading price of $1204.11. Now, if you bought a widget for under $70 and it currently sells for over $1200 that is quite the increase, no? Be careful of what prices you enter into a portfolio tool as some people may be able to use options to have a strike price different than the current trading price by a sizable difference. Take the gain of $1122.06 on an initial cost of $82.05 for seeing where the 1367% is coming. User error on the portfolio will lead to misleading statistics I think as you meant to put in something else, right? "BestInvest is a UK site looking at that URL, base on the ""co.uk"" ending. Yahoo! Finance that you use is a US-based site unless you add something else to the URL. UK & Ireland Yahoo! Finance is different from where you were as there is something to be said for where are you looking. If I was looking for a quarter dollar there are Canadian and American coins that meet this so there is something to be said for a higher level of categorization being done. ""EUN.L"" would likely denote the ""London"" exchange as tickers are exchange-specific you do realize, right?" There's a concept called interest rate parity, which sort of says that you cannot profit on the difference in interest rates. This difference accounts for the predicted movement in exchange rates as well, along with the stability of the currencies. Returns reported by mutual funds to shareholders, google, etc. are computed after all the funds' costs, including Therefore the returns you see on google finance are the returns you would actually have gotten. "The solution I've come up with is to keep income in CAD, and Accounts Receivable in USD.  Every time I post an invoice it prompts for the exchange rate. I don't know if this is ""correct"" but it seems to be preserving all of the information about the transactions and it makes sense to me.  I'm a programmer, not an accountant though so I'd still appreciate an answer from someone more familiar with this topic." On closer look, it appears that Google Finance relies on the last released 10-k statement (filing date 10/30/2013), but outstanding shares as of last 10-Q statement. Using these forms, you get ($37,037M / 5.989B ) = $6.18 EPS. I think this is good to note, as you can manually calculate a more up to date EPS value than what the majority of investors out there are relying on. Now, is there any clever way to combine FOREX transactions so that you receive the US interest on $100K instead of the $2K you deposited as margin?  Yes, absolutely. But think about it -- why would the interest rates be different? Imagine you're making two loans, one for 10,000 USD and one for 10,000 CHF, and you're going to charge a different interest rate on the two loans. Why would you do that? There is really only one reason -- you would charge more interest for the currency that you think is less likely to hold its value such that the expected value of the money you are repaid is the same. In other words, currencies pay a higher interest when their value is expected to go down and currencies pay a lower interest when their value is expected to go up. So yes, you could do this. But the profits you make in interest would have to equal the expected loss you would take in the devaluation of the currency. People will only offer you these interest rates if they think the loss will exceed the profit. Unless you know better than them, you will take a loss. "What most of these answers here seem to be missing is that a stock ""price"" is not exactly what we typically expect a price to be--for example, when we go in to the supermarket and see that the price of a gallon of milk is $2.00, we know that when we go to the cash register that is exactly how much we will pay.  This is not, however, the case for stocks. For stocks, when most people talk about the price or quote, they are really referring to the last price at which that stock traded--which unlike for a gallon of milk at the supermarket, is no guarantee of what the next stock price will be.  Relatively speaking, most stocks are extremely liquid, so they will react to any information which the ""market"" believes has a bearing on the value of their underlying asset almost (if not) immediately.  As an extreme example, if allegations of accounting fraud for a particular company whose stock is trading at $40 come out mid-session, there will not be a gradual decline in the price ($40 -> $39.99 -> $39.97, etc.)-- instead, the price will jump from $40 to say, $20.  In the time between the the $40 trade and the $20 trade, even though we may say the price of the stock was $40, that quote was actually a terrible estimate of the stock's current (post-fraud announcement) price. Considering that the ""price"" of a stock typically does not remain constant even in the span of a few seconds to a few minutes, it should not be hard to believe that this price will not remain constant over the 17.5 hour period from the previous day's close to the current day's open.  Don't forget that as Americans go to bed, the Asian markets are just opening, and by the time US markets have opened, it is already past 2PM in London.  In addition to the information (and therefore new knowledge) gained from these foreign markets' movements, macro factors can also play an important part in a security's price-- perhaps the ECB makes a morning statement that is interpreted as negative news for the markets or a foreign government before the US markets open.  Stock prices on the NYSE, NASDAQ, etc. won't be able to react until 9:30, but the $40 price of the last trade of a broad market ETF at 4PM yesterday probably isn't looking so hot at 6:30 this morning... don't forget either that most individual stocks are correlated with the movement of the broader market, so even news that is not specific to a given security will in all likelihood still have an impact on that security's price. The above are only a few of many examples of things that can impact a stock's valuation between close and open: all sorts of geopolitical events, announcements from large, multi-national companies, macroeconomic stats such as unemployment rates, etc. announced in foreign countries can all play a role in affecting a security's price overnight. As an aside, one of the answers mentioned after hours trading as a reason--in actuality this typically has very little (if any) impact on the next day's prices and is often referred to as ""amateur hour"", due to the fact that trading during this time typically consists of small-time investors.  Prices in AH are very poor predictors of a stock's price at open."