Someone paid $76,477.50 CAD for a pair of tickets to Game 1 of the NBA Finals in Toronto. The average household income in Toronto is $65,929 CAD.The average ticket price of NBA Finals games in Toronto is $1,933 CAD. With these unbelievable numbers, what’s a fan to do? Do you fork over a month’s worth… Continue reading Dynamic Pricing: How MLSE Controlled the Sale of Raptors NBA Finals Tickets
Category: Finance
Where the Money Comes From: Toronto Councillors
The Toronto Municipal Election is scheduled for October 22, 2018. Incumbent mayor John Tory is running for re-election, but there is expected to be a lot of change in terms of those governing the city. Toronto City Council has added the new wards in the downtown core to account for the rising growth in population… Continue reading Where the Money Comes From: Toronto Councillors
Pulling Stock Data and Creating an Efficient Frontier in Excel
I mentioned in a previous post on how to get (nearly) live stock data from Google Finance. However, if you start pulling data from different markets, daily historical rates won’t make sense as different markets are closed on different days. This causes problems when trying to figure out the correlation between stocks. A solution to… Continue reading Pulling Stock Data and Creating an Efficient Frontier in Excel
Scraping Stock Data from Google Finance
For this tutorial we will be using Google Sheets. Google Sheets is a great resource for scraping data from the internet and it’s free!