Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Retrieving Prices

See Also:  Retrieving Prices Video Tutorial

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 price retrieve 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.  You can also use command line arguments to perform unattended price updates.

The following quote servers are supported by the current version of Fund Manager:

Server Instructions FM Version
Association of Mutual Funds in India Details All
Boerse Berlin - Bonds Details All
Boerse Stuttgart Details All
Canada Stockwatch Details All
Canada Stockwatch (3M Historical) Details All
CNN Money Details All
Coin Market Cap Details All
Cyprus Stock Exchange Details All
Financial Times - Funds (1M Historical) Details All
Finra - Bonds Details All
FondsCheck Details All
FondsCheck (Historical) Details All
Fund Library (Canadian Mutuals) Details All
Morningstar - Funds Details All
Morningstar - Stocks Details All
Morningstar Asia - Funds Details All
Morningstar AU - Funds Details All
Morningstar BE - Funds Details All
Morningstar CA Details All
Morningstar DE - Funds Details All
Morningstar ES - Funds Details All
Morningstar FR - Funds Details All
Morningstar IT - Funds Details All
Morningstar NL - Funds Details All
Morningstar SE - Funds Details All
Morningstar TH - Funds Details All
Morningstar UK - Unit Trusts Details All
Morningstar ZA - Funds Details All
NZX - Bonds Details All
Quandl Details All
Quandl (Historical) Details All
Reuters Details All
Sharenet Details All
Swiss Quote Details All
Thailand Stock Exchange Details All
Thrift Savings Plan Details All
US Treasury Details All
Wall Street Journal Details All
Wall Street Journal (Historical) Details All
Wall Street Journal (Real-Time) Details Professional/Advisor
Yahoo Details All
Yahoo - Argentina Details All
Yahoo - Australia & New Zealand Details All
Yahoo - Brazil Details All
Yahoo - France Details All
Yahoo - Germany Details All
Yahoo - India Details All
Yahoo - Italy Details All
Yahoo - Mexico Details All
Yahoo - Singapore Details All
Yahoo - Spain Details All
Yahoo - Spanish Details All
Yahoo - UK & Ireland Details All
Yahoo (Adjusted Historical) Details All
Yahoo (Alternate) Details All
Yahoo (Historical) Details All
Yahoo (Options) Details All
Yahoo (Real-Time) Details Professional/Advisor
Stock Dividends and Splits Details Professional/Advisor
<local file> Details All

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.

Server specific information, as well as a revision history of Quote Modules 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.  Enter the "Scheme code" (usually a 6 digit number) for the symbol in your Fund Manager investment.

Boerse Berlin - Bonds:

This server provides closing prices for a wide variety of international bonds.  Prices are updated for the last trade date specified by the server.  Enter the ISIN of your bonds as the symbol in Fund Manager to retrieve them from this server.  Visit Boerse Berlin with your web browser to see if they offer the bond quotes you need and verify the ISIN.

Boerse Stuttgart:

This server provides historical pricing information for approximately the last 1 month.  Many international stock and bond quotes are available.  Visit Boerse Stuttgart to look up required symbol to use in Fund Manager.  From the quote page, click on "Times & Sales".  The symbol to use is everything after "/en/" in the URL.  For example, the Deutsche Bank URL is: https://www.boerse-stuttgart.de/en/Deutsche-Bank-stock-DE0005140008-Times-und-Sales-196, so the symbol to record in Fund Manager would be: Deutsche-Bank-stock-DE0005140008-Times-und-Sales-196.  In the event the symbol is longer than the allowed 49 characters, you can replace "-Times-und-Sales-" with an asterisk (*).  In this example, the symbol would be recorded as: Deutsche-Bank-stock-DE0005140008*196.

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.

Coin Market Cap

This server provides closing prices for cryptocurrencies.  To use this server, record the desired cryptocurrency's "id" value as the symbol in Fund Manager.  For example, the id value for Bitcoin is "bitcoin".  Use the "id" value, and not the reported "symbol".  For a list of the available quotes and to look up the id values go here.

CNN Money

This server provides current prices for stocks, funds, and indices from around the world.  Prices and volume are updated for the date specified by the server.  Open, High, and Low are not available with this server.  Visit CNN Money to look up symbols used by this server.  This server is very fast, updating 25 quotes per request.  This is the default server, unless specified otherwise under Options / Internet Settings...

Cyprus Stock Exchange:

This server updates close, high, low, open, and volume for the default date.  Quotes from the "Regulated Market" are available from this server.

Financial Times - Funds (1M Historical):

