Open BuildWithData opened 3 months ago
Scenario:
Suppose on day X there is no trading bcs TradFi is shut down (eg christmas), data are scraped and then data are extracted with ref_date = X -1
X
ref_date = X -1
On Day X + 1 trading is back, ie on Day X + 2 data are updated and when they are scraped ref_date = X + 1
X + 1
X + 2
ref_date = X + 1
Problem:
Any consumption table will be missing a row with ref_date= X
ref_date= X
Solution:
Add row for ref_date= X with data from X -1
X -1
Scenario:
Suppose on day
X
there is no trading bcs TradFi is shut down (eg christmas), data are scraped and then data are extracted withref_date = X -1
On Day
X + 1
trading is back, ie on DayX + 2
data are updated and when they are scrapedref_date = X + 1
Problem:
Any consumption table will be missing a row with
ref_date= X
Solution:
Add row for
ref_date= X
with data fromX -1