Dynamic Pricing: How MLSE Controlled the Sale of Raptors NBA Finals Tickets

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

Published
Categorized as Finance

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

Published
Categorized as Finance