Page 1 of 1

ECB SDMX database

Posted: Wed Dec 09, 2020 4:58 am
by farrel
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?
pic1.PNG
pic1.PNG (28.77 KiB) Viewed 65923 times

Re: ECB SDMX database

Posted: Wed Dec 09, 2020 9:28 am
by EViews Katerina
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)?

Re: ECB SDMX database

Posted: Thu Dec 10, 2020 3:35 am
by farrel
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.
pic1.PNG
pic1.PNG (38.01 KiB) Viewed 65871 times
pic2.PNG
pic2.PNG (28.43 KiB) Viewed 65871 times

Re: ECB SDMX database

Posted: Thu Dec 17, 2020 10:43 am
by EViews Katerina
Latest patches of EViews 11 (Build date Dec 14 2020 or later) contain fix for the issue.

Re: ECB SDMX database

Posted: Fri Oct 20, 2023 5:45 am
by paolo.zanghieri
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

Re: ECB SDMX database

Posted: Fri Oct 20, 2023 5:50 am
by paolo.zanghieri
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

Re: ECB SDMX database

Posted: Fri Oct 20, 2023 9:33 am
by EViews Alejandro
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.

Re: ECB SDMX database

Posted: Fri Oct 20, 2023 10:29 am
by paolo.zanghieri
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

Re: ECB SDMX database

Posted: Fri Oct 20, 2023 11:33 am
by EViews Alejandro
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

Re: ECB SDMX database

Posted: Fri Oct 20, 2023 12:28 pm
by paolo.zanghieri
Thanks, I rand the line, Eviews keeps fetching but cannot find anything

Re: ECB SDMX database

Posted: Fri Oct 20, 2023 12:57 pm
by EViews Gareth
Is your copy of EViews 13 up to date?

Re: ECB SDMX database

Posted: Wed Oct 25, 2023 5:20 am
by paolo.zanghieri
I think so. I have the Aug. 8 2023 build.
thanks

Re: ECB SDMX database

Posted: Wed Oct 25, 2023 6:01 am
by EViews Gareth
You should update to the latest version.