Page 1 of 1
Updating data in imported series
Posted: Fri Apr 01, 2016 6:53 am
by Mukanov
Hello everyone :)
I have an issue with managing data "up-to-date".
For example to add actual and forecasted values for BRENT price:
Code: Select all
dbopen(type=fredv1, server=api.stlouisfed.org/fred)
fetch("link", m) mcoilbrenteu
Is there some easier way to do, except of this:
Code: Select all
smpl 2016M03 2016M03
series mcoilbrenteu=40
smpl 2016M04 2016M04
series mcoilbrenteu=40
smpl @all
Through something like this (I know that it is not working):
Code: Select all
mcoilbrenteu.insertobs(2016M03) 2
series mcoilbrenteu(2016M03)=40
series mcoilbrenteu(2016M04)=40
Thank you in advance!
P.S. Eviews version 9.5
Re: Updating data in imported series
Posted: Fri Apr 01, 2016 7:59 am
by EViews Gareth
It isn't exactly clear what you're asking, but perhaps series.adjust will help you.
http://www.eviews.com/help/helpintro.ht ... 23ww200856
Re: Updating data in imported series
Posted: Fri Apr 01, 2016 8:10 am
by Mukanov
I want to change exact date value in series by code lines, without changing sample every time :series:
To be clear BRENT price that I imported from FRED was looking like this:
2015M12 38.01
2016M01 30.7
2016M02 32.18
2016M03 NA
2016M04 NA
And I want to fill with new data and forecast, to make it look like this:
2015M12 38.01
2016M01 30.7
2016M02 32.18
2016M03 40
2016M04 40
Is there is other way to do it, except of changing sample? Because it is not convenient
Re: Updating data in imported series
Posted: Fri Apr 01, 2016 9:13 am
by EViews Gareth
No, but you only need to change the sample once.
Re: Updating data in imported series
Posted: Fri Apr 01, 2016 10:46 am
by Mukanov
No, but you only need to change the sample once.
Yeah, If numbers will be the same (equal to 40) it will work, but if not, sample must be changed each time, am I right
For example to get series like this:
2015M12 38.01
2016M01 30.7
2016M02 32.18
2016M03
40
2016M04
45
2016M05
44
2016M06
42
2016M07
50
2016M08
48
Re: Updating data in imported series
Posted: Fri Apr 01, 2016 10:51 am
by EViews Gareth
If you're using .adjust you only need to set the sample to the first period that needs to be changed.
Re: Updating data in imported series
Posted: Fri Apr 01, 2016 11:48 am
by Mukanov
If you're using .adjust you only need to set the sample to the first period that needs to be changed.
So it should look something like that (don't have an opportunity to check it right now):
Code: Select all
smpl 2016M03 2016M08
mcoilbrenteu.adjust = 40 45 44 42 50 48
Thank you very much, now I understand!
