FundPeriodEndDate (Function)

$image\trumpet2.gif$ Disclaimer

The FundPeriodEndDate function returns the end date of the reporting period for the specified fundamental data from some number of periods ago.

Syntax

FundPeriodEndDate(FundFieldName,PeriodsAgo,oErrorCode)

Returns (Integer)

The function returns the end date of the reporting period (in Julian date format) of a specified fundamental data field from some number of periods ago. The oErrorCode output parameter returns a status code for the fundamental data request that should be checked after each use of FundPeriodEndDate to verify that the data was retrieved without error.

Parameters

Name	Type	Description
FundFieldName	String	Specifies the short name of the fundamental data to read.
PeriodsAgo	Numeric	Sets the number of periods ago from which to read the fundamental data.
oErrorCode	Numeric	Outputs the status of the fundamental data request. If no error occurred a constant value of fdrOK is returned, otherwise a specific error code is set. See reserved word GetLastFundDataError for a list of error codes.

Remarks

Fundamental data names are listed in tables under the following categories:

Snapshot, Balance Sheet Assets & Liabilities, Cash Flow, Income, Shareholder Equity

All units, except share values, are converted to Millions for all periods. Percentages are returned as whole values (i.e. a value of 26.5 represents 26.5% and not 2650.00%)

Typically, PeriodsAgo refers to a number of calendar quarters ago, since most companies report fundamental information (such as revenues and earnings) on a quarterly basis.

You can also access fundamental data from other data streams using by adding an alias after the function, such as 'of Data2'

See Multiple Output Function for more information on using output parameters to return values.

Example

Assigns Value1 the end date value of fundamental data "ONET" (Net Income) from one period ago. The status of the request is returned using the output parameter RetError.

vars: RetError(-1);