Frequency from Macrobond database?

[paues]

Is it possible to get metadata for a series (e.g. first/last period with data and frequency) in the Macrobond database before copying it to a workfile?

[EViews Chris]

There may not be a way to do this at the moment because of limits in the communication between EViews and Macrobond.

On an EViews native database (and some other database formats) you could do the following

string metainfo = @wquery("dbname", "name=gdp", "freq,start,end")

to retrieve the frequency, start date and end date for the series 'gdp' in the database 'dbname'.

I'll check in with the Macrobond development team to see if I'm missing anything.

Chris

[paues]

It seems that this does not work with a Macrobond database. I will contact them from my end as well.

Also, the function @wquery does not appear to be documented in the reference material to Eviews 7.2.

[EViews Gareth]

It was added after the documentation was written

[ThomasO]

We have added support for the @wquery function in Macrobond. It will be available in all version after 1.4.40.

Regards,

Thomas O
Macrobond Financial

[paues]

How do I give the Macrobond database a shorthand name when I open it through a written Eviews program? It works just fine when I open it through the menus (File/Open/Database...). But when I use

Code: Select all

dbopen(type=macrobond) as mb

the shorthand is not mb, as I would expect, but whatever I chose the last time I opened the database through the menus.

[paues]

Also, is there some way to check that the Macrobond database can indeed be opened before opening it? I have co-workers who do not have Macrobond installed and I would like to give them an error message saying something like "Macrobond has to be installed in order to run this program."

[EViews Gareth]

Also, is there some way to check that the Macrobond database can indeed be opened before opening it? I have co-workers who do not have Macrobond installed and I would like to give them an error message saying something like "Macrobond has to be installed in order to run this program."

There isn't something built into EViews that can do it. I suppose you could try opening a Macrobond database straight away, and if it errors, you know it won't work

[paues]

I guess I have to dive into the wondrous world of error handling

Do you have any insights on the shortname issue I posted earlier in this thread?

[EViews Jason]

In regards to the shorthand issue, it could be one of several things. The first thing I would try is changing your syntax to

Code: Select all

dbopen(type=macrobond) xx as mb

'xx' is the database name. In the Macrobond case, database name is irrelevant and ignored. So it can be anything. It is needed as a placeholder for the EViews parser. Without the database name, the EViews the parser will get confused.

If you find the shorthand is still not changing, make sure the database is not in the database registry (options->database registry).

If it is not in the database registry, change your default database by opening a second database. For example

Code: Select all

dbopen(t=fred)

[paues]

Thank you! The syntax

Code: Select all

dbopen(type=macrobond) xx as mb

worked wonders.