Finacial-Edu: Your Financial Knowledge Source
Accounting & Finance
Asset Management
Calculators & Converters
Consulting & Strategy
CRM & Sales
- more
Guides & Courses
Excel & VBA
Finance & Economics
Trading & Investing
- more
Investing & Trading
Futures & Options
IRA + 401k
Online Services
Quotes & Data
- more
Personal Finance
Credit Repair
- more
Business and Finance
Home & Education
Investing & Trading Software
PDA & Mobile
Software Development
- more
Tools & Models
Forms & Templates
Graphing & Charting Tools
Risk & Portfolio Models
Trading Models
- more

Build an Automated Trading System in Excel - Three Course Series

Price: $89.95 each



Financial-edu's three expert courses guide you step-by-step through building sophisticated trading models using Microsoft Excel. Microsoft's Visual Basic (VBA) language is used in conjunction with Excel's user interface, formulas, and calculation capabilities to deliver powerful and flexible trading tools.

Build an Automated Stock Trading System in Excel
This Online Course shows you how to build an automated stock trading model using Microsoft Excel. The Model includes five proven technical indicators (ADX, moving average crossovers, stochastics, Bollinger bands, and DMI). You are guided in a detailed fashion through creating worksheets, files, ranges, indicator formulas, control buttons, DDE/Active-X links, and code modules.
Learn More

Build an Automated Sector Fund System in Excel
This Online Course walks you through building a long term sector fund rotation model using Microsoft Excel. The System is based on the classic market economist's Sector Rotation Model. It incorporates three proven technical indicators--relative strength, moving average crossovers, and moving average slope, to identify the sector funds most likely to provide long term profits. The System can be used with any mutual fund, index fund, SPDR, ETF, future, or other index security.
Learn More

Build an Automated Spread Trading System in Excel
This Online Course shows you how to build and use an automated spread trading model in Microsoft Excel. The System captures the price difference between security pairs of any type -- indexes, stocks, futures, options, LEAPs, etc. Spread returns are typically non-correlated with other strategies, making the model an excellent addition to your trading program. The System uses three proven technical indicators--exponential moving averages, Percentage Price Oscillator (PPO), and Donchian Channels.
Learn More

EZ-Files Technical Indicators in Excel If you like to design and build your own trading models these pre-built technical indicators in Excel are tremendously helpful. EZ-Files save you countless hours of research and calculation time, and each indicator is guaranteed to have 100% correct formulas.
Learn More

What You Get With Each Course: A Tremendous 3-in-1 Value!

  • A complete how-to course PLUS VBA Code and FAQs sections
  • A complete pre-built Backtesting Model in MS Excel with graphs and trade statistics for your historical analysis
  • Fast access to the course materials

    Features & Benefits

  • Learn to integrate Excel, VBA, formulas, and data sources into a profitable trading tool
  • Acquire unique knowledge applicable to any Excel modeling or analysis project
  • Save money by eliminating recurring software costs
  • Calculate trading signals on a large number of stocks, funds, or spreads within seconds (limited only by Excel's data capacity)
  • Fast access to the course materials

    Technical Requirements

  • Microsoft Excel
  • 5 megabytes disk space (for stock data storage)
  • Intraday, daily, or weekly Open-High-Low-Close-Volume price data
  • Internet access (high speed DSL or cable modem suggested, but not necessary)
  • OPTIONAL: DDE/Active-X data import link for Excel through your data provider (advised for more than 5-10 securities, otherwise free price data from Yahoo!Finance or other source works fine)

    Frequently Asked Questions

  • What will I learn in this course? Is it something I can learn somewhere else?
    Our courses teach you how to build the components, code, formulas, and data handling architecture for functioning trading models. While it is possible to learn each part individually, no book shows you how to integrate all of these skills into a functioning trading model. Our courses provide tremendous savings in time and money by alleviating the need to discover and implement the knowledge it takes to build institutional-level trading models in Excel. The courses focus directly on building trading models without the unnecessary or over-generalized content found in most Excel and Visual Basic books. Furthermore, the knowledge is transferable to any type of trading, investment, statistical, or economic models, providing long term value far beyond the courses themselves.

  • Do the models have graphs or visual indicators?
    Yes, the models contain graphs to show historical performance and trade signals versus price. The automated trading models you build are calculation-based, rather than a graphical charting tools. The greatest strength of the models are their ability to calculate trading signals on hundreds of stocks, funds, or spreads rapidly.

  • Can the models backtest using different scenarios and indicators?
    Yes. In addition to the course materials, separate backtesting models are provided for download so you can test various stocks, funds, and spreads.

  • Do I have to build the models from scratch or do the courses come with finished models?
    The purpose of these online courses is to teach the skills and techniques of building trading models in Excel. You are required to build the model as part of the course. For convenience, each course includes a complete pre-built backtesting model incorporating the same indicators and logic. There is no substitute for building a model from the ground up in terms of knowing how it works in actual trading conditions. This is especially important for investment professionals, who must know all the details and nuances of their tools in order to meet risk and disclosure requirements.

  • Are the trading rules and logic provided?
    Yes. Each course discusses trading logic and rules in significant depth. The models are not "black boxes". You are taught how the system logic works so its strengths and weaknesses are clearly evident.

  • Do the courses come with technical support?
    Yes. Two methods of support are available: 1) An online Frequently Asked Questions section is included within each course, and 2) If the FAQs section does not answer your question, email support is available at no charge.

    Copyright 2000-2013 All rights reserved.