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”
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 Location of files Settings for sharing Configuration file Embedding Excel in-house Editing Excel in-house How it works and what is important? How to edit Excel in-house series? Deleting … 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”
Excel add-in loads itself when Macrobond is installed. If it does not appear please check if you can re-enable it. Instruction can be found on Enabling Macrobond add-in.
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”
The settings dialog box in the Excel add-in allows you to adjust your Macrobond account credentials, communication settings, and document directories directly from the Excel add-in. Account Communication Advanced Document paths Account In the account tab, your Macrobond username and password, as provided by your sales representative, are stored. These credentials enable access to the … Continue reading “What’s in Macrobond settings in Excel?”
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”