- Creating data set
- Editing document
Excel add-in includes most commonly used calculations, such as Rate of change and Scale, for everyday work. But this is not the full range of analyses that Macrobond offers. You can quite easily use more advanced analyses and download the output to Excel.
To access the full range of analyses you can use with your work in Excel, start by opening the application and going to the Analytics tab. Add the series to a Macrobond document. All you have to do now is add the analysis and select which settings to use.
To open rebased the series in Excel, right-click on the corresponding branch in the Analysis tree and select Copy as Excel data set.
Now, you can go to Excel and paste the data set (with Ctrl+V or by right-click and Paste Special). Every data set you paste comes with a red object. It stores your downloaded data set as well as the settings.
This feature is available in Macrobond 1.25 and later.
Here you can decide which calculation you want to use when downloading the data. The list shows you what you applied in your Macrobond document. You could, for instance, output the original data by clicking Series list.
Although the overall look is a bit different than in Data set object created with Excel's All series - each panel works the same. For more information on how they work see Working with All series mode.
You can also add empty rows or columns to the data set, these are called blank items.
Series list is like a big basket of assorted time series. If you want to keep the order of series copy data set from Time table. For more information see Copy special from time table.
If you want to make any adjustments to the calculations, just click the Edit document... button. An information window will show up and data set will open as Macrobond document. Once you’re done with your changes, you can close the Macrobond document.