In yesterday’s post about all my Amazon orders, JonathanC posted an interesting comment: “How about this one as a Power BI challenge: current value of the portfolio if you had purchased stock of Amazon instead of the product.” … Challenge accepted!
I already had a list of all my Amazon orders. I think headed to Yahoo Finance and downloaded a daily history of Amazon stock stretching back to 2001 when I made my first product purchase. That came as a CSV file too. Both files got loaded into Power Query. I did a merge on the date column, removed the columns that I didn’t need, and added a custom column that was the money spent divided by the closing share price that day. That told me how many shares I could have purchased. A quick sum over that column divided by a sum of the money spent revealed that I would have made an 81% return on my money! But wait a minute, transactions aren’t free. If I was pay $8 per transaction then I would have only made a 37% return. But that’s silly since I probably wouldn’t have bought $10 of stock at a time like I do with Amazon orders.

I’ve been reading a lot of good books lately thanks to
There are a lot of board game fans at work. They buy pretty much every game that comes out and give it a whirl. A year or two back, I asked some of them what would be a good next game now that we’re getting a bit played out of
My second RC plane is an 
We make heavy use of OneNote which probably isn’t much of a surprise, but Tyla and I also use it a lot at home. We both have our own sections where we keep all kinds of notes and then we have a shared section where we keep the grocery list, ideas for gifts for friends and family, lists of doctors, and much more. It’s a great tool for getting rid of miscellaneous pieces of paper and for keeping in sync with other people.
Amazon Order History
Did you know that you can download a report of your Amazon orders? I pulled all that data into Excel and started playing with our Power BI toolset even though it was a pretty simple scenario. Here are some of the facts I discovered:
Here are some graphs over the data. It will be pretty obvious that I signed up for Amazon Prime in June of 2008. On a side note, the recent Amazon Prime price increase doesn’t bother me at all. It’s still one of the best deals in online shopping, not to mention that I also get some free Kindle books, and a pretty good collection of streaming video for free. They could charge a lot more and I’d still pay for it.