Page Comparison

Daily and Monthly Return Examples

An example of a monthly return calculation follows. Daily Report Return Calculation Compared to Monthly Report Return Calculation shows a sample daily return calculation used in the Daily report on the left and the corresponding monthly return calculation used in the Monthly report on the right. The Daily report uses a Performance Analysis field to retrieve a gross return. The Monthly report uses a month to date Performance Link Analysis field to calculate the corresponding month to date value.

Image Added

Anchor
_Toc521324143 _Toc521324143

Month to Date Return Field Example

You can link daily returns for your month to date return using a Performance Link Analysis field that includes the predefined Month to Date date rule and the Performance Analysis return field. See the sample field shown in the following figure.

Image Added

Anchor
_Toc521324144 _Toc521324144

Beginning Market Value Field Example

You can pull the beginning market value for the month using a Performance Link Analysis field that includes a custom date rule and a Performance Analysis field that uses the End Value effect. See the sample field shown in the following figures.

Image Added

Anchor
_Toc521324145 _Toc521324145

Ending Market Value Field Example

You can pull the ending market value for the month to date period using a Performance Link Analysis field that includes a custom date rule and a Performance Analysis field that uses the End Value effect. See the sample field shown in the following figure.
Image Modified

Anchor
_Toc521324146 _Toc521324146

Month to Date Cash Flows Field Example

You can show the total month to date cash flows using a Performance Risk Analysis field that uses the Sum function, the predefined Month to Date time period, and your Performance cash flow field. See the sample field shown in the following figure.
Image Modified

Anchor
_Toc521324147 _Toc521324147

Month to Date Gain Loss Field Example

You can show the total month to date gain/loss using a Performance Risk Analysis field that uses the Sum function, the predefined Month to Date time period, and your Performance gain/loss field. See the sample field shown in the following figure.

Image Added

Anchor
_Toc521324148 _Toc521324148

Month to Date Investment Base Field Example

You can show the average month to date investment base using a Performance Risk Analysis field that uses the Cumulative Mean Return function, the predefined Month to Date time period, and your Performance Investment Base field. See the sample field shown in the following figure.