This server provides daily historical pricing for a wide variety of funds for the last 1 month.  For a list of the available quotes and to look up the ticker symbols go here.  This server only retrieves quotes from the "Funds" section of this server.

Finra - Bonds:

This server updates corporate bond pricing for the default date.  Visit the Finra - Bonds website to look up the "ticker" value for your bond.  This "ticker" value is shown in the URL of the page displaying your bond.  This "ticker" is different than the symbol and CUSIP.  Record the bond's "ticker" as the symbol property of your Fund Manager bond investment in order to retrieve from this server.  For tips on bond prices, please see the bond pricing FAQ.

FondsCheck and FondsCheck (Historical):

These servers provide both current and historical quotes for a wide variety of stocks, bonds, funds, exchange rates, indices, options, and ETFs.  To use this server, visit www.fondscheck.de to find the value of "secu" for the item you wish to retrieve and record this as your symbol in Fund Manager.  The "secu" value is shown in the URL of the page displaying historical prices for the item in question.  To get to the historical prices page, click on "Kurse" at the bottom of the item's page, and then "Hist. Kurse".

For example the fund "BGF World Mining Fund A2 EUR" with an ISIN of LU0172157280 has a "secu" of 197748.  You would record 197748 as your symbol in Fund Manager.

Fund Manager also supports the case where an item uses "list" instead of "secu", which is the case for some indices.  In this case record the symbol with "list=" at the beginning.  For example, consider DAX (ISIN: DE0008469008).  This historical price page shows "list=dax" in the URL, so you would record the symbol in Fund Manager as list=dax.

Advanced: It is usually not necessary, but you can specify the exchange of your item by appending ";<#>" to the end of your Fund Manager symbol, where <#> is the exchange number.  You can find this number by looking at the source of their historical prices page and searching for "boerse_id".  For example the fund  "BGF World Mining Fund A2 EUR" with an ISIN of LU0172157280 and a "secu" of 197748 is from the "Fonds Frankfurt" exchange.  This exchange has a value of 85 as viewed in the page's source.  You could record your symbol as either 197748 or 197748;85.  It doesn't seem necessary to record the exchange as part of your symbol, but if you come across a case where there is a secu conflict you can make use of this advanced feature to specify the exchange.

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.

Morningstar - Funds:

This server (morningstar.com) provides daily closing prices for a wide variety of funds from around the world.  Data is updated for the date specified by the server.  If your requested symbol is not on a US exchange, include the exchange prefix and colon (e.g. XTSE:) prior to the symbol.

Morningstar - Stocks:

This server (morningstar.com) 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.  If your requested symbol is not on a US exchange, include the exchange prefix and colon (e.g. XTSE:) prior to the symbol.

Morningstar Asia - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar Asia website to look up the "PerformanceId" value used by Morningstar Asia for your fund, and enter this as the symbol in Fund Manager.  The "PerformanceId" is shown in the URL of the page displaying your fund.  For example, the fund with an ISIN of IDN000016706 has a "PerformanceId" value of 0P0000KSMF.  Enter 0P0000KSMF as the symbol in your Fund Manager investment.

Morningstar AU - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar AU website to look up the ID value used by Morningstar AU for your fund, and enter this as the symbol in Fund Manager.  The ID is shown in the last part of the URL (after the last "/") of the page displaying your fund.  For example, the fund with an APIR Code of LEF0149AU has an ID of 6860.  Enter 6860 as the symbol in your Fund Manager investment.

Morningstar BE - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar BE website to look up the "id" value used by Morningstar BE for your fund, and enter this as the symbol in Fund Manager.  The "id" is shown in the URL of the page displaying your fund.  For example, the fund with an ISIN of BE0949074265 has an "id" value of F00000GX2F.  The id value of F00000GX2F is what you would enter as the symbol in your Fund Manager investment.

Morningstar CA:

This server updates Canadian quotes for stocks and funds from Morningstar.ca for the date specified by the server.

Morningstar DE - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar DE website to look up the "id" value used by Morningstar DE for your fund, and enter this as the symbol in Fund Manager.  The "id" is shown in the URL of the page displaying your fund.  For example, the fund with an ISIN of GB0030938145 has an "id" value of F0GBR06IBG.  The id value of F0GBR06IBG is what you would enter as the symbol in your Fund Manager investment.

Morningstar ES - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar ES website to look up the "id" value used by Morningstar ES for your fund, and enter this as the symbol in Fund Manager.  The "id" is shown in the URL of the page displaying your fund.  For example, the fund with an ISIN of LU0995386439 has an "id" value of F00000T4PS.  The id value of F00000T4PS is what you would enter as the symbol in your Fund Manager investment.

