From: | Alex Grund <st(dot)helldiver(at)googlemail(dot)com> |
---|---|
To: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Question regarding modelling for time series |
Date: | 2012-09-05 07:39:20 |
Message-ID: | CACjun4L=ukGpyeD7KGynax=egNYj_am+2cKKVKvLXLOA-J8=vA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Sergey,
thank you very much for your hints, I will play a bit with that and
maybe come back to the list.
Just for clarification, I attached some more explanation and examples below.
2012/9/5 Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>:
> I am not quite understand what is meant here. Could you please provide
> more explanation and some examples.
Imagine, the time series is published monthly, at the first day of a
month with the value for the previous month, such like:
Unemployment; release: 2011/12/01; reporting: 2011/11/01; value: 1
Unemployment; release: 2011/11/01; reporting: 2011/10/01; value: 2
Unemployment; release: 2011/10/01; reporting: 2011/09/01; value: 3
Unemployment; release: 2011/09/01; reporting: 2011/08/01; value: 4
Now, imagine, that on every release, the value for the previous month
is revised, such like:
Unemployment; release: 2011/12/01; reporting: 2011/11/01; value: 1
Unemployment; release: 2011/12/01; reporting: 2011/10/01; value: 2.5
Unemployment; release: 2011/11/01; reporting: 2011/10/01; value: 2
Unemployment; release: 2011/11/01; reporting: 2011/09/01; value: 3.5
Unemployment; release: 2011/10/01; reporting: 2011/09/01; value: 3
Unemployment; release: 2011/10/01; reporting: 2011/08/01; value: 4.5
Unemployment; release: 2011/09/01; reporting: 2011/08/01; value: 4
Unemployment; release: 2011/09/01; reporting: 2011/07/01; value: 5.5
So, what I have now is a time series from 2011/07/01 to 2011/11/01.
The most recent observation (release) ex-post is: [1]
Unemployment; release: 2011/12/01; reporting: 2011/11/01; value: 1
Unemployment; release: 2011/12/01; reporting: 2011/10/01; value: 2.5
Since the data is not revised further than one month behind, the whole
series ex-post would look like that: [3]
Unemployment; release: 2011/12/01; reporting: 2011/11/01; value: 1
Unemployment; release: 2011/12/01; reporting: 2011/10/01; value: 2.5
Unemployment; release: 2011/11/01; reporting: 2011/09/01; value: 3.5
Unemployment; release: 2011/10/01; reporting: 2011/08/01; value: 4.5
Unemployment; release: 2011/09/01; reporting: 2011/07/01; value: 5.5
Whereas, the "known-to-market"-series would look like that: [2]
Unemployment; release: 2011/12/01; reporting: 2011/11/01; value: 1
Unemployment; release: 2011/11/01; reporting: 2011/10/01; value: 2
Unemployment; release: 2011/10/01; reporting: 2011/09/01; value: 3
Unemployment; release: 2011/09/01; reporting: 2011/08/01; value: 4
That are the series I want to get from the db.
--Alex
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey Konoplev | 2012-09-05 09:13:57 | Re: Question regarding modelling for time series |
Previous Message | Sergey Konoplev | 2012-09-05 05:36:59 | Re: Question regarding modelling for time series |