Home > Store > Finance & Investing > Investing
Microsoft Excel for Stock and Option Traders: Build Your Own Analytical Tools for Higher Returns
- By Jeff Augen
- Published Apr 18, 2011 by FT Press.
- Copyright 2011
- Dimensions: 5-3/8" x 8"
- Pages: 208
- Edition: 1st
- Book
- ISBN-10: 0-13-713182-8
- ISBN-13: 978-0-13-713182-2
Register your product to gain access to bonus material or receive a coupon.
Product Author Bios
Jeff Augen (Carmel, NY), now a private investor and writer, has spent over a decade building a unique intellectual property portfolio of algorithms and software for technical analysis of derivatives, including 1+ million lines of computer code embodying powerful new options trading strategies. As founding executive of IBM’s Life Sciences Computing business, he defined a growth strategy leading to $1.2B of new revenue. His books include Trading Realities, Day Trading Options, and The Options Trader Workbook. He teaches advanced options at NYIF.
Trade more profitably by exploiting Microsoft Excel’s powerful statistical and data mining tools:
· Uncover subtle anomalies and distortions that signal profit opportunities
· Create powerful new custom indicators, alerts, and trading models
· Visualize and analyze huge amounts of trading data with just a few clicks
· Powerful techniques for every active investor who can use Excel
Now that high-speed traders dominate the market, yesterday’s slower-paced analysis strategies are virtually worthless. To outperform, individual traders must discover fleeting market trends and inefficiencies and act on them before they disappear. Five years ago, this required multimillion-dollar data mining and analytical infrastructures. Today, traders can use Excel with the help of world-class trader Jeff Augen’s Microsoft Excel for Stock and Option Traders: Build your Own Analytical Tools for Higher Returns.
Augen shows how to use Excel 2007 or 2010 to uncover hidden correlations and reliable trade triggers based on subtle anomalies and price distortions, create and test new hypotheses others haven’t considered, and visualize data to reveal insights others can’t see!
"Jeff Augen turns things inside out in his remarkable and challenging book Microsoft Excel for Stock and Option Traders."
- John A. Sarkett, SFO Magazine, October 2011
|
44 of 49 people found the following review helpful
This review is from: Microsoft Excel for Stock and Option Traders: Build Your Own Analytical Tools for Higher Returns (Hardcover)
Now that I'm trading options full time on my own, I need to do my own quantitative analysis. Despite having have an MBA in finance from Wharton and being in the investment management business for 25 years, I didn't have the practical, day to day skills to effectively analyze large datasets for the purpose of separating merely OK trades from the great ones (I had always relied on my firms' quantitative analysts to do the work for me). This book is ideal for traders who have come to realize that one must do at least some degree of proprietary quantitative research to consistently make money. In all his books (and I've read all of Jeff Augen's books--I think they are an immensely important body of work), Augen emphasizes that there are no shortcuts or easy formulas to successful trading--certainly none that you will find included in a trading platform or through some webinar. (If you believe that someone is going to give you the key to making easy money, Augen's books are not for...
Read more
43 of 49 people found the following review helpful
By
Amazon Verified Purchase(What's this?)
This review is from: Microsoft Excel for Stock and Option Traders: Build Your Own Analytical Tools for Higher Returns (Kindle Edition)
Having benefited significantly from his earlier two books (The Volatility Edge in Options Trading: New Technical Strategies for Investing in Unstable Markets and Trading Options at Expiration: Strategies and Models for Winning the Endgame), I was very eager to read this book - despite Augen's previous book Trading Realities: The Truth, the Lies, and the Hype In-Between was eminently forgettable. This one is mostly disappointing "book". The issue is not that there are no good ideas here - but the "book" at best has material sufficient for a decent paper in a...
Read more
10 of 11 people found the following review helpful
Amazon Verified Purchase(What's this?)
This review is from: Microsoft Excel for Stock and Option Traders: Build Your Own Analytical Tools for Higher Returns (Hardcover)
"Microsoft Excel for Stock and Option Traders" is the first major book of its kind. It guides you step by step in building your own analytical tools for generating more profitable returns. Chapter 1 presents the value of utilizing this information. The chapter has 10 sub chapters that discuss how data mining can identify great trading opportunities. It provides examples of how using data on stocks and ETFs can allow you to identify unique changes that can be developed into proper trading strategies. This section demonstrates how using data entered into Microsoft Excel can be used in practical ways to benefit your trading. This is an excellent presentation of this material and has practical uses. Chapter 2 shows how to obtain quality data on stocks and ETFs and getting it into Excel for analysis. To my knowledge this Chapter is the first clear presentation of how to use these powerful tools to make our own data bases for analysis. This chapter has 12 sub chapters that cover...
Read more
|
› See all 17 customer reviews...
Online Sample Chapter
Sample Pages
Download the sample pages (includes Preface and Index)
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

This book is temporarily out of stock, but will ship for free when in stock.
Book
$49.99
$39.99
We're temporarily out of stock, but order now and we'll send it to you later.
This book is temporarily out of stock, but will ship for free when in stock.
eBook (Watermarked)
$49.99
$39.99
Includes EPUB, MOBI, and PDF
About eBook Formats
This eBook includes the following formats, accessible from your Account page after purchase:
EPUBThe open industry format known for its reflowable content and usability on supported mobile devices.
MOBIThe eBook format compatible with the Amazon Kindle and Amazon Kindle applications.
PDFThe popular standard, used most often with the free Adobe® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discretely watermarking it with your name, making it uniquely yours.
- Request an Instructor or Media review copy.
- Corporate, Academic, and Employee Purchases
- International Buying Options
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.

