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

Portfolio Balancing with Historical Stock Data

Posted by Jack McKew on Fri 19 April 2019 in Python • Tagged with finance, python • 4 min read

Following last weeks' post (Python for the Finance Industry). This post is to demonstrate a method of determining an optimized portfolio based on historical stock price data.

First of all while attempting to tackle this problem, I stumbled across many very informative articles in which based on what I learned …


Continue reading

Python for the Finance Industry

Posted by Jack McKew on Fri 12 April 2019 in Python • Tagged with python, finance • 3 min read

This is the first post in a series of posts dedicated for demonstrating how Python can be applied in the finance industry. Personally, the first thing that comes to mind when I think of the finance industry is the stock market. For fellow Australians, our main stock exchange is the …


Continue reading

How to Program an ESP8266 with MicroPython

Posted by Jack McKew on Fri 05 April 2019 in Engineering • Tagged with electrical, esp8266 • 1 min read

Following the previous two weeks of topics, Introduction to ESP32/ESP8266 and What is MicroPython?.  I wrote an article on maker.pro in which I describe how to program the ESP8266 with MicroPython in detail.


What is MicroPython?

Posted by Jack McKew on Fri 29 March 2019 in Python • Tagged with python, micropython • 2 min read

From the MicroPython docs themselves “MicroPython is a lean and efficient implementation of the Python 3 programming language that includes a small subset of the Python standard library and is optimised to run on microcontrollers and in constrained environments.”. But what does all this mean? Python 3 is one of …


Continue reading

Episode 10 - Python Package Cheat Sheet

Posted by Jack McKew on Fri 25 January 2019 in Python • Tagged with python, packaging • 3 min read

One of the biggest skills in any career path comes solely from knowing where to look and what to look for when breaking down a problem. The same principle applies for Python programming. Since there are millions of different packages out there that all serve different purposes, it is often …


Continue reading

Episode 8 - Anaconda

Posted by Jack McKew on Fri 11 January 2019 in Python • Tagged with python • 3 min read

Python is one of my favourite languages to develop in (if you haven't noticed yet). My favourite feature of Python is how easy it is to share your work with others and integrate other's code into your own projects. However as a project grows and gets older as time goes …


Continue reading

Episode 4 - Visualization

Posted by Jack McKew on Fri 14 December 2018 in Python • Tagged with data, visualization • 1 min read

In an ever growing world of data, every person perceives data in their own personalized way. This calls for data analysis to be visualized in a clear straightforward way so that it is accessible by anyone may come into contact with the system.

By further making the data analysis system …


Continue reading

Episode 3 - Open Mind

Posted by Jack McKew on Fri 07 December 2018 in Python • Tagged with database, selfimprovement • 1 min read

While it always may seem to be easiest to keep using what you've always used in the past, sometimes it pays off to keep an open mind about how you approach problems.

Recently was asked to create a database with minute interval data from 600-700 data recording stations for up …


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