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
Does anyone know a solution to this problem. I'm using Eviews 10.
Thanks!