How to trigger TimeSeriesEngine without waiting for next window data

Summary The problem lies in the delayed aggregation of 5-minute K-line data into 1-hour K-lines using DolphinDB’s TimeSeriesEngine. The current implementation waits for the next window’s data to arrive before triggering the aggregation, resulting in a significant delay. This delay is unacceptable for live trading. Root Cause The root cause of the issue is the … Read more

How to model and track monthly snapshot data in PostgreSQL when no natural key exists?

Summary The problem at hand involves loading a monthly snapshot dataset into PostgreSQL where the source does not provide a stable natural key for one of the entities. The goal is to track the current state and historical presence of rows without corrupting history or inventing false keys. The main challenges include: No explicit “exit” … Read more

Google Sheets formula changes when an outside process inserts data into one of the sheets referenced in the formula

Summary The issue at hand is that Google Sheets formulas are being altered when an outside process inserts data into one of the sheets referenced in the formula. Specifically, the XLOOKUP formula is having its references updated as if the rows were manually inserted, resulting in incorrect data being reported. Root Cause The root cause … Read more