ECB SDM - Wrong Decimal Notation

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

reep
Posts: 14
Joined: Fri Jan 27, 2012 2:24 am

ECB SDM - Wrong Decimal Notation

Postby reep » Mon May 27, 2019 6:11 am

Hello,

I'm downloading the following time series from the ECB data warehouse with the following code:

Code: Select all

WfCreate q 1990 2019
dbopen(type=ecb, server=https://sdw-wsrest.ecb.europa.eu/service)
fetch bls__bank_selection=all.bls_agg_method=fnet.bls_count=e.bls_count_detail=z.bls_item=o.collection=b.decimals=2.effect_domain=st.freq=q.market_role=s.ref_area=de.time_format=p3m.time_horizon=b3.unit=units.unit_mult=0


Unfortunately, there is a problem with the notation (decimal places) of the time series.

The time series should look like this (taken from the ECB website)
https://sdw.ecb.europa.eu/quickview.do?SERIES_KEY=258.BLS.Q.DE.ALL.O.E.Z.B3.ST.S.FNET
2019-Q2 3.13
2019-Q1 -3.13
2018-Q4 -3.23
2018-Q3 -3.13
2018-Q2 -3.13
2018-Q1 -3.13
2017-Q4 -9.68
2017-Q3 -3.23

But it looks like this from my Eviews spreadsheet
test.PNG
test.PNG (9.63 KiB) Viewed 311 times


Does anyone know a solution to this problem. I'm using Eviews 10.

Thanks!

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

Re: ECB SDM - Wrong Decimal Notation

Postby EViews Katerina » Wed Jun 05, 2019 8:44 am

Latest patch of EViews10 and EViews11 (build date June 4, 2019) includes an update on ECB SDMX database.

Additionally in your program change your fetch command as follows :

fetch bls__bank_selection=all.bls_agg_method=fnet.bls_count=e.bls_count_detail=z.bls_item=o.collection=b.decimals=2.effect_domain=st.freq=q.market_role=s.ref_area=de.time_format=p3m.time_horizon=b3.unit=units.unit_mult=0


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests