While Excel is ubiquitous, I prefer Python for my data analysis. Spreadsheets are great for formatting data, but it's Python that's allowed me to build my own super calculator out of regular Python ...
QuantStats Python library that performs portfolio profiling, allowing quants and portfolio managers to understand their performance better by providing them with in-depth analytics and risk metrics.
Then you should have the IBSpy command available. If you want to use the KMC binder, install the KMC and compile the python instructions. Then, run the following command to setup the path for it.