Morningstar FR - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar FR website to look up the "id" value used by Morningstar FR for your fund, and enter this as the symbol in Fund Manager.  The "id" is shown in the URL of the page displaying your fund.  For example, the fund with an ISIN of LU0034463017 has an "id" value of F0GBR04P99.  The id value of F0GBR04P99 is what you would enter as the symbol in your Fund Manager investment.

Morningstar IT - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar IT website to look up the "id" value used by Morningstar IT for your fund, and enter this as the symbol in Fund Manager.  The "id" is shown in the URL of the page displaying your fund.  For example, the fund with an ISIN of LU0922333322 has an "id" value of F00000PWXI.  The id value of F00000PWXI is what you would enter as the symbol in your Fund Manager investment.

Morningstar NL - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar NL website to look up the "id" value used by Morningstar NL for your fund, and enter this as the symbol in Fund Manager.  The "id" is shown in the URL of the page displaying your fund.  For example, the fund with an ISIN of LU0849851638 has an "id" value of F00000Q212.  The id value of F00000Q212 is what you would enter as the symbol in your Fund Manager investment.

Morningstar SE - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar SE website to look up the "perfid" value used by Morningstar SE for your fund, and enter this as the symbol in Fund Manager.  The "perfid" is shown in the URL of the page displaying your fund.  For example, the fund with an ISIN of SE0000621393 has a "perfid" value of 0P00000FYO.  The perfid value of 0P00000FYO is what you would enter as the symbol in your Fund Manager investment.

Morningstar TH - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar TH website to look up the "id" value used by Morningstar TH for your fund, and enter this as the symbol in Fund Manager.  The "id" is shown in the URL of the page displaying your fund.  For example, the fund with an ISIN of TH1086010002 has an "id" value of F000000RR2.  The id value of F000000RR2 is what you would enter as the symbol in your Fund Manager investment.

Morningstar UK - Unit Trusts:

This server updates unit trust prices for the date specified by the server.  Visit the Morningstar UK website to look up the "id" value used by Morningstar UK for your unit trust, and enter this as the symbol in Fund Manager.  The "id" is shown in the URL of the page displaying your unit trust.  For example, the unit trust with an ISIN of GB00B3P1W132 has an "id" value of F00000LYYJ.  The id value of F00000LYYJ is what you would enter as the symbol in your Fund Manager investment.

Morningstar ZA - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar ZA website to look up the "id" value used by Morningstar ZA for your fund, and enter this as the symbol in Fund Manager.  The "id" is shown in the URL of the page displaying your fund.  For example, the fund with an ISIN of ZAE000019444 has an "id" value of F000002CO9.  The id value of F000002CO9 is what you would enter as the symbol in your Fund Manager investment.

NZX - Bonds:

This server provides current quotes for bonds on the NZX market.  Visit NZX to look up the "code" for your bonds and record this code as the symbol in Fund Manager to retrieve from this server.  Prices are updated for the default date.

Quandl and Quandl (Historical):

These servers provide both current and historical quotes for a wide variety of investments.  Before using a Quandl server you must sign up for a free account with Quandl and obtain a "Quandle API Key".  You can sign up here.  Once you have your Quandl API Key, enter this into Fund Manager under "Options / Internet Settings..." by selecting either Quandl server as a quote server and then pressing the "Quandle API Key..." button.  You do not need to leave Quandl set as a default quote server, but you must at least temporarily select Quandl in order to enter your Quandl API Key.  To use this server, enter the "Quandl Code" as the symbol in your Fund Manager investment.  You can browse the available quotes here.  For example "WIKI/INTC" is the Quandl Code and thus the symbol you would enter to retrieve the price for Intel.  This code is using their WIKI database, and you can choose from any of the databases you have access to.  Quandl offers a variety of free databases as well as premium databases you would need to subscribe in order to access.  This optional premium subscription is through Quandl and is not related to Beiley Software or your Fund Manager license.

Advanced: Quandl offers a variety of data, besides closing prices.  You can enter your symbol in the format <Quandl Code>:<CSV column> to import data from the specified column number of their CSV download format.  Column 0 is the date.  For example, the Quandl code LBMA/GOLD offers the price of an ounce of gold.  Downloading the CSV file shows the first field is the date, then the USD (am) price, followed by the USD (pm) price.  To download the USD (pm) price, record the symbol in Fund Manager as: LBMA/GOLD:2

