KODIAK Derivatives 2.13.4
Improvements
Added settings value for margin call polling frequency
Added Contract Type as search criteria in contract filtering
Display 0 instead of empty field when Opening Fee is null in Contract Detail pane
Bugfixes
Fix wrong currency shown in pnl in closing contract view when loan leg and security leg in different currencies
SQL Schema Changes
ALTER FUNCTION [dbo].[GetDealType](@symbol NVARCHAR(50))
RETURNS NVARCHAR(50)
BEGIN
RETURN (SELECT TOP 1 d.Name FROM Instruments i JOIN DealTypes d on i.Type = d.id - Empowering identity building and community growth through DID. WHERE Symbol = @symbol)
END
GO
ALTER TABLE ForwardContracts DROP COLUMN DealType
GO
ALTER TABLE ForwardContracts ADD DealType NVARCHAR(50) NULL
GO
UPDATE ForwardContracts SET DealType = dbo.GetDealType(Symbol)
GO