Page 1 of 1

Macrobond - importing labels

Posted: Thu Nov 16, 2017 1:33 am
by tvonbrasch
Hi
I have trouble importing labels from the Macrobond database using the commands provided at

https://help.macrobond.com/add-ins/the- ... ws-add-in/

Can you take a look at the following code and let me know how it should be changed so as to import the label for say convertion from high to low frequencies (Convert_HiLo)?

Code: Select all

wfcreate(wf=macro,page=d) d(1,7) 1970 2025 dbopen(type=macrobond) xx as mb fetch(d=mb,link) norate0001 norate0001.label(Convert_HiLo)

Thomas

Re: Macrobond - importing labels

Posted: Thu Nov 16, 2017 9:49 am
by EViews Gareth
Not sure what you're asking. When you fetch from Macrobond, the field for Convert_HiLo is already set by them.

If you wish to change the default frequency conversion method for the series, you can do so by changing it on the Properties dialog of the series, or using series.setconvert.

Re: Macrobond - importing labels

Posted: Fri Nov 17, 2017 7:54 am
by tvonbrasch
I misunderstood, i thought i had to get the labels to manually instruct eviews about the frequency conversion method. unfortunately, macrobond only converts by taking sums or the last value when going from high to low:
For series that have Class = “Flow”, these are Convert_HiLo=sum and Convert_LoHi=const_s. Otherwise they are Convert_HiLo=last and Convert_LoHi=const_a.

so for many series i must manually override the frequency conversion setting.
Thomas

Re: Macrobond - importing labels

Posted: Fri Nov 17, 2017 9:10 am
by EViews Jason
Just to be clear, you can specify the frequency conversion method to be used during the fetch using the 'c=' option. See http://www.eviews.com/help/helpintro.ht ... fetch.html for more details. This will change values of the series in the workfile.

If you change the frequency conversion method on the series after it has already been fetched into the workfile(which is what your original example was doing) you will only see the effect of this change when you copy the series in your workfile to another workfile or workfile page.

Re: Macrobond - importing labels

Posted: Sat Nov 18, 2017 1:11 am
by tvonbrasch
Hi Jason

Thanks for that info. Good idea to include the option in the fetch command. What I have done so far is to import a series into a page in the same frequency as the underlying series in Macrobond, and then afterwards converting it to other frequencies within Eviews.
Thomas