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
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