Retrieving Prices

The Price Internet Retrieve feature in Fund Manager is one of the most popular and time-saving features.  This feature allows you to quickly and easily update the prices for all your investments. This feature is available as the menu command Edit / Internet Retrieve / Prices..., or from the toolbar with the button.

In addition to retrieving prices, Fund Manager can retrieve transactions directly from your broker or mutual fund company.  For more on this, see Retrieving Transactions.

Fund Manager can retrieve prices from a wide variety of quote servers.  Select the default server with Edit / Internet Retrieve / Settings....  If you track investments from multiple exchanges, you can assign unique quote servers to different investments under Investment Properties... / Internet Retrieve.  Portfolios memorize your global quote server preference.  Also, you can use the /I and /Q command line arguments to perform unattended price updates.  See the "User Interface / Commands / Command Line Arguments" topic in the documentation.

The following quote servers are supported:

Fund Manager uses the recorded ticker symbol to request price quotes from each of these servers.  If you are uncertain of the ticker symbol for a particular investment you can go to each of these sites (by clicking on the links above) and do a ticker lookup.  For some of the unique investments, such as indexes, each server may utilize its own symbol, so you may need to look up the symbol for the particular server you choose to use for retrieving prices.

The list of supported servers can change over time.  Fund Manager has the ability to automatically update the list of supported servers and the retrieve functionality.  By choosing Edit / Internet Retrieve / Check for Updates... from the menu within Fund Manager the latest server status can be obtained.  This will also cause Fund Manager to check for any updates to the internet retrieve functionality.  If an update is available you will be given the opportunity to automatically download the update.  The current Quote Module version number in use is available under Help / About... from within Fund Manager.

In addition to 'retrieving' prices, you can also import prices.  This may be necessary when the quotes you're looking for are not available on any of our supported quote servers listed above.  Importing is a two step process where you first obtain the pricing data in some file, and then import from this file using one of the "File / Import / Prices" menu commands.  Some specific tips relating to importing prices can be found on our Helpful Tips page.

Some helpful, server specific information, as well as a revision history of Quote Modules is available.  Also, a list of possible error codes is available.

Server Specific Information

Specific instructions and details for using each of the following servers are provided.

Association of Mutual Funds in India:

This site updates the closing price using the quote date specified by the server.

Australian Stock Exchange:

This site updates the close, high, low, open, and volume during market hours.  After hours, only the closing price is updated.  The data is updated using the default date.  (This server does not provide volume/high/low/open once the market is closed.  You may prefer to use the Yahoo - Australia & New Zealand quote server instead.)

Bloomberg:

This server provides daily close, high, low, open, and volume for a wide variety of stocks, funds, and indices from all over the world for the date specified by the server.

This server specifies the quote time/date for the US ET time zone.  If you are in a significantly different time zone you may want the quote updated for an offset time/date in some cases.  For example, if you are in Australia, and are 15 hours ahead of US ET retrieving AU quotes in the morning of day X, the prices may be quoted for day X-1 in US ET.  To have these AU quotes updated correctly for day X you can either have Fund Manager use the default date, or specify an hour offset to apply from the specified US ET time/date.  Either of these options can be accomplished by setting a registry value.

See the instructions for forcing Fund Manager to use the default date (set force_def_date to 1).

Alternatively, to specify an hour offset, create a string value named bloomberg_hour_offset under the existing Internet Retr key and set this value to the number of hours you wish to offset the quote time/date.  The offset can be either positive or negative.  For example, if you want the quotes updated for a time/date that is 15 hours ahead of the specified US ET time/date, set this registry value to 15.  See the default date instructions for how to find this key and create registry values.

If you force Fund Manager to use the default date, the hour offset setting is ignored.

Bloomberg (Historical):

This server provides historical close, high, low, open, and volume for a wide variety of stocks.

Canada Stockwatch:

This server provides daily close, high, low, open, and volume for Canadian stock and mutual funds.  The quotes are updated in Fund Manager for the date specified by this server.  This server also offers prices from US exchanges.  For a list of the available quotes and to look up the ticker symbols go here.

Canada Stockwatch (3M Historical):

This server provides daily historical close, high, low, open, and volume for Canadian stock and mutual funds for the last 3 months.  For a list of the available quotes and to look up the ticker symbols go here.

Cyprus Stock Exchange:

This server updates close, high, low, open, and volume for the date specified by the server.

Finra - Bonds:

This server updates bond pricing for the default date.  Record the bond's CUSIP in the symbol property in order to retrieve from this server.  For tips on bond prices, please see the bond pricing FAQ.

Fund Library (Canadian Mutuals):

This server provides daily closing prices on Canadian Mutual funds.  Visit Fund Library to look up the "Fund Codes" for the mutual funds you wish to retrieve.  Record the Fund Code as your symbol in Fund Manager to retrieve from this server.

Google (Historical Mutuals):

This server provides historical pricing for a wide variety of mutual funds.  A maximum of 200 prices is available per requested date range.  To get prices for a longer period of time, perform multiple retrieves with different ending dates.  The 200 prices are from the ending requested date range backwards 200 days.

Google (Historical):

This server provides historical close, high, low, open, and volume for a wide variety of stocks.  Unlike the Google (Historical Mutuals) server, there is no 200 quote limit for this server.  This server does not support mutual funds.  Instead, use Google (Historical Mutuals) for mutual fund quotes.

Prices retrieved from this server are adjusted for splits, but not distributions.  This means that retrieved prices prior to a split are adjusted down by the ratio of the split.  When using this server for historical prices you should not also record split transactions in Fund Manager, so you do not double count the splits.

Google (Real-Time):

This server provides real-time quotes from a variety of exchanges.  Data from other exchanges is also available, but not in real-time.  For details, see Google's help center.  This server is only available in the Professional and Advisor versions.

MSN:

This server provides daily closing price (no high, low, open, or volume) for a wide variety of stocks, funds, and indices from around the world.  Data is updated for the date specified by the server.

MSN (Historical):

This server provides daily historical quotes on stocks, mutual funds, and indices.  When using this server selection you will be asked for the date range to update prices.  Mutual funds will have their closing prices updated for the specified date range.  Stocks will have the volume, high, low, open, and close updated.

Reuters:

This server provides daily close, high, low, open, and volume for a wide variety of stocks from all over the world for the date specified by the server.

Swiss Quote:

This server provides daily close, high, low, open, and volume from the Zurich stock exchange.  It also provides daily close for mutual funds.  The quotes are updated in Fund Manager for the date specified by this server.

Thailand Stock Exchange:

This server provides daily close, high, low, open, and volume data for approximately the last 25 trading days.  Open, high, and low are only available for some quotes.

Yahoo:

This is the default server, unless specified otherwise under Options / Internet Settings....  This server updates close, high, low, open, and volume for the date specified by the server.

Yahoo - Argentina:

Yahoo - Australia & New Zealand:
Yahoo - Brazil:
Yahoo - France:
Yahoo - Germany:
Yahoo - India:
Yahoo - Italy:
Yahoo - Mexico:
Yahoo - Singapore:
Yahoo - Spain:
Yahoo - Spanish:
Yahoo - Taiwan:

These servers all update the close, high, low, open, and volume for the date specified by the server.  Note, your symbols must be recorded with the appropriate suffix.  For example, Australian symbols end with .AX (example: BHP.AX).  Visit the appropriate server using your browser to determine the required symbols.

Yahoo - UK & Ireland:

This server offers quotes from the London, Paris, Frankfurt, Madrid, Milan, Oslo, and Stockholm exchanges.  To request a quote from a particular exchange, add the appropriate exchange specific suffix to the Fund Manager investment symbols.  The available suffixes for each exchange are .L, .P, .F, .MAD, .M, .O, and .S, respectively.  Fund Manager retrieves close, volume, high, low, and open data from this source, and updates the investments for the date as specified by the server.

Yahoo (Adjusted Historical):

This server provides daily historical quotes on stocks, mutual funds, and indices.  When using this server selection you will be asked for the date range to update prices.  Only closing prices are updated when using this server (no open, high, low, or volume).

Prices retrieved from this server are adjusted for distributions and splits.  This means that prices prior to a distribution are lower than the actual closing price on that day by the amount of the distribution.  Prices prior to a split are adjusted down by the ratio of the split.  This makes the prices useful for comparison purposes (especially when you do not have the distribution or split history available), but not for updating investments with recorded splits and/or distributions in the updated time period.  When updating investments with recorded distributions use the Yahoo (Historical) server instead, so as to not double count for the distributions.

Yahoo (Historical):

This server provides daily historical quotes on stocks, mutual funds, and indices.  When using this server selection you will be asked for the date range to update prices.  Mutual funds will have their closing prices updated for the specified date range.  Stocks will have the volume, high, low, open, and close updated.

Prices retrieved from this server are not adjusted for distributions or splits.  This means that prices are updated with the actual closing price on that date.  To update investments that have, or will have, recorded splits and/or distributions in the specified time frame use this server rather than the Yahoo (Adjusted Historical) server.

When using the Professional or Advisor version of Fund Manager, options to retrieve stock dividends and splits will be available with this server.  If enabled, any available dividend and split information will automatically be retrieved with the prices.  Fund Manager will only add a dividend or split transaction for a particular date if one isn't already recorded.  This prevents duplicate transactions from getting recorded.

Yahoo (Options):

This server updates stock option prices for the default date.

Yahoo (Real-Time):

Real-Time ECN stock quotes from Yahoo.  This server is available in the Professional and Advisor versions.

Default Date

Depending upon the server you're using to update prices the date of the price quotes may or may not be specified by the server.  See the server specific information to learn which and when each server will provide date information.  When the date information is not provided, a default date will be used to update prices.  By default this date is the last weekday on or before your computer's system date.  If you desire a different date, you can adjust this by adding a value to the following registry key:

HKEY_CURRENT_USER\Software\Beiley Software\Fund Manager\CurrentVersion\Internet Retr

Set a value for adjust_date in this registry key to the string of "X"

The Internet Retr key will probably already exist, so you can just add the adjust_date value to this existing key.  Registry values can be added with the "regedit" application.  The X in the above description should be replaced with an integer number.  It can be either a positive or negative value.  The X represents the number of days relative to your computer's system date in which the prices should be updated when the default date is used.  For example, if you wish for your prices to be updated using yesterday's date, set X to -1.  The default date is always set to a weekday, so if you using the default date on a Monday with X set to -1 the prices will be updated for last Friday.

Under normal conditions Fund Manager will update prices for the date specified by the server.  If the server does not specify a date with the prices Fund Manager will update using the default date.  If you prefer to change this behavior and always update prices using your default date you can set the force_def_date value to a string value of 1.  This value also goes under the Internet Retr key.  This will affect all non-historical quote servers.