Skip to content

Macrobond Help

  • Application Overview
  • Q&A
  • User Guide
  • Test your skills
  • Analyses
  • Charts
  • APIs/Feeds/Connectors
  • Technical information
  • Legal
  • Support

Naming patterns

  • Structure of codes
  • Prefixes you might encounter in Macrobond
    • Data stored in Macrobond
      • Calculated in-house series
    • External sources
      • Excel in-house
      • Bloomberg connector
      • SQL connector

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.

External sources

Excel in-house

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.

Bloomberg connector

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.

SQL 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.

Tags: account in-housecalculated in-housedata structuredocument in-houseExcel in-houseexternal dataMy series

Contents

  • Finding data
    • Finding data – overview
    • The data-tree structure
    • Finding data
    • Integrating and using external data (My series activity tab)
      • Naming patterns
      • Account in-house – creating & managing
      • Excel in-house – creating & managing
      • Other types of in-house series
    • My lists activity tab
  • Analyzing data
  • Charting
  • Publishing & saving your work

Related material

  • Other types of in-house series 4 tags related Finding
  • Excel in-house – creating & managing 3 tags related Finding
  • Account in-house – creating & managing 3 tags related Finding
  • Introduction to the Excel add-in 3 tags related MB in Excel
  • Document series – adding external data 2 tags related Analyzing
  • Class, AR & Prices 1 tag related Finding
  • Different views – entry-points and how to work with them 1 tag related Finding
  • Finding data – overview 1 tag related Finding
  • Databases in Macrobond 1 tag related Finding
  • Search activity tab – ‘Macrobond defined’ and ‘By description’ 1 tag related Finding
  • Concept & Category view – comparable data in data-tree 1 tag related Finding
  • Calculated in-house series – saving your own calculation 1 tag related Publishing & saving
  • Locate series in Tree 1 tag related Finding
  • List of currencies 1 tag related Finding
  • List of countries & regions 1 tag related Finding
  • Macrobond key series names 1 tag related Finding
  • Naming conventions & other information 1 tag related Finding
  • Integrating and using external data (My series activity tab) 1 tag related Finding
  • Different strategies – How to find the same indicator for different countries? 1 tag related Finding
  • The data-tree structure 1 tag related Finding
  • Application Overview
  • Q&A
  • User Guide
  • Test your skills
  • Analyses
  • Charts
  • APIs/Feeds/Connectors
  • Technical information
  • Legal
  • Support
Macrobond Help © Macrobond Financial AB