Page 1 of 1

ECB SDM - Wrong Decimal Notation

Posted: Mon May 27, 2019 6:11 am
by reep
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 3693 times


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

Thanks!

Re: ECB SDM - Wrong Decimal Notation

Posted: Wed Jun 05, 2019 8:44 am
by EViews Katerina
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