четверг, 21 декабря 2017 г.
вторник, 28 ноября 2017 г.
понедельник, 27 ноября 2017 г.
воскресенье, 26 ноября 2017 г.
вторник, 1 августа 2017 г.
SP_EVLS_CLEAR_2_DAYS
USE EventLog1
-- USE EventLog
-- USE EvlContext
DECLARE @EVL_ID INT
DECLARE @EVL_CODE VARCHAR (100)
DECLARE @MIN_DT DATE
DECLARE @MAX_DT DATE
DECLARE @CURSOR CURSOR
SET @CURSOR = CURSOR SCROLL
FOR
SELECT EventLogID, Code
FROM dbo.EventLogs
OPEN @CURSOR
FETCH NEXT FROM @CURSOR INTO @EVL_ID, @EVL_CODE
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT DB_NAME() [DB_NAME], [Code] [EVL_NAME], 'DELETE' [Operation]
FROM EventLogs WHERE EventLogID = @EVL_ID
Select DB_NAME() [DB_NAME], @EVL_CODE [EVL_NAME], 'Before Delete' as Operation, Count(*) as Cnt,
Min(Cast( DT as Date)) as Dt1, Max(Cast( DT as Date)) as Dt2, DATEDIFF(day, Min(DT), Max(DT)) +1 [DAYS]
From EventLogItems
where EventLogID = @EVL_ID
SELECT @MIN_DT = Min(dt), @MAX_DT = Max(dt)
FROM
(
select top 2 Cast( DT as Date) dt
from EventLogItems o
WHERE EventLogID = @EVL_ID
Group by Cast( DT as Date)
Order by Cast( DT as Date) DESC
) a
PRINT(@MIN_DT)
if @MIN_DT IS NOT NULL
BEGIN
--SET @MIN_DT = CAST(@MIN_DT as Datetime)
--PRINT(@MIN_DT)
DELETE from EventLogItems
WHERE EventLogID = @EVL_ID
AND @MIN_DT IS NOT NULL
AND DT < @MIN_DT
END
Select DB_NAME() [DB_NAME], @EVL_CODE [EVL_NAME], 'After Delete' as Operation, Count(*) as Cnt,
Min(Cast( DT as Date)) as Dt1, Max(Cast( DT as Date)) as Dt2, DATEDIFF(day, Min(DT), Max(DT)) +1 [DAYS]
From EventLogItems
where EventLogID = @EVL_ID
FETCH NEXT FROM @CURSOR INTO @EVL_ID, @EVL_CODE
END
CLOSE @CURSOR
_________________________________________________________
EventLog1
USE [EventLog1]
GO
/****** Object: StoredProcedure [dbo].[SP_EVLS_CLEAR_2_DAYS] Script Date: 02.08.2017 7:26:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[SP_EVLS_CLEAR_2_DAYS]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @EVL_ID INT
DECLARE @EVL_CODE VARCHAR (100)
DECLARE @MIN_DT DATE
DECLARE @MAX_DT DATE
DECLARE @CURSOR CURSOR
SET @CURSOR = CURSOR SCROLL
FOR
SELECT EventLogID, Code
FROM dbo.EventLogs
OPEN @CURSOR
FETCH NEXT FROM @CURSOR INTO @EVL_ID, @EVL_CODE
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT DB_NAME() [DB_NAME], [Code] [EVL_NAME], 'DELETE' [Operation]
FROM EventLogs WHERE EventLogID = @EVL_ID
Select DB_NAME() [DB_NAME], @EVL_CODE [EVL_NAME], 'Before Delete' as Operation, Count(*) as Cnt,
Min(Cast( DT as Date)) as Dt1, Max(Cast( DT as Date)) as Dt2, DATEDIFF(day, Min(DT), Max(DT)) +1 [DAYS]
From EventLogItems
where EventLogID = @EVL_ID
SELECT @MIN_DT = Min(dt), @MAX_DT = Max(dt)
FROM
(
select top 2 Cast( DT as Date) dt
from EventLogItems o
WHERE EventLogID = @EVL_ID
Group by Cast( DT as Date)
Order by Cast( DT as Date) DESC
) a
PRINT(@MIN_DT)
if @MIN_DT IS NOT NULL
BEGIN
--SET @MIN_DT = CAST(@MIN_DT as Datetime)
--PRINT(@MIN_DT)
DELETE from EventLogItems
WHERE EventLogID = @EVL_ID
AND @MIN_DT IS NOT NULL
AND DT < @MIN_DT
END
Select DB_NAME() [DB_NAME], @EVL_CODE [EVL_NAME], 'After Delete' as Operation, Count(*) as Cnt,
Min(Cast( DT as Date)) as Dt1, Max(Cast( DT as Date)) as Dt2, DATEDIFF(day, Min(DT), Max(DT)) +1 [DAYS]
From EventLogItems
where EventLogID = @EVL_ID
FETCH NEXT FROM @CURSOR INTO @EVL_ID, @EVL_CODE
END
CLOSE @CURSOR
PRINT('OK')
END
-- USE EventLog
-- USE EvlContext
DECLARE @EVL_ID INT
DECLARE @EVL_CODE VARCHAR (100)
DECLARE @MIN_DT DATE
DECLARE @MAX_DT DATE
DECLARE @CURSOR CURSOR
SET @CURSOR = CURSOR SCROLL
FOR
SELECT EventLogID, Code
FROM dbo.EventLogs
OPEN @CURSOR
FETCH NEXT FROM @CURSOR INTO @EVL_ID, @EVL_CODE
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT DB_NAME() [DB_NAME], [Code] [EVL_NAME], 'DELETE' [Operation]
FROM EventLogs WHERE EventLogID = @EVL_ID
Select DB_NAME() [DB_NAME], @EVL_CODE [EVL_NAME], 'Before Delete' as Operation, Count(*) as Cnt,
Min(Cast( DT as Date)) as Dt1, Max(Cast( DT as Date)) as Dt2, DATEDIFF(day, Min(DT), Max(DT)) +1 [DAYS]
From EventLogItems
where EventLogID = @EVL_ID
SELECT @MIN_DT = Min(dt), @MAX_DT = Max(dt)
FROM
(
select top 2 Cast( DT as Date) dt
from EventLogItems o
WHERE EventLogID = @EVL_ID
Group by Cast( DT as Date)
Order by Cast( DT as Date) DESC
) a
PRINT(@MIN_DT)
if @MIN_DT IS NOT NULL
BEGIN
--SET @MIN_DT = CAST(@MIN_DT as Datetime)
--PRINT(@MIN_DT)
DELETE from EventLogItems
WHERE EventLogID = @EVL_ID
AND @MIN_DT IS NOT NULL
AND DT < @MIN_DT
END
Select DB_NAME() [DB_NAME], @EVL_CODE [EVL_NAME], 'After Delete' as Operation, Count(*) as Cnt,
Min(Cast( DT as Date)) as Dt1, Max(Cast( DT as Date)) as Dt2, DATEDIFF(day, Min(DT), Max(DT)) +1 [DAYS]
From EventLogItems
where EventLogID = @EVL_ID
FETCH NEXT FROM @CURSOR INTO @EVL_ID, @EVL_CODE
END
CLOSE @CURSOR
_________________________________________________________
EventLog1
USE [EventLog1]
GO
/****** Object: StoredProcedure [dbo].[SP_EVLS_CLEAR_2_DAYS] Script Date: 02.08.2017 7:26:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[SP_EVLS_CLEAR_2_DAYS]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @EVL_ID INT
DECLARE @EVL_CODE VARCHAR (100)
DECLARE @MIN_DT DATE
DECLARE @MAX_DT DATE
DECLARE @CURSOR CURSOR
SET @CURSOR = CURSOR SCROLL
FOR
SELECT EventLogID, Code
FROM dbo.EventLogs
OPEN @CURSOR
FETCH NEXT FROM @CURSOR INTO @EVL_ID, @EVL_CODE
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT DB_NAME() [DB_NAME], [Code] [EVL_NAME], 'DELETE' [Operation]
FROM EventLogs WHERE EventLogID = @EVL_ID
Select DB_NAME() [DB_NAME], @EVL_CODE [EVL_NAME], 'Before Delete' as Operation, Count(*) as Cnt,
Min(Cast( DT as Date)) as Dt1, Max(Cast( DT as Date)) as Dt2, DATEDIFF(day, Min(DT), Max(DT)) +1 [DAYS]
From EventLogItems
where EventLogID = @EVL_ID
SELECT @MIN_DT = Min(dt), @MAX_DT = Max(dt)
FROM
(
select top 2 Cast( DT as Date) dt
from EventLogItems o
WHERE EventLogID = @EVL_ID
Group by Cast( DT as Date)
Order by Cast( DT as Date) DESC
) a
PRINT(@MIN_DT)
if @MIN_DT IS NOT NULL
BEGIN
--SET @MIN_DT = CAST(@MIN_DT as Datetime)
--PRINT(@MIN_DT)
DELETE from EventLogItems
WHERE EventLogID = @EVL_ID
AND @MIN_DT IS NOT NULL
AND DT < @MIN_DT
END
Select DB_NAME() [DB_NAME], @EVL_CODE [EVL_NAME], 'After Delete' as Operation, Count(*) as Cnt,
Min(Cast( DT as Date)) as Dt1, Max(Cast( DT as Date)) as Dt2, DATEDIFF(day, Min(DT), Max(DT)) +1 [DAYS]
From EventLogItems
where EventLogID = @EVL_ID
FETCH NEXT FROM @CURSOR INTO @EVL_ID, @EVL_CODE
END
CLOSE @CURSOR
PRINT('OK')
END
среда, 26 июля 2017 г.
Current Time Plan in GS.Trade
Current TImePlan in GS.Trade = TimePlan15.xml
Defined in spsInit.xml
<SyncPositionsInit>
<SyncPositions_XmlFileName>D:\Mts\Mts1\Sps.xml</SyncPositions_XmlFileName>
<TradeContextInit_XmlFileName>Init\TradeContextInit.xml</TradeContextInit_XmlFileName>
<Quotes_XmlFileName>D:\Mts\Mts1\Quotes.xml</Quotes_XmlFileName>
<Tickers_XmlFileName>Repozitary\Xml\Tickers.xml</Tickers_XmlFileName>
<TimePlans_XmlFileName>Repozitary\Xml\TimePlans15.xml</TimePlans_XmlFileName>
<Accounts_XmlFileName>Repozitary\Xml\Accounts.xml</Accounts_XmlFileName>
<Positions_XmlFileName>D:\Mts\Mts1\Positions.xml</Positions_XmlFileName>
<EventLogs_XmlFileName>Init\EventLog.xml</EventLogs_XmlFileName>
Defined in spsInit.xml
<SyncPositionsInit>
<SyncPositions_XmlFileName>D:\Mts\Mts1\Sps.xml</SyncPositions_XmlFileName>
<TradeContextInit_XmlFileName>Init\TradeContextInit.xml</TradeContextInit_XmlFileName>
<Quotes_XmlFileName>D:\Mts\Mts1\Quotes.xml</Quotes_XmlFileName>
<Tickers_XmlFileName>Repozitary\Xml\Tickers.xml</Tickers_XmlFileName>
<TimePlans_XmlFileName>Repozitary\Xml\TimePlans15.xml</TimePlans_XmlFileName>
<Accounts_XmlFileName>Repozitary\Xml\Accounts.xml</Accounts_XmlFileName>
<Positions_XmlFileName>D:\Mts\Mts1\Positions.xml</Positions_XmlFileName>
<EventLogs_XmlFileName>Init\EventLog.xml</EventLogs_XmlFileName>
вторник, 25 июля 2017 г.
Forts Historical Data
http://www.moex.com/ru/orders?historicaldata
ТАРИФЫ
Все сделки и все заявки - Тип А
1 рынок (месяц / год ) – 15 000 руб. / 150 000 руб.
1 инструмент (месяц / год ) – 4 500 руб. / 45 000 руб.
1 рынок (месяц / год ) – 15 000 руб. / 150 000 руб.
1 инструмент (месяц / год ) – 4 500 руб. / 45 000 руб.
Все сделки и лучшие заявки - Тип B
1 рынок (месяц / год ) – 4 500 руб. / 45 000 руб.
1 инструмент (месяц / год ) – 1 500 руб. / 15 000 руб.
1 рынок (месяц / год ) – 4 500 руб. / 45 000 руб.
1 инструмент (месяц / год ) – 1 500 руб. / 15 000 руб.
Ежедневные итоги торгов (архивы за прошлые периоды) - Тип C
Все рынки (месяц) – 2 700 руб.
Все рынки (месяц) – 2 700 руб.
Все цены указаны без учета НДС
ПРИМЕРЫ ДАННЫХ
Все сделки и все заявки - Тип А
Все сделки и лучшие заявки - Тип B
Ежедневные итоги торгов (архивы за прошлые периоды) - Тип C
Подписаться на:
Комментарии (Atom)