Home > Store > Finance & Investing > Investing

larger cover

Add To My Wish List

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.

  • Description
  • Reviews
  • Sample Content

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

Customer Reviews

44 of 49 people found the following review helpful
5.0 out of 5 stars Better trading through analysis, May 3, 2011
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
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


43 of 49 people found the following review helpful
3.0 out of 5 stars A few good ideas...but..., April 30, 2011
By 
Sreeram Ramakrishnan (Lynnfield, MA) - See all my reviews
(VINE VOICE)    (REAL NAME)   
Amazon Verified Purchase(What's this?)
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
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


10 of 11 people found the following review helpful
5.0 out of 5 stars Long overdue: A must read for the serious option trader, May 16, 2011
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
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Share your thoughts with other customers:
 See all 17 customer reviews...

Online Sample Chapter

Preface to Microsoft Excel for Stock and Option Traders: Build Your Own Analytical Tools for Higher Returns

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

 
Best Value

Book + eBook Bundle  $99.98  $57.49

Book Price $39.99
eBook Price $17.50
eBook formats included

Buy

This book is temporarily out of stock, but will ship for free when in stock.

Buy

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.

Buy

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:

ePubEPUBThe open industry format known for its reflowable content and usability on supported mobile devices.

MOBIMOBIThe eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

Adobe ReaderPDFThe 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.

Purchase Reward: One Month Free Subscription
By completing any purchase on FT Press, you become eligible for an unlimited access one-month subscription to Safari Books Online.

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.