O'Reilly - Safari Books Online: Advanced Modelling in Finance Using Excel and VBA

Table of Contents

Home
Subscribe
Free Trial

Category Map
My Quick Links
Books
Video
Rough Cuts
Short Cuts
Tools

Search:criteria:

Title=Bold Reference Entry=Italic

Advanced Search

This Book

Advanced Modelling in Finance Using Excel and VBA

Advanced Modelling in Finance Using Excel and VBA

Search

search in
search for

Contents

Table of Contents

Acknowledgements

Ch. 1. Introduction

Pt. 1. Advanced Modelling in Excel

Ch. 2. Advanced Excel Functions and Procedures

Ch. 3. Introduction to VBA

Ch. 4. Writing VBA User-defined Functions

A SIMPLE SALES COMMISSION FUNCTION

CREATING COMMISSION(SALES) IN THE SPREADSHEET

TWO FUNCTIONS WITH MULTIPLE INPUTS FOR VALUING OPTIONS

MANIPULATING ARRAYS IN VBA

EXPECTED VALUE AND VARIANCE FUNCTIONS WITH ARRAY INPUTS

PORTFOLIO VARIANCE FUNCTION WITH ARRAY INPUTS

FUNCTIONS WITH ARRAY OUTPUT

USING EXCEL AND VBA FUNCTIONS IN USER-DEFINED FUNCTIONS

PROS AND CONS OF DEVELOPING VBA FUNCTIONS

Pt. 2. Advanced Modelling in Equities

Pt. 3. Options on Equities

Pt. 4. Options on Bonds

Create BookmarkCreate Bookmark
Create Note or TagCreate Note or Tag
DownloadDownload
Email This PageEmail This Page
PrintPrint

Thumbnail View (Key: v)
Zoom Out (Key: -)Zoom Out
Zoom In (Key: +)Zoom In
Fit PageFit Page
Fit WidthFit Width
Previous (Key: p)Previous
Next (Key: n)Next

URL

Show search terms

Help

Chapter 4. Writing VBA User-defined Func... > CREATING COMMISSION(SALES) IN THE SPREADSHEET - Pg. 74

You are viewing the content on this page in Preview Mode.

Sign In, Subscribe or
Register For a Free Trial
to access full content of this book.