Microsoft Excel for Stock and Option Traders: Build Your Own Analytical Tools for Higher Returns (paperback) - Softcover

Augen, Jeff

Softcover

ISBN 10: 013340904X ISBN 13: 9780133409048

Verlag: Financial Times Prent., 2013

Inhaltsangabe

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.

Über diesen Titel

Über die Autorin bzw. den Autor

Jeff Augen, currently a private investor and writer, has spent more than a decade building a unique intellectual property portfolio of databases, algorithms, and associated software for technical analysis of derivatives prices. His work, which includes more than a million lines of computer code, is particularly focused on the identification of subtle anomalies and price distortions.

 

Augen has a 25-year history in information technology. As cofounding executive of IBM’s Life Sciences Computing business, he defined a growth strategy that resulted in $1.2 billion of new revenue and managed a large portfolio of venture capital investments. From 2002 to 2005, Augen was President and CEO of TurboWorx Inc., a technical computing software company founded by the chairman of the Department of Computer Science at Yale University. His books include Trading Realities, Day Trading Options, Trading Options at Expiration, The Option Trader’s Workbook, and The Volatility Edge in Options Trading. He currently teaches option trading classes at the New York Institute of Finance and writes a weekly column for Stocks, Futures and Options magazine.

Von der hinteren Coverseite

“Augen authors another winner. A skilled analyst and trader himself, Augen offers individuals a cutting-edge approach to analysis, utilizing simple software, which allows traders to better steer their own financial destiny. In this new book, he outlines his personal investing techniques, unlike any other technical approach I’ve ever seen. This unique book is a must-read for self-directed traders seeking to create their own tools to gain an edge in the computer-driven markets of today.”

--Kira McCaffrey Brecht, Managing Editor, SFO Magazine

 

“Jeff Augen continues his streak of great books that can help traders improve returns with a book about programming option trades that doesn’t require a quant degree to be put into action. He has done what I thought was impossible: He has written a programming guide for option traders that is interesting and actionable. This is the most interesting, understandable, and actionable guide to using Excel to trade options that I have read.”

--Mark Sebastian, COO and Director of Education, Option Pit

 

"Jeff's insights into modern-day options have provided me with several real-world trading breakthroughs. I increasingly lean on Jeff for clarity in today's hard-charging, volatile markets--I'd get my hands on everything he puts out!"

--Preston James, Founder, Traders Edge Network, LLC

 

Trade More Profitably by Exploiting Excel’s Powerful New Statistical and Data Mining Tools!

 

There’s only one way to gain a consistent edge in today’s high-speed markets: adopt the same advanced data mining and analysis techniques the institutions use. Fortunately, with Microsoft Excel and a modern PC, you can do just that. In this book, Jeff Augen covers a variety of approaches for systematically improving your trades by exploiting Excel’s most powerful new features.

 

Augen demystifies key analytical concepts and teaches all the Excel skills you’ll need. Using realistic examples, he explains everything from simple conditionals and expressions to sophisticated VBA macro programming.

 

You’ll learn to create new indicators and alerts that identify high-profit opportunities...perform statistical analyses to back-test strategies more accurately...validate, invalidate, or tune combinations of indicators across any time frame...quickly visualize enormous datasets, so hidden trends jump out at you.

 

Own Excel? Use a trading platform? You already have the tools to gain a powerful trading advantage. Get this book--and put those tools to work.

• Use Excel 2007/2010 to systematically improve the way you analyze trades
  Translate complex trading hypotheses into simple, testable Excel models
• Uncover market distortions in time to profit from them
  Profit from inefficiencies that disappear in hours, minutes, or even seconds
• Identify new correlations the market hasn’t noticed
  Perform “experiments” of virtually unlimited size, number, or complexity

Details zur Ausgabe

• Verlag: Financial Times Prent.
• Erscheinungsdatum: 2013
• Sprache: Englisch
• ISBN 10: 013340904X
• ISBN 13: 9780133409048
• Einband: Taschenbuch
• Auflage: 1
• Anzahl der Seiten: 208
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar