Hi!
I have updated NR7 tracker. There were few errors in the last one. So I am removing it and uploading a new and updated version.
In the last version, we have to punch the scrip id one by one to know whether it is on NR7 day or not. In this new version, we can see the scrips which fall on NR7 all at the same time.
To avoid errors/wrong results, we need to copy only EQ series (or just one series). In the bhavcopy we will get data of EQ,BE,IL,W1.... etc. There are scrips which fall on more than one series. In such case we would get wrong data which leads to wrong result. So we need to copy and paste only one series.
As in the last version, we need to copy and paste bhavcopy in the worksheet which contains oldest data. After pasting go to last row of the worksheet in which you just pasted data and look for any old datas and delete them. Because there could be some old data even after we pasted the new one or else you can copy the blank rows (from column A - K) as well from bhavcopy and paste it in NR7 Tracker file. While deleting don't delete formulas in the column L (RANGE).
After you are done with copy and paste, go to RESULT sheet where you can find the scrips which are on NR7 day. You can filter and see only the scrips which falls on NR7.
This might look like time taking process. I am sure, it won't take much time may be 2-3 min or even less. This will be helpful for those who don't have sophisticated software to find the NR7 scrips. I hope this will be useful for you guys. Please let me know if there is any error or something. And sorry I didn't know there were some in the last version.
ht tp://www.4shared.com/file/BrarzsEG/NR7_Tracker.html
Please remove the space.
I have attached a snap of the RESULT worksheet. As you see, there are 213 scrips are on NR7 day.