ECB SDMX database

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

ECB SDMX database

Postby farrel » Wed Dec 09, 2020 4:58 am

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 24572 times

EViews Katerina
Posts: 51
Joined: Thu Jun 25, 2015 9:54 am

Re: ECB SDMX database

Postby EViews Katerina » Wed Dec 09, 2020 9:28 am

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)?

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

Re: ECB SDMX database

Postby farrel » Thu Dec 10, 2020 3:35 am

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 24520 times


pic2.PNG
pic2.PNG (28.43 KiB) Viewed 24520 times

EViews Katerina
Posts: 51
Joined: Thu Jun 25, 2015 9:54 am

Re: ECB SDMX database

Postby EViews Katerina » Thu Dec 17, 2020 10:43 am

Latest patches of EViews 11 (Build date Dec 14 2020 or later) contain fix for the issue.

paolo.zanghieri
Posts: 49
Joined: Wed Mar 05, 2014 10:52 am

Re: ECB SDMX database

Postby paolo.zanghieri » Fri Oct 20, 2023 5:45 am

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

paolo.zanghieri
Posts: 49
Joined: Wed Mar 05, 2014 10:52 am

Re: ECB SDMX database

Postby paolo.zanghieri » Fri Oct 20, 2023 5:50 am

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

EViews Alejandro
Posts: 2
Joined: Fri Oct 20, 2023 8:50 am

Re: ECB SDMX database

Postby EViews Alejandro » Fri Oct 20, 2023 9:33 am

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.

paolo.zanghieri
Posts: 49
Joined: Wed Mar 05, 2014 10:52 am

Re: ECB SDMX database

Postby paolo.zanghieri » Fri Oct 20, 2023 10:29 am

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

EViews Alejandro
Posts: 2
Joined: Fri Oct 20, 2023 8:50 am

Re: ECB SDMX database

Postby EViews Alejandro » Fri Oct 20, 2023 11:33 am

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

paolo.zanghieri
Posts: 49
Joined: Wed Mar 05, 2014 10:52 am

Re: ECB SDMX database

Postby paolo.zanghieri » Fri Oct 20, 2023 12:28 pm

Thanks, I rand the line, Eviews keeps fetching but cannot find anything

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13306
Joined: Tue Sep 16, 2008 5:38 pm

Re: ECB SDMX database

Postby EViews Gareth » Fri Oct 20, 2023 12:57 pm

Is your copy of EViews 13 up to date?
Follow us on Twitter @IHSEViews

paolo.zanghieri
Posts: 49
Joined: Wed Mar 05, 2014 10:52 am

Re: ECB SDMX database

Postby paolo.zanghieri » Wed Oct 25, 2023 5:20 am

I think so. I have the Aug. 8 2023 build.
thanks

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13306
Joined: Tue Sep 16, 2008 5:38 pm

Re: ECB SDMX database

Postby EViews Gareth » Wed Oct 25, 2023 6:01 am

You should update to the latest version.
Follow us on Twitter @IHSEViews


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 20 guests