New Version Available (Download) Last Update: 06-Sep-2014
Recent feedback has indicated that Yahoo Finance isn't providing updated quotes for many non-US funds. I've also been noticing that Yahoo sometimes "times out" when requesting quotes from their csv interface. I'm not sure what's happening with either, but I decided to look into adding support for an additional quote source, as a backup.
My first stop was Google Finance, and I was very happy with what I found. Without digging in too much, I'll just say that Google embeds quote parameters into their html web interface in such a way that's easy to grab. More specifically, Google provides "meta data" packets, allowing for (reasonably) reliable parsing, regardless of screen formatting for browser users.
A new version is now available for download, and has support for both Yahoo and Google finance sites. Yahoo takes precedence, and is always checked first, unless it has been disabled. If a quote isn't found on Yahoo, then a lookup is performed on Google. You can enable (disable) either quote source in sites.dat.
The settings related to Quotes have been updated in sites.template, and are summarized below:
|EnableYahooFinance||Yes||Enable quote lookup on Yahoo Finance|
|YahooURL||http://finance.yahoo.com||Alternate site for quotes|
|QuoteCurrency||USD||Currency for quotes|
|EnableYahooScrape||Yes||Try a screen scrape if the primary Yahoo interface fails|
|EnableGoogleFinance||Yes||Enable quote lookup on Google Finance|
|YahooTimeZone||-5:EST||Timezone rule for the Yahoo quote server|
|ShowQuoteHTM||No||Always show quotes.htm from Getdata|
|AskQuoteHTM||Yes||Ask to show quotes.htm from Getdata (overrides ShowQuoteHTM)|
|ForceQuotes||No||Force Money to record a transaction when importing quotes*|
|QuoteAccount||0123456789USD||Custom account number for Quotes|
These settings should work for most users. If you are trying to grab quotes for non-US funds, and Yahoo isn't providing accurate data, then head over to Google Finance and see if you can find a match on their site. I'm going to bet that you can, and that their data is up to date.
An example that I've tested is F0CAN05LUD.TO on Yahoo Finance. The Google Finance symbol for this fund is MUTF_CA:RBF460. Of the two, only Google Finance is currently providing an updated, correct quote result. To use the Google version, the user would put the MUTF_CA:RBF460 symbol in the quotes section of their sites.dat file, but *not* the Yahoo symbol. The Google symbol will not be found on Yahoo, so a check will automatically be performed on Google, and should return the correct value set. If you need to match an existing stock/fund symbol in Money (rather than the one provided by Google), use the s: option for the quote.
Many ticker symbols are unique to Yahoo and Google, and the two don't use the same symbols for indexes or foreign stocks/funds. For example, the symbol for the DOW is INDEXDJX:.DJI on Google, but is ^DJI on Yahoo. Long time users of the scripts know that Yahoo's quote service is unreliable for the DOW symbol, so if you're interested in that one, I'd suggest using the Google symbol instead.