Download Build an Automated Stock Trading System in Excel
Over 28,629 Win x64 downloads! Bookmark Now!

Windows 64 bit Software - the latest is here right now! But that's not all. We update our collections every single minute -

Home > >


Build an Automated Stock Trading System in Excel  

Build an Automated Stock Trading System in Excel 1 Windows

    Platform: Win95,WinNT,Windows 2000,WinXP,Win98,Windows Server 2003,.NET Windows,.NET Cross-Platform,XP Tablet PC,Windows XP x64,Windows Server 2003 x64,.NET 2.0 Windows,Windows Vista
Download Build an Automated Stock Trading System in Excel Now
  Buy Now     
Size: 1 MB $ 89.95  
This Online Course shows you step-by-step how to build a sophisticated automated stock trading model using Microsoft 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 in a detailed fashion through creating worksheets, files, ranges, indicator formulas, control buttons, DDE/Active-X links, and code modules. The model incorporates both trend-trading and swing-trading features. The swing-trading feature can be turned on or off, depending upon your investing style. After building the model, you simply import the data you need, run the model automatically with a click of a button, and make your trading decisions.

The system operates with your choice of FREE ASCII .TXT files available on the internet (from Yahoo!Finance or other provider), or your subscription data service (with our without a DDE link). The model can be used alone or in conjunction with your existing fundamental and market analysis to improve investment timing and avoid unprofitable situations.

A separate pre-built Backtesting Model is also included for historical analysis and testing various stocks and time periods.

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

-A complete Online Course PLUS VBA Code and FAQs sections
-Detailed instructions on importing prices into Excel using eSignal QLink and Yahoo!Finance
-A complete pre-built Backtesting Model in MS Excel with graphs and trade statistics for your historical analysis
-60 days of online access to access the course materials and learn how to build and use your new Trading Model

Features & Benefits

-Access to the course materials with your own login and password
-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)

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 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)

Table of Contents

Introduction
Basic Technical Requirements
The 5 Technical Indicators
Step 1: Average Directional Movement Index (ADX)
Step 2: Trending or Oscillating?
Step 2A: Trending = Moving Average Crossovers
Step 2B: Oscillating = Stochastic Oscillator
Step 3: Timing the Buy/Sell Signals with Bollinger Bands
Step 4: Enhancing Percentage Trade Success with the DMI
System Architecture
Setting Up
Building the Directory and File Structure
Building the Spreadsheet Structure
Building the Indicator Formulas
Market Data
ADX Indicator
Moving Averages
Stochastic
Bollinger Bands
DMI
Building the Macro Code
Step 1: Opening the Visual Basic Editor window
Step 2: Writing the Macro Code
Step 3: Checking the Code for Errors
What the Code Does
Building the Signals/ Sheet
Step 1: Signals/ Sheet Labels and Formulas
Step 2: Build the Ranges
Step 3: Adding a Control Button and Assigning a Macro
Step 4: Formatting the worksheet
Building the Data Source File
Loading Data from Other Sources
Loading .CSV or .TXT Files
Getting FREE Historical Data from Yahoo! Finance
Running the Model on a Daily Basis
When to Run the Model
Combining the Signals with Other Market Information
Money and Risk Management
Common Macro Errors
FAQs
Backtesting the model

Login Delivery

You will receive an email at the address you provided during the payment process to access the online materials. We generally email usernames and passwords within 48 hours of purchase (usually much sooner). In some cases (due to holidays, weekends, or technical difficulties) it may take longer than 48 hours.
Click to view Build an Automated Stock Trading System in Excel screenshots
Click to Enlarge
Publisher: Alpha Squared Management | More by Alpha Squared Management | Visit Home Page
Downloads: so far this month, 0 last month, 449 total
License: Shareware $ 89.95
Last updated: More than a year ago ( 2 Oct 09)
Install support: Install and Uninstall
Watch for updates:
Want to be notified when Build an Automated Stock Trading System in Excel is updated?
(no spam, just a single confirmation email)
Subscribe

Tell a friend... | Add to My CD | What's on My CD
User Rating: 5.00 / 5
Rated by: 2 user(s)
5.00 out of 5 stars
User 5.00/5 stars User 5.00/5 stars User 5.00/5 stars User 5.00/5 stars User 5.00/5 stars  
Ask a question about Build an Automated Stock Trading System in Excel

Add this link to your website:

Or to a forum:


PayWindow Payroll System - Winner of Best Business Application Award, and the People's Choice, Best Business Application Award at the Shareware Industry Conference Awards. Pay by any pay period; hourly, salaried,... ...
Multilingual Stock Exchange & Investment Dictionary Screen shot

Multilingual Stock Exchange & Investment Dictionary

This Multilingual Dictionary of Stock Exchange & Investment Terms contains an extensive vocabulary, covering a wide...

Shareware | $ 19.26
Peachtree Password Recovery (for personal use) buy, download and review

Peachtree Password Recovery (for personal use)

Peachtree Password Recovery is a tool that instantly recovers passwords for Peachtree Accounting company files...

Shareware | $ 29.95
MLDownloader buy, download and review

MLDownloader

MLDownloader downloads intraday, end of day and historical stock quotes, Options and Futures from various Internet...

Shareware | $ 58.47
Zorro MT4 Bridge buy, download and review

Zorro MT4 Bridge

Zorro is a robot platform and development system for automated trading strategies. It supports Gamestudio's lite-C...

Shareware | $ 19.51
MLDownloader buy, download and review

MLDownloader

MLDownloader downloads intraday, end of day and historical stock quotes, Options and Futures from various Internet...

Shareware | $ 58.47
VMInvoice Invoices Management PRO (12 months license) buy, download and review

VMInvoice Invoices Management PRO (12 months license)

VMInvoice - Invoices Management Fast and easy software to create, manage, print and email invoices. VMInvoice is...

Shareware | $ 57.55
MYOB Password Recovery (for personal use) buy, download and review

MYOB Password Recovery (for personal use)

MYOB Password Recovery is a solution that instantly recovers passwords for MYOB Accounting files. All passwords are...

Shareware | $ 29.95
MYOB Password Recovery (for business use) buy, download and review

MYOB Password Recovery (for business use)

MYOB Password Recovery is a solution that instantly recovers passwords for MYOB Accounting files. All passwords are...

Shareware | $ 59.95
ReNoNet Add-In (1-2 User) buy, download and review

ReNoNet Add-In (1-2 User)

Sorry, German Text only ReNoNet ist ein fur den Einsatz in kleinen Netzwerken geeignetes Tools zum Einfugen und...

Shareware | $ 28.29
Friscal Screen shot

Friscal

Friscal is both a FOREX risk calculator as well as a useful toolkit for assisting you with your FOREX currency...

Shareware | $ 25.00