Applied Portfolio Management Theories with VBA and Excel
| Author | : Rachel Stark |
| Publisher | : |
| Total Pages | : 114 |
| Release | : 2013 |
| Genre | : Investment analysis |
| ISBN | : |
Applied Portfolio Management Theories With Vba And Excel
Download Applied Portfolio Management Theories With Vba And Excel full books in PDF, epub, and Kindle. Read online free Applied Portfolio Management Theories With Vba And Excel ebook anywhere anytime directly on your device. Fast Download speed and no annoying ads. We cannot guarantee that every ebooks is available!
Essentials of Applied Portfolio Management
| Author | : Massimo Guidolin |
| Publisher | : |
| Total Pages | : 249 |
| Release | : 2016 |
| Genre | : Business & Economics |
| ISBN | : 9788899902056 |
Advanced Modelling in Finance using Excel and VBA
| Author | : Mary Jackson |
| Publisher | : John Wiley & Sons |
| Total Pages | : 276 |
| Release | : 2006-08-30 |
| Genre | : Business & Economics |
| ISBN | : 0470061669 |
This new and unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. Advanced Modelling in Finance provides a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. The book adopts a step-by-step approach to understanding the more sophisticated aspects of Excel macros and VBA programming, showing how these programming techniques can be used to model and manipulate financial data, as applied to equities, bonds and options. The book is essential for financial practitioners who need to develop their financial modelling skill sets as there is an increase in the need to analyse and develop ever more complex 'what if' scenarios. Specifically applies Excel and VBA to the financial markets Packaged with a CD containing the software from the examples throughout the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Portfolio Theory and Management
| Author | : H. Kent Baker |
| Publisher | : Oxford University Press, USA |
| Total Pages | : 802 |
| Release | : 2013-03-07 |
| Genre | : Business & Economics |
| ISBN | : 0199829691 |
Portfolio Theory and Management examines the foundations of portfolio management with the contributions of financial pioneers up to the latest trends. The book discusses portfolio theory and management both before and after the 2007-2008 financial crisis. It takes a global focus by highlighting cross-country differences and practices.
Robust Equity Portfolio Management
| Author | : Woo Chang Kim |
| Publisher | : John Wiley & Sons |
| Total Pages | : 256 |
| Release | : 2015-11-25 |
| Genre | : Business & Economics |
| ISBN | : 111879737X |
A comprehensive portfolio optimization guide, with provided MATLAB code Robust Equity Portfolio Management + Website offers the most comprehensive coverage available in this burgeoning field. Beginning with the fundamentals before moving into advanced techniques, this book provides useful coverage for both beginners and advanced readers. MATLAB code is provided to allow readers of all levels to begin implementing robust models immediately, with detailed explanations and applications in the equity market included to help you grasp the real-world use of each technique. The discussion includes the most up-to-date thinking and cutting-edge methods, including a much-needed alternative to the traditional Markowitz mean-variance model. Unparalleled in depth and breadth, this book is an invaluable reference for all risk managers, portfolio managers, and analysts. Portfolio construction models originating from the standard Markowitz mean-variance model have a high input sensitivity that threatens optimization, spawning a flurry of research into new analytic techniques. This book covers the latest developments along with the basics, to give you a truly comprehensive understanding backed by a robust, practical skill set. Get up to speed on the latest developments in portfolio optimization Implement robust models using provided MATLAB code Learn advanced optimization methods with equity portfolio applications Understand the formulations, performances, and properties of robust portfolios The Markowitz mean-variance model remains the standard framework for portfolio optimization, but the interest in—and need for—an alternative is rapidly increasing. Resolving the sensitivity issue and dramatically reducing portfolio risk is a major focus of today's portfolio manager. Robust Equity Portfolio Management + Website provides a viable alternative framework, and the hard skills to implement any optimization method.
Hedge Fund Modelling and Analysis Using Excel and VBA
| Author | : Paul Darbyshire |
| Publisher | : John Wiley & Sons |
| Total Pages | : 294 |
| Release | : 2012-02-23 |
| Genre | : Business & Economics |
| ISBN | : 111994564X |
Co-authored by two respected authorities on hedge funds and asset management, this implementation-oriented guide shows you how to employ a range of the most commonly used analysis tools and techniques both in industry and academia, for understanding, identifying and managing risk as well as for quantifying return factors across several key investment strategies. The book is also suitable for use as a core textbook for specialised graduate level courses in hedge funds and alternative investments. The book provides hands-on coverage of the visual and theoretical methods for measuring and modelling hedge fund performance with an emphasis on risk-adjusted performance metrics and techniques. A range of sophisticated risk analysis models and risk management strategies are also described in detail. Throughout, coverage is supplemented with helpful skill building exercises and worked examples in Excel and VBA. The book's dedicated website, www.darbyshirehampton.com provides Excel spreadsheets and VBA source code which can be freely downloaded and also features links to other relevant and useful resources. A comprehensive course in hedge fund modelling and analysis, this book arms you with the knowledge and tools required to effectively manage your risks and to optimise the return profile of your investment style.
Modern Portfolio Theory, + Website
| Author | : Jack Clark Francis |
| Publisher | : John Wiley & Sons |
| Total Pages | : 576 |
| Release | : 2013-01-22 |
| Genre | : Business & Economics |
| ISBN | : 111837052X |
A through guide covering Modern Portfolio Theory as well as the recent developments surrounding it Modern portfolio theory (MPT), which originated with Harry Markowitz's seminal paper "Portfolio Selection" in 1952, has stood the test of time and continues to be the intellectual foundation for real-world portfolio management. This book presents a comprehensive picture of MPT in a manner that can be effectively used by financial practitioners and understood by students. Modern Portfolio Theory provides a summary of the important findings from all of the financial research done since MPT was created and presents all the MPT formulas and models using one consistent set of mathematical symbols. Opening with an informative introduction to the concepts of probability and utility theory, it quickly moves on to discuss Markowitz's seminal work on the topic with a thorough explanation of the underlying mathematics. Analyzes portfolios of all sizes and types, shows how the advanced findings and formulas are derived, and offers a concise and comprehensive review of MPT literature Addresses logical extensions to Markowitz's work, including the Capital Asset Pricing Model, Arbitrage Pricing Theory, portfolio ranking models, and performance attribution Considers stock market developments like decimalization, high frequency trading, and algorithmic trading, and reveals how they align with MPT Companion Website contains Excel spreadsheets that allow you to compute and graph Markowitz efficient frontiers with riskless and risky assets If you want to gain a complete understanding of modern portfolio theory this is the book you need to read.
Financial Analysis and Modeling Using Excel and VBA
| Author | : Chandan Sengupta |
| Publisher | : John Wiley & Sons |
| Total Pages | : 822 |
| Release | : 2009-11-09 |
| Genre | : Business & Economics |
| ISBN | : 047027560X |
An updated look at the theory and practice of financial analysis and modeling Financial Analysis and Modeling Using Excel and VBA, Second Edition presents a comprehensive approach to analyzing financial problems and developing simple to sophisticated financial models in all major areas of finance using Excel 2007 and VBA (as well as earlier versions of both). This expanded and fully updated guide reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial problems and models that you can learn from, use for practice, and easily adapt for work and classroom use. A companion website includes several useful modeling tools and fully working versions of all the models discussed in the book. Teaches financial analysis and modeling and illustrates advanced features of Excel and VBA, using a learn-by-doing approach Contains detailed coverage of the powerful features of Excel 2007 essential for financial analysis and modeling, such as the Ribbon interface, PivotTables, data analysis, and statistical analysis Other titles by Sengupta: Financial Modeling Using C++ and The Only Proven Road to Investment Success Designed for self-study, classroom use, and reference This comprehensive guide is an essential read for anyone who has to perform financial analysis or understand and implement financial models.
Professional Financial Computing Using Excel and VBA
| Author | : Donny C. F. Lai |
| Publisher | : John Wiley & Sons |
| Total Pages | : 372 |
| Release | : 2011-12-28 |
| Genre | : Business & Economics |
| ISBN | : 1118179080 |
"Professional Financial Computing Using Excel and VBA is an admirable exposition that bridges the theoretical underpinnings of financial engineering and its application which usually appears as a "black-box" software application. The book opens the black-box and reveals the architecture of risk-modeling and financial engineering based on industry-standard stochastic models by utilizing Excel and VBA functionality to create a robust and practical modeling tool-kit. Financial engineering professionals who purchase this book will have a jumpstart advantage for their customized financial engineering and modeling needs." Dr. Cameron Wicentowich Vice President, Treasury Analytics Canadian Imperial Bank of Commerce (CIBC) "Spreadsheet modeling for finance has become a standard course in the curriculum of many Quantitative Finance programs since the Excel-based Visual Basic programming is now widely used in constructing optimal portfolios, pricing structured products and managing risks. Professional Financial Computing Using Excel and VBA is written by a unique team of finance, physics and computer academics and practitioners. It is a good reference for those who are studying for a Masters degree in Financial Engineering and Risk Management. It can also be useful for financial engineers to jump-start a project on designing structured products, modeling interest term structure or credit risks." Dr. Jin Zhang Director of Master of Finance Program and Associate Professor The University of Hong Kong "Excel has been one of the most powerful tools for financial planning and computing over the last few years. Most users utilize a fraction of its capabilities. One of the reasons is the limited availability of books that cover the advanced features of Excel for Finance. Professional Financial Computing Using Excel and VBA goes the extra mile and deals with the Excel tools many professionals call for. This book is a must for professionals or students dealing with financial engineering, financial risk management, computational finance or mathematical finance. I loved the way the authors covered the material using real life, hands-on examples." Dr. Isaac Gottlieb Temple University Author, Next Generation Excel: Modeling in Excel for Analysts and MBAs
Portfolio Theory and Performance Analysis
| Author | : Noel Amenc |
| Publisher | : John Wiley & Sons |
| Total Pages | : 280 |
| Release | : 2005-01-21 |
| Genre | : Business & Economics |
| ISBN | : 0470858753 |
For many years asset management was considered to be a marginal activity, but today, it is central to the development of financial industry throughout the world. Asset management's transition from an "art and craft" to an industry has inevitably called integrated business models into question, favouring specialisation strategies based on cost optimisation and learning curve objectives. This book connects each of these major categories of techniques and practices to the unifying and seminal conceptual developments of modern portfolio theory. In these bear market times, performance evaluation of portfolio managers is of central focus. This book will be one of very few on the market and is by a respected member of the profession. Allows the professionals, whether managers or investors, to take a step back and clearly separate true innovations from mere improvements to well-known, existing techniques Puts into context the importance of innovations with regard to the fundamental portfolio management questions, which are the evolution of the investment management process, risk analysis and performance measurement Takes the explicit or implicit assumptions contained in the promoted tools into account and, by so doing, evaluate the inherent interpretative or practical limits
