Direct download from Excel add-in Copy as Excel data set from Macrobond Updating data sets in Excel There are two ways to access Macrobond data in Excel. You can either start in Excel, perform a direct download using the Macrobond add-in. Or you can start in the application and download the calculations you’ve performed there … Continue reading “Accessing Macrobond data in Excel”
Positioning the data set Adding metadata Inserting columns & rows in a data set Locating series in the data tree Selecting more series Switching between database views Positioning the data set When you work in Excel, organizing data is crucial, especially if you download a lot of data sets from Macrobond into one sheet. Each … Continue reading “Working with All series mode”
By pressing Import button you can download data used in your saved charts directly to Excel. Double-click on a chart and it will open as ‘red object’ panel. Press OK and it will be added on the sheet.
With Overview tool you can download overview data for selected entity. This same feature as in Macrobond main-app under Browse tab > Overview. 1. Pick a country or company Here, you select the country or company that you want to include in your report. 2. Type of overview Here, you can select type of data. … Continue reading “Overview mode”
With the report tool in Excel, you can quickly get an overview of countries or companies by downloading Macrobond’s selected key indicators for them. This same feature as in Macrobond main app under Browse tab > Overview > Reports. 1. Pick a country or company Here, you select the country or company that you want … Continue reading “Create reports in Excel”
Which mode to use Processed Adding calculations in the Processed mode Raw When downloading data from the application database to Excel, you will need to select one of two download modes: Processed and Raw. The primary difference between the two options whether start dates and/or frequencies have been harmonized. Which one of the options you … Continue reading “Processed/Raw data selection”
Purpose The All series workspace Convert to document data set All series mode is the main access point for downloading data into Excel. It gives you access to your entire application database and provides various options for downloading the data in a specific format. Purpose Use it to: Search through all the time series available … Continue reading “All Series mode”
Far be it from us to tell you where you work best. At times, what works best for you might be Excel, even if you still want the benefits of using the Macrobond database. Working with Macrobond data in Excel can be very efficient, and probably more flexible than you’d expect.
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”