The Signal Amidst the Noise

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

Hey, chocolate lovers! Do you have a sweet tooth for investing as well? If so, you might be wondering whether The Hershey Company (HSY) is a good or bad stock to buy right now. Well, I'm here to give you some insights on this iconic confectionery giant and its prospects for the future. This isn't advice. It's my thoughts and I do have a position in HSY. The Hershey Company is one of the largest and oldest chocolate manufacturers in the world, with a history dating back to 1894. It produces and sells a variety of products, such as chocolate bars, kisses, Reese's peanut butter cups, Kit Kat, Twizzlers, Jolly Rancher, and more. It also owns some salty snacks brands, such as SkinnyPop and Pirate's Booty. The company operates mainly in North America, but also has a presence in international markets. The Hershey Company has been performing well in recent years, despite the challenges posed by the COVID-19 pandemic. In 2023, the company reported revenue of $11.24 billion, ...

Welcome, dear readers, to the fascinating world where science fiction meets reality – the realm of robotic surgery! Over the years, technology has propelled us into realms we never thought possible, and the field of medicine is no exception. In this blog post, we'll take you on a journey through the evolution of robotic surgery, from its humble beginnings to the cutting-edge marvels of today. Buckle up, because this ride is equal parts informative and downright amusing! The Genesis of Robotic Surgery: Our journey begins in the 1980s when the first robots entered the surgical scene. No, they didn't come wielding lightsabers or talking like C-3PO, but they did mark a groundbreaking shift in the way surgeries were performed. The PUMA 560, developed by Unimation, was the pioneer – a robot designed for neurosurgical procedures. While it was a giant leap for medical technology, the PUMA 560's capabilities were still quite limited compared to the surgical spectacles we witness tod...

If you are interested in purchasing Treasury Bills, Notes, or Bonds you might want to consider using Treasury Direct, a website that allows you to buy and sell securities directly from the U.S. Department of the Treasury. However, you might encounter some difficulties when linking your Bank Account to your Treasury Direct account, as I did recently. In this blog post, I will share my experience and how I solved the problem. I have a Morgan Stanley Private Savings Account (eTrade) that I use for my Investments. I wanted to link it to my Treasury Direct account so that I could transfer funds easily and quickly. However, when I tried to add my bank account information on the Treasury Direct website, it did not recognize either the Bank or my Account Number. I was puzzled and frustrated, as I had entered everything correctly using, "Copy and Paste". I decided to call eTrade Customer Service and explain the situation. They were very helpful and courteous, and they suggested that t...

Hey, dividend lovers! If you're looking for some juicy payouts this week, you might want to check out these five stocks that are going ex-dividend soon. That means you need to buy them before the ex-dividend date to qualify for the next dividend payment. Here's a quick list of the companies, their recent closing prices, and their dividend amounts, and Targets for Dividend Capture Strategies: Name and Symbol          |      Ex-Dividend Date      |      Closing Price      |      Dividend Amount 1) Apple (AAPL)          |        12/27/23          |           $189.34          |       $0.22 2) Microsoft (MSFT)     |      12/28/23     |      $312.45     |      $0.62 3) Coca-...

Welcome to my blog! Wow, it's been a month since I tapped-on these keys. I put away the Surface Tablet and I'm writing from my Desktop. This Computer was my late Stepdads. It's a bit older, Intel Pentium 7 Processor, but it can calculate my 1% targets!  Today I want to talk about a serious issue that affects many people in our country: homelessness. Homelessness is one of the most urgent and tragic crises that we face as a nation, and it has many causes and solutions that we need to understand and act on. What inspired me to write about this? I was gathering unwanted clothes to drop in one of those Bins for gathering Clothes. My Spouse suggested I give the one, hardly worn, Pull-Over to the, "Homeless Guy". It has been very cold and this particular Pull-Over appears to be warm.