Product Cover Image

Microsoft Excel for Stock and Option Traders: Build Your Own Analytical Tools for Higher Returns, CourseSmart eTextbook

By Jeff Augen

Published by FT Press

Published Date: Apr 6, 2011

More Product Info

Description

Virtually every active trader or investor uses Microsoft Excel. During the past few years, however, Excel has evolved into a powerful analytical tool that can be used for complex statistical analysis and to create new indicators and custom charts. Few investors understand how to exploit these capabilities. This book is designed to show average investors how they can use the power of Excel to gain an advantage in the marketplace by designing their own analytical tools and indicators. This book is 100% focused on using Excel for trading and investing, and delivers many useful programs and macros that can be directly copied and implemented. Augen discusses specific approaches for creating and testing new custom indicators, provides step-by-step guidance on creating new statistical analysis techniques and new data visualization strategies that any investor can utilize with just a few simple commands.

 

Augen also walks investors through constructing massive price history databases that exploit Excel’s 1,000,000-row capability—and using them to pursue data-mining strategies and statistical analyses.

Table of Contents

Preface     1

Chapter 1: Introduction--The Value of Information     7

Chapter 2: The Basics     63

Chapter 3: Advanced Topics     153

Index     187

Purchase Info ?

With CourseSmart eTextbooks and eResources, you save up to 60% off the price of new print textbooks, and can switch between studying online or offline to suit your needs.

Once you have purchased your eTextbooks and added them to your CourseSmart bookshelf, you can access them anytime, anywhere.

Buy Access

Microsoft Excel for Stock and Option Traders: Build Your Own Analytical Tools for Higher Returns, CourseSmart eTextbook
Format: Safari Book

$24.99 | ISBN-13: 978-0-13-282218-3