Home > Excel Business Solutions > Financial Markets > Technical Analysis > Technical Analysis Functions Share

Technical Analysis Functions

Excel technical analysis functions for technical analysis

Excel Technical Analysis Functions

Rate this solution:
(4.3/5 from 14 votes)
Technical Analysis Functions screenshot
Technical Analysis Functions for Excel (Analyzer XL) is a library of 146 technical analysis functions, indicators and experts in the form of Excel formulas. An indicator is used to determine the trend of a market, the strength of the market and the direction of the market. An expert is a predefined stock market system. All 146 formulas include wizards that make entering data easy.

The Technical Analysis Function's seamless integration with Excel provides opportunities for customization that are just not possible with competing software packages. With knowledge of VBA, traders can easily develop custom indicators and experts in a fraction of the time it would take with other software. Users can also create and name macros using the AnalyzerXL interface.

Types of technical analysis functions:
An indicator is used to determine the trend of a market, the strength of the market and the direction of the market. Expert functions produce special outputs, such as Buy/Sell signals, trend directions and more.

Types of outputs:
All technical analysis functions are categorized by the type of output they produce. There are two types of outputs: Formulas and Values. Formulas are automatically re-calculated when you change input data, whereas Values remain the same. With Formulas, you do not need to re-enter range references or function parameters when you update data.

Key features include:
  • 146 technical analysis functions, indicators, and experts
  • Built-in charts for more accurate analysis
  • Macro creation and management

Technical Analysis Functions for Excel is a package that together with the technical analysis component includes:
  • Downloader XL - downloads free historical stock, index and mutual fund data from Yahoo! Finance. Historical data is available from exchanges in the USA, Canada, UK, Ireland, Germany, France, Italy, Australia, New Zealand, India and more.
  • BulkQuotes XL - designed to handle easily downloads and updates for tens or hundreds of tickers simultaneously. BulkQuotes XL is designed as an Excel add-in, giving you great flexibility and allowing you immediately to apply technical analysis to downloaded data. You can even have your own macros applied instantly to all your tickers.
  • RTQuotes XL - downloads real-time stock, index, futures, options and mutual fund quotes directly into Microsoft Excel spreadsheets. Free 15-minute delayed and fee-based real-time quotes for stocks, options, indexes, and mutual funds are retrieved from Yahoo! Finance. Data is available from more than 50 worldwide markets, including the US, Canada, UK, Germany, France, Italy, Australia, and India. Fee-based real-time quotes are available from PCQuote for stocks, options, indexes, and futures.
  • Portfolio XL - a portfolio tracking add-in for Microsoft Excel. It allows you to create a portfolio of stocks which can be updated intraday. You specify certain tickers, the purchase price and date, and Portfolio XL monitors the price value of your portfolio and your transaction history. It also displays the current value of your stocks.
  • Options XL - an option chains and LEAPS series download tool for Microsoft Excel. It downloads chains for options traded on these exchanges: CBOE (Chicago Board Options Exchange), AMEX (American Stock Exchange), PHLX (Philadelphia Stock Exchange), PCX or PSE (Pacific Stock Exchange), ISE (International Securities Exchange).

Version upgrades are free for life.

Try It  Get It

(Pricing is available on the next page)
(Updated on 2023-12-01)

Related Excel Solutions for Technical Analysis Functions

Portfolio OptimizationPortfolio Management  Download Market DataMarket Data Access  Complete Trading SystemTechnical Analysis  Technical IndicatorsTechnical Analysis  Trading IndicatorsTechnical Analysis  Derivatives AnalysisTechnical Analysis  Financial Investment ToolsTechnical Analysis

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.