دانلود کتاب مشتقات – گزینه‌ها و معاملات آتی

In this book, we analyze derivatives from the perspective of financial modeling. In financial modeling, the central questions from the financial industry are mapped and solved holistically with the help of software. We use Excel as our software. Excel is very variable, very widely used, the basic functions are relatively easy to learn, and there are good control options and relatively large amounts of data that can be processed. It must be said, however, that Excel cannot replace a database when it comes to large data sets. To apply data analytics to big data as a whole, the use of higher-level programming languages, such as Python, is recommended. However, we want to make our book accessible to a wide range of readers, which is why we decided on Excel and not Python. As mentioned in the title, the reader should be able to understand how options and futures work step by step. The book’s clear focus is on options due to the holistic design of the book. Step by step, a control cockpit is built from pricing to strategies. Our approach of financial modeling based financial engineering is in the foreground. To present this entire process not only for options but also for futures would go beyond the scope of the book. Therefore, we have limited ourselves to option strategies. You can download the Excel spreadsheets discussed in this book from the publisher’s website. These spreadsheets are based on the teaching concept of Financial Modeling based Financial Engineering, which consists of the following four steps: Step 1: The assignment is defined. This is where the exact task is outlined. Step 2: Background information on this topic is listed here. Step 3: Here you will get to know the respective formula with which the result of the respective assignment can be calculated. Step 4: The respective implementation in Excel is shown there. At the end of each assignment, you will see the Excel result with all figures in an Excel screenshot.