• DataSlicer - DataFrame for Excel

    Introducing DataSlicer Add-In: Advanced Data Analysis in Excel DataSlicer brings over a hundred functions from the pandas DataFrames right into Excel, enhancing your data analysis capabilities. As an early prototype, we’re actively seeking feedback to refine its features and functionality. As we continue to enhance the user experience, we’re also in the process of adding new functions and refining our API. We would appreciate your insights and suggestions; please drop us a line at info@adaptiverisk.
  • 64bit

    Introduction In this post we describe a technique that allows your Excel addin to be loadable by 32 bit Excel, but lets you run calculations that require more than 2GB of RAM. Most people in financial industry use 32 bit Excel even though they are running it on 64 bit Windows. The main reason for this is backward compatibility - if you have a set of 32 bit addins that you used with previous version of Excel you’ll stick to 32 bit Excel when upgrading.
  • Deployment Blues

    Introduction It happens often: you compile your xll addin and give it to yor client just to hear them complaining that they cannot load the xll into Excel. The error that they see is: “The file you are trying to open, ‘MyAddin.xll’, is in a different format than specified by the file extension. Verify that the file is not corrupted and is in from a trusted source before opening the file.
  • Time Stamp Your Library

    When you distribute your program, library, or xll addin it is usefull to have a function that can tell you when your project was compiled. This way you can ensure that the new program, library, or xll addin is correctly installed on a user’s system. In this post I will describe how to set up such function in your Visual Studio C++ project. Create timestamp.h with the following content: 1 2 3 #include <string> std::string TestTimeStamp();