O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Analyzing Securities

Excel offers a group of functions designed for specific tasks relating to the computation and analysis of various types of securities. All these functions are part of the Analysis ToolPak. For more information about the Analysis ToolPak, see "Installing the Analysis ToolPak".

Many of these functions share similar arguments. We'll describe the most common ones in Table 16-3 to avoid revisiting the same information in the function discussions that follow.

Table 16-3. Security-Analysis Function Arguments

Argument

Description

Basis

Day count basis of the security. If omitted, defaults to 0, indicating US (NASD) 30/360 basis. Other basis values include: 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360

Coupon

The security's ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required