OS_DivsBetweenDates (Function)

image\trumpet2.gif Disclaimer

The OS_DivsBetweenDates function calculates the present value of the dividends that are to be paid between two user-specified dates.  This function is designed primarily for use in OptionStation.

Syntax

OS_DivsBetweenDates(CurrDate, FutureDate, FirstDivMonth, FirstDivDay, DivAmt, Rate, PV);

Returns (Double)

A numeric value representing the present value of the dividends that are to be paid between two user-specified dates, the date input as CurrDate and the date input as FutureDate.

Parameters

Name

Type

Description

CurrDate

Numeric

Sets today’s date using EasyLanguage date format, YYYMMDD (enter 1061212 for Dec 12 2006).

FutureDate

Numeric

Sets the expiration date of an option using EasyLanguage date format, YYYMMDD  (enter 1061212 for Dec 12 2006).

FirstDivMonth

Numeric

Sets the month in which the first annual dividend payment is due. Enter 1 for January, 2 for February and so on.

FirstDivDay

Numeric

Sets the day of the month on which the first annual dividend payment is due (enter 15 if the due date is January 15th).

DivAmt

Numeric

Sets the amount of dividend  (enter 0.0125 for 1.25%).

Rate

Numeric

Sets the short-term risk free interest rate, usually the 90-day T-Bill (enter .049 for 4.9%).

PV

TrueFalse

Sets whether the function will calculate the dividend in present value.  True = Calculate present value adjustment, and False = Do not calculate present value adjustment.

Example

Assigns to Value1 the periodic dividend adjustment for a stock that will pay a dividend of 1.25 on December 15, and do not calculate the present value adjustment.

Value1 = OS_DivsBetweenDates(1060803, 1061117, 12, 15, 1.25, False);