I recently discovered the amazing work of Fabrice Rimlinger at http://sparklines-excel.blogspot.com and thought of what I believe is a novel way of using the Microsoft Excel integration with Advent Axys reports to potentially achieve a dashboard style report. This would be far more visually compelling and informative than anything else I have seen in Axys. For this report, we will just use the standard Axys Portfolio Summary Report and then an Excel macro http://www.box.com/s/9jenb341qmv4iaoeh5uy. Please also install the appropriate Excel add-in from http://sparklines-excel.blogspot.com.
I know the audience for this will be more limited than my general audience. I might move these Axys report discussions to my incomplete and defunct http://axysreporting.com site.
For the R lover, I am hoping to also incorporate the unbelievable RExcel from http://rcom.univie.ac.at/.
No comments:
Post a Comment