Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Stock investmentsStocks

Volatile Penny Stocks – How To Identify Them?

Written by Ansh Thakkar (Individual Contributor)
Sat Mar 27 2021
Useful lists
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Useful lists

Volatile Penny stocks are those stocks trading at a value of $5 or less than that, and its price is touching its highs and lows quickly and erratically.
In short, Volatile penny stocks are low-priced stocks that experience unusually rapid and significant price fluctuations.
Before diving deep, let us consider the various aspects related to volatile penny stocks:
• Why is volatility significant?
Volatility is significant to keep the market moving and to keep the prices fluctuating. The stock volatility can help us book our profits quickly but can also put us at risk of losing a large amount of money. We have to be safe from catching the top and bottom of price moves.
• What affects stock volatility?
Three things can affect stock volatility: the float (supply), volume (demand), and the stop losses.
The float is the total amount of shares of a company available to the public for trading. A low float means a limited supply. If there is a high demand for that stock, then it can result in a quick and erratic price rise due to high demand but not an equivalent supply to satisfy it. And on the other side, if there is low demand in case of a high float, then the stock price might drop suddenly due to high supply but not equivalent to high demand.
There is a general rule: The price of a stock must be backed by volume. Those stocks which are highly rated must have a high volume. If a stock price is very high, but it doesn’t have much volume traded, it might be overpriced, and the stock might see a sudden fall in price sooner or later. And on the flip side, if the price of a stock is low and its volume traded is comparatively high, then it might be under-priced, and the stock might see an erratic rise in price in the near future.
Stop losses are sell orders set at a particular price by traders to prevent their losses from being significant. Most traders put them at the same price level. This is where the problem occurs. When the stock hits that price, tons of stop losses get executed, and there might be a sudden fall in price.
• What are different categories of penny stocks?
o Tier 1: These stocks are under $5 per share but can also have a slightly higher price. They are listed on a major exchange and not on an OTC market.
o Tier 2: These are stocks that have a price of $0.01 to $1. They can be listed on a major exchange if they meet the minimum listing requirements.
o Tier 3: These are stocks below $0.01. They can be very volatile and hence profitable if traded in large quantities. But, they carry an equal amount of risk. Since they can not be listed on a major exchange, they are traded in an OTC market.
o Tier 4: Known as “hot penny stocks” or trip zero stocks are listings that must be priced with 3 0’s.

How can we identify volatile penny stocks using MarketXLS?
Step 1: Go to MarketXLS tab and click on the drop-down option of utilities under the utils section highlighted in yellow.

MarketXLS Tab


Step 2: From the drop-down list, click on “Useful lists.” A dialog box will appear. Double click on any category of penny stock list, i.e., “Stocks under $5” or “Stocks under $1,” to download that particular list. Let us consider the list – “Stocks under $5”.

Useful lists
Step 3: Now, you will see a list of all the stocks under $1.
Now, the second concept which you need to consider is volatility. You can add a column heading that says “15 days Volatility”. MarketXLS provides functions for calculating volatility across various time periods. You can see this function in the formula bar. This will return the result of the stock volatility of that particular stock.

Table of volatile penny stocks
Similarly, you can add various columns for stock volatility. We have added three columns for the sake of this example. They are:
• Volatility – 15 days
• Volatility – 30 days
• Volatility – 1 year

Identifying volatility
Step 4: You have your list ready. Thanks to the software – MarketXLS! It excels in every work you assign. Now you can try your hands on and invest in the stocks according to your risk capacity.
Thus, you can easily make a list of all those penny stocks currently trading at a highly volatile range using the MarketXLS Software. Volatile penny stocks come with a lot of risks, and hence you have to make your decisions wisely and smartly, keeping all the pros and cons in mind. You need to keep in mind two things while trading with these stocks: 1) When to book profits, 2) When to cut out losses. Timing is the most crucial factor while dealing with these stocks.
The pictures and graphics used were taken from this software itself – MarketXLS.
For more such useful information, please visit https://marketxls.com/.
None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person.
The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.
The article is written to help users collect the required information from various sources deemed to be an authority in their content. The trademarks, if any, are the property of their owners, and no representations are made.


Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Dick's Sporting Goods Inc logo

Dick's Sporting Goods Inc

Optionable: Yes
Market Cap: 8,757 M
Industry: Specialty Retail
52 week range    
Dillard's Inc. logo

Dillard's Inc.

Optionable: Yes
Market Cap: 4,506 M
Industry: Department Stores
52 week range    
EOG Resources Inc. logo

EOG Resources Inc.

Optionable: Yes
Market Cap: 61,798 M
Industry: Oil & Gas E&P
52 week range    
STORE Capital Corporation logo

STORE Capital Corporation

Optionable: Yes
Market Cap: 8,941 M
Industry: REIT - Diversified
52 week range    
National Research Corporation logo

National Research Corporation

Optionable: No
Market Cap: 983 M
Industry: Diagnostics & Research
52 week range    
Chesapeake Energy Corporation logo

Chesapeake Energy Corporation

Optionable: Yes
Market Cap: 11,105 M
Industry: Oil & Gas E&P
52 week range    
NACCO Industries Inc. logo

NACCO Industries Inc.

Optionable: No
Market Cap: 346 M
Industry: Coal
52 week range    
Marathon Oil Corporation logo

Marathon Oil Corporation

Optionable: Yes
Market Cap: 14,494 M
Industry: Oil & Gas E&P
52 week range    
Destination XL Group Inc. logo

Destination XL Group Inc.

Optionable: No
Market Cap: 340 M
Industry: Apparel Stores
52 week range    
CF Industries Holdings Inc. logo

CF Industries Holdings Inc.

Optionable: Yes
Market Cap: 19,103 M
Industry: Agricultural Inputs
52 week range    

More Features