February 13, 2018

There’s been a Market Correction, Should you be Worried?

Should you be Scared of the Dow’s 1700 point drop

On the fifth of February 2018 the Dow Jones Industrial Average saw its largest single day drop in history. This drop coming off a market sell-off at the end of January has caused many investors to call for the start of a bear market. Are these claims well founded, or just good headlines?

Firstly, dollar amounts are likely the worst way to look at market changes as they skew the data. In 1929 the Dow fell from around 300 to 230. A 70 point move means nothing in today’s market environment.…

January 23, 2018

Importing Assignments – University Series

Sometimes it’s better to not reinvent the wheel. A number of our existing professors have allowed a few of their class assignments to be publicly available to other professors. You can import these assignments into your class environment and either use them as-is or change them to follow your syllabus. To do this simply follow the guide below – 

1. Click on “Import/Copy Homework”


2. Choose a homework to import into your class

Not all homeworks created within Equities Lab are placed into our imports section. A few of our professors have graciously allowed us to use a few of their homework creations within the section – giving you a number of different assignments to import from a number of different universities.

January 23, 2018

Creating your first class and homework – University Series

So you’ve just downloaded Equities Lab and are ready to set up your account for the class you’re teaching next semester. To successfully do this just follow the below steps –

1. Navigate to Account Settings

 

2. Click on “Create Course”

 

3. Name your course following the rules

 

4. Click on “Create new homework”

 

5. Name your homework

There are no rules to naming homeworks, but you should name it something that fits into the flow of your course.

6. Edit Passing Requirements

 

There are a wide range of editable fields within the homework environment. You can set a minimum/maximum standard deviation, monthly return, beta, drawdown, etc.…

November 20, 2017

Investment Green Flags – High Cash Flow Score

Now, this flag looks incredibly simple, but whenever you see orange text in Equities Lab, it means that there is a deeper formula to explore. Clicking on that formula we are presented with the following –

Though the flag itself is simple, the underlying formula is not. Understanding and analyzing cash flow statements takes time. Thankfully, we can do it easily here by importing the Cash Flow Score – a number from 0 to 10 based on the above metrics. For each line that is true for a company, it will score 1 point. The lines look for the following –

  • A company must be ranked in the bottom 35% of all companies within their sector for (total debt 1Q/free cash flow t12m) and free cash flow MUST be a positive number.
August 5, 2017

Can’t Compare Split Adjusted Prices

If you have been using the Equities Lab system in recent weeks, you may have seen a new error that hadn’t appeared before.

———————————

Stock Server Error:Server Error:Cannot compare split ajusted quantities to constants: greater(Close, 444)

Don’t worry! This error message doesn’t mean that the system is down; it simply tells you that there is a split adjusted value in a place it shouldn’t be.

Have you ever input the following line into a screener?

If you have, you’ll need to change that to the following –

What’s the difference?

  • Close
    • This is the split-adjusted value. When a company undergoes a stock split the value of stock changes, typically by half, and the number of available shares doubles.
July 25, 2017

Ohlson O-Score

If you’re a short seller, then I’d like to introduce you to the Ohlson O-Score. This is a score created by Dr. James Ohlson of New York University, aimed at predicting the financial distress of a company. The Ohlson O-Score is the result of a nine-factor linear combination of coefficient-weighted accounting ratios that are found from financial disclosure statements that are provided by publicly traded companies. Below is the actual formula for the Ohlson O- Score.






Ohlson O-score formula

Ohlson O-score formula

So, from a first glance it looks very complex, well that’s because it is. For the purpose of understanding what exactly this equation is composed of, let’s break it down piece by piece.…

July 12, 2017

Industry Rotation – Something you might stay away from

I’ve been seeing a lot of articles recently that are very focused on the idea, that by purchasing the industry or sector that performed best over the past year you are giving you the best chance at making returns. I’m a little skeptical, but just as hopeful to see whether or not this is a potential new avenue to take in my portfolio.

Here is the base screen for what we want to do. This screener takes each sector and finds the total average change of close over the past year – making sure they have a market cap of at least $1 billion.…

July 8, 2017

Stocks That Have Always Gone Down

   When investing, for every fairy tale stock like an Amazon(AMZN) or Nvidia(NVDA), there’s an equally disastrous stock like MoSys(MOSY) or Gevo (GEVO). To avoid getting into stocks like these, it’s important to look at their failures and analyze them to avoid getting into the next potential train wreck of a stock.  Let’s screen for some stocks that have always gone down.




   For this screener we used the equation [always ((change of close over 252 days) < 0 ) within 752 days)] To simplify that equation, it basically means “screen for stocks that have consistently declined every year for 3 years. Only 7 results were shown, so let’s take a look at a couple of these companies’ history and see where it all went wrong for them.…

June 30, 2017

Creating Your Own Score

Most anytime we analyze a company or build a screen; we use any number of scores that are pre-built in the Equities Lab system. These scores are tried and tested, but they lack that personal touch. I think it’s time we learned how to build our own scores within the software.

To begin creating your score, you need to open up your explorer and click “Formula” under the Create New area. Go ahead and name your formula anything you like, but you’ll want it to be something regular that you can remember.

At its core, a score is a collection of True/False variables.…

June 17, 2017

Monte Carlo Simulation – Advanced Investing

Monte Carlo Simulation

As investors, we all know that each investment we make comes with a certain amount of risk. We can decrease this risk by understanding all possible outcomes. Better yet, we can visualize each outcome through the use of a Monte Carlo Simulation. In a broad stroke definition – a Monte Carlo simulation allows for people to make informed quantitative decisions based on a range of possible outcomes.

What does this mean?

First, we build a model we want to test. In the case below, that model would be the Screener of which we want to plug in different values for the Value Score.…