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 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:

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

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 updates the most recent pricing information for the date specified by the server.  Many international stock and bond quotes are available.  Visit Boerse Stuttgart to look up required symbol to use in Fund Manager.  The symbol to use is everything after "/en/products/" in the URL.  For example, the Deutsche Bank URL is: https://www.boerse-stuttgart.de/en/products/equities/stuttgart/514000-dt-bank, so the symbol to record in Fund Manager would be: equities/stuttgart/514000-dt-bank.  In the event the symbol is longer than the allowed 49 characters, you can replace "equities/stuttgart/" with "e*" or replace "bonds/stuttgart/" with "b*".  In this example, the symbol would be recorded as: e*514000-dt-bank.

When the symbol is longer than 49 characters you can also split it up between the "Symbol" and "Description" investment properties when using Fund Manager 2020 or later.  To do this, enter a "+" at the beginning of the Description and everything after that will be added to the Symbol when requesting a quote. 

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.

CoinGecko

This server provides current prices for cryptocurrencies.  Prices are updated as of the default date.  Visit CoinGecko to look up symbols used by this server.  The symbol can be found either in the URL or by looking at the "id" value in the complete list of available coins.  Use the "id" value as your symbol in Fund Manager (not the "symbol" value).  For example, the quote for Bitcoin is at the URL: https://www.coingecko.com/en/coins/bitcoin so the symbol to use in Fund Manager is "bitcoin".  By default, prices are updated in USD, however you can change this to update in other currencies.  To change the quote to be referenced to a different currency add a registry value at:  "HKEY_CURRENT_USER\Software\Beiley Software\Fund Manager\CurrentVersion\Internet Retr" where you add a string value named "coingecko_currency" (without the quotes) and set it to the desired reference currency.  See the full list of available reference currencies here.

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.

FastTrack, FastTrack (Adjusted Historical), and FastTrack (Historical):

FastTrack servers offer a wide variety of mutual funds, ETFs, indexes, and stocks.  Pricing includes close, open, high, low, and volume.  The regular "FastTrack" server updates pricing for the 7 most recent days.  The "FastTrack (Historical)" server updates with actual closing prices, where the "FastTrack (Adjusted Historical)" server updates with distribution adjusted closing prices.  To use any of the FastTrack quote servers you must first sign up for a free (or paid) FT Cloud account.  You will receive a Data Export Token when you sign up.  Visit their website to sign up.  Once you have your token, enter this into Fund Manager under "Options / Internet Settings..." by selecting any FastTrack server as a quote server and then pressing the "FastTrack Token..." button.  You do not need to leave FastTrack set as a default quote server, but you must at least temporarily select FastTrack in order to enter your token.  A big benefit of this server is the speed, as up to 50 symbols can be retrieved at once, so this server is very fast.  Another benefit is the extensive adjusted historical pricing available.  FastTrack offers both free and paid plans.  The optional paid subscription is through FastTrack and is not related to Beiley Software or your Fund Manager license.

Financial Times - Equities:

This server provides the current pricing for a wide variety of equities from around the world.  For a list of the available quotes and to look up the ticker symbols go here.  This server only retrieves quotes from the "Equities" section of this server, and the price is updated for the date specified by the 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 bond pricing for the last trade date specified by the server.  Visit the Finra - Bonds website to look up the "CUSIP" value for your bond.  Record the bond's CUSIP 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, 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, stocks, and ETFs.  Visit Fund Library to look up the investment you wish to retrieve.  Record everything after "Detail/" in the URL as your symbol in Fund Manager.  When the symbol is longer than 49 characters you can split it up between the "Symbol" and "Description" investment properties.  To do this, enter a "+" at the beginning of the Description and everything after that will be added to the Symbol when requesting a quote.  The "investment type" must also be assigned properly for your investments. Here are some examples:

marketstack and marketstack (Historical):

These servers provide both the most recent end of day and historical quotes for a wide variety of stocks.  These servers update close, open, high, low, and volume for a wide variety of stocks (no mutual funds though).  Before using a marketstack server you must sign up for a free (or paid) account with marketstack and obtain a "marketstack API Key".  You can sign up here.  Once you have your marketstack API Key, enter this into Fund Manager under "Options / Internet Settings..." by selecting either marketstack server as a quote server and then pressing the "marketstack API Key..." button.  You do not need to leave marketstack set as a default quote server, but you must at least temporarily select marketstack in order to enter your marketstack API Key.  A big benefit of this server is the speed, as up to 100 symbols can be retrieved at once, so this server is very fast.  You can search for the available stock symbols here.  marketstack offers both free and paid plans if you need more quota.  The optional paid subscription is through marketstack and is not related to Beiley Software or your Fund Manager license.

Morningstar - Funds:

This server (morningstar.com) provides daily closing prices for mutual funds.  Data is updated for the default date.

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 "Katana Australian Equity Fund" with a security ID of "KKTA0002AU" has an ID of 41070.  Enter 41070 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 CH - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar CH website to look up the "id" value used by Morningstar CH 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 "Acatis Aktien Global Fonds D" has an "id" value of F00000LP8J.  The id value of F00000LP8J is what you would enter as the symbol in your Fund Manager investment.

Morningstar CL - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar CL website to look up the "id" value used by Morningstar CL 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 "Fondo Mutuo BCI Competitivo AP" has an "id" value of F000013FG9.  The id value of F000013FG9 is what you would enter as the symbol in your Fund Manager investment.

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 FI - Funds:

This server updates fund prices for the date specified by the server.  Visit the Morningstar FI website to look up the "id" value used by Morningstar FI 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..

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 "ACATIS Datini Valueflex Fund A" with an ISIN of DE000A0RKXJ4 has an "id" value of F000002FR8.  The id value of F000002FR8 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 "id" value used by Morningstar SE 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 SE0000621393 has a "id" value of F0GBR04FXO.  The id value of F0GBR04FXO 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 fund 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 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 LU0297941469 has an "id" value of F000000F1L.  The id value of F000000F1L 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.

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.

Stooq:

Stooq (Historical):

These servers are very fast and provide daily close, open, high, low, and volume for a wide variety of stocks, indices, currencies, cryptocurrencies, and economic indicators.  The data is updated for the date specified by the server.  To use this server, record the symbol in Fund Manager as displayed on the Stooq website.

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.

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 header row of the table here.  For example: L Income, L 2025, L 2030, L 2035, L 2040, L 2045, L 2050, L 2055, L 2060, L 2065, G Fund, F Fund, C Fund, S Fund, I Fund.

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).

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.

Advanced:  By default these servers requests 10 symbols at a time for faster performance.  This 10 symbol request requires the initial overhead of obtaining a cookie/crumb.  In some cases you may find it faster to skip this cookie/crumb overhead and only request 1 symbol at a time, which doesn't require the cookie/crumb process.  Cookies/crumbs can also be problematic in some countries (Europe).  If the 10 symbol request fails, Fund Manager reverts to the 1 symbol method.  If you are located somewhere that prevents the cookie/crumb process or you have a smaller number of investments, you may prefer to just start with the 1 symbol request for faster retrievals.  You can do this 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_use_v11 and set it to a value of 1.

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.  This conversion will also apply to any symbols with the .L suffix when using any of the Yahoo (Historical), (Adjusted Historical), (Alternate), (Options), or (Real-Time) servers.  The registry option yahoo_use_v11 described above also applies to this 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.   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.

If the local file contains historical data, set the state of "View / Split Adjusted" to match how the data is recorded in the importing file.  If the importing historical data is reported in split adjusted terms, leave on this option.  Otherwise, leave it off when importing.

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.