Fundwatch Help Contents Press F1 to get context-sensitive help for any active control on any screen. Overview Quick Start Changes in this Release Use of Technical Analysis File Options Owner's Name Password Protect Edit Securities/Prices Update Data Intra-Day Data Find/Screen New Securities Import List of Symbols Import Security Export Security Portfolio Distributions Streamer Links Menu Analysis Report Settings Configure Analysis and Alerts Configure Data File Signals Analysis Rate of Return Analysis Performance Analysis Yearly Analysis Trend Analysis Volatility Analysis Momentum Analysis Summary Analysis Graphic Analysis
Backtesting (and Building Trading Systems)
Fundwatch is a tool for evaluating and comparing the performance of common market-based securities and helping to determine good times to buy or sell. Fundwatch uses price and volume data with incorporated dividends and distributions to compare performance and analyze market movements with technical analysis and backtesting. Fundwatch can analyze a variety of securities, including mutual funds, stocks, ETFs, options, and market indexes. Data is downloaded from a public source but is saved in data files for fast access, requiring updates only on demand or at periodic intervals. Data Files Whether downloaded, imported or entered, all data is stored in data files. You can create as many data files as you want. Each data file stores a price-volume history for a set of securities for which you have entered symbols or names. Fundwatch provides two options for the granularity of price-volume histories: daily or weekly. You can choose daily or weekly any time you download data and can change between the two at any time. Because the size of the data file is limited, choosing daily may provide a shorter history. You can configure the size of your data file to control the maximum number of securities or timespan it can store. You build each data file by entering symbols or names of securities and downloading security price information (or manually entering or importing it if it is not publicly available). Securities can be added or deleted at any time, and price histories can be updated at any time for any or all securities. Once a data file has been started, securities analysis can be performed at any time. Each data file will store data according to regularly-spaced price dates. In a weekly data file each price date will represent one week (assumed to be Friday's closing price). Fundwatch expects prices to be present for each regular interval (day or week), but if prices are missing on some price dates, the prices for skipped dates are simply assumed to be the same as their previous entries. Building Your Data File (See also Quick Start) The first step in building a data file is selecting its initial daily or weekly designation. You will then add the names and symbols of securities you wish to track, and then add price data, either by downloading it from the internet, importing it from a file, or entering it manually. You can update prices at your discretion, and new securities can be added at any time. A security's price is the closing price (or Net Asset Value for mutual funds) on the price date for which it is being entered. Available high, low, open, and volume data is also collected on each price date if you download from the internet. Distributions (and dividends) are typically included in downloaded historical data for most securities so you will rarely need to enter these manually, but they may be entered manually for any date falling within the time span of the data file (does not have to be on a price date). Entering dividends and distributions allows securities of various types to be accurately compared on the basis of their total return. Fundwatch also stores the number of shares you own of each security in the data file, and allows you to enter "cash equivalent" accounts for securities without tracked price histories, so you can monitor your entire portfolio's current value and asset allocation. Backups Each time you save a data file, Fundwatch makes a backup of the previous version using file extension .bak.dtb. You should perform external backups of your data files since they will contain a lot of custom information that cannot be recovered from the internet. Fundwatch data files are identified by the extension .dtb. Trading Systems (for backtesting) are kept in FWSystems.dat. Data File Limitations Fundwatch's data file is limited but can be configured to accommodate more securities or longer price histories (the default configuration stores 50 years worth of weekly prices or 10 years worth of daily prices for up to 100 securities). New price dates can be added beyond its limit (a price date added beyond the time limit causes the earliest price date to be lost, having the effect of scrolling the data file forward). An unlimited number of distributions may be entered for any security, however only the 1200 most recently entered are able to be listed or edited. Those entered prior to the last 1200 are still included in all calculations. Other Limitations Fundwatch does not make predictions or investment recommendations; it merely performs calculations on historical data to help you make assessments of what has happened historically and make better informed decisions. You should understand that past performance of market investments does not guarantee similar performance in the future. Also, be advised that computer-aided analysis is potentially susceptible to both program and user error, and that you use and rely upon the results of Fundwatch at your own risk. See License Terms and Limited Warranty for further information. Technical Support
You can email questions to fwsupport@hamiltonsoftware.com.
It is strongly advised
that you read the Overview section before you proceed because it explains the
structure, limitations, and proper usage of the program.
A sample data file is provided to help you learn the program's operation. Simply click the
File
menu, then under File, click Open Data File. Open the file by double clicking on "Sample"
in the file list.
While using Fundwatch, you will be collecting price-volume data for one or more
stocks, mutual funds, etc. at daily or weekly intervals. You may create and maintain as many data
files as you want; each may contain as much as 50 years of weekly data or 10 years of daily
data for up to 100 securities (these numbers can be configured).
To start a new data file:
1. Click the File menu. Under File, click New Data File. You will first be asked if you have
historical data which must be entered manually. Unless you plan to enter historical data for a
special investment that is not listed publicly, answer "No". The new file will be shown as
"untitled"; you will be prompted to name the file later when you save it. You will be asked to designate the
pricing interval for securities in the file as weekly or daily (it can be
changed later). If you have data which must be
entered manually, you will need to specify the beginning date (this is the date of the oldest
prices you plan to enter manually).
You can also drag and drop a symbol file
onto the main display to create a new data file.
2. A spreadsheet will then appear which allows entry of security symbols, names and prices.
Here is where you add securities you want to track. You can either add
securities by (1) entering this information in the fields above the spreadsheet, pressing Tab for each data item and
Enter for each new security (steps 3 thru 6 explain this in more detail). Or (2)
you can drag and drop a symbol file onto this grid. Leave prices blank if
you intend to download them. Fundwatch asks if you want to download security
data as you add securities, but you can wait and download all
securities at once by
clicking
Download History after you've
entered all symbols and names. Once data has been entered, it will appear in the
spreadsheet. Data in the spreadsheet can be edited by clicking cells in the
spreadsheet and editing the data in fields above the spreadsheet.
3. To add a security, enter the symbol (e.g. FPURX) in the Symbol field
(if the security has a symbol).
If the security does not have a symbol, leave this field blank.
4. Press the Tab key to move the cursor to the Name field. Fundwatch
will attempt to automatically provide the name and style from the symbol but if
it cannot, you must enter the security's name (e.g. Fidelity Puritan). The name is
limited to 20 characters. Select a Style from the dropdown menu (if it
hasn't been correctly set). You can then enter the security's
Price for
the displayed Price Date, but if you plan to download the data from the
internet, leave the price blank.
5. Either press the Enter key or click the OK button to add the new security to your file.
Fundwatch will then ask you if you want to download the security data. Downloading takes
very little time, but you can wait until you've added all your securities and then download them
all at once if you prefer. If you have more securities to add, repeat steps 3, 4 and 5. Securities
can be added by clicking on an empty grid row or by clicking the Add New
Security button, and prices can be added or edited for existing securities
by clicking on a cell under the corresponding price date.
6. If you didn't enter or download prices for the securities you entered above,
you can download them now. Click the Download
icon button in the upper left, select a single security (or select "All"), and click
Download.
7. When you have no more data to enter, close the display to return you to the
main display.
Here, you can enter the name of the owner of the
portfolio. You can also open the Portfolio display to
edit your holdings in each of the securities you own.
8. To save your new data, click the File menu and
Save Data File As selection. In the File Name box, enter a filename for your data file and click
Save.
9. Once you have price data in your file for more than one date, you can click on the analysis
functions in the Analysis menu. Refer to Contents for instructions on the use of the Analysis
functions and the Analysis Report Settings.
Press F1 to get context-sensitive help for
any active control on any screen.
Changes in this Release
Major changes added in Version 18:
Major changes added in Versions 15 thru 17:
Major changes added in Versions 12 to 14:
Major changes added since 2000:
Technical analysis is the process of analyzing a security's historical prices in an effort to predict
probable future price movement.
To be a profitable trader, your goal should be to improve your odds of making profitable trades.
Even if you do nothing more than determine the long- or short-term trends of a security, proper
use of technical analysis will gain you an edge you would not otherwise have. You'll never
know for sure that a security's price is going to rise, but if you buy a security when it is in a
rising trend after a minor selloff, you will have improved your odds of making a profit, and over
time, the practice of improving your odds will show up in your returns.
The price at which an investor is willing to buy or sell depends mostly on price expectations. If
the investor expects the security's price to rise, he will buy it; if he expects the price to fall, he
will sell it. If prices are based on investor expectations, then knowing what a security is worth
(fundamental analysis) becomes less important than knowing how investors expect its price to
move. That's not to say that knowing what a security is worth isn't important, but there is
usually a fairly strong consensus of a stock's future value that fundamental analysis cannot
predict. This principle of analyzing investor expectations by examining price or price/volume
patterns by themselves provides the basis for technical analysis.
The roots of modern-day technical analysis stem from the Dow Theory, developed
around 1900 by Charles Dow. Its principles include the trending nature of prices,
confirmation and divergence, volume accompanying price changes, and support/resistance.
Today, technical analysis is accepted as a viable analytical approach by most universities and
brokerage firms. Rarely are large investments made without reviewing the technical climate.
While there are probably hundreds of technical analysis methods in use, and new ones
continuously being invented, a few have gained widespread credibility and refinement, and are
relied upon on a daily basis across world markets. Fundwatch employs a number of these
most popular methods, both as charting tools, and to provide
alerts of common buy/sell signals.
A key principle in the interpretation of technical analysis is the phenomenon known as
confluence, or confirmation of indicators. Simply put, confluence is a simultaneous prediction
of price direction from multiple technical indicators. If one technical indication increases your
odds of predicting price movement, multiple indications occurring together theoretically
strengthen those odds. Many analysts will ignore a technical indication altogether unless it is
confirmed by another. You can configure Fundwatch's technical analysis methods to alert you
using parameters you specify.
Before setting these configurations, you may want to do some research to suit your investment
approach and get the most harmonious confluence from alerts. Fundwatch provides a
backtesting platform that allows you to combine indicators and experiment with varying
parameters. You can also use these tailored indicator combinations (called Trading Systems)
to provide buy/sell alerts.
New Data File initializes the program for creation of a new Fundwatch data
file.
You'll be asked if you
have historical data which must be entered manually. Answer "No" unless you plan to
manually enter historical data for a special investment that cannot be downloaded from the
internet. You will then be asked to designate the pricing interval for all securities in the file as
weekly or daily. Choose a frequency that best fits the type of investments you are tracking and
the granularity of analysis you need (for instance, you might create a weekly data file for mutual
funds and a daily file for frequently traded stocks). Note that a weekly data file
that can store up to 50 years of data can store only 10 years of daily data. You can
easily change the designation at any time in the future, switching from daily to
weekly, or weekly to daily. All securities maintained within the same data file will use
the interval designated for that file.
See Quick
Start or Edit Securities/Prices for instructions on creating a new data file.
If you have data which must be entered manually, you will need to specify the beginning date
(this is the date of the oldest prices you plan to enter manually). All price data you manually
enter will be subsequent to the starting date; you will not be able to manually enter price data
occurring before this date.
Open Data File asks you for a Fundwatch data file filename, and then loads the file from disk.
There is a sample data file, "Sample.dtb", in the Fundwatch program directory which you can
open and experiment with.
Save Data File saves the data file currently in memory to the currently opened data file. It also
saves the previous version of your data file with the file extension .bak.dtb.
Save Data File As allows you to save the data file currently loaded to a new filename or
location. The filename extension .dtb (automatically appended) is used for identifying Fundwatch data
files.
Import List of Symbols allows you to add multiple securities to your data
file using a text file containing a list of symbols (see Import List of Symbols).
Import Security allows you to import a security's price-volume data from a text file. You are
presented a popup which allows you to specify the data to import (see Import Security).
Password Protect allows you to specify a password for the currently
loaded file which will be required to open the file in the future.
This window allows you to add or delete securities, and edit any of the existing
security data.
The grid shows what the data file contains, with each row representing a single
security and its price history, and each column a single price date and the
security prices on that date. Clicking on a cell in the grid selects a security,
a price date, and the security's price on that date for editing in the text
boxes above the grid.
You can also edit the security's name, symbol or investment style.
New security names can be added to the data file by clicking the Add New Security
button (or by clicking an empty row on the grid). For step-by-step instructions for
adding security data, see Quick Start. You can
also add new securities via the Securities Finder/Screener
Tool, which is accessed by clicking Find Securities, or you can enter
a search term in the Search for Symbol field and select a security from
the results that appear in the adjacent dropdown.*
Once there is price data in the data file, Fundwatch will create future entries
at either weekly or daily intervals depending on the file's current tracking
interval. A new price date is therefore predetermined when you open the price
entry display, however if the file is weekly, you can adjust it to any day
within the week. Fundwatch will normally prompt you to update price data
automatically when you open the data file, so you would only need to update
prices on this display if you are maintaining securities that cannot be
downloaded.
Three buttons in the upper left-hand corner allow you to delete the selected security
from the data file, view detailed information on the selected security from
Yahoo!®, or download historical price-volume data from Yahoo!®. You can
change the daily/weekly tracking interval for the file any time you download data
for the entire file.
Downloading Price-Volume Data
*Please note that the Find Securities and Search for Symbol features make use of
third-party websites that could be impeded by your browser or system security,
or may change or reduce their functionality in ways beyond our control.
Owner's Name
This editable field on the main Fundwatch display allows you to designate a person as owner of the
portfolio holdings contained within the currently loaded data file.
For instance, you may have several files, each representing the investments of different people.
Full Update
A price-volume history going back as far as what will
fit in your data file (depending on available data) can be downloaded for a selected
security by clicking the Download icon button on the Edit Securities/Prices display or by choosing
Update Data from the main menu. Fundwatch will normally prompt you
automatically for updates as it determines they're needed.
If you're editing a specific security in the Edit Securities/Prices display, there must be a symbol entered for the security. The
downloaded data is obtained from Yahoo!®. If Yahoo!® is unavailable or you cannot connect
to Yahoo!®, you will not be able to use this feature. Be advised that Yahoo!® may not adjust
this data for dividends, stock splits, distributions, etc, and that it could be inaccurate for other
reasons. The start date of the data will be limited to either the capacity of Fundwatch's data file
or to what Yahoo!® provides.
Changing the Tracking Interval
Whenever you download data for all securities, you can designate the tracking interval as either
daily or weekly. Choose a frequency that best fits the type of investments you
are tracking and the granularity of analysis you need (for instance, you might
create a weekly data file for mutual funds and a daily file for frequently
traded stocks). Note that a weekly data file can store up to 50 years of data,
whereas a daily file can only store up to 10 years. Daily data takes
longer to download.
Changing the tracking interval from weekly to daily shortens the time span of
the data, causing earlier data to be lost. Changing from daily to weekly will
preserve only one day per week (the final values) causing the other days of the
week to be lost. If the data cannot be re-downloaded (i.e. you've entered it
yourself), it is not recoverable once you save your file.
Update Latest Only
The "Update Latest Only" option downloads only the most current (real-time)
price-volume data for the current day (this will not be the day's closing prices unless the market
has closed). This is normally the default option for daily data since full
updates take much longer for daily data. Note this method will not capture distribution data. Distribution data (if available) can only be
downloaded with the full history, so Fundwatch will periodically suggest a full history
download of daily data. The default for weekly data is always a
full update.
Earnings and Morningstar Ratings
Morningstar® updates its ratings approximately once a month, so Fundwatch
automatically selects the Morningstar checkbox once a month. Corporate earnings
are reported at periodic intervals (usually quarterly), so this is also a good
frequency for updating earnings as well.
High, Low, Open, and Volume data can only be entered into Fundwatch by download
or import, and only if it is available for the security (e.g., not all such data is available
for mutual funds). High, Low, Open, and Volume data is only displayed on the Graph and
cannot be edited.
Intra-day Data (prices collected during the trading session) can also be
downloaded throughout the day if you set Fundwatch to
collect it.
You can collect and view price data for the current trading session in real time
(collected at intervals as short as one minute). Intra-day data
cannot be obtained from the past... it must be collected in real time.
For this reason, you must set up the data collection in advance of the trading
session by opening the Intra-Day Data Collection dialog under the Options menu.
Set your local times for when the market opens and closes, set the desired
collection interval, and then click Start Collecting. This can be set up well in
advance of the trading session (or at any time during the trading session), and
can be set to run continuously as a background process over indefinite future sessions. If you set it
to run in the background, you can close the file or the program and it will continue to
collect intra-day data each day for that file indefinitely until you
reopen the file, reopen the dialog and click Stop.
The program will save up to 5 days of intra-day data, so you can continue to
view it until it is more than 5 trading days (one week) old or until you have
downloaded fresh high-low-open-close-volume data that overlaps it. Intra-day data can only be viewed on the Graph, where
Technical Analysis can also be applied (not all technical indicators will work
for intra-day data, as some are not applicable or require additional data like
volume).
Note that if you
want to collect intra-day data for more than one file, you must open each file
individually and start (or stop) the collection process for each one. Be
aware that if you reboot your computer, the background process(es) will be killed,
so you will need to reopen each file to
restart background data collection... it will not be restarted automatically
(this is also true whenever you perform a Fundwatch version update).
The Securities Finding and Screening Tool (accessible from the
Edit Securities/Prices Display) allows you
to search the web for securities meeting your selection criteria and then add
them to your data file. The tool simply provides access to securities screening
features available on third-party websites and allows you to easily add your selected
mutual funds, stocks, or ETFs to your Fundwatch data file.
Use the tool as a web browser, navigating the third-party screening features
to set your search criteria. You may have to scroll the
page and click an action button to get results.
When results appear on the
webpage, a list opens on the right side of the display allowing you to select
one or more of the result securities for addition to your data file. Select the
securities you want to include in your data file in this list and click Add selected
securities to data file. You can
also view charts and other data via links on the third-party's pages, but you must return
to the results page to add securities to your file.
Be aware that third-party web pages may display ads or
error messages during navigation. Generally, these can be ignored or dismissed.
Also be aware that third-party websites are beyond our control and may change functionalities or become inoperable
in the future. Additionally, their functionality may be blocked or limited
by your browser or system security settings.
Import List of Symbols from a Text File
You can add multiple securities to your data file in one easy step simply by importing a text file containing a comma-delimited
list of symbols (e.g. "AAPL, TIP, S, FPURX"). Symbols in the list must be separated by commas or line feeds. This type of text
file is also known as a CSV (comma separated variable) file, which can often be exported by other programs. You can also
easily create such a file yourself using a simple text editor like Notepad.
You can import the file using the File->Import List of Symbols menu selection, or you can
simply drag and drop the file
directly onto Fundwatch's main display (if a data file is active) or onto the
Edit Securities/Prices display. Fundwatch
will ask and then download the price histories for the added securities.
Fundwatch attempts to automatically supply names and styles for the
added symbols, but you should check these for correctness. Also, Fundwatch will
not add symbols which are already in the data file.
Import Security from a Text File
You can import a security along with its price-volume history from a text file by selecting
Import
Security from the File menu. The Import Security popup allows you to enter the name,
symbol, and type of the security (securities must be imported one at a time), and specify a text
file containing its historical data. The file must be a CSV (comma separated value) ASCII text
file.
The text file must be formatted as rows for each price date, containing comma-separated
values for each row, and must include on each row at least a date and price. The rows can
optionally contain high, low, open and volume data, and can include an adjusted price in
addition to the listed close price (an adjusted price is the listed price adjusted for dividends,
splits, and distributions).
You tell Fundwatch what data is included in your file by checking the appropriate checkboxes.
The required format is displayed in the Format field below. All specified data items in the
Format field must be included on each row and must be in the order shown. If your data file is
not formatted the way Fundwatch requires, you can edit your text file using Excel or a similar
spreadsheet program and rearrange the columns of data so they are in the required order.
Make sure you resave the file as a CSV file. Once you have properly formatted your file
according to the displayed format, you can then import it by clicking the Import button.
Also note the importance of properly indicating whether the dates are in
ascending or descending order.
This example shows five rows of data, including date, open, high, low, close,
volume, and adjusted price (in that order). The dates are in descending order:
9/19/2008, 4880, 5351.2, 4857.1, 5311.3, 2147442800, 5311.3
Once imported, this data will provide a price-volume history of five days for a new security,
which will be given the name entered on the popup. Once you've imported a security, it will be
viewable just as though you had downloaded or entered it manually, but you must
save your
data file to permanently add it to your file.
Export Security to a Text File
You can export a security's price-volume history to a text file by selecting
Export
Security from the File menu. The Export Security popup allows you to select the security (securities must be
exported one at a time), and specify the name of a text
file. The file produced will be a CSV (comma separated value) text
file.
Each row of the file will contain a price date followed by open, high, low,
close and volume data, and an adjusted close (adjusted for dividends,
splits, and distributions). Dates are in descending order. Example
output:
9/19/2008, 4880, 5351.2, 4857.1, 5311.3, 2147442800, 5311.3
The Portfolio window allows you to maintain a record of your current holdings
and view their current value and allocation. You can maintain the shares you
own of any of the securities in your data file, and you can add the values of
other accounts you have so that the portfolio accurately represents
the value of all your holdings.
A list of all the securities in the data file is displayed along with the number of shares you own
of each security (initially zero), the most recently recorded price per share, the total value
based on that price, the ratio of each dollar amount with respect to the total, and the date on
which you last changed the number of shares.
To enter or change the number of shares for a specific security, select the security from the list
and
edit the Shares text box. At this point, you can also select a Tax
Type designation for the holding. Adding a tax type will allow you to view
your asset allocation not only by investment style (e.g. stocks, bonds, etc.),
but also by tax treatment (tax-deferred, tax-free, or unsheltered). Press Enter
or click on OK to save your changes.
Whenever you change the number of shares held for a security, the Last Change date is
updated with the current date.
Cash Equivalent Accounts
Click the Add Cash Equivalent Account button (plus icon) to add a holding that
is not a security in the data file (because it is not a publicly traded security
or does not have a fluctuating price history). Examples could be savings accounts, bonds,
CDs, real estate, personal property, or even debts such as a mortgage. Adding
these accounts (and periodically updating their values) will allow you to get a
frequently updated view of your net worth, along with extensive breakdowns of
your asset allocation. This information can also be imported by other HSI
programs (Easy ROR Pro and EarlyRetire Pro). These accounts will only be
viewable and editable in the Portfolio; they will not appear in any analysis
reports (other than asset allocation). You can delete a cash equivalent
account by setting its value to zero.
The portfolio can be updated automatically when you enter a distribution, as described in
Distributions. When this occurs, the Last Change date will also be automatically updated with
the date that you entered the distribution.
Securities in which you specify a holding in the Portfolio will appear bold faced and
highlighted in all analysis reports. Checking the My Portfolio box restricts the displayed list to only those securities in which you own shares.
Asset Allocation Pie Chart
The Asset Allocation button (pie chart icon) displays a pie graph of your portfolio's
percentage breakdown, which you can control to show by security, by style, by
tax type, or
by security within a category.
Many investments, including most stocks, bonds and mutual funds, periodically pay interest,
dividends, and/or capital gain distributions to their shareholders. Regardless
of whether such
distributions are paid out as cash or reinvested in the security, they represent a part of the
security's total return not reflected in the security's price change. It is
therefore necessary to track such distributions in the data history in order to accurately represent the security's performance.
Note that stock splits are also effectively distributions, and can be treated the same way (e.g. a
two-for-one split is equivalent to a distribution of the full share price; or a three-for-two split is
equivalent to a distribution of half the share price, etc).
When you download the complete
history of a security, Fundwatch automatically
extracts distributions from the downloaded data (for most securities), so
you don't have to manually enter them. Distributions must be manually
entered for securities whose prices you are manually entering.
To enter or change a distribution, select the appropriate security from the pull-down list to get a listing of the
1200 last entered
distributions. The listing will show the date of each distribution and the percent distributed.
The price of the security on the distribution date and the dollar amount of the distribution will be
displayed only if there is a price in the data file on the distribution date. Click the Add
icon to
add a new distribution, or click a distribution in the list to edit or remove it.
When the Add (or Change) Distribution window appears, enter the date on which the
distribution actually occurred, usually called the Trade Date on accounting statements (if you
are editing a distribution, the date cannot be changed; the only way to change the date of an
existing distribution is to remove the entire distribution and re-enter it). If there is a price in the
data file for this date, Fundwatch will display it, otherwise you must enter it from your statement.
Check to make sure the price displayed is correct... Fundwatch will display the
most recently recorded price, which may not always be accurate.
You must then enter the dollar amount of the
distribution either as dollars paid per share or as total dollars paid to you (if you owned shares at the
time). One or both of these figures is typically reported on your statement (dollars per share is
the figure you will be quoted by institutions which handle the security). If you are unable to
obtain the information in one of these forms, you may have to calculate it from
provided
information.
Checking the Update Portfolio Shares box tells Fundwatch to automatically update the number
of shares in your portfolio based on the number of shares you owned when the distribution was
paid. You must therefore enter the number of shares of the selected security you owned just
before the distribution occurred. This number is also important if you enter the distribution as
total dollars paid (even if you don't update the portfolio) because it will be used to calculate
dollars paid per share.
When you click the OK button, the data file will be adjusted to include the distribution as part of
the security's return, and the distribution can be viewed on the Graph or in the Rate of
Return report.
Removing Distributions
You can remove a distribution by
selecting it from the list and clicking the Delete button. It may ask you for the number of
shares you owned before you received the distribution because it cannot always calculate this
value from the information it has saved. Simply enter the number of shares you owned prior to
receiving the distribution you are removing.
Regenerate Distributions
You can regenerate distributions from a security's price history by clicking the
Regenerate icon. This isn't normally necessary.
The Streamer updates stock, index, and ETF quotes collected from the internet at
approximately 1-second intervals. The interval may vary according to the speed
of your internet access and servers, and the quotes themselves may be delayed.
You can sort information on the Streamer by clicking on the column you want to
sort. You can also filter the displayed securities by category, and you
can display market index charts by clicking the Chart toggle at top.
Since mutual funds do not update during the trading session, they are excluded from the
display; only stocks, ETFs and indexes are displayed. Quotes are obtained from Yahoo!®
and/or CNN.
Any symbol which is invalid, misspelled, contains a bad character, or for any other reason is
not listed on Yahoo!® or CNN, will not be updated and may cause quote data for subsequent symbols to be corrupted. The
Streamer attempts to exclude such symbols automatically, but if you see bad quote information
on the Streamer starting on a particular row, check all your symbols
for correctness.
The Links menu provides you quick access to external websites such as brokerages or news sources
(similar to Favorites or Bookmarks).
It automatically contains links to the login pages of several major brokerages, and allows you to
add and edit your own links. Use Add/Change/Delete to add a new link or edit an
existing one. All links you create are saved between sessions and can be edited or
deleted by clicking the Add/Change/Delete menu and selecting the desired link in
the User Links dropdown list.
This is the section of controls on the main Fundwatch display.
All of the Analysis Reports require you to specify a time period, the significance of which is
explained in each of the Analysis sections. For instance Rate of Return Analysis
and Summary Analysis each require a specified start and end date, while
Trend Analysis requires a specified number of price intervals (days or weeks). Only securities
with prices spanning the specified time period will be processed in the selected Analysis
function.
Start/End Date: When a Fundwatch data file is loaded, a list is
displayed on the main screen showing the securities contained in the data file,
their start dates and number of price intervals. Pull-down lists in the Analysis
Report Settings area provide access to every price date in the data file to use
as the start and end dates for Analysis reports. If you type in a start or end
date which is not a price date in the data file, Fundwatch will use the closest
price date to the date you entered. You can also quickly set the start
date to that of a desired security by clicking on the security in the list, or
you can set it by clicking any of the standard time period buttons (YTD, 1 yr, 5
yr, etc.).
The Trend Period defaults to 9 months (it is configurable in the
Configuration dialog), but can
be set anywhere between 2 and the maximum number of price intervals currently in the data
file.
The Filter allows you to create Analysis reports which include only the securities meeting the
filter criteria. For instance, if you only want to compare rate of return for Small-cap Growth
securities, you can set the filter to Small Growth before selecting the Rate of Return Analysis.
The filter also limits what is displayed on the Streamer.
Many of the technical analysis methods Fundwatch uses allow you to vary the parameters used
in the analysis. These parameters are usually the specification of a period (number of days or
weeks depending on the data file type) to use as a trend period (except for "Risk-Free Rate of
Return" which is specified as a percent). You may want to use different trend periods
depending on the analysis method, the type of investments you're tracking, the type of trading
you're doing, or to follow a specific approach. Risk-free Rate of Return is simply the rate of
return you would expect from a riskless investment (e.g. money market fund) and is used to
calculate Sharpe Ratio and interest on
cash-equivalent accounts.
Fundwatch allows you to set these parameters so they will be remembered between sessions
and automatically applied to calculations on the reports and associated alerts (see descriptions
of the various alerts in Signals Analysis, Trend Analysis,
Momentum Analysis, and
Summary Analysis). They
also appear as modifiable defaults in the Graphics functions.
The Configuration Settings are accessible under the Options menu. Settings
for Daily files and Weekly files are saved separately so you can use different
parameters for different trading approaches. Fundwatch provides defaults for these values that are the most recommended and widely used
by technical analysis experts.
Each data file has limited space, which can be allocated to either longer
price-volume histories or more securities. Each file can be configured
differently. You can reconfigure any existing file (your currently loaded file), or you can
set a default configuration for all future files you create.
Access the File Configuration display under the Options menu.
When you increase the number of securities a file can hold, the maximum time
span of the price-volume history will be limited, and conversely, when you
increase the time span of price-volume history, the number of securities the
file can hold will be limited. You may want to reduce the time span of
price-volume histories simply to reduce the time it takes your file to download
if you don't need long histories.
The Signals report shows a list of technical buy/sell indications for each
security. Buy/sell indications (also called signals or alerts) occur when price or
price-volume movements cross thresholds calculated for technical analysis
functions according to settings in your Configuration. Some technical analysis
functions are often evaluated in conjunction with others (to implement
strategies of confluence),
and in general, signals are considered more meaningful when they are
corroborated by others simultaneously. This is especially true if you have
configured your alert settings in a coordinated way.
The report lists each security for which an alert (buy/sell signal) has occurred
on the specified date, and for each listed security, lists all alerts occurring on that
date. Each alert is represented by a three-character abbreviation for the
technical indicator and its calculated value. It will be color-coded green if it
is a buy and red if it is a sell. In the right-hand column, a "score" is
produced by adding the number of buys and subtracting the number of sells, thus
showing the net buy or sell strength of the combined signals. Scores are highlighted in
green or red when the net buy or sell total is 3 or more.
How signals are calculated:
MAV (moving average) and EMA (exponential moving average) produce
a buy signal when the price crosses up through the average and a sell signal
when the price crosses down through the average. The value shown is the
price-to-moving
average margin ((current price - average) / average).
RSI (relative strength index) produces a buy signal when the index
crosses upward through the 30% level, and a sell signal when it crosses downward
through the 70% level. The value shown is the RSI itself.
MFI (money flow index) produces a buy signal when the index crosses
upward through the 20% level, and a sell signal when it crosses downward through
the 80% level. The value shown is the MFI itself.
BOL (Bollinger bands) produce a buy signal when the price crosses up
through the lower band and a sell signal when the price crosses down through the
upper band. The value shown is the price-to-band margin ((current price - crossed band) /
band).
SAR (parabolic stop and reverse) produces a signal when its trend
direction reverses. The value shown is the price-to-SAR margin ((current price - sar) / sar).
MAC (MACD) produces a buy signal when the MACD crosses up through its
signal line, and a sell signal when it crosses down through the signal line. The
value shown is the MACD-to-signal margin ((MACD - signal) / signal).
RET (retracement) produces a buy signal when the price makes an upward
retracement (following a downward trend) through its Fibonacci 61.8% level, and
a sell signal on a downward retracement of an upward trend through the 61.8%
level. The value shown is the retracement.
MOM (momentum oscillator) produces a buy signal when it turns from
negative to positive and a sell signal when it turns from positive to negative.
The value of the momentum oscillator itself is shown.
STO (stochastic) produces a buy signal when the fast stochastic crosses
up through the slow stochastic and a sell when the fast crosses down through the
slow. The value shown is the difference between the fast and slow stochastic (fast stochastic - slow stochastic).
KVO (Klinger volume oscillator) produces a buy signal when the KVO rises
from below zero and crosses its signal line, and produces a sell signal when it
falls from above zero and crosses its signal line. The value shown is the KVO itself.
SQZ (TTM Squeeze) produces a buy signal when the TTM Squeeze fires with a positive RSI, and produces a sell signal when the TTM
Squeeze fires with a negative RSI. The value shown is the RSI.
P/E (Price/Earnings Ratio) produces a buy signal when the
P/E is below the minimum threshold in your Configuration, and a sell signal when
it is above the maximum threshold. The value shown is the P/E Ratio itself.
2TOP, 3TOP, H&S, 2BOT, 3BOT, IH&S (Chart
Pattern Recognition) produces a sell signal when key reversal patterns are
identified in the most recent period defined by the Pattern Recognition Window
in your Configuration. The type of pattern identified is abbreviated as
indicated in boldface (e.g. double top, triple bottom, inverse head & shoulders,
etc), and the value shown is the window in which the pattern was found.
Securities in this report can be ranked or sorted by column value by clicking on the desired
column. Bold faced, highlighted securities are those in which you currently hold an
investment (see Portfolio). Checking the My Portfolio box restricts the displayed list to only
those securities in which you own shares. You can double-click a security to
highlight it for easy identification while sorting.
The Rate of Return report shows (and ranks) security rate of return over a
specified period. Rate of Return Analysis computes the total rate of return for that period
(including distributions) of all the securities in the data file having prices spanning that period. It
then annualizes those percentages and separates the portions of the return due to price growth
and distributions paid. It also summarizes each of these figures for your portfolio by weighting
each return figure according to how much of the security you own.
Period Return is the actual computed percentage return (including
distributions) of the securities over the time period.
Annual Return is a conversion of the Period Return to an annualized
Rate of Return. Be aware that this figure is only a mathematical conversion for the period you
selected and may not accurately represent the actual annual return for any given year.
Annual Growth and Annual Distributions represent a
breakdown of the Annual Return into components of the total return due to price growth, and
distributions, respectively. This breakdown tells you a little more about the nature of each
security by revealing the relative roles of income and growth in its performance, and is often
useful for estimating the effect of income tax on the returns of different investments. Bear in
mind, however, that Fundwatch makes no distinction between distributions due to interest or
dividends, and capital gains distributions which may be taxed differently.
Least Squares ROR is the annualized rate of return obtained from a least
squares regression of the security prices between the beginning and ending dates. A least
squares regression finds a constant rate of return that best fits all the data points within the
span, not just the beginning and end. For more explanation of least squares regression, see
Plotting Least Squares Curve.
Portfolio Total figures expressed at the bottom represent the weighted combinations of
the security performance figures proportioned by the dollar amount currently owned of each
security in your portfolio (including cash-equivalent
accounts, which earn your
risk-free return). If, for example, you had your money split evenly between two
securities, your Portfolio Total return would be the average of the returns of these two
securities. Since you may have moved money in or out of your securities during the time
period of the analysis, these figures may not accurately represent your past
performance. They are most useful as indicators of your portfolio's current (and projected)
performance.
Securities in this report can be ranked or sorted by column value by clicking on the desired
column. Bold faced, highlighted securities are those in which you currently hold an
investment (see Portfolio). Checking the My Portfolio box restricts the displayed list to only
those securities in which you own shares.
You can double-click a security to highlight it for easy identification while
sorting.
Performance Analysis lists the annualized returns of each security over 10-yr, 5-yr, 3-yr, 1-yr,
6-mo, 3-mo, and 1-mo periods. This compares securities on the basis of both long and short
term performance, and on consistency of performance over time. Additionally, the last column
lists the Performance Momentum of each security.
Performance Momentum
Studies have shown there to be value in concentrating on a fund's more recent track record as
a predictor of future success. Building on work by Burton Berry, author Austin Pryor developed
a formulaic approach to rank the performance of mutual funds which he calls "Performance
Momentum". Performance Momentum theory holds that securities that have been the
strongest of late are the more likely winners in the coming months (who would you bet on to
win the Superbowl at midseason, the team that has done the best over the last 5 years, the
team that won last year, or the team that is currently leading the league?). The Performance
Momentum value is the sum of the unannualized 12-mo, 6-mo, and 3-mo returns. Notice that
the most recent three months' performance is reflected in all three statistics. It represents
100% of the first number, 50% of the second number, and 25% of the final number. In this
way, a security's more recent performance is given greater weight.
Portfolio Total figures expressed at the bottom represent the weighted combinations of
the security performance figures proportioned by the dollar amount currently owned of each
security in your portfolio (including cash-equivalent
accounts, which earn your
risk-free return). If, for example, you had your money split evenly between
two securities, your Portfolio Total return would be the average of the returns
of these two securities. Since you may have moved money in or out of your
securities during the listed time periods, these figures may not accurately
represent your past performance.
Securities in this report can be ranked or sorted by column value by clicking on the desired
column. Bold faced, highlighted securities are those in which you currently hold an
investment (see Portfolio). Checking the My Portfolio box restricts the displayed list to only
those securities in which you own shares.
You can double-click a security to highlight it for easy identification while
sorting.
Yearly Analysis lists the returns of each security for each of the last 7 calendar years (showing
unannualized YTD returns for the latest year). As with all analysis functions, the End Date in the Analysis
Report Settings is used to determine the latest date used, so that choosing an End Date prior
to the current year will allow you to see yearly performance more than 7 years ago.
This report is especially useful to see how securities perform relative to each other during
different economic cycles. While some securities fall in a given year, others may rise in that
same year, suggesting they may be good candidates for providing diversification in a portfolio.
Securities that perform consistently well in all years may be good choices for risk mitigation.
Securities in this report can be ranked or sorted by column value by clicking on the desired
column. Bold faced, highlighted securities are those in which you currently hold an
investment (see Portfolio). Checking the My Portfolio box restricts the displayed list to only
those securities in which you own shares.
You can double-click a security to highlight it for easy identification while
sorting.
Portfolio Total figures expressed at the bottom represent the weighted combinations of
the security performance figures proportioned by the dollar amount currently owned of each
security in your portfolio (including cash-equivalent
accounts, which earn your
risk-free return). If, for example, you had your money split evenly between
two securities, your Portfolio Total return would be the average of the returns
of these two securities. Since you may have moved money in or out of your
securities during the listed time periods, these figures may not accurately
represent your past performance.
The belief behind Trend theory is that prices tend to move in cyclical trends, and that the
strength of the current trend provides an indicator of the probable direction of a security's future
price movement. The objective of Trend Analysis is to measure the strength of the existing
trend and to identify changes in the trend.
A selected length of time called the trend period is necessary for trend calculation. Fundwatch
calculates trend data with respect to the End Date and the number of weeks (or days) for the
Trend Period (specified in Analysis Settings
or at the top of the report). All data shown on this report will be calculated
using the specified trend period, and only securities in the data file having prices spanning that
period will be included in the analysis. Selection of a trend period appropriate for your
investments is a subjective process, and Graphic Analysis is an excellent tool for evaluating
different values. Commonly used periods include 39-week and 52-week.
Simple Moving Average Margin is a comparison of the current price to a
simple moving average. For a 39-week trend period, for example, a 39-week price
average (adjusted for distributions) would be calculated for each security. The
moving average margin ((current price - price average) / price average) of each
security is reported. This represents the percentage difference of a
security's current price from its moving average. Thus, if the trend margin for a security is
positive, its price is above its moving average; its trend is presumably upward, and the strength
of its trend is suggested by the trend margin's magnitude.
Exponential Moving Average
Margin uses an exponentially weighted moving average. Exponential weighting
has the effect of mathematically assigning greater value to the more recent data, which some
analysts believe produces a more accurate trend indicator. The Exponential
margin is calculated in the same way as the Simple, giving the percentage difference of
the security's current price from its weighted average.
Least Squares Margin involves calculation of a constant rate of return trend curve using a
Least
Squares regression of the logarithmically adjusted price data. The least squares curve is a
mathematical best fit of the price data to a smooth curve with a constant rate of return. The
Least Squares Margin is calculated the same way as the other trend margins. A positive margin indicates that the current price is above the least
squares curve, and a negative margin means that the price is below this curve.
R Squared values are associated with the Least Squares regression.
R-squared is a measure of how tightly correlated the price movement is over the period and
reflects the strength of the trend. The more closely prices move in a linear relationship with the
passing of time, the stronger the trend. R-squared values (which range between 0 and 1) show
the percentage of movement that can be explained by trend. One of the most useful ways to
use R-squared is as a confirming indicator. Momentum based indicators (e.g., MACD, RSI)
and moving average systems require a confirmation of trend in order to be consistently
effective, and R-squared provides a means of quantifying the trend. For instance, when using
momentum based indicators, you may want to only trade overbought/oversold levels if you
have determined that prices are trendless or weakening (i.e., a low or lowering R-squared
value) because in a strong trending market, prices can remain overbought or oversold for
extended periods.
R-Squared Change is important because a rising R-squared
indicates a strengthening of the trend and a falling R-squared indicates a weakening of the
trend.
Parabolic SAR Margin (calculated the same way as the other
margins) compares the price of a security with its
Parabolic SAR value. A positive margin
means its price is above its SAR point and the security is in a rising trend.
P/E Ratio is simply the
price/earnings ratio using the TTM (trailing twelve months) earnings for the
security. Red values are above the high threshold set in your
Configuration, and green values
are below the low threshold.
Alerts: Backlighted green values indicate a transition from negative to positive (commonly
considered a buy signal), and backlighted red values indicate a transition from positive to
negative (commonly considered a sell signal). R-Squared changes are not normally used as
buy/sell signals by themselves and therefore do not produce alerts.
Securities in this report can be ranked or sorted by column value by clicking on the desired
column. Bold faced, highlighted securities are those in which you currently hold an
investment (see Portfolio). Checking the My Portfolio box restricts the displayed list to only
those securities in which you own shares.
You can double-click a security to highlight it for easy identification while
sorting.
Volatility Analysis measures and compares the volatility of your securities, and helps to
compare investments with different behavior and performance characteristics. In general,
investments with higher expected returns tend to be more volatile; that is, their prices tend to
fluctuate over a broader range. Higher volatility introduces increased risk of losses at time of
liquidation. Volatility analysis helps to assess whether or not an investment's potential for
higher returns is in desirable proportion to the risk added by its volatility.
It should be noted that while volatility is the one form of risk most readily addressed by
technical analysis, it is certainly not the only form of risk associated with an investment, and
other hidden risk factors may exist for numerous reasons and may vary between investments.
Annual ROR is the annualized total rate of return over the time period for the
list of securities with data spanning the period.
Volatility is the average absolute daily (or weekly) percentage change in
price (adjusted for distributions) of each security during the time period.
ROR Stability is the ratio of the average daily (or weekly) rate of return over
the average daily (or weekly) volatility. This number is expressed as a percent (between 0 and
100) and measures the extent to which price movement was consistent with overall
performance during the time period. An ROR Stability of 100% would indicate a constant
growth rate (i.e., a perfectly smooth exponential performance curve). Lower numbers indicate
larger price movement variations with respect to such a curve.
Max Drawdown is the maximum peak-to-valley loss the security
experienced during the time period.
Standard Deviation is the standard deviation of the rate of return over the
period. Standard deviation is a common way to measure the variance of data points from a
mean calculated by least squares regression. A standard deviation of 25% means that the
security's rate of return differed from the security's least squares rate of return regression by an
average of 25% over the period. Fundwatch always uses logarithmically-adjusted data when
calculating least squares regression and standard deviation to neutralize the effect of
expanding variations at higher percentage levels.
R Squared is a measure between 0 and 1 of how well the least squares
regression fit the data over the period. An R squared value of 1.00 means a perfect fit. Low R
squared values suggest that the standard deviation and Beta values derived from the least
squares regression may not be meaningful, and that a different period should be selected for
such analysis.
Beta is a measurement of how closely a security's performance
correlates with the performance of a benchmark index, such as the S&P 500, and thus is a
measurement of what portion of its performance can be explained by the performance of the
overall market. The benchmark index (Beta Index) is selectable at top from any security or
index in the data file which spans the specified period. You can think of Beta as the tendency
of a security's returns to respond to swings in the benchmark index. A Beta value of 1
suggests a security is closely correlated with the index and will tend to move in concert with the
index. A Beta greater than 1 suggests a strong directional correlation but with higher volatility.
Values less than one suggest a low correlation or lower volatility, and negative numbers
suggest an inverse correlation (price movement in the opposite direction). By itself, Beta can
be ambiguous, so one must always consider the R-squared value when examining Beta. A
higher R-squared value will indicate a more useful Beta. For example, if a fund has a Beta
below 1, it could mean there is little correlation with the benchmark index. But if it has an R-
squared value of close to 1, it is most likely offering less volatility than the benchmark. A low R-
squared value generally means you should ignore the Beta.
Sharpe Ratio is a ratio developed by Nobel Laureate William Sharpe to
measure risk-adjusted performance. The Sharpe Ratio is calculated by subtracting the
risk-
free rate of return from the security's rate of return and dividing the result by the security's
standard deviation. Greater excess returns from an investment will result in a greater Sharpe
Ratio, but the opposite is true for its standard deviation, a measurement of the investment's
volatility. The Sharpe ratio is thus a measurement of return per unit of risk. Securities with
larger Sharpe Ratios are generally considered to have a better risk/reward ratio. For mutual
funds, Sharpe Ratios are typically between about 0.5 and 3. A Sharpe Ratio over 1 is good;
over 2 is considered outstanding.
Securities in this report can be ranked or sorted by column value by clicking on the desired
column. Bold faced, highlighted securities are those in which you currently hold an
investment (see Portfolio). Checking the My Portfolio box restricts the displayed list to only
those securities in which you own shares.
You can double-click a security to highlight it for easy identification while
sorting.
Momentum Analysis provides alerts for common momentum indicators (green backlighting is a
buy signal; red backlighting is a sell signal). The theory behind momentum analysis is that a
strongly trending market acts like a pendulum; the move begins at a fast pace, with strong
momentum. It gradually slows down, or loses momentum, stops, and reverses course.
Momentum indicators lead the advance or decline in prices and produce signals in advance of
price trend reversals. Parameters used to calculate the alerts can be adjusted in the
Configuration dialog.
X-Week Momentum (X-Day Momentum in a daily file) is the
X-week
momentum on the end date of the report (X is set by the Mometum period configuration
setting). Backlighted green values indicate an upward transition from negative to positive, and
backlighted red values indicate a downward transition from positive to negative.
X-Week RSI is the Relative Strength Index (X is set by the RSI period
configuration setting). Backlighted green values indicate an upward transition through the 30%
level, and backlighted red values indicate a downward transition through the 70% level.
X-Week MFI is the Money Flow Index (X is set by the MFI period
configuration setting). Backlighted green values indicate an upward transition through the 20%
level, and backlighted red values indicate a downward transition through the 80% level.
X/Y-Week MACD is the percentage value of the
X/Y-week MACD over the
price (X and Y are set by the MACD period configuration settings). Backlighted green values
indicate an upward transition of the MACD through its signal line, and backlighted red values
indicate a downward transition of the MACD through the signal line.
R Squared is a measure between 0 and 1 of the strength of the trend over
the momentum period (how well the least squares regression fit the data over the period).
Since momentum indicators are indicators of reversals in the trend, they are more meaningful
when the trend is strong and less meaningful when the trend is weak. A high R squared value
means a tight fit, thus a strong trend. A low R squared value means the trend over the period
was not strong.
Stochastic is the current value of the X-week fast
stochastic oscillator, a
number between 0 and 100. Values over 80 are considered to indicate an overbought
condition, and values below 20 are considered to indicate an oversold condition. Backlighted
green values signal an upward crossing through the Y-week slow stochastic oscillator (buy
signal) and backlighted red values signal a downward crossing through the slow stochastic (sell
signal). (X and Y are set by the Stochastic Oscillator period configuration settings.)
The last column is the Performance Momentum for each security.
Securities in this report can be ranked or sorted by column value by clicking on the desired
column. Bold faced, highlighted securities are those in which you currently hold an
investment (see Portfolio). Checking the My Portfolio box restricts the displayed list to only
those securities in which you own shares.
You can double-click a security to highlight it for easy identification while
sorting.
Summary Analysis provides an overview comparison of securities with alerts for common
technical indicators (green backlighting is a buy signal; red backlighting is a sell signal).
Parameters used to calculate the alerts can be adjusted in the
Configuration Settings dialog.
The overall time period for the report is set in the
Analysis Settings.
Annual ROR is the annualized total Rate of Return over the report time
period for the list of securities with data spanning the period.
X-Week MA Margin is a comparison of the current price to a simple
moving average over the specified trend period (see Trend Analysis for a description).
Positive values mean the price is above the moving average, negative values mean
the price is below the average. Backlighted green values indicate a transition from negative to positive, and backlighted red
values indicate a transition from positive to negative.
X/Y-Week MACD is the percentage value of the
X/Y-week MACD over the
price (X and Y are set by the MACD period configuration settings). Backlighted green values
indicate an upward transition of the MACD through its signal line, and backlighted red values
indicate a downward transition of the MACD through the signal line.
X-Week RSI is the Relative Strength Index. Backlighted green values
indicate an upward transition through the 30% level, and backlighted red values indicate a
downward transition through the 70% level.
X-Week Retrace is the percentage of retracement of the X-week trend that
has occurred (X is set by the Fibonacci period configuration setting). Backlighted green values
indicate an upward retracement of a downward trend through the 61.8% level, and backlighted
red values indicate a downward retracement of an upward trend through the 61.8% level.
Sharpe Ratio is a measurement of return per unit of risk. Securities with
larger Sharpe Ratios are generally considered to have a better risk/reward ratio
(see Volatility Analysis for details).
P/E Ratio is simply the price/earnings ratio using
the TTM (trailing twelve months) earnings for the security. Red values are above
the high threshold set in your
Configuration, and green values are below the low threshold.
Morningstar Rating is the Morningstar mutual fund "star" rating (only
available for mutual funds). The range of this rating is 1 thru 5, with 5 being the best. For an
explanation of this rating, visit Morningstar's website at www.morningstar.com.
If the name of the security itself is backlighted green, that indicates that its price on the end
date is a new high for the Trading Range Period indicated at top. Likewise, a backlighted red name
indicates the security has established a new low over the period.
Securities in this report can be ranked or sorted by column value by clicking on the desired
column. Bold faced, highlighted securities are those in which you currently hold an
investment (see Portfolio). Checking the My Portfolio box restricts the displayed list to only
those securities in which you own shares.
You can double-click a security to highlight it for easy identification while
sorting.
Graphic Analysis plots security performance,
allowing you to superimpose technical indicators and other securities for
comparison.
The x-axis represents the selected period (initially specified in the
Analysis
Report Settings area). It can be expanded or scrolled using the arrow glyphs
at top, or expanded/contracted using the slider at the top.
The y-axis represents either the price or the percentage change relative to the start date of the
graph. The y-axis can be logarithmically or linearly scaled, as set by the
Linear / Log toggle
above the graph.
Add securities to a graph by choosing them from the dropdown in the upper-left
corner.
Multi mode allows you to superimpose and compare securities directly as a percent of initial plotted value,
either in Total Return or Price scale (as set by the
toggle above the graph). A Total Return graph includes the effects of all dividends, splits and
distributions. A Price graph excludes these effects. Total Return
provides a better comparison of investments, but Price is often useful to
measure unrealized capital gain or perform technical analysis. In Multi mode,
securities are distinguished by color and all technical indicators are colored
according to the securities to which they apply.
Single mode isolates the selected security on a price scale and
distinguishes applied technical indicators by separate colors (the security may
be yellow, the stochastic may be red, etc). More information is displayed
on the y-axis in this mode. Also, when in Single mode, the
plot is always a price graph (as described above) without the effects of
distributions.
Click on the name of a security in the legend to change the selected
security for adding technical
indicators or to remove a security from the graph.
The selected security is underlined.
Technical Analysis indicators
available on the upper toolbar (see list below) can be superimposed on the selected security
in any order. Technical indicators can be added or removed by
clicking icons on the toolbar.
Volume is plotted along the bottom for only the selected security if
the Volume toggle is selected. If the Distribs toggle is
selected, all distributions, dividends and splits are indicated on all plots.
If the Hi-Lo toggle is selected, vertical lines representing the hi-lo
range for the day or week are plotted. You can zoom the graph by left-clicking and dragging along the horizontal span you wish to
zoom. Unzoom by clicking the magnifying lens icon at top. When zoomed, the graph can be scrolled
forward or backward by means of the arrow glyphs along the top margin. The
double arrow glyphs extend the graph's range to the beginning or ending edges of
the data file. The slider at the top of the Graph extends or shrinks the range by moving the beginning date.
The Set Range button will set the beginning and ending dates to whatever
is set in the Analysis Report Settings.
You can draw trendlines by right-clicking and dragging. Trendlines are scaled and
colored according to the security selected in the legend.
A Vertical Marker can be positioned by means of the lower scrollbar or
date entry (lower right corner), and a date stamp can be applied. A Horizontal Marker can be turned on and off,
which displays price and percentage change of the
selected security above the graph.
Icons along the top of the graph provide the following functions:
Securities Menu (Plot Security)
Add securities to a graph by selecting from the Plot Security dropdown.
When the Graph is in Multi mode, the plot shows the security's percentage change with respect to
the security's value on the beginning date of the Graph. This means that all plots start at 0 on the y-axis and
represent percentage performance independent of the security's base
share price. The plot will start at the security's start date on the x-axis if it is later than the
beginning date of the graph. Note that unless plots start at the same point on the x-axis, they
cannot be compared directly on the y-axis. In order to compare securities directly, set the
beginning date of the graph to a date on which there is data for all securities you are wanting to
compare.
If the Volume checkbox is selected, any volume data existing for the selected security will be
plotted as a bar graph along the bottom of the graph. The magnitude of the volume data is
adjusted so that it fits legibly in the lower section of the graph while keeping patterns clearly
visible, but the range of the volume data is not displayed. If there is no volume data, it means
that volume data has not been collected for this security over the displayed interval. Some
securities, such as mutual funds, do not have associated volume data.
If the Hi-Lo checkbox is selected, any high-low data existing for the security will be
superimposed on its performance plot. If there is no high-low data, it means high-low data has
not been collected for this security over the displayed interval. Some securities, such as
mutual funds, do not have associated high-low data.
If the Distribs checkbox is selected, any distributions or dividends
existing for the security will be indicated (with Xs) on its performance plot.
Click on the name of a security in the legend to change the selected security for adding
analytical plots, displaying volume, or plot removal.
Clicking the red X icon on the toolbar will remove the plot of the currently selected security and all its associated
technical indicators from the graph.
To remove only certain technical indicators from a security, click the icon of
the indicator you want to remove (as if you're going to add it) and it will
either disappear or display a parameters dialog, whereupon you click the Remove
All button.
To mark a particular price date on the graph (e.g. to identify a
certain event or period of special interest), use the lower scrollbar or enter a date in the textbox
to position the date marker. If you click on the thumbtack icon on the toolbar, a dated mark will be drawn
on the graph at the position of the Vertical Marker.
The Horizontal Marker (if turned on) follows the Vertical Marker along the currently selected
security, and its actual price and percentage growth (with respect to the beginning of the graph)
are displayed above the graph at top right according to the Vertical Marker's position.
The Trading Range icon marks the high and low price of the selected security
over a specified period. Some analysts use a 52-week period to define a stock's trading range,
applying the theory that when a stock moves above or below its 52-week high or low, it has
broken out of its trading range and established a new trend, either up or down. If a stock's
current price is the same as its 52-week high or low, it has already broken out of its trading
range and set a new trend.
Least Squares Regression Curve
The Least Squares Curve icon plots a least squares regression curve for the currently
selected security. A least squares regression curve is a smooth growth curve (constant rate of
return) which best fits the plotted data. Because it has a constant rate of return, it is a straight
line when plotted logarithmically. Its mathematical meaning is easier to visualize on a
logarithmic graph, because there, it is the line which passes through the data points with the
least variance between itself and the data points (the same is true on a linear graph, but since
the data variance on a linear scale has not been adjusted for percentage, the line is curved and
variances are wider with higher prices). It provides a very good indicator of where the security
is likely to continue moving if market conditions don't change, and is a good basis for
comparison of securities. Its rate of return fluctuates less between different periods than a rate
of return simply calculated between two endpoints, and thus may be a more reliable indication
of the security's expected performance over time.
The Moving Average icon lets you specify a trend period in days (or weeks) for plotting
a moving average for the currently selected security. A moving average is the set of
simple or
exponential price averages (as discussed in Trend Analysis) calculated for each price date in
the range of the graph and plotted with respect to the security's performance. This effectively
provides a moving trend analysis for the security over time. Points at which the moving
average is above the security performance plot correspond to positive trend margins, below the
performance plot are negative trend margins, and points at which the moving average crosses
the performance plot indicate trend reversals.
In addition to selecting the period for the moving average, you can also specify a percentage
value with which to plot bands above and below the moving average. For example, if you enter
5, bands will be plotted around the moving average representing + and - 5% of the moving
average value.
You can select the security for which to plot a moving average by clicking on its name
displayed in the graph legend. Multiple moving averages can be plotted for any security. The
legend is modified for each moving average with an "MA" followed by the number of days or
weeks for that moving average. If exponential was selected, "E" is appended, and if
percentage bands were specified, they are indicated with a dash followed by the percentage.
Example for a 52-week exponential moving average with a 3% band:
EMA52-3%
The RSI icon will produce a plot of the Relative Strength Index of the selected security
beneath the performance graph.
Developed by Welles Wilder, the relative strength index is a momentum oscillator--a
calculation that measures the velocity (rate of change) of directional price movement over a
period of time. The RSI is one of the most widely used technical indicators because of its
success in identifying trend reversals and price range breakouts at a very early point. The
formula for RSI is:
RSI = 100 - 100 / (1 + RS)
where RS = the average of up closes over a period of time divided by the average value of
down closes over the period.
Like the moving average, the RSI requires a trend period, but the rules for selecting this period
are different than for moving averages. The period should be between 2 and 30 price intervals,
with 14 being most often recommended as ideal (although some studies have suggested a 21-
interval period produces the best results). Both simple and exponentially weighted methods
can be used, with exponential weighting assigning greater value to the more recent data.
There are a number of things the RSI can reveal: Tops (overbought conditions) and bottoms
(oversold conditions) are indicated when the RSI rises above 70% or drops below 30%
respectively. The RSI typically tops before the actual price tops, and crossing the 70% line
going downward is considered a sell signal according to experts. Likewise, a crossing of the
30% line going upward is considered a buy signal. Failure swings (subsequent trading range
breakout attempts which are weaker than the previous) above the 70% or below the 30% lines
are very strong advanced indicators of trend reversals, as is divergence in direction between
RSI and security performance (i.e., when the RSI changes direction and price movement does
not, a price trend reversal is expected).
The RSI legend appears below the RSI plot and shows the period prefixed with "RS" ("ERS"
if exponential is selected).
Invented by John Bollinger in the 1980s, Bollinger Bands are curves drawn in and around a
security's price structure to form an envelope that provides relative definitions of high and low.
Knowing whether prices are high or low allows you to make smarter investment decisions when
comparing price action to other indicators. The base for the bands is a moving average and
the band's width is determined by volatility as measured by standard deviation. Unlike simple
percentage bands, Bollinger Bands are extremely quick to react to large moves in the market.
Many reversals occur near the bands, and the average provides support and resistance in
many cases.
The use of Bollinger Bands varies widely, but experts recommend the use of Bollinger Bands
for generating buy and sell signals through comparison of another indicator (e.g. RSI) to the
action of price within the bands. Some traders buy when the price touches the lower band and
exit when price touches the moving average, or buy when the price breaks above the upper
band and sell when price falls below the lower band. Others believe buy and sell signals are
not based solely on price touching the bands. Some believe a top (chart formation) formed
outside the bands followed by a second top inside the bands constitutes a sell signal (there is
no requirement for the second top's position relative to the first top, only relative to the bands).
The converse is then true for lows.
For mutual funds, market indexes and stocks, a 20-50 interval period is considered optimal for
calculating Bollinger Bands. The average that is selected should be descriptive of the desired
time frame (short, medium or long-term). The easiest way to identify the proper average is to
choose one that provides support to the correction of the first move up off a bottom. If the
average is penetrated by the correction, then the average is too short. If, in turn, the correction
falls short of the average, then the average is too long. An average that is correctly chosen will
provide support far more often than it is broken.
A Bollinger band plot is indicated in the legend with "B" followed by the number of weeks
selected for the trend period.
Fibonacci numbers are a numerical sequence made by adding the two previous numbers
together (i.e., 1, 2, 3, 5, 8, 13, etc.). An interesting property of these numbers is that as the
series proceeds, the ratio of any two adjacent numbers approaches 1.618. This property of the
Fibonacci series occurs throughout nature, and the number 0.618 is often referred to as the
"golden ratio". Fibonacci numbers are commonly used in technical analysis to determine
potential support and resistance levels, theorizing that market behavior follows this natural
pattern (also the basis of Elliott Wave theory). According to experts, a 61.8% retracement from
a high or low usually implies a new trend is establishing itself, and a 38.2% (1 - .618)
retracement implies that the prior trend will continue. 38.2% retracements are considered
natural retracements in a healthy trend.
There are three popular ways to plot Fibonacci levels: retracement lines, fans, and arcs.
Changes in trend are anticipated as prices approach the lines created by the Fibonacci levels.
Confluence occurs when Fibonacci projections using multiple trend periods yield the same
number and strengthens when it corresponds with other technical indications. Each plot
method requires first finding a trendline between the high and low (preferrably a peak and
valley) over a specified period. Fibonacci levels are calculated within the range of the high and
low and lines are then drawn to indicate retracement levels signifying trend continuance or
reversal.
Retracement Lines: Three horizontal lines are drawn at the Fibonacci levels of 38.2%, 50%,
and 61.8% of the range. After a significant price move (either up or down), prices will often
retrace a significant portion of the original move. As prices retrace, support and resistance
levels often occur at or near the Fibonacci retracement levels. After reaching the 38.2%
retracement, the price should normally break through the previous extreme on heavier volume.
61.8% retracements are warning signs of potential trend changes.
Fan Lines: Three trendlines are drawn from the first extreme so they pass through an invisible
vertical at the second extreme at Fibonacci levels of 38.2%, 50%, and 61.8%. Support and
resistance is anticipated as prices approach the fan lines.
Arcs: Three arcs are drawn, centered on the second extreme, so they intersect the trendline
at the Fibonacci levels of 38.2%, 50%, and 61.8%. Support and resistance is anticipated as
prices approach the arcs, though another common technique is to anticipate support/resistance
at points where the corresponding Fibonacci arcs and fan lines intersect.
A Fibonacci plot is indicated in the legend with "F" followed by the number of weeks selected
for the trend period.
Developed by the late Edson Gould, Speed Resistance Lines are constructed by drawing
trendlines between the most recent high and low of a trend period, and represent support or
resistance levels. A dashed trendline is drawn from the two extremes of a selected period.
Two "speedlines" are then drawn from the first extreme so they pass through an invisible
vertical at the second extreme at the 1/3 and 2/3 levels. The speedlines show the expected
support on retracement. In an uptrend, for example, prices should find support above the
upper speedline. When prices do fall below the upper speedline, they should quickly drop to
the lower speedline where they should then again find support.
Speed resistance lines are considered especially good when a technician is looking at
securities that are inside of strong trends, and can be used by those interested in both short
and intermediate phases as well as long-term outlooks. Analysts theorize that a pullback from
a major trend will always be within a range of 1/3 to 2/3 of the most recent upward movement,
where 1/3 is the minimum an investor can expect. At the 1/3 level of retracement, an increase
in trading volume is expected to occur because of the increasing number of individuals that
understand retracements and wait for them as a buy signal. Investors have also learned that,
should the retracement continue to fall through the 1/3 level, the next support will be found at
the 2/3 level. For a security that is currently showing a downtrend, the reversal is true; a
penetration through the lower speedline signals a likely rally to the upper line, and if the upper
line is broken this usually indicates a continued rally.
MACD (Moving Average Convergence/Divergence)
Developed by Gerald Appel in the sixties, Moving Average Convergence/Divergence (MACD)
uses the difference between a fast and slow moving average, which are lagging indicators, to
produce an oscillator with trend-following characteristics. These lagging indicators are turned
into a momentum oscillator (so named because the resulting curve swings back and forth
across the zero line) by subtracting the slower moving average from the faster moving average.
MACD = ema1 - ema2
The most popular formula for the "standard" MACD is the difference between a security's 26-
interval (day or week) and 12-interval EMAs (exponential moving averages). This series is
plotted as a solid line. Then a 9-interval EMA (3/4 of the shorter period) of the difference is
plotted as a dashed "signal" line. The signal line trails the primary series by just a bit, and
trades are signalled whenever the solid line crosses the dashed line. A bullish crossover
presumably occurs when MACD moves above the signal line and a bearish crossover occurs
when MACD moves below the signal line.
Another common indicator provided by MACD is known as the "Golden Cross", which is the upward crossing of a short moving average through a longer moving average.
The MACD reflects this crosspoint when it crosses the zero line (the signal line is ignored). A common combination for the Golden Cross is a 200-day and 50-day moving average.
For more volatile markets, you may want to shorten the periods of the EMA's (for example, a 7-
day and 13-day pair is popular for evaluating commodities). Using shorter moving averages
will produce a quicker, more responsive indicator, while using longer moving averages will
produce a slower indicator, less prone to whipsaws.
You must enter the number of weeks (or days) to use for both ema1 and ema2 (order doesn't
matter), and Fundwatch automatically determines the period used for the trailing signal line.
The legend appears above the graph and shows the two ema values prefixed with "MAC" and
separated by a slash (e.g. MAC12/26).
R-squared provides a means of quantifying the strength of the trend, and is thus typically
calculated using the same trend period used for other trend analysis methods. It is calculated
using Least Squares regression and is a measure of how tightly correlated the price movement
is over the period. R-squared ranges between 0 and 1 and is plotted as a dashed line in the
lower region beneath performance. The number of weeks used to calculate each R-squared
plot is listed at the very bottom of the region, starting at the left. A solid, horizontal "critical
value" line indicates the 95% confidence level of the R-squared indicator. Where the R-
squared indicator falls below the critical value line, assume there is no correlation between the
price and the Least Squares Trendline.
One of the most useful ways to use R-squared is as a confirming indicator. Momentum based
indicators (e.g., MACD, RSI) and moving average systems require a confirmation of trend in
order to be consistently effective. For instance, when using momentum based indicators, you
may want to only trade overbought/oversold levels if you have determined that prices are
trendless or weakening (i.e., a low or lowering R-squared value) because in a strong trending
market, prices can remain overbought or oversold for extended periods.
The R-squared legend appears beneath the R-squared graph and shows the period used
prefixed with an "R".
Momentum Oscillator (aka Rate of Change)
The Momentum icon produces a plot of the raw momentum beneath the performance graph.
Raw momentum is simply the rate of change calculated as follows: (price(n) - price(n - period))
/ price(n - period) where the period is a selectable number of days or weeks. A 10-day
momentum line fluctuates on an open scale around a zero line (the midline). When the latest closing price is higher than that of 10 days
ago, a positive value is plotted above the zero line. If the latest close is lower than 10 days
previous, a negative value is plotted.
The Momentum line leads price action frequently enough to signal a potential trend reversal in
the market. Momentum indicators can warn of dormant strength or weakness in the price well
ahead of the turning point. At extreme positive values, momentum implies an overbought
position; at extreme negative values, an oversold position.
The theory behind momentum analysis is that a strongly trending market acts like a pendulum;
the move begins at a fast pace, with strong momentum. It gradually slows down, or loses
momentum, stops, and reverses course. The momentum line is assumed to be always a step
ahead of the price movement. It leads the advance or decline in prices and levels off while the
current price trend is still in effect. It then begins to move in the opposite direction as prices
begin to level off.
Three common signals are generated by the momentum oscillator: midline crossings, trendline
violations, and extreme values. A crossing above the midline is considered a buy signal if the
price trend is up and a crossing below the midline, a sell signal, if the price trend is down.
Trends on the momentum chart are normally broken sooner than those on the price chart. The
theory is that the momentum indicator turns sooner than the market itself, making it a leading
indicator.
Ten days or weeks are usually used in calculating momentum, but any time period can be
employed. The shorter the time frame used the more sensitive momentum becomes to short
term fluctuations with more marked oscillations. Oscillator swings are smoother and more
stable when a longer period is used.
The momentum legend appears above the momentum graph and shows the period used
prefixed with "Mom".
A Candlestick plot uses boxes to show the open, high, low and close values for a security.
Each day (or week) is represented by two superimposed boxes. The outer box delineates the
high and low, and the inner box depicts the open and close. If the closing price is higher than
the opening price, the inner box is hollow. If the security closes lower than its opening price,
the inner box is solid.
Many traders consider candlestick charts more visually appealing and easier to interpret than
traditional bar charts. Each candlestick provides an easy-to-decipher picture of price action,
allowing a trader to immediately see the relationship between the open and close as well as the
high and low. The relationship between the open and close is considered vital information,
making the candlestick plot an essential tool. Hollow candlesticks, where the close is greater
than the open, suggest buying pressure. Filled candlesticks, where the close is less than the
open, suggest selling pressure.
Parabolic SAR (Stop and Reverse)
Developed by Welles Wilder, creator of RSI, the Parabolic SAR (stop and reverse) is used to
set trailing price stops for long or short positions. Parabolic SAR is more popular for setting
stops than for establishing direction or trend. Wilder recommended establishing the trend first,
and then trading with Parabolic SAR in the direction of the trend. If the trend is up, buy when
the indicator moves below the price. If the trend is down, sell when the indicator moves above
the price.
The name of the system is derived from its parabolic shape, which follows the price movements
in the form of a dotted line. When the parabola follows along below the price, the trader should
be buying or going long, according to Wilder. A parabola above the price suggests selling or
going short. The value of the Parabolic SAR is that it allows traders to catch new trends
relatively early. If the new trend fails, the parabola quickly switches from one side of the price
to the other, thus generating the stop and reverse signal.
SAR(i) = SAR(i-1) + acceleration * (extreme(i-1) - SAR(i-1))
Where:
The acceleration factor increases through the trend, causing Parabolic SAR and the price to
converge. The faster the price grows or sinks, the faster the indicator approaches the price.
When the SAR value crosses within the price range, a new trend direction is signaled, and the
SAR switches sides, thus establishing the stop and reverse point.
Developed by George C. Lane in the late 1950s, the Stochastic Oscillator is a momentum
indicator that compares a security's closing price to its price range over a given time period.
The theory is that in an upward-trending market, prices tend to close near their high, and during
a downward-trending market, prices tend to close near their low. Closing levels that are
consistently near the top of the range indicate buying pressure and those consistently near the
bottom of the range indicate selling pressure.
The oscillator's sensitivity to market movements can be reduced by adjusting the time period or
by taking a moving average of the result. Thus it is normally plotted as two indicators, the
"Fast" Stochastic (known as %K) and its moving average, called the "Slow" Stochastic.
Fast Stochastic = %K = 100 (C - L(n)) / (H(n) - L(n))
C = the most recent closing price
The Fast Stochastic (%K) tells us the percentile of the high/low range the close was in, and
ranges between 0 and 100. The Fast Stochastic is normally plotted alongside the Slow
Stochastic, which is simply its own moving average. The number of periods used to generate
the Fast and Slow Stochastics will vary according to the sensitivity and the type of signals
desired. As with RSI, 14 is a popular number of periods for Fast, and 3 is most commonly used
for Slow.
Readings below 20 are considered oversold and readings above 80 are considered
overbought. However, Lane believed that some of the best signals occurred when the
oscillator moved from overbought territory back below 80 and from oversold territory back
above 20. Buy and sell signals can also be given when the Fast Stochastic crosses above or
below the Slow Stochastic, however such crossover signals can be quite frequent. One of the
most reliable signals is said to be a threshhold crossover which occurs after a "divergence"
develops. This appears as a "double dip" accross the threshold, with the second crossing
providing the signal.
You must enter the number of weeks (or days) to use for both fast and slow stochastics. The
order doesn't matter because Fundwatch automatically uses the longer period for fast and the
shorter for slow. The legend in the lower section of the graph will show the the two values
prefixed with "%K" and separated by a slash (e.g. %K14/3).
On-balance volume (OBV) is a momentum oscillator developed by Joseph Granville in the
1960s. OBV is calculated by adding the day's volume to a running cumulative total when the
security's price closes up, and subtracts the volume when it closes down. Only the shape of
the resulting indicator is used, not the actual level of the total. OBV is generally used to confirm
price moves. The idea is that volume is higher on days where the price move is in the
dominant direction. For example, in a strong uptrend there is more volume on up days than on
down days. So when prices rise, OBV is expected to rise too, and when prices set a new rally
high, OBV should too. If OBV fails to exceed its previous rally high while prices continue rising,
this negative divergence suggests a weakening trend.
OBV can be used to predict trend reversals in other ways. Granville's theory stated that when
volume increases dramatically without any significant change in the issue's price, then a major
trend reversal is imminent. He believed that as institutions (pension funds, investment funds,
trading houses, etc.) begin to buy into an issue that retail investors are selling, volume
increases as the price begins to level out. Over a period of time volume begins to drive the
price upward and the converse then appears as institutions begin selling their positions and
retail investors begin to accumulate (the term "smart money" thus refers to the institutions that
buy stock from consumers at the bottom and then sell it back to them near the top).
A trendline is a straight line connecting two or more price extremes or "pivot points", and is
regarded as a bounding line for price movement. In an uptrend, the trendline is drawn below
the price action and acts as a support line. Similarly, in a downtrend, the trendline is drawn
above the price action and acts as a resistance line. Significant breakouts through the
trendline signal trend reversals.
Trendlines are commonly drawn by hand because it is rarely possible to connect all pivot points
neatly with a straight line, and subjective judgement must be used to determine exactly how the
trendline should be drawn. Fundwatch allows hand-drawn trendlines to be applied to the graph
by right-clicking and dragging, but it also provides a useful tool to quickly create trendlines by
automatically identifying and connecting price extremes.
The Auto Trendline is calculated according to the price action within the visible range of the
graph; therefore, the best way to use it is to isolate the trend using the zoom feature and then
apply the trendline. Note that on a linear graph, the auto trendline is actually a curve because it
is calculated in log scale.
A technical indicator developed by Stephen Klinger, the Klinger Volume Oscillator (KVO) uses
volume to determine long-term trends of money flow to enable a trader to predict short-term
reversals. The indicator compares the volume flowing in and out of a security to its price
movement, and produces an oscillator (plotted below the security's performance graph).
The KVO has a complex calculation based on cumulative volume, with volume added or
subtracted according to the direction of "typical prices" and weighted by a daily range
calculation. A trend direction is determined from today's and yesterday's "typical prices" (which
are (high+low+close)/3). A "Volume Force" is then formed by accumulating volume amounts,
adding or subtracting according to the direction of the price trend, and with the values scaled by
daily and cumulative measures of the trend. The oscillator is then formed as the difference
between fast and slow EMAs (exponential moving averages) of the Volume Force. Typical
values for fast and slow EMAs are 34-periods and 55-periods, respectively.
KVO = EMA[34] of VF - EMA[55] of VF
A signal line (EMA of one quarter of the slow period) is used to trigger transaction decisions.
To interpret the KVO, look for divergence with the price to signal the coming end of a trend, or
to indicate that rising/falling prices are not forming a new trend. A buy signal is generated
when the KVO rises from below zero to cross above the trigger line. A sell signal is generated
when the KVO falls from its high and crosses below the trigger line. The KVO also uses
divergence to identify when price and volume are not confirming the direction of the move. It is
considered bullish when the value of the indicator is heading upward while the price of the
security continues to fall. Likewise, when the KVO starts decreasing but the price is increasing,
the price is likely to start decreasing.
Money Flow Index (MFI) is a momentum oscillator calculated over an n-day period, whose
value ranges from 0 to 100. MFI is similar to RSI, but measures dollar accumulation rather
than price change.
MFI = 100 * positive mf / (positive mf + negative mf)
Positive mf is the total for those days (in n) where the typical price is higher than the previous
day's typical price, and negative mf is the total for those days where the typical price is lower
than the previous day's typical price.
Since mf measures dollar volume, an up day is said to represent the enthusiasm of buyers, and
a down day the enthusiasm of sellers. An extreme MFI in one direction or the other is
interpreted as a prediction of a price reversal.
A value over 80 is generally considered to indicate an overbought condition, and a value under
20 oversold. An upward crossing through 20 is often considered a buy signal, while a
downward crossing through 80 is considered a sell. Divergences between MFI and price action
are also considered significant. For example, if price achieves a new high but the MFI peaks at
a point less than its previous high, that may suggest a likely price reversal. Many traders
simply watch for an MFI moving in the opposite direction of the price, as divergence can be a
leading indicator of a change in the trend.
If you have collected Earnings when downloading, you can plot the P/E
(price/earnings) Ratio of a security for the most recent twelve months.
Earnings may not be available for all securities, and
the Earnings figure Fundwatch collects is TTM (trailing twelve months), so it is not accurate any farther
back than one year. Companies update their earnings at different intervals so you should update Earnings
roughly once a month to be sure all values are current.
The P/E Ratio itself is plotted in the lower section of the graph, but the lower and upper thresholds for P/E Ratio
(specified in your Configuration) are indicated by dashed lines in the upper section of the graph (on the security price plot). They indicate the
price levels at which the security is above or below the associated P/E Ratio represented by each threshold.
Because the earnings figures Fundwatch uses are only valid for the trailing
twelve months, P/E Ratio is not charted, reported, or backtested beyond that
historical period. This is particularly important to remember when specifying
P/E Ratio as a backtesting
criteria, because it will not be tested any further back than the most recent
twelve months.
Developed by Welles Wilder,
Average true range (ATR) is a volatility indicator that shows how much an asset
moves, on average, during a given time frame. The indicator moves up and down as
price movements in a security become larger or smaller. It is calculated as a
moving average of the maximum True Range (TR) of each trading session, as
defined below. ATRt = (ATRt-1
* (n - 1) + TRt) / n TR = max [ (high - low),
abs(high - previous close), abs(low - previous close) ] ATR is not
a directional indicator, but a volatility indicator that reflects the degree of
interest or disinterest in a move (a gauge of trend strength). Strong moves are
often accompanied by large ATR, especially at the beginning of the move. A
bullish reversal with an increase in ATR would show strong buying pressure and
reinforce the reversal. A bearish support break with an increase in ATR would
show strong selling pressure and reinforce the support break.
Developed by Chester Keltner,
The Keltner Channel is a volatility based technical indicator composed by creating an envelope of two bands around
an exponential moving average (EMA) of the price. The upper band is two times the
Average True Range (ATR) above
the EMA, and lower band is two times the ATR below the EMA. The bands expand and contract as volatility (measured
by ATR) expands and contracts.
Since most price action will be encompassed within the Keltner Channel, moves outside the channel can signal trend
changes or an acceleration of the trend. The direction of the channel can also aid in identifying the trend direction.
Price reaching a band may indicate continuation of a trend... reaching the upper band is often seen as bullish, while
reaching the lower band is bearish.
The Keltner Channel is often used in conjunction with
Bollinger Bands. Fundwatch uses the default period
configuration
for Bollinger Bands as the default for Keltner Channel.
Developed by analyst John Carter,
The TTM Squeeze indicator identifies periods of consolidation in a market. In general the market is either
in a period of consolidation or vertical price discovery. The TTM Squeeze captures the moments where a market
is in a period of consolidation right before a big move and uses its momentum to predict the subsequent direction of that move.
The TTM Squeeze indicator is built from 3 components...
Keltner Channel, Bollinger Bands, and
Relative Strength Index.
When the Bollinger bands become so tight they are inside the Keltner Channel, the market has entered a squeeze...
a period of consolidation that is statistically primed to result in a large move. Once the Bollinger Bands expand
and again move outside the Keltner Channel, the squeeze is said to have “fired”, providing a buy or sell signal based on the value of the RSI.
Fundwatch uses the RSI to predict the direction of the breakout, however other indicators (such as momentum) can
also be used. Both the direction and magnitude of the RSI should be taken into account, as well as confluence from other indicators.
The TTM Squeeze is shown in the lower section of the graph as a solid straight line with breaks indicating squeeze
periods. The RSI is superimposed as vertical lines. Look for the moment the squeeze fires (the right edge of the
squeeze period), then note the direction and strength of the RSI at that point for a signal. Upward RSI means buy, downward means sell.
A Renko chart of the selected security can be viewed by clicking the Renko icon
on the Graph toolbar. This icon is a toggle that converts between Renko and
regular Graph modes.
Renko charts are a chart type that measures price movement independent of time. Renko
charts (the name derived from the Japanese word for “bricks”) are constructed from a series of bricks representing
price movement. Bricks are added only when price movements meet or exceed a predetermined brick size. Once price moves more than the brick size (either above or below the most recent brick), a new brick is added to the chart.
It could take several trading sessions to add a new brick, or several bricks
could be added in a single trading session. Thus the plot is
independent of time, and the time scale is not constant nor the same between
securities or selected periods (which is why other
plots and indicators cannot be superimposed).
For example, if the brick size is $2 and the last brick covers prices of $52 to $54. The new brick won’t be formed until prices close either at or above $56 or at or below $50. If
the price closes above $56,
(e.g. $57), the new brick will still stop at $56 and the threshold for a
new brick will be at $58.
Brick size is determined from the security's average true range (ATR).
Fundwatch uses a 14-period ATR by default, but this can be set in the
Configuration. When the Linear
Graph setting is used, ATR is calculated once from the most recent
trading session and a fixed brick size is used to create the entire chart. This is the convention for a short-term Renko chart.
When the Log setting is used, ATR is recalculated each day from the ATR moving average, thus the brick size will vary over time. This is generally more accurate when long time periods are charted because it filters the effect of price inflation over time.
Trading signals are typically generated when the bricks change direction. For example, a trader might sell an underlying asset when a
downward (solid) box appears at the end of a series of climbing (open) boxes. Traders
normally use Renko charts in conjunction with other technical analysis. For
example, a Renko chart may be useful for determining the prevailing trend, and then other technical indicators used to identify specific entry and exit points.
Support and Resistance Levels: Trading ranges appear when ascending and
descending series are generated between levels of support and resistance (a row
of tops or bottoms). Breakouts occur when a series continues to generate in a defined direction after a period of trading within a support/resistance-bound trading range.
Overbought/Oversold Conditions: A good example of combining indicators
with a Renko chart to identify trade signals is using
RSI to identify overbought
or oversold levels. RSI showing an overbought condition is confirmed by a Renko peak
formation.
In technical analysis, transitions between rising and falling trends are often
signaled by patterns in the price chart. A chart pattern is a recognizable
configuration of price movement identified using a series of trendlines, peaks
and/or curves. Patterns typically form when the trend "takes a break",
signifying areas of consolidation that can result in a continuation or reversal
of the prevailing trend. Volume plays a role in interpreting patterns, often
declining during the pattern's formation, and increasing as price breaks out of
the pattern. When a price pattern signals a change in trend direction, it is
known as a reversal pattern; a continuation pattern occurs when
the trend pauses briefly and then continues its current direction. Technical
analysts thus use chart patterns to forecast future trend direction.
The Portfolio Designer uses Monte Carlo simulation to help you determine the best asset allocation for a portfolio of securities of your choosing.
Overview
Thus the first steps in building an effective portfolio are 1) selecting a set of good securities that provide desired diversification,
and 2) defining investment objectives in the form of the three variables
described above.
Selecting good securities requires doing some research using Fundwatch's
analysis and Screening functions, and defining
objectives requires a realistic assessment of your financial needs.
Once data has been downloaded, the data span for each security is displayed in
the list.
Larger portfolios (more symbols) take much longer to calculate, so you will
probably want to perform experiments using only a few symbols representing broad
asset categories, or group symbols into sub-portfolios.
This report is obtained from the Portfolio Designer by pressing View Report.
This display controls the algorithm used by the
Portfolio Designer.
Backtesting (and Building Trading Systems)
Backtesting is the process of evaluating a trading strategy (or "system") by applying it to
historical data. Backtesting calculates how a trading system would have performed if it had
actually been applied in the past. A trading system consists of a set of rules or specific
conditions under which to buy or sell a security, and is meant to be applied methodically,
without the variation of emotional decisions. Backtesting a system of this nature provides
statistical measurements of its performance in real conditions.
While backtesting is a common and methodologically accepted approach to research, the
results achieved are highly dependent on the market movements of the tested period. Using
backtesting to develop a trading strategy assumes that what happened in the past will at least
resemble what happens in the future, and this assumption adds varying degrees of risk to the
strategy.
Fundwatch allows you to define a number of different Trading Systems (up to 200), each
consisting of a set of buy and sell rules based on Fundwatch's technical analysis toolkit. You
can quickly backtest a system on any individual security over any time period to get a set of
statistical results and a graphic display of buy and sell points. This is known as "single-symbol"
backtesting and produces results for only one security at a time. It is up to you to design a
system and associated testing method that targets your objectives, and to subsequently
manage a trading account containing multiple securities with margins, asset allocations, and
other considerations.
Building/Editing a Trading System
Each Trading System must have:
A Name
All Buy (or Short) rules must be satisfied to enter a position. (For a long system
this means a buy, for a short system it means a short sell.)
When a position is entered, the system is totally invested in the security (open position) until a
subsequent exit occurs (position closes). Between positions, the system is totally invested in
cash, earning your Cash ROR (Risk-Free ROR).
If your account balance is positive (as it always is in a long system) you will
earn the Cash ROR. If you have a short system with a negative balance, you
are charged the Cash ROR.
Each rule consists of a selected technical Signal (an indicator with specified parameters) and a
Condition of that signal.
Note that some Conditions are triggers, meaning they describe specific events (e.g. price
crosses up through its moving average), while others describe general conditions that may
exist for periods of time (e.g. price is above its moving average). It is common to combine
triggers with general conditions (for instance, to restrict the trigger to a certain trend), but it may
not be your intention to specify a general condition as the only rule for a buy or sell. Be
attentive to the exact Condition description when specifying rules.
Add rules using the Add Buy Rule, Add Sell Rule, Add Short Rule,
Add Close Rule, and Add Alternate Exit buttons. Once a
rule is added to its list, you can change or delete it by clicking on it in the list.
Once you've defined your rules, Click Add System to add the new system to the list of Trading
Systems. The systems in this list will be automatically saved on disk. Once a system is in the
list, you can edit it, backtest it on any security(s) over any time period, or apply it to current prices
to give buy/sell alerts.
Backtesting a Trading System
To perform a backtest (on the Backtest tab), you must select a system, a security, and a time
period (which defaults to the total span of the security). When you click the Backtest button,
the system is applied to the security over the time span, simulating all buys and sells, and
calculating associated statistics.
To backtest at a one-minute resolution over your intra-day data, set the
beginning date to Intra-Day. The time period then includes whatever
intra-day data is available (up to 5 days). Any intervals/periods in your rules
(days or weeks) will be interpreted as minutes.
The Short Sells toggle (available for long systems) causes each sell event to enter a short position instead of cash (by
default, each sell event places your investment in cash). Even if you don't want to actually
enter short positions in practice, testing with this option provides a measure of the quality of
your sell rules, and helps unbias your results to the effect of the prevailing trend. Note that
short selling causes each transaction to result in a new position, which roughly doubles your
number of closed trades and increases your time invested to nearly 100%. Also be aware that
it is possible to lose more than 100% of your investment in a short sale.
Backtest results are displayed as follows (note that all RORs are annualized):
System ROR shows the rate of return your system produced by trading the selected security.
The Graph button produces a graph of the security showing the buys (empty circles) and sells
(filled circles). Also plotted is the "equity curve" of your system, or the total return of your initial
investment as it was invested in the selected security according to your buy/sell rules. You can
add indicator plots to this graph.
Note that a System ROR that underperforms the security does not necessarily mean you have
a bad system. There are many factors to consider. If your system only keeps you invested in
the security for a brief percentage of the year, for instance, you have less market exposure risk
than if you buy and hold, and your capital is freed part of the year for other opportunities (e.g. a
mirror system on an inverse security). If you have a high success rate with each trade and very
few losing trades, that may indicate your system is reliable and only puts money in during safe
opportunities. A system that performs consistently can produce a positive return in bear
markets, or simply keep you out of the market during those times. So your objective may be to
get a consistent and safe return rather than to beat the market.
It is good to expand the number of test cases as much as possible and test over varying time
periods. Be careful not to over-optimize, or "curve-fit". It is a common mistake to tweak a
system repeatedly until it gives the best backtest results. Such activity tends to tailor a system
for previous market events which will not repeat themselves in the future. It is best to keep
systems simple, and find ones that work consistently on multiple securities and various time
periods.
Testing a Group of Securities
If you select "All" as your security selection, all securities in the selection
list will be backtested. You can use the Filter to narrow the list to a
specific group or category. When a group is selected, the test period will
default to the longest period in which data is present for every security (i.e.,
the span of the shortest security). You may select dates outside that span, but
doing so will cause some securities to be evaluated over shorter test periods,
making comparison of individual results less valid.
When the test completes, the results displayed on the Backtest display are
averages for the group. Clicking the List All button will produce a list
of results for each individual security, which can be sorted by clicking the
column header over any variable. You can also view the equity curve for any
security in the list by selecting its row and clicking the Graph button.
Applying a System to Current Prices
Once you have confidence in a certain system, you can apply it for trading pruposes by going
to the Apply to Current Prices tab and selecting a security or group of securities. The system
selected in the Trading Systems list will then be applied to your security selection(s) and
securities producing a buy condition will appear in the Buys list, while those producing a sell
condition will appear in the Sells list (regardless of whether you actually hold a position in the
security). Note that Stop-Loss and Target Profit Exit rules are not applied in this list because
Fundwatch does not track your actual transactions.
|