Back to skip links

Additional product details

eText: 
ISBN-10 0132822180ISBN-13 9780132822183
Print: 
ISBN-10 0-13-713182-8ISBN-13 978-0-13-713182-2
Author(s): Jeff Augen
Publisher: FT Press
Copyright year: © 2011 Pages: 208
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.

Three Ways to Study
with eTextbooks!

  • Read online from your computer or mobile device.
  • Read offline on select browsers and devices when the internet won't be available.
  • Print pages to fit your needs.

CourseSmart eTextbooks let you study the best way – your way.