Code:
* Example generated by -dataex-. For more info, type help dataex clear input float stock_id str51 stock int date double pr float(rf bse_all rt ertn mk emk mdate) 2 "3M India Ltd." 20332 10888.5 .005884333 3017.21 . . -.7108147 -.716699 668 2 "3M India Ltd." 20362 11683.05 .005918917 3069.72 .072971486 .067052566 .017403498 .011484582 669 2 "3M India Ltd." 20393 11519.1 .005953583 3050.05 -.01403315 -.019986734 -.006407725 -.012361309 670 2 "3M India Ltd." 20423 11407.4 .006022833 3068.39 -.009696938 -.015719771 .006012965 -9.867828e-06 671 2 "3M India Ltd." 20454 9928.75 .006022833 2885.94 -.129622 -.13564482 -.05946114 -.065483965 672 2 "3M India Ltd." 20485 10376.6 .006022833 2647.7 .04510638 .03908355 -.08255196 -.0885748 673 2 "3M India Ltd." 20514 10782.8 .006057417 2929.13 .03914577 .033088356 .10629223 .10023481 674 2 "3M India Ltd." 20545 13395.6 .00567675 2995.35 .24231184 .2366351 .02260747 .01693072 675 2 "3M India Ltd." 20575 12415.85 .005711333 3093.9 -.07313969 -.07885102 .03290093 .0271896 676 2 "3M India Ltd." 20606 12844.8 .005607667 3174.42 .03454858 .028940914 .02602541 .020417746 677 2 "3M India Ltd." 20636 14596.95 .0054695 3334.55 .13640928 .13093978 .0504439 .0449744 678 2 "3M India Ltd." 20667 12842.15 .0054695 3404.51 -.1202169 -.12568639 .02098033 .01551083 679 2 "3M India Ltd." 20698 12865.15 .005434917 3367.68 .0017909773 -.0036439395 -.010818026 -.016252942 680 2 "3M India Ltd." 20728 13305.7 .005296917 3427.86 .034243673 .028946755 .017869921 .012573004 681 2 "3M India Ltd." 20759 11303.35 .0048835 3227.23 -.15048814 -.15537164 -.05852926 -.06341276 682 2 "3M India Ltd." 20789 11155.3 .005227917 3181.83 -.013097887 -.018325804 -.014067762 -.01929568 683 2 "3M India Ltd." 20820 11978.75 .0051935 3362.46 .07381693 .06862343 .05676918 .05157568 684 2 "3M India Ltd." 20851 11191.4 .005124583 3511.02 -.065728895 -.07085348 .04418196 .03905737 685 2 "3M India Ltd." 20879 11583 .004849083 3642.95 .034991153 .03014207 .03757596 .032726873 686 2 "3M India Ltd." 20910 11431.45 .005159 3748.09 -.01308383 -.018242829 .028861264 .023702264 687 2 "3M India Ltd." 20940 13856.1 .005227917 3805.38 .21210346 .20687553 .015285064 .010057147 688 2 "3M India Ltd." 20971 13209.2 .005227917 3801.54 -.04668702 -.05191493 -.0010090566 -.006236973 689 2 "3M India Ltd." 21001 13370.2 .005124583 4011.39 .012188475 .007063892 .05520127 .05007669 690 2 "3M India Ltd." 21032 14724.05 .005090083 3970.35 .10125877 .0961687 -.010230817 -.0153209 691 2 "3M India Ltd." 21063 14434.55 .005090083 3928.84 -.01966171 -.024751794 -.010455 -.015545083 692 2 "3M India Ltd." 21093 14175.7 .005090083 4188.69 -.017932668 -.02302275 .06613908 .061049 693 2 "3M India Ltd." 21124 15469.2 .005124583 4196.28 .0912477 .08612312 .001811985 -.003312598 694 2 "3M India Ltd." 21154 19165.25 .005159 4349.86 .2389296 .2337706 .036599103 .0314401 695 2 "3M India Ltd." 21185 18724.55 .005331417 4440.44 -.022994744 -.02832616 .02082368 .01549226 696 2 "3M India Ltd." 21216 20683.05 .005296917 4244.46 .1045953 .09929839 -.04413526 -.04943218 697 2 "3M India Ltd." 21244 19383.6 .005090083 4077.51 -.062826805 -.067916885 -.03933362 -.0444237 698 2 "3M India Ltd." 21275 20482.35 .005159 4347.82 .05668452 .05152552 .06629287 .06113387 699 2 "3M India Ltd." 21305 19397.95 .005331417 4255.06 -.05294314 -.05827456 -.021334777 -.026666194 700 2 "3M India Ltd." 21336 19629.7 .005434917 4174.26 .01194714 .006512222 -.018989226 -.024424143 701 2 "3M India Ltd." 21366 23436.1 .005573083 4395.97 .19391024 .18833716 .05311372 .04754063 702 2 "3M India Ltd." 21397 26109.6 .00567675 4547.53 .11407614 .1083994 .034476932 .02880018 703 2 "3M India Ltd." 21428 22440.3 .005988167 4132.97 -.14053452 -.14652269 -.09116148 -.09714965 704 2 "3M India Ltd." 21458 19853.35 .0057805 3975.4 -.11528143 -.12106194 -.0381252 -.0439057 705 2 "3M India Ltd." 21489 21589 .005642167 4127.54 .08742353 .08178136 .0382704 .03262823 706 2 "3M India Ltd." 21519 20850.8 .0055385 4161.09 -.03419334 -.03973184 .008128281 .002589781 707 2 "3M India Ltd." 21550 20127.25 .0054695 4080.32 -.034701306 -.04017081 -.019410726 -.024880227 708 2 "3M India Ltd." 21581 22837.5 .005331417 4051.06 .13465576 .12932435 -.007171008 -.012502425 709 2 "3M India Ltd." 21609 24067.9 .005262417 4368.94 .0538763 .04861388 .07846832 .0732059 710 2 "3M India Ltd." 21640 22907.9 .005331417 4361.68 -.04819698 -.05352839 -.0016616767 -.006993094 711 2 "3M India Ltd." 21670 22632.85 .005159 4425.91 -.012006775 -.017165774 .014725972 .009566972 712 3 "A B B India Ltd." 20332 1057.9 .005884333 3017.21 . . -.7108147 -.716699 668 3 "A B B India Ltd." 20362 1234.9 .005918917 3069.72 .1673126 .1613937 .017403498 .011484582 669 3 "A B B India Ltd." 20393 1170.6 .005953583 3050.05 -.05206899 -.05802258 -.006407725 -.012361309 670 3 "A B B India Ltd." 20423 1118.1 .006022833 3068.39 -.0448488 -.05087163 .006012965 -9.867828e-06 671 3 "A B B India Ltd." 20454 973 .006022833 2885.94 -.12977372 -.13579655 -.05946114 -.065483965 672 3 "A B B India Ltd." 20485 1015.3 .006022833 2647.7 .04347379 .03745096 -.08255196 -.0885748 673 3 "A B B India Ltd." 20514 1276.5 .006057417 2929.13 .25726387 .25120646 .10629223 .10023481 674 3 "A B B India Ltd." 20545 1291.6 .00567675 2995.35 .01182922 .00615247 .02260747 .01693072 675 3 "A B B India Ltd." 20575 1231.3 .005711333 3093.9 -.04668628 -.05239761 .03290093 .0271896 676 3 "A B B India Ltd." 20606 1224.7 .005607667 3174.42 -.005360188 -.010967855 .02602541 .020417746 677 3 "A B B India Ltd." 20636 1260.45 .0054695 3334.55 .02919082 .02372132 .0504439 .0449744 678 3 "A B B India Ltd." 20667 1161 .0054695 3404.51 -.0789004 -.0843699 .02098033 .01551083 679 3 "A B B India Ltd." 20698 1134.7 .005434917 3367.68 -.022652885 -.0280878 -.010818026 -.016252942 680 3 "A B B India Ltd." 20728 1100 .005296917 3427.86 -.03058077 -.035877686 .017869921 .012573004 681 3 "A B B India Ltd." 20759 1060.2 .0048835 3227.23 -.03618182 -.04106532 -.05852926 -.06341276 682 3 "A B B India Ltd." 20789 1039.1 .005227917 3181.83 -.019901905 -.02512982 -.014067762 -.01929568 683 3 "A B B India Ltd." 20820 1094.2 .0051935 3362.46 .05302666 .04783316 .05676918 .05157568 684 3 "A B B India Ltd." 20851 1199.9 .005124583 3511.02 .09660026 .09147567 .04418196 .03905737 685 3 "A B B India Ltd." 20879 1279.65 .004849083 3642.95 .06646387 .06161479 .03757596 .032726873 686 3 "A B B India Ltd." 20910 1410.45 .005159 3748.09 .10221545 .09705645 .028861264 .023702264 687 3 "A B B India Ltd." 20940 1459.65 .005227917 3805.38 .034882486 .02965457 .015285064 .010057147 688 3 "A B B India Ltd." 20971 1451.1 .005227917 3801.54 -.005857569 -.011085486 -.0010090566 -.006236973 689 3 "A B B India Ltd." 21001 1427.6 .005124583 4011.39 -.016194612 -.021319196 .05520127 .05007669 690 3 "A B B India Ltd." 21032 1343.75 .005090083 3970.35 -.05873494 -.06382502 -.010230817 -.0153209 691 3 "A B B India Ltd." 21063 1396.05 .005090083 3928.84 .03892093 .033830848 -.010455 -.015545083 692 3 "A B B India Ltd." 21093 1382.85 .005090083 4188.69 -.00945525 -.014545332 .06613908 .061049 693 3 "A B B India Ltd." 21124 1394.55 .005124583 4196.28 .008460787 .003336204 .001811985 -.003312598 694 3 "A B B India Ltd." 21154 1399.5 .005159 4349.86 .003549532 -.001609468 .036599103 .0314401 695 3 "A B B India Ltd." 21185 1657.3 .005331417 4440.44 .18420865 .17887723 .02082368 .01549226 696 3 "A B B India Ltd." 21216 1534.55 .005296917 4244.46 -.07406625 -.07936317 -.04413526 -.04943218 697 3 "A B B India Ltd." 21244 1286.6 .005090083 4077.51 -.1615783 -.1666684 -.03933362 -.0444237 698 3 "A B B India Ltd." 21275 1355 .005159 4347.82 .05316338 .04800437 .06629287 .06113387 699 3 "A B B India Ltd." 21305 1227.65 .005331417 4255.06 -.09398524 -.09931666 -.021334777 -.026666194 700 3 "A B B India Ltd." 21336 1180.6 .005434917 4174.26 -.03832525 -.04376017 -.018989226 -.024424143 701 3 "A B B India Ltd." 21366 1221.8 .005573083 4395.97 .03489751 .02932443 .05311372 .04754063 702 3 "A B B India Ltd." 21397 1312.35 .00567675 4547.53 .07411197 .06843522 .034476932 .02880018 703 3 "A B B India Ltd." 21428 1402.55 .005988167 4132.97 .068731666 .0627435 -.09116148 -.09714965 704 3 "A B B India Ltd." 21458 1280.05 .0057805 3975.4 -.08734091 -.09312142 -.0381252 -.0439057 705 3 "A B B India Ltd." 21489 1405.85 .005642167 4127.54 .09827741 .09263524 .0382704 .03262823 706 3 "A B B India Ltd." 21519 1332 .0055385 4161.09 -.0525305 -.058069 .008128281 .002589781 707 3 "A B B India Ltd." 21550 1274.9 .0054695 4080.32 -.04286787 -.04833737 -.019410726 -.024880227 708 3 "A B B India Ltd." 21581 1229.95 .005331417 4051.06 -.035257667 -.04058908 -.007171008 -.012502425 709 3 "A B B India Ltd." 21609 1319.85 .005262417 4368.94 .0730924 .06782998 .07846832 .0732059 710 3 "A B B India Ltd." 21640 1473.4 .005331417 4361.68 .11633898 .11100756 -.0016616767 -.006993094 711 3 "A B B India Ltd." 21670 1571 .005159 4425.91 .06624135 .06108235 .014725972 .009566972 712 4 "A C C Ltd." 20332 1344.15 .005884333 3017.21 . . -.7108147 -.716699 668 4 "A C C Ltd." 20362 1376.1 .005918917 3069.72 .02376967 .017850753 .017403498 .011484582 669 4 "A C C Ltd." 20393 1347 .005953583 3050.05 -.02114672 -.0271003 -.006407725 -.012361309 670 4 "A C C Ltd." 20423 1359.55 .006022833 3068.39 .009317 .0032941676 .006012965 -9.867828e-06 671 4 "A C C Ltd." 20454 1240.4 .006022833 2885.94 -.0876393 -.09366213 -.05946114 -.065483965 672 4 "A C C Ltd." 20485 1191.15 .006022833 2647.7 -.03970493 -.04572777 -.08255196 -.0885748 673 4 "A C C Ltd." 20514 1380.3 .006057417 2929.13 .1587961 .1527387 .10629223 .10023481 674 4 "A C C Ltd." 20545 1443 .00567675 2995.35 .04542491 .03974816 .02260747 .01693072 675 4 "A C C Ltd." 20575 1531.8 .005711333 3093.9 .06153846 .05582713 .03290093 .0271896 676 4 "A C C Ltd." 20606 1613.65 .005607667 3174.42 .05343387 .0478262 .02602541 .020417746 677 end format %td date format %tm mdate
Please go through the attached file for details of the query.
