The formula for calculating the qstick indicator with excel is as follows:

moving average n periods of (closing-opening)

This indicator was created by Tushar Chande and measures buying and selling pressure without considering volumes.
When the price, on average, closes lower than when it opens, the indicator moves lower. When the price, on average, is closing higher than the open, the indicator rises.

The signal occurs when the qstick crosses the zero line up or down.
Above zero indicates that buying pressure is increasing and vice versa below zero.
Here is the graph created with excel made with a 20-period moving average on a daily scale on the euro price of BTC:

This article does not contain investment advice. Every investment and trading move carries a risk, readers should conduct their own research when making a decision.
THE OPINIONS EXPRESSED BY THE AUTHOR ARE FOR INFORMATION PURPOSES ONLY AND DO NOT CONSTITUTE FINANCIAL, INVESTMENT OR OTHERWISE ADVICE.

Open a Coinbase account to get bonuses:

https://www.coinbase.com/join/carote_7

Log in to Publish0x:

https://www.publish0x.com/?a=oQeZ4DR6bp

Open an account with Kucoin use my code: rJEUMUV

https://www.presearch.org/signup?rid=2331971

Thanks for reading and suggestions are welcome in the comments.