Document in-house series Calculated in-house series External in-house series Beside Account and Excel in-house you can create other in-house series with Macrobond: Document in-house series If you need one-time data that will be accessible only in that file it’s what you were looking for. Its prefix is ih:mb:doc. For more information see Document series – … Continue reading “Other types of in-house series”
Purpose and warning How it works? Creating Excel in-house How to link Excel file? Range vs Entire column Adding Excel in-house to a chart Sharing Excel in-house Sharing through Sharepoint/Office 365 Location of files Settings for sharing Configuration file Embedding Excel in-house Editing Excel in-house How to edit Excel in-house series? Deleting Excel in-house Purpose … Continue reading “Excel in-house – creating & managing”
Purpose Creating Account in-house From application Multiple series From Excel Elements of template Multiple templates Uploading templates Adding Account in-house to a chart Sharing Account in-house Editing Account in-house Changing Account in-house’s location Deleting Account in-house Questions Can i download in-house series through other Macrobond API (i.e., Python)? How do I upload a time series, … Continue reading “Account in-house – creating & managing”
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 FactSet Direct & Terminal Integration 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 … Continue reading “Naming patterns”
What is it for? About document series How to create a document series Manually enter the values & dates Using ‘Paste document series’ Paste data set Using document series What is it for? Every now and then you might want to use a non-Macrobond series in your analyses, for a one-off calculation. In cases like … Continue reading “Document series – adding external data”
There are two ways of embedding an in-house series into a document. Document properties Press F4 (or go to File > Document properties) and in the dialog box tick the checkbox Embed in-house series in document. Then (re)save the file and you can share your own in-house series with other Macrobond users. Please note that … Continue reading “How to embed an in-house series in a document?”
Enabling Macrobond add-in From Disabled Items From COM Add-ins By adding .dll file Macrobond Excel Udf Functions Import time series Select series by using the data navigator Get series from country overviews Use the result from a Macrobond document Data sets Import reports In-house series With the Macrobond Excel add-in (which works as Excel connector … Continue reading “Introduction to the Excel add-in”