Finance

A 1-post collection A 5-post collection

This Week: Troy Hunt’s tips on personal finance for technology professionals

By Matt Button |  Jan 25, 2019  | open-source-software, finance, art, tdd

A collection of 5 things from the week that I found interesting, am enjoying, or am working on.

This week:

  • Sometimes Netflix preview images and descriptions get out of sync, creating amusing mashups
  • Troy Hunt’s tips on personal finance for technology professionals
  • Patrick McKenzie on: Should you choose a commercial license or donation model to monetise your open source project?
  • A great thread discussing when to practice TDD (Test Driven Development)
  • Blender 3D tutorial: Create a Modern Bedroom in Blender in 35 Minutes
Continue Reading...

Tony Alexander Presentation Notes - things which affected the NZ housing market over the decades

By Matt Button |  Jan 2, 2019  | investment, finance, property

I recently attended a presentation by BNZ’s Chief Economist, Tony Alexander.

One of the topics that really caught my attention was his perspective on the things that influenced the housing market over the decades, from the 1950’s until today.

I wrote up a bunch of notes to summarise his points.

If you’re interested in getting a bit of perspective on the NZ property market, and some of the things that caused it’s near-relentless movement upward over time, then read on.

Continue Reading...

How to scrape Yahoo Finance and extract fundamental stock market data using Python, LXML, and Pandas

By Matt Button |  Jan 24, 2019  | python, pandas, lxml, scraping, finance, featured

In this blog post I’ll show you how to scrape Income Statement, Balance Sheet, and Cash Flow data for companies from Yahoo Finance using Python, LXML, and Pandas.

I’ll use data from Mainfreight NZ (MFT.NZ) as an example, but the code will work for any stock symbol on Yahoo Finance.

The screenshot below shows a Pandas DataFrame with MFT.NZ balance sheet data, which you can expect to get by following the steps in this blog post:

After taking you step by step on how to fetch data from the balance sheet, I’ll show you how to generalise the code to also generate a DataFrame containing data from the Income Statement, and Cash Flow statement.

After creating the Pandas DataFrames, I’ll then show you how to export everything to an Excel file, so you’ll have output that looks something like this:

This post was last updated in October, 2019. Prior to this, Yahoo Finance conveniently had all this data in a regular HTML table, which made extracting the data super easy. Since then, they’ve updated the page with a new structure, which was a wee bit tricker to get the data from. Fortunately, it’s still possible. Read on to find out how.

Continue Reading...