Yes, R has lots of stuff. I saw a few projects, but they were above my ability to comprehend since I have yet to learn R. I have been avoiding it so far to learn R but I guess I will have to start it someday. Thanks
It makes sense to look for a third party tool first, actually. In my experience, something like this takes 2 hours to build the functionality (even if you need fancy analytics like resampling and factor correlation). After that, it takes 2 days to make sure the output is nicely formatted. Those two days are always better spent doing something else, but you sometimes need it nicely formatted.
As always multiply estimates with pi (3.14...) and solve for developer When starting from scratch ("I know nathing"), it can actually take days just to find the tools you'll be productive in. LibreOffice Calc may get you started most quickly, but at some point you'll want something more customizable. Going 3rd party comes with extra learning and adapting to infexible ways of doing things as well, but can be great for learning. If you've done it before and used the tools before, then it can take 2 hours for reals. Your wife may claim otherwise though!
The beauty of something like that is that it’s an easy to define stand-alone project. At my previous place of employment, I built something that does this (a bit more complex, as I also used it for allocating risk) as a library and an intern used this library to build a bunch of reporting tools. The library literally too a few hours. The tools took the whole summer, albeit by a guy who knew nothing about finance at the time, but it was still imperfect. This time around, if (more like when) I need pretty presentation of the results I’ll hire a consultant.