Microsoft Excel For Stock And Option Traders

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

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.

A top options trader shows investors how they can use certain strategies, teaches why day trading options are more practical than ever, and helps them understand trends in the options market that have leveled the playing field between large institutions and private traders.

Successful stock options trading requires extensive practice. Most options books offer theory and strategies, but don't offer the practice needed to prepare for real-world trades, where the wrong split-second decisions can cost you dearly. In The Option Trader's Workbook: A Problem-Solving Approach, expert trader Jeff Augen covers every key scenario you'll encounter in modern options trading, guides you through successful trade executions, and shows how to overcome key pitfalls that trip up most traders. You'll walk through trades designed to profit from changing prices and volatility, time decay, rapid price spikes, and many other factors. This second edition introduces powerful new techniques, and reflects the long-term impacts of the 2009 crash. New problems include: - New CBOE Weekly Options Expiration options, and their unique pricing dynamics. - Using collars, covered calls, and covered puts to structure income-generating trades with well-defined risk profiles. - Using ratio trading, VIX options, volatility ETFs, and variance trading to generate profits from shifts in volatility. Each section contains information for beginners, intermediate, and advanced traders, helping you build your skills one trade at a time, no matter how much experience you have--or how little. You'll find several hundred questions, all designed to mirror real life, and supported with clearly explained solutions.

A comprehensive guide to understanding the implications andapplications of valuing employee stock options in light of the newFAS 123 requirements Due to the new requirements of the Proposed Statement of FinancialAccounting Standards (FAS 123) released by the Financial AccountingStandards Board (FASB)-namely the fact that employee servicesreceived in exchange for equity instruments be recognized infinancial statements-companies are now scrambling to learn how tovalue and expense employee stock options (ESOs). Based on authorDr. Johnathan Mun's consulting and advisory work with the FASBconsulting projects with several Fortune 500 firms, ValuingEmployee Stock Options provides readers with a comprehensive lookat this complex issue. Filled with valuable information on binomial lattice andclosed-form modeling techniques, Valuing Employee Stock Options canhelp financial professionals make informed decisions whenattempting to ascertain the fair-market value of ESOs under the newrequirements. Johnathan Mun, PhD, MBA, MS, CFC, FRM (San Francisco, CA), is VicePresident of Analytical Services at Decisioneering, Inc., themakers of Crystal Ball analytical software. He is also the authorof Applied Risk Analysis (0-471-47885-7), Real Options Analysis(0-471-25696-X), and Real Options Analysis Course (0-471-43001-3),all of which are published by Wiley.

This comprehensive guide offers traders, quants, and students the tools and techniques for using advanced models for pricing options. The accompanying website includes data files, such as options prices, stock prices, or index prices, as well as all of the codes needed to use the option and volatility models described in the book. Praise for Option Pricing Models & Volatility Using Excel-VBA "Excel is already a great pedagogical tool for teaching option valuation and risk management. But the VBA routines in this book elevate Excel to an industrial-strength financial engineering toolbox. I have no doubt that it will become hugely successful as a reference for option traders and risk managers." —Peter Christoffersen, Associate Professor of Finance, Desautels Faculty of Management, McGill University "This book is filled with methodology and techniques on how to implement option pricing and volatility models in VBA. The book takes an in-depth look into how to implement the Heston and Heston and Nandi models and includes an entire chapter on parameter estimation, but this is just the tip of the iceberg. Everyone interested in derivatives should have this book in their personal library." —Espen Gaarder Haug, option trader, philosopher, and author of Derivatives Models on Models "I am impressed. This is an important book because it is the first book to cover the modern generation of option models, including stochastic volatility and GARCH." —Steven L. Heston, Assistant Professor of Finance, R.H. Smith School of Business, University of Maryland

