Skip to main content

Google sheets with importHTML for finviz.com

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 finvis.com.  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 finvis.com 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

Comments

Post a Comment

Popular posts from this blog

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 n...
Post a Comment
Read more

July traffic

Just a quick update to let everyone know that the measured traffic on Blogger.com 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.
Post a Comment
Read more

As a webmaster, I am a failure.........so far.

The traffic to this blog has began to fall.  Here are my monthly numbers according to Blogger.com Jan, 2020 214 Feb, 2020 567 Mar, 2020 577 Apr, 2020 278 May, 2020 312   I only purchased the blog in January after someone else failed to renew the name.  I was looking for a low cost name which the number.xyz are at only .99 per year.  I looked this number up as it is one of the few phone numbers that I actually remember now that all my contacts live in my phone.  The person that had the name before me simply setup a wordpress website and did not make any posts or attempts to post anything.  I assume they were simply hoping to sell the name at a higher price.  When that did not work, they dropped it and I picked it up.  As you can see from the number of posts, I have not done much either.  I have always assumed much of the traffic here at the start was from things the previous owner of 8675309.xyz did with the name.  I am attempting to trac...
Post a Comment
Read more