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