Extracting data from multiple financial models using Modano

APIData Sourcing
2 posts / 0 new
Log in or register to post comments.
Last post
6 years ago
#1
X 0
Extracting data from multiple financial models using Modano

Hi Modano Community,

We have a group of modular financial models that we've built using Modano and, while the core of each is quite standard, there are lots of variations between them in things like categories and drivers and modules, etc. We're trying to find a way of getting some key stats out of each of the models - but a challenge with that is that everything is in different places in each of the different models.

I know Modano allows for links to be assigned in and out of rows and category blocks within modules, so what I was wondering is, is there a way to access those fields across multiple files (up to hundreds of files). For example, if I had 100 models in a folder and they all had a standard module for 'credit output' that included revenue, EBITDA, and whatever else, is there a way to pull the revenue line from all 100 models into one place?

It wouldn't need to be native functionality or 'click of a button' to be helpful. For example, the way I extract the data now is with Power Query, but it requires a lot of manual manipulation to tag fields etc. If I knew that all those models had a standard set of output fields, that would allow me to access it more cleanly.

Thanks,

Jeffrey

6 years ago
Michael Hutchens A+ 162

Hi Jeffrey,

I’ve attached an example of how you can easily source data out of modular workbooks using VBA and the Modano API to locate the precise location of data. The example sources revenue from 3 completely different workbooks to demonstrate this concept, and could be used for pretty much any data sourcing very reliably.

This really is the tip of a very large iceberg, as the Modano API is a bunch of VBA code we’ve written to facilitate the automation of modular workbooks using VBA code. It’s really powerful stuff, and we’re using it with Modano users all around the world to automate things never previously easy to automate.

As always, the code in the attached workbook (Modano-API Example-Data Sourcing.xlsm) speaks best for itself, but please note that:

  1. You will need to install at least version 10.1.15.0 of Modano (see www.modano.com/software/updates) before running this code.
  2. Make sure you unzip all 4 workbooks in the attached ZIP file into the same folder, and that you open only the workbook named ‘Modano-API Example-Data Sourcing.xlsm’ before running the macro. The code is in a module named ‘GetData’.

If you’re interested in learning more about the API and playing with a range of example code, you can download the latest Modano API using this link: http://www.modano.com/api/latest

I hope you like it!

M.

Attachments: 
Modano-API Example-Data Sourcing.zip