Efficient Frontier for Balancing Portfolios

Posted by Jack McKew on Fri 26 April 2019 in Python • Tagged with python, data, analysis • 5 min read

Following last 2 weeks’ posts (Python for the Finance Industry & Portfolio Balancing with Historical Stock Data), we now know how to extract historical records on stock information from the ASX through an API, present it in a graph using matplotlib, and how to balance a portfolio using randomly generated portfolios …


Continue reading

Episode 1 - Optimization

Posted by Jack McKew on Fri 23 November 2018 in Python • Tagged with data, analysis • 1 min read

Recently I had to opportunity to optimize some workflows that involved heavy data processing, before the users were completing calculations/statistics by hand on up to 10 million rows in Excel, causing many complications (and crashes).

With the use of Python this data analysis has been reduced to a matter …


Continue reading