Introducing Functions, a lot of them...

We are pleased to introduce several mathematical functions on IndiaDataHub in addition to the existing ones to allow you to interact and analyse data with just a few clicks. The newly added functions include CAGR, Interpolation, Moving Averages, Rebase, YTD and MTD transformations, Year on Year as well as Period on Period change, HP Filter, among others. Each of the functions have sub options (you can for example specify the interpolation logic or method of frequency transformation etc).

This video below shows how to apply functions in the Economic Monitor and compare CPI Inflation for India and USA:

And more importantly, the functions can be applied sequentially (one on top of another, upto 3 at a time per series) as well as separately (two separate functions at a time on the same series). And the functions can be applied across the databases. So for example, you can convert a daily NAV series for a mutual fund scheme into monthly series and compare it’s YoY growth to the growth in its monthly AUM. The video below shows how to achieve this with just a few clicks:

Lastly, you can even apply functions programmatically. So the functions are accessible even through our APIs. So instead of simply calling daily 10-year GSec yield, you can through the API call, 20-day moving average of the series. Or YoY Change of the 20-day moving average! Or you can get rolling 3-year Cagr of the NAV of mutual fund schemes, interpolated to fill in the missing dates! Next week, the functions will get rolled out to our Excel plugin, so you can set up your series with the functions you want and just refresh whenever required to get the latest data.

And we will continue to build more analytical features. Next quarter we will be rolling out the ability to build your own custom series by applying different mathematical operations (the entire range of BODMAS operations) as well as currency and unit conversion. And we will be extending functions to the corporate fundamentals database as well. Stay tuned...!

We hope this is useful. Let us know any feedback or suggestions you may have…