Some Bars Not Marked as Finalised

smartift / grail

0 stars 0 forks source link

Some Bars Not Marked as Finalised #90

Closed guytp closed 6 years ago

guytp commented 6 years ago

UPDATE [ChartBar] SET IsFinalised = 1 WHERE IsDirtyBar = 1 AND OpenTime < (SELECT MAX(OpenTime) FROM ChartBar cb2 WHERE cb2.InstrumentId = [ChartBar].InstrumentId AND cb2.ExchangeId = [ChartBar].ExchangeId AND cb2.Timeframe = [ChartBar].Timeframe)

guytp commented 6 years ago

Only on dev, doesnt appear in prod