KODIAK Derivatives 2.4

2.3.0

Released TBA

New Features and fixes for the KODIAK Derivatives Client

Options Demo - Hægt er að birta nýjan flipa á aðalvalmynd sem meðhöndlar og birtir options.

Aðrar breytingar:

Uppfærsla á Entity Framework í 6.1.3
Uppfærsla á Wcf Data Services í 5.6.3
async-await virkni fyrir market data service
Client side cache fyrir market data service

Config breytingar:

Ný appSettings færlsa, OptionsEnabled, í .config á client sem stjórnar því hvort options flipi sé birtur.

Gagnagrunnsbreytingar:

Eftirfarandi gagnagrunnsbreytignar eru nauðsynlegar fyrir options demo:

CREATE TABLE OptionStates
(
 Id INT NOT NULL PRIMARY KEY,
 Name NVARCHAR(30) NOT NULL
)
INSERT INTO OptionStates (Id,Name) VALUES (1,'Open')
INSERT INTO OptionStates (Id,Name) VALUES (2,'Closed')
INSERT INTO OptionStates (Id,Name) VALUES (3,'Excercised')
CREATE TABLE Options
(
 Id INT NOT NULL IDENTITY(1,1) PRIMARY KEY, 
 BrokerId INT NOT NULL, 
 CustomerId INT NOT NULL, 
 StateId INT NOT NULL, 
 Symbol NVARCHAR(30) NOT NULL, 
 
 Rights BIT NOT NULL, 
 Side BIT NOT NULL,

StartDate DATETIME NOT NULL,
 ExpiryDate DATETIME NOT NULL,
 Quantity FLOAT NOT NULL, 
 Premium FLOAT NOT NULL, 
 Commission FLOAT NOT NULL,
 StrikePrice FLOAT NOT NULL,
 OptionSymbol VARCHAR(50) NOT NULL, 
 Comment VARCHAR(255) NOT NULL,
 
 ExercisePrice FLOAT NULL,
 
 DateCreated DATETIME NOT NULL, 
 DateUpdated DATETIME NULL, 
 UserGroupId INT NOT NULL, 
 UserId INT NOT NULL, 
 IsCancelled BIT NOT NULL,
 CONSTRAINT FK_Options_StateId FOREIGN KEY (StateId) REFERENCES OptionStates(Id)
)