Skip to main content

Google sheets with importHTML for

Hello everyone, I have been working on a Google sheet that helps me stay on top of some stocks.  I really like the googlefinance function as it updates various fields with almost no effort at all.  One attribute that I want in my spreadsheet is yield.  I have found that Google only provides this information for mutual funds.  In order to capture this information, you can use the importHTML function if you can find an appropriate website.  In seems yahoo finance has provided a good source in the past, but does not want to provide this data going forward.  They keep changing the data structure which wrecks the formulas in your spreadsheet.  It seems a very popular alternative is  If you visit their website, you can see a table structure with the various fields that are available.  In my linked spreadsheet, you will find two tabs.  The finvis tab contains two sets of data.  At the top is a simple copy paste of the website for aapl of all table data.  The second data set is the complete table of data, just put you preferred ticker in cell B1.

The template tab is what you are probably trying to find to complete your spreadsheet.  This tab has a formula to return each of the individual fields of the table on the finvis tab.  Now you can simply find the individual field that you desire in your personal spreadsheet, just copy and paste the formula that you want.  The only change you might want to make is the reference cell of $B$1 to the cell that contains you ticker symbol.

When I was working on getting the values for my personal project, I kept getting errors.  I could not find a link to a working spreadsheet to tweek the formula to my own personal needs.  Through some trail and error, I finally got this working and thought I will share my Google sheet to help someone else.  Now you might be able to find this awesome Google sheet with a working importHTML function that can be paired with googlefinance function.  I hope this helps you create the Google sheet that puts you on the road to financial success.

Shared Google sheet


Popular posts from this blog

July traffic

Just a quick update to let everyone know that the measured traffic on to my blog has continued to drop. July's views were 292, down slightly from June which came in at 374. My traffic peaked back in February and March when traffic averaged 572 over both months. I might post a google sheet with each month's traffic that I will keep updated. Let me know if you have any questions. Thanks.

An open love letter to Microsoft OneNote

  This is an open love letter to Microsoft   OneNote .  I finally get you.  I have struggled with you for years, never quite seeing the power of your platform.  I am not sure that I have the best organization for the data that I collect with various sections, pages and notebooks.  I have created various entries and collected some somewhat useful data, but honestly until recently   OneNote   has been my second or third choice for saving research.  What recently changed for   m e has been connecting the   OneNote   clipper extension.  The   OneNote   clipper extension has enabled me to capture an entire article as searchable data.  In the past, I generally found that I needed to copy and paste to have all the text saved to   OneNote .  I did try the print to   OneNote   printer driver, while it did capture all the data of the article it seems to be   an image   file.  I was not able to copy and paste text from a printed article and the title is simply printout on my   OneNote   book.  Cl