This online course shows you how to build a sophisticated automated stock trading model using MS Excel. Microsoft's Visual Basic (VBA) language is used in conjunction with Excel's user interface, formulas, and calculation capabilities to deliver a powerful and flexible trading tool. The Model includes five proven technical indicators (ADX, moving average crossovers, stochastics, Bollinger bands, and DMI). You are guided step-by-step through creating worksheets, files, ranges, indicator formulas, control buttons, DDE/Active-X links, and code modules. Build the model, import the price data, run the model by clicking a button, and make your trading decisions. Uses both trend-trading and swing-trading features. Operates with your choice of FREE ASCII .TXT files available on the internet, or a subscription data service. Can be used alone or in conjunction with your existing fundamental and market analysis to improve investment timing and avoid unprofitable situations. A complete PDF Guide is provided so you can choose how to learn in the most comfortable way. A separate pre-built Backtesting Model is also included for historical analysis and testing various stocks and time periods.
What You Get: A TREMENDOUS 3-IN-1 VALUE!
- A PDF Guide showing you how to build and use the model
- An Online Course including everything in the PDF Guide PLUS VBA Code and FAQs sections
- A pre-built Backtesting Model in MS Excel with graphs and trade statistics
- 60 days of online access to download the materials and take the course
Benefits
- Learn to integrate Excel, VBA, formulas, and data sources into a trading tool
- Acquire unique knowledge for any Excel modeling project
- Save money by eliminating recurring software costs
- Calculate trading signals on hundreds of stocks within seconds
Technical Requirements
- MS Excel for Windows
- Adobe Acrobat Reader
- 5Mb disk space
- Daily Open-High-Low-Close stock data
- OPTIONAL: DDE price import link for Excel
Software related to Build an Automated Stock Trading System
System Fibonacci Excellent looking charts with Fibonacci Arcs and Trends. Download historical prices for free as provided by Yahoo Finance to create sophisticated charts with candlesticks, lines, price points and even zigzag lines.
System Fibonacci FX Excellent looking charts with Fibonacci retracemenst, projections, arcs, fans and 2 trends. Download historical prices for free from Yahoo Finance to create sophisticated charts. Import any valid financial data csv file including foreing exchange.
Jigaro Fibonacci Market Timer 3.0.0.5 The Jigaro Fibonacci Market Timing principle is based on the Dow theory, the Elliot Wave principle and the Fibonacci percentages. Even though there is no absolute certainty in the market, the use of this tool in combination with the proper technical analysis, will greatly enhance your chances at making better investing decisions. Suitable for Forex trading as well.
Equity Rider Standard Edition, monthly EquityRider is an advanced stock charting and trading systems analysis software for many markets: stocks, forex, and futures. It allows you to create custom indicators, derive indicators based on standard ones, and plot them on charts Real-Time
Jigaro Fibonacci Market Timer The Jigaro Fibonacci Market Timer principle is based on the Dow theory, the Elliot Wave principle and the Fibonacci percentages. Even though there is no absolute certainty in the market, this tool will enhance your investing decision making.
OTCBB Penny Stock Browser 1.0 Free OTCBB penny stock screener & research tool. Scan, analyze and screen for penny stocks using this all-in-one browser. Look up company profiles, news, level II quotes, trading signals and more. Get the latest trading alerts from multiple sources and scan the top investment sites which offer penny stock analysis. Simple and it works!
Pikker Dynamic portfolio rotation trading system. A new dimension in technical analysis. Matrix calculations of a list of securities over a date range allow for stock rotation through a portfolio, and a new category of "Market Breadth" indicators.
TSXV Penny Stock Browser 1.0 Free TSXV penny stock screener & research tool. Scan, analyze and screen for penny stocks using this all-in-one browser. Look up company profiles, news,market depth, trading signals and more. Get the latest trading alerts from multiple sources and scan the top investment sites which offer penny stock analysis. Simple and it works!
Traders Log Traders Log is a software trading diary. Calculate position size and risk on capital. Add comments, pictures and information about your trades. Will show over 20 statistics on your trading.
Stock NeuroMaster Stock NeuroMaster is a stock prediction tool based on Neural Networks with advanced technical analysis module. Supported data sources: CSV, Metastock database and free online stock quotes. Maximize your profit by predicting the best BUY/SELL moments.
