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.
Note you have to have installed our Office add-in to use these codes. Add-in installs itself along with Macrobond main-app installation. See below prepared VBA codes to use in Office programs: Excel update all data from VBA code upload all series from VBA code automatically when opening an Excel file update a selected chart or … Continue reading “VBA codes”
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”
Overview List of formula functions Notes about arrays Using formulas through ‘insert’ in Excel Question Can I access vintage data through MbndGet? Where do I find the list of metadata available with the MbndMeta Excel function? Why it is not working? Overview Macrobond Excel formula functions give you flexibility and enhance your work in Excel. … Continue reading “The Macrobond Excel formula functions”
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?”