文档介绍：Creating an Automated Stock Trading System in Excel
Automated Stock Trading System
/automatedstocktradingsystem
Copyright (c) 2008, ConnectCode Pte Ltd.
All Rights Reserved.
ConnectCode accepts no responsibility for any adverse affect that may result from undertaking our
training.
Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. All other product
names are trademarks, registered trademarks, or service marks of their respective owners
Table of Contents
1. Introduction ........................................................................................................................... 1-1
2. Download Stock Trading Prices .......................................................................................... 2-2
Download Data from Yahoo Finance ......................................................................... 2-2
Sort the Data ................................................................................................. 2-5
Automating the download of Stock Prices ................................................................. 2-6
3. Moving Average Trends ....................................................................................................... 3-8
Simple Moving Average ............................................................................................. 3-8
10 Days Moving Average .............................................................................. 3-8
14 Days Moving Average .............................................................................. 3-8
20/30 Days Moving Average ......................................................................... 3-9
Charting the Moving Average ....................................................................... 3-9
Using the Moving Average ....................................................