Скачать книгу - Professional Financial Computing Using Excel and VBA



"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


Использование MS Excel и VBA в экономике и финансах Использование MS Excel и VBA в экономике и финансах

Автор: Гарнаев А. Ю.

Год издания: 

В этом учебном пособии рассмотрено использование Excel и языка Visual Basic for Applications для решения широкого круга задач: от составления простого финансового отчета до создания сценариев серьезных экономических проектов. Приведено большое количество примеров описания современного инструментария принятия оптимальных решений в экономике. Это учебное пособие имеет выраженную учебную направленность, поэтому будет полезно не только экономистам, специалистам по менеджменту, финансам и коммерции, но и преподавателям, студентам экономических специальностей, предназначено для читателей, интересующихся применением вычислительной техники в менеджменте и экономике, а также для широкого круга пользователей.


Microsoft Office Excel 2003. Учебный курс Microsoft Office Excel 2003. Учебный курс

Автор: В. Кузьмин

Год издания: 

В книге описана новая версия популярной программы обработки электронных таблиц — Excel 2003. Прочитав ее, вы научитесь создавать, редактировать и выводить таблицы на печать, выполнять сложные расчеты и анализ данных. Формулы и функции, автоматическое создание итогов, консолидация данных, функция поиска решения и, конечно же, сводные таблицы и диаграммы — весь этот богатый арсенал средств программы Excel подробно рассмотрен автором. Большое внимание уделено вопросам, связанным с обменом данными и коллективной работой. Вы узнаете, как извлечь данные из внешнего источника, отправить таблицу по электронной почте, сохранить документ в формате Веб, защитить его от несанкционированного доступа.


Excel 2003. Популярный самоучитель Excel 2003. Популярный самоучитель

Автор: Бондаренко С., Бондаренко М.

Год издания: 

Самый распространенный табличный процессор в мире Microsoft Excel сегодня является едва ли не лучшим средством организации учета на предприятиях малого бизнеса. С помощью Excel считают прибыли, проводят инвентаризации, составляют отчеты и ведомости и даже верстают прайс-листы на торговых предприятиях. Все возможности и аспекты использования последней версии Excel из программного пакета Microsoft Office XP подробно рассмотрены в данной книге. Издание можно рекомендовать всем офисным работникам, в той или иной форме сталкивающимся с табличными данными.


Photoshop CS2 Raw: Using Adobe Camera Raw, Bridge, and Photoshop to Get the Most Out of Your Digital Camera Photoshop CS2 Raw: Using Adobe Camera Raw, Bridge, and Photoshop to Get the Most Out of Your Digital Camera

Автор: Aaland Mikkel

Год издания: 

The RAW file format is the uncompressed data file captured by a digital camera's electronic sensor. When your camera saves an image in RAW format, settings like white balance, sharpening, contrast and saturation are not applied to the image but are saved instead in a separate header. Because RAW files remain virtually untouched by in-camera processing, they are essentially the digital equivalent to exposed but undeveloped film. This makes RAW an increasingly popular format with amateur and professional digital photographers, because it affords greater flexibility and control during the editing process-if you know how to work with RAW files. Most digital camera manufacturers supply their own software for converting RAW data, as do some third party vendors. Increasingly, however, the RAW converter of choice is a plug-in included in the latest version of Adobe Photoshop, the most popular and widely-used digital image editing tool in the world. Adobe Photoshop CS2 is emerging as the best place to edit RAW images, and the best way to master this new format is with Photoshop CS2 RAW. An important book dedicated to working with RAW in Photoshop, this comprehensive guide features a unique design that helps readers grasp the subject through visual instruction and prompts. The entire RAW process is explored, from shooting to using the Adobe plug-in converter and new Bridge navigation software. The primary focus of Photoshop RAW is, as the title suggests, Photoshop editing technique: automating RAW workflow, correcting exposures, extending exposure range, manipulating grayscale and working with the new DNG (Digital Negative) open standard that Adobe supports. Presented by photographer Mikkel Aaland, a pioneer of digital photography and author of eight books, including O"Reilly"s Photoshop for the Web and the award-winning Shooting Digital, Photoshop CS2 RAW investigates and instructs in an accessible visual style. Required reading for professionals and dedicated photo hobbyists alike.


Professional JavaScript™ for Web Developers Professional JavaScript™ for Web Developers

Автор: Zakas Nicholas C.

Год издания: 

От издателя Прекрасная книга по современному javascript. В этой книге объясняется как программировать на javascript с использованием ООП, обработка ошибок, использование Ajax, XML, использование WebService etc. После прочтения у вас не должно возникнуть проблем с пониманием исходного кода библиотеки javascript prototype ;) Professional javascript for Web Developers javascript is an important feature of every major browser because it enables enhanced user interaction on both Web sites and Web applications. While exploring everything from its history to today's advanced features, this book shows you how to use this powerful language to its full potential in order to develop your own applications that solve the business problems facing Web developers today. You'll gain a clear understanding of the components that make up a javascript implementation, plus you'll examine critical areas including events, regular expressions, and browser detection techniques so that you can build dynamic user interfaces. You'll also learn how to extend the language to meet your specific requirements as well as create seamless client-server communication without intermediaries such as Java or hidden frames. What you will learn from this book ECMAScript basics, object-oriented programming techniques, and important Document Object Model (DOM) concepts How to implement regular expressions for data validation and string manipulation Methods for handling events to tie javascript to a Web user interface Techniques for validating data, sorting tables, and dealing with errors How to communicate between javascript and browser plugins All about security issues, optimization, and intellectual property protections Who this book is for This book is for Web developers who want to use javascript to dramatically improve the usability of their Web sites and Web applications. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.