- Structure of codes
- Prefixes you might encounter in Macrobond
Structure of codes
Series provided by Macrobond are identified by a unique name such as usgdp, which can contain letters, numbers and underscores.
Series provided by the user or via external sources, such as Bloomberg or a SQL database, always have the prefix 'ih:' in the series name. This will be followed by the name of the data source and another colon in the form ih:bl:BBGsymbol.
Prefixes you might encounter in Macrobond
Data stored in Macrobond
Series stored in the Macrobond account database uses the prefix 'ih:mb:', this is then followed by an indicator that tells if where the series is stored:
|ih:mb:priv:||Personal account that can only be accessed by you.|
|ih:mb:dept:||Department account that can be access by everyone in the same department as you.|
|ih:mb:com:||Company account that can be access by everyone within the company.|
|ih:mb:lib:||Library account that can be read by everyone within the company, but only some users can store series.|
|ih:mb:doc:||Series which exist only in one document and nowhere else. For more information about this functionality see here.|
The last part of the name for account series must then be followed by an identifier starting with a lower-case letter a-z and followed by lower case letters or numbers. The full name must be unique. For example, ih:mb:priv:myseries1.
First three can be created with Account in-house solution.
Calculated in-house series
You can save your entire calculation in a file to use the outcome elsewhere. Such series has double naming, for example, ih:mb:priv:calc1:calc1. For more information about this type of in-house see: Calculated in-house series – saving your own calculation.
When you create a series in the application or Excel add-in, the prefix 'ih:xl' is added by default and later you only specify the last part of the name. For more information about this feature see: Excel in-house solution.
As mentioned earlier, data downloaded from Bloomberg will start from 'ih:bl:' and after that there will be Bloomberg's symbol as in ih:bl:BBGsymbol. Bloomberg's overrides can be added after next colon sign ( : ). For more information see: The Bloomberg Connector.
When using the SQL Database Connector, you specify the database prefix as part of the database registration. If your prefix is 'mydb' and the series identifier is 'myseries1' the series name will be ih:mydb:myseries1.