High Volume stocks live on spreadsheet for Intraday trading

#11
If anyone wants to add your own stuff to this list for further manipulation, first a create a new blank spreadsheet.
Then to add top 30 stock names(Column A), add the below line.

=IMPORTRANGE("1UGagv9jm9EmDcnLWvtrHGJrFJGf576_YJio7EdcIFB0","TOP!A1:A31")

From column B onward you can add your own formulas.
Same way you can import any other columns to your sheet.



Please publish your sheet in this thread for use by others.
 
#17
Hello Dilip Ji, Can we multiply the price in the volume to figure out to get TRUE Effect. As most of the time volume only spikes when Price action is about to finish. By multiplying we would be able to get true picture and any cleverness done by MARKET MAKERS... Pls Suggest...
 
#18
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.
Thank you sir, for this sheet this helps to find trade more easily ❤
 

Similar threads