DOI: 10.21227/aqpa-ds26
title: Invest like Warren Buffet using Excel and Google Sheets

description: Warren Buffett is one of the most famous and successful investors of all time. At the time of this writing his networth is $86.5 billion USD. He has been value investing for over 50 years which means that he can provide a lot of wisdom based on his experiences with the financial markets.Perhaps you are one of those people who wants to use Warren Buffett’s wisdom to assess and invest in companies for the long-term but are bogged down by jargon, lack of experience and not enough time. Wouldn’t it be nice if Warren Buffett was your advisor? Let me show you how Warren Buffett could be your advisor (without even talking to him) by using freely available information and tools on the Internet.To be clear I am not going to teach you how to do value investing since it is out of my league (for now). Instead, I am going to teach you how to copy/imitate/replicate Warren Buffett’s portfolio. A word of caution, even Warren Buffett makes mistakes so always consult your financial advisor for your specific situation.Warren Buffett said:Someone’s sitting in the shade today because someone planted a tree a long time ago.What You Will NeedToday, you are going to learn to plant a seed of your financial tree using the following free information and tools:Google SheetsWhale Wisdom for getting 13F Filing DataYahoo! FinanceAn online commission-free brokerage account (e.g., Robinhood)Finsheet to get stock price in Excel and stock price in Google SheetsAt the end of this, your Google Sheet should look something like this:The StepsStep 1 — Getting Google Sheets Workbook Ready:Open a blank Google Sheet workbook and name it whatever you want (e.g., My Empire).On cell B1 (it could be any cell but for me I like to have information upfront), write How much money do you want to spend on buying shares?rty3On cell E1, write the amount.Step 2 — Getting 13F Filing DataGo to Whale Wisdom to get Berkshire Hathaway Inc.’s 13F filing data. FYI — Warren Buffett is Berkshire Hathaway Inc.’s CEO.Copy that 13f filing data onto your Google Sheet workbook.Step 3 — Setting Up Your ColumnsRemove columns you don’t need. I have removed some for simplicity.Create the following columns:Recent PriceAre you paying less than Warren Buffett per share?Approximate money you could spend on this ShareApproximate number of Shares you will get with your moneyDividends Per Share Per YearDividends Expected To Be Received Per YearTo Be Eligible for Dividends Buy Shares Before This DateStep 4 — Lets do some coding (kindof)To get latest (20 minute delayed) current price of a share, on cell E3 type =GOOGLEFINANCE(A3)Cell E32. To compare if you paid less for a share than Warren Buffett, on cell F3, type =if(E3&lt;D3, “Yes”, “No”)Cell F33. To calculate how much of your money should go to this stock, on cell G3, type =($E$1*B3)/100Cell G34. On cell H3, type =G3/E3Cell H35. On cell I3, type =LEFT(IMPORTXML(“https://finance.yahoo.com/quote/"&$A3&"","//*[@id='quote-summary']/div[2]/table/tbody/tr[6]/td[2]"),4)Cell I36. On cell J3, type =H3*I3Cell J37. On cell K3, type =IMPORTXML(“https://finance.yahoo.com/quote/"&$A3&"","//*[@id='quote-summary']/div[2]/table/tbody/tr[7]")Cell K3Ok. Done. This Google Sheet will pull information from Yahoo! Finance. The beauty of this Google Sheet is that you can put any Stock Symbol in column A and it will pull information in. In this case, you might want to remove the columns where you compare yourself to Warren Buffett.Step 5 (optional)— Lets Get FancyWhat Google Sheets can do is just the tip of the (data) iceberg plus its free. If you have gotten this far, you can also do some fancy? things such as:To pull 52-week low for the share on cell M3, type =GOOGLEFINANCE(A3, “low52”)To pull 52-week high for the share on cell N3, type =GOOGLEFINANCE(A3, “high52”)To calculate if the current price is &lt; than the 52-week average, type =if(E3&lt;((M3+N3)/2), “Yes”, “No”)Feel free to add/share your fancy tweaks and improvements in the comments section.ConclusionNow that you are equipped with this new tool that you created, perhaps it is time to test it out. Remember that your Google Sheet workbook is pulling data from other sources and thus if something happens to the data sources then your Google Sheet workbook might have issues.I got to know all of these amazing services for spreadsheet via this guide, which provides details about how you can get stock price in Excel and stock price in Google Sheets. It is super helpful, check it out if you are interested.