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”
The All series workspace Purpose 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. The All series workspace Series browser Download settings Data download list Purpose Use it to: Search … 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 Data sets Import reports In-house series With the Macrobond Excel add-in (which works as Excel connector to Macrobond) you can import data from Macrobond into Microsoft Excel and easily keep it updated with the latest … Continue reading “Introduction to the Excel add-in”