ECB SDMX database
Moderators: EViews Gareth, EViews Moderator
ECB SDMX database
Dear Eviews,
On any request for data from ECB database, I obtain the following issue (below).
Is this problem on my side or this is common problem? Does ECB database work on your side?
On any request for data from ECB database, I obtain the following issue (below).
Is this problem on my side or this is common problem? Does ECB database work on your side?
-
- Posts: 51
- Joined: Thu Jun 25, 2015 9:54 am
Re: ECB SDMX database
Are you getting this error when you press the Browse button?
What version and build date of EViews are you using (On menu click Help->About EViews)?
What version and build date of EViews are you using (On menu click Help->About EViews)?
Re: ECB SDMX database
I can press "Browse" and I see datasets, but then I choose any database and press "Next", and then error occurs...
I use Eviews 11 with the latest patch, Dec 8 2020 build.
I use Eviews 11 with the latest patch, Dec 8 2020 build.
-
- Posts: 51
- Joined: Thu Jun 25, 2015 9:54 am
Re: ECB SDMX database
Latest patches of EViews 11 (Build date Dec 14 2020 or later) contain fix for the issue.
-
- Posts: 49
- Joined: Wed Mar 05, 2014 10:52 am
Re: ECB SDMX database
I am trying downloading series using the mnemonics provided in the database (see below) but I always get an error message as Eviews cannot find them. Any clue?
thanks
dbopen(type=ecb, server=https://sdw-wsrest.ecb.europa.eu/service)
fetch YC.B.U2.EUR.4F.G_N_A.SV_C_YM.SR_10Y
thanks
dbopen(type=ecb, server=https://sdw-wsrest.ecb.europa.eu/service)
fetch YC.B.U2.EUR.4F.G_N_A.SV_C_YM.SR_10Y
-
- Posts: 49
- Joined: Wed Mar 05, 2014 10:52 am
Re: ECB SDMX database
same happens with the Bundesbank site.
thanks
dbopen(type=bbk, server=https://api.statistiken.bundesbank.de/rest)
fetch BBSIS.M.I.ZAR.ZI.EUR.S1311.B.A604.R01XX.R.A.A._Z._Z.A
thanks
dbopen(type=bbk, server=https://api.statistiken.bundesbank.de/rest)
fetch BBSIS.M.I.ZAR.ZI.EUR.S1311.B.A604.R01XX.R.A.A._Z._Z.A
-
- Posts: 2
- Joined: Fri Oct 20, 2023 8:50 am
Re: ECB SDMX database
Hi Paolo,
May I know what datasets are you trying to fetch the series from?
I believe the commands you provided may have some syntax errors.
For example, this is a fetch command for getting a series in the BKN dataset from ECB database:
fetch bkn__bkn_denom=10n1.bkn_item=nc10.bkn_series=as.bkn_type=c.data_type_bkn=s.freq=m.ref_area=u2.series_denom=e
It is made by:
-fetch command
-the series dataset: "bkn"
-followed by: "__"
-the dimensions name and value (name=value), separated by "." : "bkn_denom=10n1.bkn_item=nc10.bkn_series=as.bkn_type=c.data_type_bkn=s.freq=m.ref_area=u2.series_denom=e"
Let me know if this helps you.
May I know what datasets are you trying to fetch the series from?
I believe the commands you provided may have some syntax errors.
For example, this is a fetch command for getting a series in the BKN dataset from ECB database:
fetch bkn__bkn_denom=10n1.bkn_item=nc10.bkn_series=as.bkn_type=c.data_type_bkn=s.freq=m.ref_area=u2.series_denom=e
It is made by:
-fetch command
-the series dataset: "bkn"
-followed by: "__"
-the dimensions name and value (name=value), separated by "." : "bkn_denom=10n1.bkn_item=nc10.bkn_series=as.bkn_type=c.data_type_bkn=s.freq=m.ref_area=u2.series_denom=e"
Let me know if this helps you.
-
- Posts: 49
- Joined: Wed Mar 05, 2014 10:52 am
Re: ECB SDMX database
Thanks a lot. I am trying to retrieve the Yield curve data for AAA government bonds. Yields and parameters of the NSS model
https://data.ecb.europa.eu/data/dataset ... odal=false
https://data.ecb.europa.eu/data/dataset ... odal=false
-
- Posts: 2
- Joined: Fri Oct 20, 2023 8:50 am
Re: ECB SDMX database
For the specific series you previously shared, the command should be like this:
fetch(d=ecb) yc__currency=eur.data_type_fm=sr_10y.freq=b.instrument_fm=g_n_a.provider_fm=4f.provider_fm_id=sv_c_ym.ref_area=u2
fetch(d=ecb) yc__currency=eur.data_type_fm=sr_10y.freq=b.instrument_fm=g_n_a.provider_fm=4f.provider_fm_id=sv_c_ym.ref_area=u2
-
- Posts: 49
- Joined: Wed Mar 05, 2014 10:52 am
Re: ECB SDMX database
Thanks, I rand the line, Eviews keeps fetching but cannot find anything
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
-
- Posts: 49
- Joined: Wed Mar 05, 2014 10:52 am
Re: ECB SDMX database
I think so. I have the Aug. 8 2023 build.
thanks
thanks
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Who is online
Users browsing this forum: No registered users and 13 guests