“Jeff’s analysis is unique, at least among academic derivatives textbooks. I would definitely use this material in my derivatives class, as I believe students would benefit from analyzing the many dimensions of Jeff’s trading strategies. I especially found the material on trading the earnings cycle and discussion of how to insure against price jumps at known events very worthwhile.” —DR. ROBERT JENNINGS, Professor of Finance, Indiana University Kelley School of Business “This is not just another book about options trading. The author shares a plethora of knowledge based on 20 years of trading experience and study of the financial markets. Jeff explains the myriad of complexities about options in a manner that is insightful and easy to understand. Given the growth in the options and derivatives markets over the past five years, this book is required reading for any serious investor or anyone in the financial service industries.” —MICHAEL P. O’HARE, Head of Mergers & Acquisitions, Oppenheimer & Co. Inc. “Those in the know will find this book to be an excellent resource and practical guide with exciting new insights into investing and hedging with options.” —JIM MEYER, Managing Director, Sasqua Field Capital Partners LLC “Jeff has focused everything I knew about options pricing and more through a hyper-insightful lens! This book provides a unique and practical perspective about options trading that should be required reading for professional and individual investors.” —ARTHUR TISI, Founder and CEO, EXA Infosystems; private investor and options trader In The Volatility Edge in Options Trading, leading options trader Jeff Augen introduces breakthrough strategies for identifying subtle price distortions that arise from changes in market volatility. Drawing on more than a decade of never-before-published research, Augen provides new analytical techniques that every experienced options trader can use to study historical price changes, mitigate risk, limit market exposure, and structure mathematically sound high-return options positions. Augen bridges the gap between pricing theory mathematics and market realities, covering topics addressed in no other options trading book. He introduces new ways to exploit the rising volatility that precedes earnings releases; trade the monthly options expiration cycle; leverage put:call price parity disruptions; understand weekend and month-end effects on bid-ask spreads; and use options on the CBOE Volatility Index (VIX) as a portfolio hedge. Unlike conventional guides, The Volatility Edge in Options Trading doesn’t rely on oversimplified positional analyses: it fully reflects ongoing changes in the prices of underlying securities, market volatility, and time decay. What’s more, Augen shows how to build your own customized analytical toolset using low-cost desktop software and data sources: tools that can transform his state-of-the-art strategies into practical buy/sell guidance. An options investment strategy that reflects the markets’ fundamental mathematical properties Presents strategies for achieving superior returns in widely diverse market conditions Adaptive trading: how to dynamically manage option positions, and why you must Includes precise, proven metrics and rules for adjusting complex positions Effectively trading the earnings and expiration cycles Leverage price distortions related to earnings and impending options expirations Building a state-of-the-art analytical infrastructure Use standard desktop software and data sources to build world-class decision-making tools

Equity and index options expire on the third Friday of each month. As that moment approaches, unusual market forces create option price distortions, rarely understood by most investors. These distortions give rise to outstanding trading opportunities with enormous profit potential. In Trading Options at Expiration: Strategies and Models for Winning the Endgame, leading options trader Jeff Augen explores this extraordinary opportunity with never-before published statistical models, minute-by-minute pricing analysis, and optimized trading strategies that regularly deliver returns of 40%-300% per trade. You’ll learn how to structure positions that profit from end-of-contract price distortions with remarkably low risk. These strategies don’t rely on your ability to pick stocks or predict market direction and they only require one or two days of market exposure per month. Augen also discusses: · Three powerful end-of-cycle effects not comprehended by contemporary pricing models · Trading only one or two days each month and avoiding overnight exposure · Leveraging the surprising power of expiration-day pricing dynamics If you’re looking for an innovative new way to reignite your returns no matter where the markets move, you’ve found it in Trading Options at Expiration. “Learn and profit from Jeff Augen’s book: It clearly explains how to take advantage of market inefficiencies in collapsing implied volatility, effects of strike price, and time decay. A must-read for individuals who are options oriented.” --Ralph J. Acampora, CMT, Director of Technical Analysis Studies, New York Institute of Finance “A fantastic, insightful book full of meticulously compiled statistics about anomalies that surround option expiration. Not only does Augen present a set of effective trading strategies to capitalize on these anomalies, he walks through the performance of each across several expirations. His advice is practical and readily applicable: He outlines common pitfalls, gives guidance on timing your executions, and even includes code that can be used to perform the same calculations he does in the text. A thoroughly enjoyable read that will give you a true edge in your option trading.” --Alexis Goldstein, Vice President, Equity Derivatives Business Analyst “Mr. Augen makes a careful and systematic study of option prices at expiration. His translation of price behavior into trading strategy is intriguing work, and the level of detail is impressive.” --Dr. Robert Jennings, Professor of Finance, Indiana University Kelly School of Business “This book fills a gap in the vast amount of literature on derivatives trading and stands out for being extremely well written, clear, concise, and very low on jargon--perfect for traders looking to evolve their equity option strategies.” --Nazzaro Angelini, Principal, Spearpoint Capital “Instead of considering macro-time strategies that take weeks to unfold, Jeff Augen is thinking micro here--hours or days--specifically the days or hours right before expiration, and harnessing grinding, remorseless options decay for profit. He builds a compelling case for the strategy here. The concept of using ratio spreads plus risk management for as brief a period as one day--open to close--to capture expiring premium is worth the price of admission alone. A superb follow-up to his first book. Must-read for the serious options student.” --John A. Sarkett, Option Wizard software