Home > Excel Catalog > 

Stock Investment With Excel

Build an Automated Stock Trading System in Excel 
Online course shows you how to build a sophisticated automated stock trading model using Excel. VBA is used with Excel's user interface and formulas to deliver a powerful and flexible trading tool. Includes five proven technical indicators: ADX, moving average crossovers, stochastics, Bollinger bands, and DMI. System operates with your choice of free ASCII text files available on the internet, or a subscription data service.
...Additional Keywords: Excel, training, VBA, Visual Basic, Stock Trading.

Build an Automated Excel Spread Trading System
Online course shows you how to build and use an automated spread trading system. Captures the price difference between security pairs of any type -- indexes, stocks, futures, options, LEAPs, etc. Uses three proven technical indicators--exponential moving averages, Percentage Price Oscillator (PPO), and Donchian Channels to filter and capture situations where spread movement (and hence risk-adjusted profits) are likely to be greatest. Includes a complete back-testing model -- simply import historical data and see statistical and graphical results for your chosen spread strategy.
...Additional Keywords: Excel, training, Spread Trading, Securities, Spread Strategies, Futures Spreads, Market Data.

Build an Automated Sector Fund System in Excel
Online course shows you how to build a long-term sector fund rotation model using Excel. The System is based on the classic market economist's Sector Rotation Model, providing several crucial improvements that eliminate the guesswork in timing fund switches. Over long periods, the author says, the system can outperform diversified buy and hold mutual fund investing by a factor of 2-4 times.
...Additional Keywords: Excel, VBA, Visual Basic, training, Sector Fund Rotation,  Investment Tool, Mutual Fund, Index Fund, SPDR, ETF, Index Security.

EZ-Files Technical Indicator Library
Contains 26 technical indicators pre-built in Excel. These are useful for constructing securities trading, technical analysis, or statistical models in Excel. Saves you countless hours of research and calculation time, and each indicator is guaranteed to have 100% correct formulas. Can be combined to build sophisticated trading models that perfectly suit your particular investment criteria.
...Additional Keywords: Excel, training, Regression, Triangular Moving Average, Sine-Weighted Moving Average, Average Directional Movement Index, Vertical Horizontal Filter, Oscillators, Commodity Channel Index, Percentage Price Oscillator, Stochastic Oscillator, Williams %R, Volatility Indicators, Bollinger Bands, Standard Deviation, Average True Range, Momentum and Strength Indicators, Moving Average, Convergence-Divergence, Relative Strength Index, Chaikin Oscillator, Momentum Oscillator, Rate of Change, Volume Indicators, On Balance Volume, Accumulation/Distribution Line, Money Flow Index, Chaikin Money Flow, Percentage Volume Oscillator, Intermarket and Breadth Indicators, Dual-Market Percentage Price Oscillator, Percentage Price Relative, Intermarket Spread.

XLChart Pro -- Point and Figure Charts in Excel
Produce point and figure charts in Excel, choosing from a variety of scales, number of reversals, and box sizes. Over 2000 satisfied clients in 25 Countries. Overlay moving averages using volume-weighted moving averages and volume histograms. Fine tune the configurable trend lines to suit your trading or investing style.

XLTradeLink
Link your trading and investing data into Excel using this add-in. XLTradeLink will link data from Metastock, Ezycharts, and CSV (text). All links are remembered and can be refreshed for new data. Use the Internet Downloader to download historical data from 49 global exchanges.

XLChartPro & XLTradeLink Bundle
XLChartPro creates Point and Figure Charts with Excel Workbooks. Configurable Number of reversals and box sizes. Choose from three different vertical axis scaling and overlay with volume histograms, trend lines and moving averages. XLTradeLink links data from Metastock, Ezycharts, and text files into Excel. Also comes with Internet downloader for 49 Global Exchanges.

XLInvestor
XLInvestor, through an easy-to-use wizard, adds 90 investing-related functions to Excel. These include: Bollinger Bands, Aroon, Chaikin, Klinger Oscillator,  numerous moving averages, and much more.

DownloaderXL
Download free current and historical stock quotes from USA, Europe, and Canada into Excel spreadsheets. Download mutual funds, corporate bonds, major USA market indices, major world indices. Daily, weekly, and monthly quotes.

AnalyzerXL Package
Technical analysis in Excel includes 146 indicators. Includes free downloads of historical stock quotes from USA, Europe, and Canada into Excel spreadsheets. The best way to start technical Analysis for the beginner.