You may need to record your symbol in this format if Fund Manager does not update the price with the desired data.  Fund Manager tries to be smart and figure out which column of data to use for the update, but not all data is returned the same from this server, so in the cases where the wrong data field is being used, record the column index as part of the symbol.

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.

Sharenet:

This server provides daily close, high, low, and volume for a wide variety of stocks and indices from JSE in South Africa.  The data is updated for the date specified by the server.  To use this server, record the "scode" value shown in the URL and on the quote page for a particular stock or index.  For example, the JSE All Share index uses the scode value of J203, which is what you would record for your investment in Fund Manager.  To get historical prices from this server you can subscribe to their service, download historical prices in CSV format, and import them with the generic price import command in Fund Manager.

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.

Thrift Savings Plan:

This server provides daily historical closing prices for the investment funds for approximately the last 25 trading days.  Record the investment symbols in Fund Manager as shown in the heading row of this table (for example: L 2050).

US Treasury:

This server updates closing prices for US Treasuries.  Visit the US Treasury website to look up the CUSIP, and record this as the symbol in your Fund Manager investment.  Prices are updated for the prior business day (most recent business day, prior to the current date).

Wall Street Journal (plain, Historical, and Real-Time):

These servers provide the most recent close, historical, and real-time quotes for a wide variety of stocks, funds, ETFs, exchange rates, bonds, and indices.

Visit the Wall Street Journal website to look up the symbols used by this server.  The symbol needs to also include the investment type as shown in the URL for the quote you're trying to retrieve.  Here are some examples:

Name: Apple (US stock)
URL: http://quotes.wsj.com/AAPL
Symbol: AAPL
   
Name: Janus Fund (US mutual fund)
URL: http://quotes.wsj.com/mutualfund/JANSX
Symbol: mutualfund/JANSX
   
Name: SPDR S&P 500 ETF Trust
URL: http://quotes.wsj.com/etf/SPY
Symbol: etf/SPY
   
Name: Australian Dollar to US Dollar
URL: http://quotes.wsj.com/fx/AUDUSD
Symbol: fx/AUDUSD
   
Name: U.S. 7 Year Treasury Note
URL: http://quotes.wsj.com/bond/BX/TMUBMUSD07Y
Symbol: bond/BX/TMUBMUSD07Y
   
Name: Dow Jones Industrial Average
URL: http://quotes.wsj.com/index/DJIA
Symbol: index/DJIA
   
Name: Adcorp Holdings Ltd (South African stock)
URL: http://quotes.wsj.com/ZA/XJSE/ADR
Symbol: ZA/XJSE/ADR

Advanced:  If you are using Fund Manager version 2016.14.10 or later you can omit the investment type from the symbol if you have the investment type property set correctly for your investment, and the symbol doesn't need anything besides the investment type added to the symbol.  For example, if you have an investment set to investment type "No Load Mutual Fund" you can record the symbol just as JANSX instead of mutualfund/JANSX.

 

Yahoo:

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 specified by the server.  By default, if your symbol uses the .L suffix, Fund Manager will divide the price by 100 to convert from pence to pounds.  If you do not want this behavior, you can use the Yahoo quote server instead.  You can also override this behavior by adding a registry value at:  HKEY_CURRENT_USER\Software\Beiley Software\Fund Manager\CurrentVersion\Internet Retr where you add a string value named yahoo_uk and set it to a value of 1.

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.   This server requires that cookies are enabled.

Yahoo (Alternate):

This is an alternative to the default "Yahoo" server that is capable of retrieving quotes sometimes not available on the normal "Yahoo" server.  This server updates prices for the default date.  This server will update close, high, low, open, and volume.

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.  This server requires that cookies are enabled.

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.

Prices retrieved from this server are not adjusted for distributions (but are adjusted for splits).  This means that prices are updated with the actual split-adjusted closing price on that date.  If using the Pro/Adv version and retrieving splits, this will be handled automatically.  If you're using the Personal version, record any split transactions before retrieving historical prices prior to that split.

Yahoo (Options):

This server updates stock option prices for the default date.  Any space characters in your Fund Manager investment's symbols are automatically removed when requesting quotes from this server.

Yahoo (Real-Time):

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

<local file>:

This is a special "server" that reads prices from a local file you specify, instead of a regular quote server on the internet.  To specify the location of this file, press the "Local File..." button from within Fund Manager under "Options / Internet Settings...".  The file should contain pricing data in either of these formats:

SYMB,MM/DD/YY,NAV
SYMB,MM/DD/YY,NAV,OO,HH,LL,VV

See the Generic Price Import Dialog for the meaning of these keys.

 

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.

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy