Stock investmentsStocks

High Volatility Penny Stocks-Tracking And Trading (With Marketxls)

Written by Anangsha Saha (Individual Contributor)
Tue Feb 23 2021
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →

Penny stocks have had a long and exciting relationship with the stock markets. How are penny stocks different from regular stocks traded in mainstream markets? A penny stock typically refers to a small-company stock sold for less than $5 per share in the markets. Although some penny stocks are traded on large exchanges like New York Stock Exchange (NYSE), most of these stocks are traded via over-the-counter type transactions (OTC). Many also use the electronic OTCBB (OTC Bulletin Board) or privately owned OTC markets. Penny stocks are said to be traded on the Pink Market.

There are four tiers of penny stocks, and investors choose their preferred tier while making buying decisions. These tiers are based on the amount of information that the company is willing to share with the public. 

Tier 1: these stocks are usually under $5 per share, but they can be priced slightly higher. These are listed on major stock exchanges 

Tier 2: stocks belonging to this tier are priced between $0.01 and $1 and might be traded in fractions. These are not always listed on major exchanges, but they can be if they meet some basic requirements.

Tier 3: These are traded for less than $0.01 and cannot be listed on the major exchanges.

Tier 4: Also known as “hot penny stocks”,  these are the cheapest option available.

Why are penny stocks so volatile?

Penny stocks are associated with small companies with low funding levels, so they often have liquidity issues. This is why investors often find it difficult to sell off such stocks because buyers are often unavailable. Due to this lack of liquidity and wide bid-ask spreads, penny stocks are generally considered to be highly speculative. What this means is that it is very easy for investors to make large gains through penny stocks but also probable for them to lose a lot of their investment.

Price fluctuations of penny stocks:

Penny stocks have a high potential for reward and a higher level of risk associated with their handling. These highly volatile stocks are thus great for investors with a high-risk appetite. Investors stand to lose their entire investment and even more if they have purchased on margin, meaning they have borrowed from banks or brokers. While trading in penny stocks, it is vital to have a strategy in place. Investors should have a stop-loss order set that is predetermined before entering the trade. If the market moves in the direction opposite to one that is favourable, the stop loss order sets in and automatically sells the securities. 

Penny stocks often fail because investors are unable to find adequate information about the company and its corporate performance to make an informed decision. Companies listed on the OTCBB are required to file their financial report with the SEC. However, stocks that are listed only on the Pink Sheets don’t have the same criteria. Penny stocks (listed on the OTCBB and Pink Sheets) are exempted from fulfilling the minimum regulations required by the NYSE, NASDAQ, and other major exchanges. When a company is not regulated correctly, it becomes too risky to invest in it. Owing to low liquidity levels in the penny stocks market, traders often manipulate stock prices using the “pump and dump” scheme. Investors are lured in by scammers who buy large quantities of a stock and raise its market price to make it lucrative for investors. Once investors start buying the stocks, the scammers sell their shares, and the investors realise that there was never a rise in the actual market value of the share and incur heavy losses.

However, trading in penny stocks does have its advantages. With a low investment, penny stocks provide a way to make large amounts of profit. Not all companies listed on the Pink Sheets are fraudulent. Penny stocks are an excellent way for small businesses to gain public funding to expand their business.

Factors to consider while trading penny stocks:

Investors should consider the lack of volatility in the penny stocks market and the relaxed accounting standards. Investors should ideally only invest in penny stocks with risk money or those funds that they can afford to lose. It is crucial to study the market correctly and not be swayed by promises of easy money. The next step is to decide which type of companies to trade in. Usually, buyers tend to follow the word of mouth or the current fads. Still, it is essential to note that by the time everyone is talking about a stock making it big, it is likely to be on everyone’s radar, making the scope of profit narrow. 

How can we use MarketXLS to track penny stocks?

MarketXLS can be a useful resource with hundreds of functions that can plugin into a list of penny stocks and help you compare them. Let us see how.

Step 1: Open a new excel workbook and go to the MarketXLS tab. Then click on Utilities and select the option “Useful Lists” and a window like this will open up.


Step 2: Under useful lists, click on “stocks under $5”. This will load penny stocks data on your sheet.

MarketXLS penny stocks

Step 3: To track the volatility of these stocks, MarketXLS provides a wide range of functions. Go to the Help button and type volatility in the search bar and options showing different volatility measures will show. Choose one most appropriate for you.

Step 4: Here, I have chosen the seven-day volatility indicator. Write down the function in cell O2 and enter the stock symbol from A2. Then drag down along column O to cover all the stocks.

None of the content published on 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 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

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

Optionable: No
Market Cap: 2,753 M
Industry: Auto & Truck Dealerships
52 week range    
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

Optionable: Yes
Market Cap: 11,592 M
Industry: Business Services
52 week range    
BWX Technologies Inc. logo

BWX Technologies Inc.

Optionable: Yes
Market Cap: 4,846 M
Industry: Aerospace & Defense
52 week range    
Ritchie Bros. Auctioneers Incorporated logo

Ritchie Bros. Auctioneers Incorporated

Optionable: Yes
Market Cap: 6,928 M
Industry: Business Services
52 week range    
Ituran Location and Control Ltd. logo

Ituran Location and Control Ltd.

Optionable: Yes
Market Cap: 504 M
Industry: Communication Equipment
52 week range    
General Mills Inc. logo

General Mills Inc.

Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
CRA InternationalInc. logo

CRA InternationalInc.

Optionable: Yes
Market Cap: 646 M
Industry: Business Services
52 week range    
ConAgra Brands Inc. logo

ConAgra Brands Inc.

Optionable: Yes
Market Cap: 16,287 M
Industry: Packaged Foods
52 week range    
Agree Realty Corporation logo

Agree Realty Corporation

Optionable: Yes
Market Cap: 5,522 M
Industry: REIT - Retail
52 week range    
UNITIL Corporation logo

UNITIL Corporation

Optionable: Yes
Market Cap: 928 M
Industry: Utilities - Diversified
52 week range    

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to to avail the extention

From all of us at MarketXLS, thank you!