One Of Warren Buffett’s Favorite Metrics Says Stocks Are Way Too Expensive.

warren-buffett

I was searching on metrics that Warren Buffett likes to track and I found this article on Forbes about U.S. Total Market Capitalization and how he uses it to determine if the market is to hot or just right.

The Buffett Indicator takes the stock market’s market capitalization and divides it by the US Gross Domestic Product. From an interview he did with Fortune in December 2001 Buffett said “For me, the message of that chart is this: If the percentage relationship falls to the 70% or 80% area, buying stocks is likely to work very well for you. If the ratio approaches 200%–as it did in 1999 and a part of 2000–you are playing with fire.”

Well, if you download Atlas Insights, now you can have Warren’s favorite market indicator right on any of your mobile devices (Apple or Android) or desktops (Windows or MAC) and you’ll be just as informed as Warren.

IMG_2900

Tracking the CNN Fear & Greed Index in my app now. Pure-awesomeness

Capture

Business Insights is not just about tracking your personal business metrics, but it is also about combining them with publically available metrics too.  I can easily load this data into my data feed and have it shown with other important metrics I’m tracking in my favorites.  Now I can see a real heartbeat of the stock market on my phone.

Right now the Index is reading at 90 which means there is extreme greed in the market.  This means it is a great time to sell the market.

Pretty amazing, Patrick

What’s the social sentiment on Godaddy and Etsy IPO? Not Good… @plusonesocial #viz

Capture

That is GoDaddy above at the end of day in regards to their IPO.  I’m using Plus One Social to pull on the $GDDY keyword on Twitter as that is what the stock analyst use to comment on stocks.  I’m using Microsoft Excel with Power Pivot and a special sentiment function I created.  It works great!!!!

Capture

Etsy ($ETSY) wasn’t any better.  It was actually worse…  Makes you wonder about companies going IPO and never making a profit…

Enjoy, Patrick

PS.  If you want to do this, visit PlusOneSocial.com and use the Excel Analyst Pack.

Real-Time Stock Quotes in Microsoft Excel. #dev #mydata #analytics

image

Do you know how to retrieve real-time stock market data into Microsoft Excel?  Yeah, me neither until now.  For years I’ve been doing cut and paste which is slow, error prone and a pain if you want to manage many stocks.

Since I’ve kind of gone “Back to Dev” in my career, I spent some time over Christmas to re-teach me some basic development skills so I started with something that is personal to me.

I have Microsoft Excel 2013 installed so I started with Power Query.  Power Query allows you to search for dataset out on the web.  I was searching for the S&P 500 and it came back with 400.  Well, that works for me.

image

I plopped the data into a spreadsheet and removed the key row.  Who needs a key right?  We have the stock ticker!   That is the key.

Now we are off to writing some code.  I’m not going to give you all the boring details, but utilizing Yahoo Finance, you can get a table CSV feed by passing over your stock ticker.  Then you take that table of data and break it down to the price column for your report.   Basically I’m writing a custom function for Excel in Visual Basic!!  I miss VB.

image

Now, I converted my Power Query into a Table of data that Excel can understand better.  Then I inserted a column for Price.  In that column, I type my custom formula I created and referenced the stockticker column and hit enter.  Since it is referenced as a table of data in Excel, the formula paints down the entire dataset retrieving the latest stock price for that stock.

image

Now I can take that data and put it into a chart and show the Top 10 stocks by price.  Wow, did you know that NVR has a share price of $1,040 today?  Crazy…
image

If you have any questions, go ahead and contact me and I would be happy to answer them.

Enjoy, Patrick