Skip to main content

The New Advisor - Automating Stock Suggestions

Recently I committed to developing a Spreadsheet that provides recommendations. The New Advisor compares and calculates several quantitative metrics that, I feel, provide optimal Buy/Sell recommendations. I value having my own program outlining which companies are likely great companies at a great Value. Here is how I automated The New Advisor (Periodical)

The Spreadsheet makes calculations on 16 Points of Quantitative Analysis. I will share periodically and start here.

1. Assets to Market Cap.

    A favored measure for an entry, or accretion, point! I first came to understand this measure from reading Graham. Market Cap is an imaginary figure determined by multiplying the last sale of the Stock by the Number of Shares. It offers a significant indication of protection and Value, revealing Assets, some intangible, backing-up the Purchase Price. Here, on the Spreadsheet, Points are allotted based upon the aforementioned percentage. If A (Assets) >= % MC (Market Cap), the Stock is allotted points. It should be understood that with a greater Percentage more points, or point accretion, occurs.

The debate, or main argument-against this; it's based upon the last sale price, Shares in circulation, and what the company last reported as Assets. Also, there is no protection against unscrupulous Managers' overstating Assets. But as an Investor should understand, Stocks are often referred to as, "Equities," for good reason. So, with thought, we must develop this puzzling question. Why did Graham point Reader's and Students of Columbia to use this assessment (Assets/Market Capitalization)? A mindful Analyst would come up While this does not illustrate or associate points for, "Equity," at this point of time in Business operations, it is the base point of what one should, in my opinion, see as potential. It is, "Time," that is fundamental of all things especially Business or Investing-in. This point of analysis is determining a good point to begin the Clock. Equity growth, or anticipated, "Vector," going further in time would only be outlined in conjunction with, A/MC along with, Vector of Equity (The margin between Assets and Liabilities).

So, one may question, "Why is the Quantitative Metric calculated using Assets rather than Equity?". I think Graham was realizing what Peter Lynch outlined in, his own, proceeding writings. We seek to find an upward, "Vector". We seek accretion in both Capital and Income from Capital (Augmenting income with Dividends). Or, at least, the former alone. So, the intention should not be to acquire a company at, what I consider to be, Book Value (The balance of the Strike Price to the Equity at Strike). We shouldn't be so strict that we are eliminating, partially or completely, risk and potential reward. Therefore, we turn to the Assets, to establish a guidance. We there may Buy at less than Equity, but very likely, indeed, then realize an increasing, "Price Vector". 

So I attempt to point-out my observation here in writing. It's not the true Book Value we seek for entry... That being the Total Assets less the Total Liabilities (Equity)… We may be paying quite a premium above the Book Value but not so much as to be below the entirety of Assets. It is here Graham thought, and taught Students at Columbia, to test this entry point, as outlined early in, "The Intelligent Investor". We then are likely to realize, by comparing the Assets to Market Cap, we could Invest in a Company that recently had an irrational Downward Vector (In Price). Graham, like any rational Investor, realized that Market Cap was the greatest barometer of Sentiment. A logical explanation of Market Cap might not exist. Was it Graham's success to Invest in a Company that is slightly out of, "Favor," but maintains promise behind the scenes? I think so. Despite this metric may offer the perfect entry point we must go further in analysis to reveal promising opportunities.

Popular posts from this blog

How to Add Beneficiaries on E*TRADE Without Losing Your Mind

“Because your money should go where you want it, not where the probate court thinks it should, I am sharing this information.” Ah, E*TRADE. The place where your money grows, your trades execute (sometimes), and your hopes for financial freedom flutter like a candlestick chart on a volatile Thursday. But what happens if you kick the bucket before you get that Tesla stock to moon? Simple: you assign a beneficiary. Unfortunately, E*TRADE doesn’t make this as intuitive as you might think. This isn’t a “click here and boom, you’re immortal” situation. But fear not, fellow capitalist. I’ve braved the pixelated jungle so you don’t have to. 🛠️ Step-by-Step: Setting a Beneficiary for Your E*TRADE Brokerage Account (aka “How to ensure your money doesn’t end up in your ex’s lap or your neighbor's GoFundMe”) Log in at etrade.com . (Obvious, yes. But worth saying—this isn’t Webkinz, you need the real site.) At the top, click “Accounts” and select your Brokerage Account . (The on...

NJ's Middle-Class Squeeze: Too Much for Help, Not Enough for Comfort

This is a long post — longer than what I usually write — because what I’m talking about here isn’t a small annoyance or a passing frustration. It’s something that has been building for years, and I’m finally putting it all into words. I’m upset, I’m exhausted, and I’m passionate about what follows, because it affects every working person in this state who’s trying to stay afloat. There’s a growing group in New Jersey — people who work full‑time, sometimes more than one job, who earn too much to qualify for assistance but not enough to absorb the constant increases in living costs. These are the people tightening their budgets, lowering their thermostats, cutting back wherever they can, and still watching their bills rise for reasons that have nothing to do with their own usage or behavior. If you’re part of that group, or you know someone who is, then what follows will probably resonate with you. And if you’re not, then I hope this gives you a clearer picture of what the middle class i...

Understanding Treasury Bond Auctions: The Difference Between High Yield and Interest Rate

Treasury bonds are a popular choice for investors looking for a reliable source of income backed by the U.S. government. However, understanding how these bonds are priced at auction can be confusing, especially when comparing the High Yield and the Interest Rate (Coupon Rate) columns. In this post, I'll break it down using a real-world example.  A Look at a Recent Treasury Bond Auction Here’s an example of a 20-year Treasury bond that was recently auctioned: Security Term CUSIP Reopening Issue Date Maturity Date High Yield Interest Rate 20-Year 912810UF3 Yes 01/31/2025 11/15/2044 4.900% 4.625% What Do These Numbers Mean? CUSIP : This is a unique identifier for the bond. Reopening : Since it says "Yes," this means the bond was originally issued earlier and is now being reoffered. Issue Date : January 31, 2025—this is when the bond will be offi...