I have recently made some changes to the hosting of the blog, if you face issues please let me know. You can always just leave me a message, you already know the number to call.
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 dat