Page 1 of 1

Importing weekly data

Posted: Tue Jan 14, 2025 6:42 am
by bpuffer
I am pulling weekly (Monday) data from a db into a workfile that is weekly (Wednesday) and am finding that it defaults to being a week off.

For instance, the weekly (Monday) DB has data through January 6th, 2025 but when brought into the workfile it remaps it to January 1st instead of the 8th. Even though the 8th is the same week as the 6th and the first is not.

How do I get it to pull in the data to the proper week?

Thanks!

Re: Importing weekly data

Posted: Tue Jan 14, 2025 7:02 am
by EViews Gareth
Just lag the data once it is in your workfile.

Re: Importing weekly data

Posted: Tue Jan 14, 2025 7:45 am
by bpuffer
Just lag the data once it is in your workfile.
How do I do that?

Re: Importing weekly data

Posted: Tue Jan 14, 2025 8:47 am
by EViews Gareth

Code: Select all

series x = y(-1)
or

Code: Select all

series x = y(1)
depending on whether you want to go forwards or backwards