Safari, the world’s most comprehensive technology and business learning platform.

Find the exact information you need to solve a problem on the fly, or go deeper to master the technologies and skills you need to succeed

Start Free Trial

No credit card required

O'Reilly logo
Microsoft Excel for Stock and Option Traders: Build Your Own Analytical Tools for Higher Returns

Book Description

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