11.7 C
Los Angeles
Saturday, April 1, 2023
HomeCryptoI created a stock...

I created a stock market volume spike screener in the daily chart | by Alger Makiputin | Coinmonks | Aug, 2022

Volume is one of the most important indicators in technical analysis. It helps us traders confirm the significance of a market move. If a price of a security increases, the price generally moves in the same direction. For us traders that means opportunity. Take a look at the example chart below.

The chart above is from DMCI Holding Inc. You can see the sudden volume surge (x8 or more volume than the previous 10 trading days), followed by strong upward momentum. The price of DMCI rose up more than 50% in a span of 2 months.

This kind of market activity signifies that something significant is happening during that trading day. As a retail trader, It’s important not to miss that opportunity. But how easy it is to spot a volume spike?

As someone who works in an 8 to 5 job, we don’t have the luxury to monitor the market movement daily. Sometimes, when I looked at the chart, the stock price has already takeoff and missed the trade or entered the trade late.

So I decided to create a stock screener using the volume spike criteria. At the end of the trading day, I want to be notified if there is abnormal trading volume during the trading session so that I can take action. Using some sort of algorithm I recorded the stock prices daily and save them to my own database. To have an understanding of what the data look like take a look at the table below.

Table structure

And below is the query I wrote to filter all the stocks with abnormal trading volume. Just for this example, I set the dates to static dates. And set a condition to display stocks with trading volume x8 greater than their 10-day trading average volume.

SELECT * FROM prices   LEFT JOIN (   SELECT AVG(volume) as avgVolume, symbol FROM prices   WHERE date <= '2022-08-04' AND date >= '2022-07-24'   GROUP BY symbol   ORDER BY date DESC) price2ON price2.symbol = prices.symbolWHERE prices.date = '2022-08-05' AND prices.volume > (price2.avgVolume * 8) ORDER BY prices.date DESC;

And here is the result:

Query results: The result of all stocks with 8x or more trading volume than their 10-day average volume

For now, it’s still not fully automated, but If you like to get updated with this project. Just follow me here on medium.

And if you are wondering where I get all the data. I have created this API to get PSE stock’s historical price, check it out on GitHub don’t forget to hit star 🙂 https://github.com/algermakiputin/PSEStocksAPI

Thanks for reading this article! Leave a comment below if you have any questions, and make sure to follow me here on medium 🙂 https://medium.com/@algerwrites

Join Coinmonks Telegram Channel and Youtube Channel learn about crypto trading and investing

Source link

Most Popular


Please enter your comment!
Please enter your name here

More from Author

Putin’s silent 147,000 man conscription will not have desired effect in short term | World | News

Vladimir Putinthe spring draft “will not increase Russian Combat power in the short term" and could even be counterproductive in the long term, the Institute for the Study of War said. Putin called up 147,000 men of military combat age earlier this week to begin training a...

Best CBD Gummies for 2022 — For Anxiety, Sleep and More

Sponsored content. Us Weekly receives compensation for this article as well as for purchases made when you click on a link and buy something below. CBD has crossed over from the world of alternative wellness into the mainstream. Thanks to its many benefits (like bringing about feelings of...

Syria’s FM visits Egypt in step toward restoring ties

Syria's diplomatic chief visits Egypt in a step towards normalizing ties between the two countriesBySAMY MAGDY Associated PressCAIRO -- Syria's diplomatic chief was in Egypt on Saturday in a step towards normalizing ties between the two countries. It was the first trip to the capital of...

Prince Harry: I’ll Go to the Coronation … But Only If William Agrees to Arm Wrestle Me! Winner Will Be Next In Line For...

In May, Britain will hold its first coronation since Queen Elizabeth II was crowned at Westminster Abbey in 1953. The world will be watching as King Charles III officially succeeds his mother in a ceremony that insiders say will be more streamlined than past coronations but no less...

Kevin Hart Explores The Power Of IP With ‘Die Hart 2’ On Roku

It's Kevin Hart The heart series rose from Quibi's ashes like a phoenix. It was one of the few shows Roku got when the short product was shut down in 2020, just months after launch. The comedian and entrepreneur saw the demise of the platform as...

RCB vs Mumbai Indians – key players missing, not many Impact Player options for teams

RCB have had a good run of late but they don't have a good record at home; Mumbai hopes to take a step towards rebuilding Source link

Apollo Theatre Roof Collapses in Illinois, Killing One and Injuring Dozens

Illinois Apollo Theater roof collapses, killing one, injuring dozens | Entertainment Tonight ...

‘Dungeons And Dragons,’ Great Box Office, Great Reviews, Great Audience Scores

I'll be honest, I had little hope for the idea that a Dungeons and Dragons movie starring Chris Pine and Michelle Rodriguez wouldn't be a serious attempt at a Lord of the Rings-style offering. Well, I was wrong. As a result, Dungeons and Dragons appears bigand is...

Migrating Your Existing Courses To A New LMS

Maximizing the Efficiency of LMS Migration Lift-shift-uplift, lift and shift, or L&S, is a popular method...

Behind the making of Panama’s $100-a-cup coffee

Panama grows some of the best coffee in the world, but no beer can be more coveted than the "Geisha" variety grown in remote parts of the country. The Panamanian version of coffee, which can sell for up to $100 a cup in...