How to find out Gapped Up/Down stocks

#1
Is there any utility/software/excel to find out all the gapped up/down stocks on NSE each day by 9.20 am. I know there are website like moneycotrol which have provide that. Apart from visiting website, is there a way of finding it though any software?
 
#4
Is there any utility/software/excel to find out all the gapped up/down stocks on NSE each day by 9.20 am. I know there are website like moneycotrol which have provide that. Apart from visiting website, is there a way of finding it though any software?
try Keystocks software , it have this feature
 

mastermind007

Well-Known Member
#5
Is there any utility/software/excel to find out all the gapped up/down stocks on NSE each day by 9.20 am. I know there are website like moneycotrol which have provide that. Apart from visiting website, is there a way of finding it though any software?
This is AFL for the same...
Code:
minGap = 1.01; 
// effectively 1%. if you set it to 0, it will catch all Gaps even 1 paisa gaps
GapUp = O > minGap * Ref(H, -1);
GapDown  = O * minGap < Ref(L, -1);
Filter = GapUp OR GapDown;
 

Giraffe

Well-Known Member
#6
NSE NOW, Nest Trader and Sharekhan have RTD link in excel.
Other's might also have, but I don't know.
In Excel, it do it this way:
1. Create a market watch with a list of scrips that you want to scan for gap movements. Market watch must have previous close and open values.
2. Via RTD link, send the data to Microsoft Excel.
3. Add an additional column in Excel where you calculate
Gap% = [(Open-Prev. Close)/Prev. Close]*100
The gap ups will be positve and gap down will be negative.
4. Format it as a table.
5. Just sort the table based on your above created column from high to low.
On top of list will be top gap ups, on bottom of list will be top gap downs.
 

Giraffe

Well-Known Member
#7
Wow.... Many thanks!!
Hmmmm.......sarcasm.......:clapping:
Patience is a virtue pal.......:rofl::rofl:

Anyway, try the above method, it works....;)

One more thing, NSE NOW allows only a list of 55. So If you will link more than 55, you will need to restart your terminal once you obtain the data.
Similarly NEST allows only 30. Don't know about sharekhan.