Skip to main content

How to enable the daily holdings history

Permanently deleted user
Updated

Release version: 5.42

Once enabled, the holdings history procedure calculates how many trusts and securities it owns on a daily basis.

To enable the stored procedure

CREATE PROCEDURE [dbo].[GetDailyPositionSummary]
(
@ValueDate DATE
)
AS
SET NOCOUNT ON;
 
SELECT
[ValueDate] ,
[ClientID] ,
[Category] ,
[AssetID] ,
[AssetCode] ,
[AssetDescription] ,
[AssetCcy] ,
[ClientBaseCcy] ,
[MIBaseCcy] ,
[BookCostInSourceCcy] ,
[BookCostInClientBaseCcy] ,
[BookCostInMIBaseCcy] ,
[MarketValueInSourceCcy] ,
[MarketValueInClientBaseCcy] ,
[MarketValueInMIBaseCcy] ,
[FXRateAssetCcyToClientBaseCcy] ,
[FXRateAssetCcyToMIBaseCcy] ,
[Price] ,
[PriceDate] ,
[Units]
FROM
[dbo].[DailyPositionSummary];
 
RETURN 0;
GO
 

To enable the system property

  1. Click Settings > Lists > Application configuration > System properties.
  2. Locate and double-click the Custom post end-of-day procedure system property.
  3. In Value, enter FNB_PostEndOfDay.
  4. Click Save and close.

Comments

0 comments

Please sign in to leave a comment.