High volume stocks are widely used by traders for intraday trading. In this spreadsheet we check the current volume of stocks and compare them with last 10 days average volume and sort them in descending. I have listed 212 F&O stocks for analyzing. The volume information is picked from GoogleFinance.
LINK ------- Shareable Link
On left side in Blue the list of top 30 volume gainers compared to previous day close are listed. The number in the rows means the percentage gain/loss compared to its 10 days average volume.
On right side in Magneta the list of top 30 volume gainers compared to last 15 minutes are listed. The number in the rows means the percentage gain/loss compared to its 10 days average volume in last 15 minutes.
Example from below screenshot: Jet Airways has gained 66% more than its 10 days average volume till now and 9% gain happened in last 15 minutes. The comparison with last 5 days average is also there.
You can also see the trail of 15 minute volume change in Sheet1. The timer begins recording at 9am to 3pm. It can be used for post market analysis till next day.
The 10days average volume is updated in Sheet1-Last column.
Trail:
Please let me know if any bug is found.
LINK ------- Shareable Link
On left side in Blue the list of top 30 volume gainers compared to previous day close are listed. The number in the rows means the percentage gain/loss compared to its 10 days average volume.
On right side in Magneta the list of top 30 volume gainers compared to last 15 minutes are listed. The number in the rows means the percentage gain/loss compared to its 10 days average volume in last 15 minutes.
Example from below screenshot: Jet Airways has gained 66% more than its 10 days average volume till now and 9% gain happened in last 15 minutes. The comparison with last 5 days average is also there.
You can also see the trail of 15 minute volume change in Sheet1. The timer begins recording at 9am to 3pm. It can be used for post market analysis till next day.
The 10days average volume is updated in Sheet1-Last column.
Trail:
Please let me know if any bug is found.
Last edited: