Importing weekly data

[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!

[EViews Gareth]

Just lag the data once it is in your workfile.

[bpuffer]

Just lag the data once it is in your workfile.

How do I do that?

[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