Michael's Investment Perspective:
Navigating Wealth, Risk, and Life’s Lessons

 Hey, everyone! In this blog post, I'm going to show you how I use Google Sheets to do some cool coding stuff with stock data. Specifically, I'm going to explain how I filter by column and calculate the closing averages over different time periods for different companies. Sounds fun, right? First, let me tell you how I set up my spreadsheet. I have a sheet called "Indicators" where I store all the data I need. In row 2, I have the ticker symbols of the companies I'm interested in, sorted alphabetically from left to right. In row 13, I have a formula that uses the GOOGLEFINANCE function to get the closing prices of each stock for the past 185 trading days. For example, in cell H13, I have this formula: =INDEX(GOOGLEFINANCE(H2,"PRICE",TODAY()-185,TODAY()),,2)

 If you're looking for a solid dividend stock in the home furnishings sector, you might want to check out Ethan Allen Interiors Inc. (ETD). This company is not only a leading interior design firm, but also a manufacturer and retailer of quality furniture and accessories. In this blog post, I'll give you some reasons why I think Ethan Allen is a good investment right now. First of all, let's look at the growth rates of Revenue and Net Income. According to the latest quarterly report, Ethan Allen's revenue for the first quarter of fiscal 2024 was $191.8 million, up 4.7% from the same period last year. Net income was $18.2 million, up 10.4% from last year. The company also reported strong operating margins of 14.7%, which reflects its operational efficiency and cost control. Second, let's talk about the expansion of services. Ethan Allen is not just a Furniture Seller, but also a very unique full-service interior design destination. The company offers free design consu...