Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    keep only the data of the last trading day

    Dear Statalisters,

    I am working on several annual variables in my dissertation. However, the data on Book-to-Market ratio is quoted on daily frequency. The financial year ends on 31st March and I only need the data of the last trading day each year for each firm. The last trading day of each year falls on different days and I am unable to resolve the issue. Any help is highly appreciated. Below is a small sample of my data.
    Thank you in advance.
    Best wishes,
    Avik

    * Example generated by -dataex-. For more info, type help dataex
    clear
    input long cocode str66 company_name str10 co_stkdate str11 bse_pe str10 bse_pb str13 nse_pe str10 nse_pb str8(eps_on_stkdate cons_eps_on_stkdate ceps_on_stkdate cons_ceps_on_stkdate)
    11 "20 MICRONS LTD." "06-10-2008" "10.0765" "1.1155" "10.1824" "1.1272" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "07-10-2008" "9.0935" "1.0066" "9.0038" "0.9967" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "08-10-2008" "7.7640" "0.8595" "7.8082" "0.8644" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "10-10-2008" "6.8829" "0.7619" "6.8387" "0.7570" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "13-10-2008" "7.4282" "0.8223" "7.3536" "0.8140" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "14-10-2008" "6.7276" "0.7447" "6.6674" "0.7381" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "15-10-2008" "7.2206" "0.7993" "7.2206" "0.7993" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "16-10-2008" "8.1564" "0.9029" "8.0536" "0.8915" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "17-10-2008" "6.5640" "0.7266" "6.5050" "0.7201" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "20-10-2008" "6.4850" "0.7179" "6.3968" "0.7081" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "21-10-2008" "6.2905" "0.6964" "6.3639" "0.7045" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "22-10-2008" "5.9292" "0.6564" "5.9146" "0.6547" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "23-10-2008" "5.4514" "0.6035" "5.4803" "0.6067" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "24-10-2008" "4.7152" "0.5220" "4.6864" "0.5188" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "27-10-2008" "4.3293" "0.4793" "4.1859" "0.4634" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "28-10-2008" "5.1321" "0.5681" "5.0317" "0.5570" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "29-10-2008" "4.7178" "0.5223" "4.7900" "0.5302" "0.0696" "NA" "0.1293" "NA"
    11 "20 MICRONS LTD." "31-10-2008" "5.2317" "0.5791" "5.3718" "0.5947" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "03-11-2008" "5.3253" "0.5895" "5.4036" "0.5982" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "04-11-2008" "5.7726" "0.6390" "5.7253" "0.6338" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "05-11-2008" "5.8350" "0.6459" "5.8838" "0.6513" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "06-11-2008" "5.7751" "0.6393" "5.7911" "0.6411" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "07-11-2008" "6.5670" "0.7270" "6.6473" "0.7358" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "10-11-2008" "6.4174" "0.7104" "6.4498" "0.7140" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "11-11-2008" "5.9298" "0.6564" "5.9298" "0.6564" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "12-11-2008" "5.7368" "0.6351" "5.7997" "0.6420" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "14-11-2008" "5.7831" "0.6402" "5.6746" "0.6282" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "17-11-2008" "5.5881" "0.6186" "5.5568" "0.6151" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "18-11-2008" "5.2944" "0.5861" "5.3253" "0.5895" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "19-11-2008" "5.1339" "0.5683" "5.1339" "0.5683" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "20-11-2008" "5.0091" "0.5545" "4.9484" "0.5478" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "21-11-2008" "4.9355" "0.5464" "4.8895" "0.5413" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "24-11-2008" "5.0674" "0.5610" "5.0674" "0.5610" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "25-11-2008" "5.3097" "0.5878" "5.2330" "0.5793" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "26-11-2008" "5.2148" "0.5773" "5.1687" "0.5722" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "28-11-2008" "5.0774" "0.5621" "5.1082" "0.5655" "0.0652" "NA" "0.1211" "NA"
    11 "20 MICRONS LTD." "01-12-2008" "5.0107" "0.5547" "5.0261" "0.5564" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "02-12-2008" "4.8152" "0.5330" "4.7999" "0.5313" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "03-12-2008" "4.9214" "0.5448" "4.9214" "0.5448" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "04-12-2008" "4.9168" "0.5443" "4.9478" "0.5477" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "05-12-2008" "5.0510" "0.5591" "5.0355" "0.5574" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "08-12-2008" "5.1306" "0.5680" "5.1306" "0.5680" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "10-12-2008" "5.2669" "0.5830" "5.4712" "0.6057" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "11-12-2008" "5.8731" "0.6502" "5.8413" "0.6466" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "12-12-2008" "5.3905" "0.5967" "5.3270" "0.5897" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "15-12-2008" "5.5576" "0.6152" "5.4931" "0.6081" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "16-12-2008" "5.7007" "0.6311" "5.6684" "0.6275" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "17-12-2008" "5.4008" "0.5979" "5.5150" "0.6105" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "18-12-2008" "5.4555" "0.6039" "5.4392" "0.6021" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "19-12-2008" "5.3310" "0.5901" "5.3638" "0.5938" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "22-12-2008" "5.4591" "0.6043" "5.3939" "0.5971" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "23-12-2008" "5.1123" "0.5659" "5.1760" "0.5730" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "24-12-2008" "5.0601" "0.5602" "5.0444" "0.5584" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "26-12-2008" "5.0796" "0.5623" "5.0474" "0.5587" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "29-12-2008" "4.9731" "0.5505" "4.9731" "0.5505" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "30-12-2008" "4.9998" "0.5535" "4.8565" "0.5376" "0.0647" "NA" "0.1202" "NA"
    11 "20 MICRONS LTD." "31-12-2008" "4.4212" "0.5496" "4.4640" "0.5549" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "01-01-2009" "5.0197" "0.6240" "5.0339" "0.6258" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "02-01-2009" "5.2153" "0.6483" "5.1446" "0.6395" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "05-01-2009" "5.3428" "0.6642" "5.2142" "0.6482" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "06-01-2009" "5.0958" "0.6335" "5.0958" "0.6335" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "07-01-2009" "4.4919" "0.5584" "4.5488" "0.5655" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "09-01-2009" "4.2375" "0.5268" "4.2516" "0.5285" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "12-01-2009" "4.1516" "0.5161" "4.1801" "0.5196" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "13-01-2009" "4.0688" "0.5058" "4.1253" "0.5128" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "14-01-2009" "4.2992" "0.5344" "4.2708" "0.5309" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "15-01-2009" "4.0688" "0.5058" "4.1251" "0.5128" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "16-01-2009" "4.0096" "0.4984" "4.1372" "0.5143" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "19-01-2009" "4.1124" "0.5112" "4.1266" "0.5130" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "20-01-2009" "4.2032" "0.5225" "4.1891" "0.5208" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "21-01-2009" "4.0655" "0.5054" "4.1217" "0.5124" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "22-01-2009" "4.0248" "0.5003" "4.0813" "0.5074" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "23-01-2009" "4.0175" "0.4994" "4.0035" "0.4977" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "27-01-2009" "4.0031" "0.4976" "4.0738" "0.5064" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "28-01-2009" "4.0439" "0.5027" "4.0156" "0.4992" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "29-01-2009" "4.0838" "0.5077" "4.1262" "0.5129" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "30-01-2009" "4.2147" "0.5239" "4.1865" "0.5204" "0.0724" "NA" "0.1291" "NA"
    11 "20 MICRONS LTD." "02-02-2009" "4.2294" "0.5258" "4.2040" "0.5226" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "03-02-2009" "4.5377" "0.5641" "4.5632" "0.5673" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "04-02-2009" "4.4433" "0.5524" "4.4490" "0.5531" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "05-02-2009" "4.5727" "0.5684" "4.5187" "0.5617" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "06-02-2009" "4.4531" "0.5536" "4.4701" "0.5557" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "09-02-2009" "4.6734" "0.5810" "4.7533" "0.5909" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "10-02-2009" "4.8490" "0.6028" "4.8433" "0.6021" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "11-02-2009" "5.0502" "0.6278" "5.0445" "0.6271" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "12-02-2009" "5.0264" "0.6248" "5.0549" "0.6284" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "13-02-2009" "4.9609" "0.6167" "4.9552" "0.6160" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "16-02-2009" "4.6391" "0.5767" "4.5707" "0.5682" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "17-02-2009" "4.5863" "0.5701" "4.6709" "0.5807" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "18-02-2009" "4.5701" "0.5681" "4.7037" "0.5847" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "19-02-2009" "4.5812" "0.5695" "4.6202" "0.5743" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "20-02-2009" "4.4646" "0.5550" "4.4591" "0.5543" "0.0721" "NA" "0.1286" "NA"
    11 "20 MICRONS LTD." "24-02-2009" "4.2358" "0.5255" "4.2386" "0.5259" "0.0716" "NA" "0.1279" "NA"
    11 "20 MICRONS LTD." "25-02-2009" "4.4434" "0.5513" "4.4406" "0.5509" "0.0716" "NA" "0.1279" "NA"
    11 "20 MICRONS LTD." "26-02-2009" "4.6157" "0.5726" "4.5825" "0.5685" "0.0716" "NA" "0.1279" "NA"
    11 "20 MICRONS LTD." "27-02-2009" "4.3527" "0.5400" "4.4435" "0.5513" "0.0716" "NA" "0.1279" "NA"
    11 "20 MICRONS LTD." "02-03-2009" "4.3259" "0.5367" "4.3531" "0.5401" "0.0710" "NA" "0.1268" "NA"
    11 "20 MICRONS LTD." "03-03-2009" "4.1835" "0.5190" "4.2380" "0.5258" "0.0710" "NA" "0.1268" "NA"
    11 "20 MICRONS LTD." "04-03-2009" "4.0262" "0.4995" "4.1482" "0.5146" "0.0710" "NA" "0.1268" "NA"
    11 "20 MICRONS LTD." "05-03-2009" "3.9621" "0.4915" "4.0702" "0.5050" "0.0710" "NA" "0.1268" "NA"
    end
    [/CODE]
    ------------------ copy up to and including the previous line ------------------

    Listed 100 out of 14402349 observations
    Use the count() option to list more

    Tags: None
  • #2
    Dear Stalisters,

    Here's an update to my issue. I have extracted the data for the month of March for all years. I need to keep only the data of the last trading day of March, which marks the end of a financial year. The problem I am facing is that the last trading day falls on different dates in different years and I only need the data for the last trading day of every year.

    Any help will be greatly appreciated.

    Thank you in advance.

    Best regards,

    Avik


    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input long cocode str66 company_name str10 date str11 bse_pe str10 bse_pb str13 nse_pe str10 nse_pb str8(eps_on_stkdate cons_eps_on_stkdate ceps_on_stkdate cons_ceps_on_stkdate) float(a_date month day)
11 "20 MICRONS LTD." "02-03-2009" "4.3259"  "0.5367" "4.3531"  "0.5401" "0.0710" "NA"     "0.1268" "NA"     17958 3  2
11 "20 MICRONS LTD." "03-03-2009" "4.1835"  "0.5190" "4.2380"  "0.5258" "0.0710" "NA"     "0.1268" "NA"     17959 3  3
11 "20 MICRONS LTD." "04-03-2009" "4.0262"  "0.4995" "4.1482"  "0.5146" "0.0710" "NA"     "0.1268" "NA"     17960 3  4
11 "20 MICRONS LTD." "05-03-2009" "3.9621"  "0.4915" "4.0702"  "0.5050" "0.0710" "NA"     "0.1268" "NA"     17961 3  5
11 "20 MICRONS LTD." "06-03-2009" "4.0864"  "0.5070" "4.0590"  "0.5036" "0.0710" "NA"     "0.1268" "NA"     17962 3  6
11 "20 MICRONS LTD." "09-03-2009" "3.9004"  "0.4839" "3.9548"  "0.4906" "0.0710" "NA"     "0.1268" "NA"     17965 3  9
11 "20 MICRONS LTD." "12-03-2009" "3.9216"  "0.4865" "3.9488"  "0.4899" "0.0710" "NA"     "0.1268" "NA"     17968 3 12
11 "20 MICRONS LTD." "13-03-2009" "4.0737"  "0.5054" "3.9511"  "0.4902" "0.0710" "NA"     "0.1268" "NA"     17969 3 13
11 "20 MICRONS LTD." "16-03-2009" "4.1218"  "0.5114" "4.0945"  "0.5080" "0.0710" "NA"     "0.1268" "NA"     17972 3 16
11 "20 MICRONS LTD." "17-03-2009" "4.1346"  "0.5129" "4.0659"  "0.5044" "0.0710" "NA"     "0.1268" "NA"     17973 3 17
11 "20 MICRONS LTD." "18-03-2009" "4.2910"  "0.5324" "4.2773"  "0.5307" "0.0710" "NA"     "0.1268" "NA"     17974 3 18
11 "20 MICRONS LTD." "19-03-2009" "4.1875"  "0.5195" "4.1459"  "0.5144" "0.0710" "NA"     "0.1268" "NA"     17975 3 19
11 "20 MICRONS LTD." "20-03-2009" "4.1699"  "0.5173" "4.2682"  "0.5295" "0.0710" "NA"     "0.1268" "NA"     17976 3 20
11 "20 MICRONS LTD." "23-03-2009" "4.3197"  "0.5359" "4.2779"  "0.5307" "0.0710" "NA"     "0.1268" "NA"     17979 3 23
11 "20 MICRONS LTD." "24-03-2009" "4.3657"  "0.5416" "4.2398"  "0.5260" "0.0710" "NA"     "0.1268" "NA"     17980 3 24
11 "20 MICRONS LTD." "25-03-2009" "4.1964"  "0.5206" "4.1410"  "0.5138" "0.0710" "NA"     "0.1268" "NA"     17981 3 25
11 "20 MICRONS LTD." "26-03-2009" "4.0534"  "0.5029" "4.1648"  "0.5167" "0.0710" "NA"     "0.1268" "NA"     17982 3 26
11 "20 MICRONS LTD." "27-03-2009" "4.0951"  "0.5081" "4.1369"  "0.5132" "0.0710" "NA"     "0.1268" "NA"     17983 3 27
11 "20 MICRONS LTD." "30-03-2009" "4.0932"  "0.5078" "4.1345"  "0.5129" "0.0710" "NA"     "0.1268" "NA"     17986 3 30
11 "20 MICRONS LTD." "31-03-2009" "4.4730"  "0.5986" "4.5028"  "0.6026" "0.0658" "0.0627" "0.1213" "0.1182" 17987 3 31
11 "20 MICRONS LTD." "02-03-2010" "9.0108"  "1.3793" "8.9996"  "1.3776" "0.0967" "0.0687" "0.1652" "0.1372" 18323 3  2
11 "20 MICRONS LTD." "03-03-2010" "9.3160"  "1.4260" "9.3836"  "1.4364" "0.0967" "0.0687" "0.1652" "0.1372" 18324 3  3
11 "20 MICRONS LTD." "04-03-2010" "9.3097"  "1.4251" "9.3322"  "1.4285" "0.0967" "0.0687" "0.1652" "0.1372" 18325 3  4
11 "20 MICRONS LTD." "05-03-2010" "9.3404"  "1.4298" "9.4082"  "1.4402" "0.0967" "0.0687" "0.1652" "0.1372" 18326 3  5
11 "20 MICRONS LTD." "08-03-2010" "9.8904"  "1.5140" "9.8448"  "1.5070" "0.0967" "0.0687" "0.1652" "0.1372" 18329 3  8
11 "20 MICRONS LTD." "09-03-2010" "9.5826"  "1.4669" "9.6167"  "1.4721" "0.0967" "0.0687" "0.1652" "0.1372" 18330 3  9
11 "20 MICRONS LTD." "10-03-2010" "9.4507"  "1.4467" "9.4620"  "1.4484" "0.0967" "0.0687" "0.1652" "0.1372" 18331 3 10
11 "20 MICRONS LTD." "11-03-2010" "8.7332"  "1.3368" "8.7786"  "1.3438" "0.0967" "0.0687" "0.1652" "0.1372" 18332 3 11
11 "20 MICRONS LTD." "12-03-2010" "8.8508"  "1.3548" "8.8508"  "1.3548" "0.0967" "0.0687" "0.1652" "0.1372" 18333 3 12
11 "20 MICRONS LTD." "15-03-2010" "10.0166" "1.5333" "10.0280" "1.5350" "0.0967" "0.0687" "0.1652" "0.1372" 18336 3 15
11 "20 MICRONS LTD." "16-03-2010" "9.7898"  "1.4986" "9.7898"  "1.4986" "0.0967" "0.0687" "0.1652" "0.1372" 18337 3 16
11 "20 MICRONS LTD." "17-03-2010" "9.5531"  "1.4624" "9.5987"  "1.4693" "0.0967" "0.0687" "0.1652" "0.1372" 18338 3 17
11 "20 MICRONS LTD." "18-03-2010" "9.4340"  "1.4441" "9.5022"  "1.4546" "0.0967" "0.0687" "0.1652" "0.1372" 18339 3 18
11 "20 MICRONS LTD." "19-03-2010" "9.4247"  "1.4427" "9.3565"  "1.4323" "0.0967" "0.0687" "0.1652" "0.1372" 18340 3 19
11 "20 MICRONS LTD." "22-03-2010" "9.4454"  "1.4459" "9.5250"  "1.4580" "0.0967" "0.0687" "0.1652" "0.1372" 18343 3 22
11 "20 MICRONS LTD." "23-03-2010" "9.1472"  "1.4002" "9.2153"  "1.4106" "0.0967" "0.0687" "0.1652" "0.1372" 18344 3 23
11 "20 MICRONS LTD." "25-03-2010" "9.0085"  "1.3790" "9.0878"  "1.3911" "0.0967" "0.0687" "0.1652" "0.1372" 18346 3 25
11 "20 MICRONS LTD." "26-03-2010" "9.0319"  "1.3826" "9.1117"  "1.3948" "0.0967" "0.0687" "0.1652" "0.1372" 18347 3 26
11 "20 MICRONS LTD." "29-03-2010" "9.0496"  "1.3853" "9.1069"  "1.3941" "0.0967" "0.0687" "0.1652" "0.1372" 18350 3 29
11 "20 MICRONS LTD." "30-03-2010" "8.9282"  "1.3667" "8.9972"  "1.3773" "0.0967" "0.0687" "0.1652" "0.1372" 18351 3 30
11 "20 MICRONS LTD." "31-03-2010" "9.0718"  "1.3455" "9.1421"  "1.3559" "0.0946" "0.0957" "0.1675" "0.1685" 18352 3 31
11 "20 MICRONS LTD." "01-03-2011" "9.6171"  "1.2135" "9.6774"  "1.2212" "0.0918" "0.0958" "0.1722" "0.1761" 18687 3  1
11 "20 MICRONS LTD." "03-03-2011" "9.6271"  "1.2148" "9.5908"  "1.2102" "0.0918" "0.0958" "0.1722" "0.1761" 18689 3  3
11 "20 MICRONS LTD." "04-03-2011" "9.5602"  "1.2064" "9.5844"  "1.2094" "0.0918" "0.0958" "0.1722" "0.1761" 18690 3  4
11 "20 MICRONS LTD." "07-03-2011" "9.4822"  "1.1965" "9.4581"  "1.1935" "0.0918" "0.0958" "0.1722" "0.1761" 18693 3  7
11 "20 MICRONS LTD." "08-03-2011" "9.5154"  "1.2007" "9.4308"  "1.1900" "0.0918" "0.0958" "0.1722" "0.1761" 18694 3  8
11 "20 MICRONS LTD." "09-03-2011" "9.2515"  "1.1674" "9.2756"  "1.1705" "0.0918" "0.0958" "0.1722" "0.1761" 18695 3  9
11 "20 MICRONS LTD." "10-03-2011" "9.3537"  "1.1803" "9.3416"  "1.1788" "0.0918" "0.0958" "0.1722" "0.1761" 18696 3 10
11 "20 MICRONS LTD." "11-03-2011" "9.1764"  "1.1579" "9.1885"  "1.1595" "0.0918" "0.0958" "0.1722" "0.1761" 18697 3 11
11 "20 MICRONS LTD." "14-03-2011" "8.9836"  "1.1336" "9.0681"  "1.1443" "0.0918" "0.0958" "0.1722" "0.1761" 18700 3 14
11 "20 MICRONS LTD." "15-03-2011" "8.9117"  "1.1245" "8.8877"  "1.1215" "0.0918" "0.0958" "0.1722" "0.1761" 18701 3 15
11 "20 MICRONS LTD." "16-03-2011" "8.8451"  "1.1161" "8.8210"  "1.1131" "0.0918" "0.0958" "0.1722" "0.1761" 18702 3 16
11 "20 MICRONS LTD." "17-03-2011" "8.8575"  "1.1177" "8.7612"  "1.1055" "0.0918" "0.0958" "0.1722" "0.1761" 18703 3 17
11 "20 MICRONS LTD." "18-03-2011" "8.8145"  "1.1123" "8.7300"  "1.1016" "0.0918" "0.0958" "0.1722" "0.1761" 18704 3 18
11 "20 MICRONS LTD." "21-03-2011" "8.6652"  "1.0934" "8.6773"  "1.0950" "0.0918" "0.0958" "0.1722" "0.1761" 18707 3 21
11 "20 MICRONS LTD." "22-03-2011" "8.7896"  "1.1091" "8.7048"  "1.0984" "0.0918" "0.0958" "0.1722" "0.1761" 18708 3 22
11 "20 MICRONS LTD." "23-03-2011" "8.7431"  "1.1033" "8.6825"  "1.0956" "0.0918" "0.0958" "0.1722" "0.1761" 18709 3 23
11 "20 MICRONS LTD." "24-03-2011" "8.9869"  "1.1340" "8.9504"  "1.1294" "0.0918" "0.0958" "0.1722" "0.1761" 18710 3 24
11 "20 MICRONS LTD." "25-03-2011" "8.9989"  "1.1355" "9.0111"  "1.1371" "0.0918" "0.0958" "0.1722" "0.1761" 18711 3 25
11 "20 MICRONS LTD." "28-03-2011" "9.0457"  "1.1415" "8.9971"  "1.1353" "0.0918" "0.0958" "0.1722" "0.1761" 18714 3 28
11 "20 MICRONS LTD." "29-03-2011" "9.5068"  "1.1996" "9.4336"  "1.1904" "0.0918" "0.0958" "0.1722" "0.1761" 18715 3 29
11 "20 MICRONS LTD." "30-03-2011" "9.4369"  "1.1908" "9.4247"  "1.1893" "0.0918" "0.0958" "0.1722" "0.1761" 18716 3 30
11 "20 MICRONS LTD." "31-03-2011" "9.9526"  "1.2028" "9.9526"  "1.2028" "0.0836" "0.0929" "0.1663" "0.1756" 18717 3 31
11 "20 MICRONS LTD." "01-03-2012" "15.9434" "2.1806" "15.8932" "2.1738" "0.1012" "0.0850" "0.1869" "0.1707" 19053 3  1
11 "20 MICRONS LTD." "02-03-2012" "17.0602" "2.3334" "17.0102" "2.3265" "0.1012" "0.0850" "0.1869" "0.1707" 19054 3  2
11 "20 MICRONS LTD." "03-03-2012" "17.2605" "2.3608" "17.2304" "2.3567" "0.1012" "0.0850" "0.1869" "0.1707" 19055 3  3
11 "20 MICRONS LTD." "05-03-2012" "16.9061" "2.3123" "16.8862" "2.3096" "0.1012" "0.0850" "0.1869" "0.1707" 19057 3  5
11 "20 MICRONS LTD." "06-03-2012" "16.2358" "2.2206" "16.2457" "2.2220" "0.1012" "0.0850" "0.1869" "0.1707" 19058 3  6
11 "20 MICRONS LTD." "07-03-2012" "16.4728" "2.2530" "16.5021" "2.2570" "0.1012" "0.0850" "0.1869" "0.1707" 19059 3  7
11 "20 MICRONS LTD." "09-03-2012" "16.4564" "2.2508" "16.3872" "2.2413" "0.1012" "0.0850" "0.1869" "0.1707" 19061 3  9
11 "20 MICRONS LTD." "12-03-2012" "16.1463" "2.2084" "16.1562" "2.2097" "0.1012" "0.0850" "0.1869" "0.1707" 19064 3 12
11 "20 MICRONS LTD." "13-03-2012" "16.1458" "2.2083" "16.2052" "2.2164" "0.1012" "0.0850" "0.1869" "0.1707" 19065 3 13
11 "20 MICRONS LTD." "14-03-2012" "16.0801" "2.1993" "16.0702" "2.1980" "0.1012" "0.0850" "0.1869" "0.1707" 19066 3 14
11 "20 MICRONS LTD." "15-03-2012" "15.8497" "2.1678" "15.9087" "2.1759" "0.1012" "0.0850" "0.1869" "0.1707" 19067 3 15
11 "20 MICRONS LTD." "16-03-2012" "16.0079" "2.1895" "15.9588" "2.1827" "0.1012" "0.0850" "0.1869" "0.1707" 19068 3 16
11 "20 MICRONS LTD." "19-03-2012" "16.1672" "2.2112" "16.1179" "2.2045" "0.1012" "0.0850" "0.1869" "0.1707" 19071 3 19
11 "20 MICRONS LTD." "20-03-2012" "16.3319" "2.2338" "16.2925" "2.2284" "0.1012" "0.0850" "0.1869" "0.1707" 19072 3 20
11 "20 MICRONS LTD." "21-03-2012" "16.1830" "2.2134" "16.2026" "2.2161" "0.1012" "0.0850" "0.1869" "0.1707" 19073 3 21
11 "20 MICRONS LTD." "22-03-2012" "15.8387" "2.1663" "15.7902" "2.1597" "0.1012" "0.0850" "0.1869" "0.1707" 19074 3 22
11 "20 MICRONS LTD." "23-03-2012" "15.8193" "2.1637" "15.8387" "2.1663" "0.1012" "0.0850" "0.1869" "0.1707" 19075 3 23
11 "20 MICRONS LTD." "26-03-2012" "15.7249" "2.1507" "15.6767" "2.1442" "0.1012" "0.0850" "0.1869" "0.1707" 19078 3 26
11 "20 MICRONS LTD." "27-03-2012" "15.7028" "2.1477" "15.6931" "2.1464" "0.1012" "0.0850" "0.1869" "0.1707" 19079 3 27
11 "20 MICRONS LTD." "28-03-2012" "15.5542" "2.1274" "15.5736" "2.1301" "0.1012" "0.0850" "0.1869" "0.1707" 19080 3 28
11 "20 MICRONS LTD." "29-03-2012" "15.4843" "2.1178" "15.4746" "2.1165" "0.1012" "0.0850" "0.1869" "0.1707" 19081 3 29
11 "20 MICRONS LTD." "30-03-2012" "15.5295" "2.1240" "15.5102" "2.1214" "0.1012" "0.0850" "0.1869" "0.1707" 19082 3 30
11 "20 MICRONS LTD." "01-03-2013" "10.7510" "1.5192" "10.4004" "1.4696" "0.0550" "0.0601" "0.0969" "0.1020" 19418 3  1
11 "20 MICRONS LTD." "04-03-2013" "10.3753" "1.4661" "10.3588" "1.4637" "0.0550" "0.0601" "0.0969" "0.1020" 19421 3  4
11 "20 MICRONS LTD." "05-03-2013" "9.9853"  "1.4110" "9.9354"  "1.4039" "0.0550" "0.0601" "0.0969" "0.1020" 19422 3  5
11 "20 MICRONS LTD." "06-03-2013" "10.2736" "1.4517" "10.3068" "1.4564" "0.0550" "0.0601" "0.0969" "0.1020" 19423 3  6
11 "20 MICRONS LTD." "07-03-2013" "10.5171" "1.4861" "10.5338" "1.4885" "0.0550" "0.0601" "0.0969" "0.1020" 19424 3  7
11 "20 MICRONS LTD." "08-03-2013" "10.7835" "1.5238" "10.7835" "1.5238" "0.0550" "0.0601" "0.0969" "0.1020" 19425 3  8
11 "20 MICRONS LTD." "11-03-2013" "10.5876" "1.4961" "10.5876" "1.4961" "0.0550" "0.0601" "0.0969" "0.1020" 19428 3 11
11 "20 MICRONS LTD." "12-03-2013" "10.8791" "1.5373" "10.8624" "1.5349" "0.0550" "0.0601" "0.0969" "0.1020" 19429 3 12
11 "20 MICRONS LTD." "13-03-2013" "10.3371" "1.4607" "10.3034" "1.4559" "0.0550" "0.0601" "0.0969" "0.1020" 19430 3 13
11 "20 MICRONS LTD." "14-03-2013" "10.3579" "1.4636" "10.4247" "1.4731" "0.0550" "0.0601" "0.0969" "0.1020" 19431 3 14
11 "20 MICRONS LTD." "15-03-2013" "10.2939" "1.4546" "10.3275" "1.4593" "0.0550" "0.0601" "0.0969" "0.1020" 19432 3 15
11 "20 MICRONS LTD." "18-03-2013" "10.2860" "1.4535" "10.2358" "1.4464" "0.0550" "0.0601" "0.0969" "0.1020" 19435 3 18
11 "20 MICRONS LTD." "19-03-2013" "10.2414" "1.4472" "10.2079" "1.4424" "0.0550" "0.0601" "0.0969" "0.1020" 19436 3 19
11 "20 MICRONS LTD." "20-03-2013" "10.1519" "1.4345" "10.1687" "1.4369" "0.0550" "0.0601" "0.0969" "0.1020" 19437 3 20
11 "20 MICRONS LTD." "21-03-2013" "10.1371" "1.4324" "10.1371" "1.4324" "0.0550" "0.0601" "0.0969" "0.1020" 19438 3 21
end
format %td a_date

    Comment

    • #3
      Dear Statalisters,

      This is an addendum to my earlier post. The sample dataset pasted below better explains my predicament. The last trading day falls on different dates each year and I need to keep only the data pertaining to the last trading day.

      Kindly guide me.

      Thank you in advance.

      Best wishes,

      Avik

      Code:
      * Example generated by -dataex-. For more info, type help dataex
clear
input long cocode str66 company_name str10 date str11 bse_pe str10 bse_pb str13 nse_pe str10 nse_pb str8(eps_on_stkdate cons_eps_on_stkdate ceps_on_stkdate cons_ceps_on_stkdate) float(a_date month day)
11 "20 MICRONS LTD." "02-03-2009" "4.3259"  "0.5367" "4.3531"  "0.5401" "0.0710"  "NA"      "0.1268" "NA"     17958 3  2
11 "20 MICRONS LTD." "03-03-2009" "4.1835"  "0.5190" "4.2380"  "0.5258" "0.0710"  "NA"      "0.1268" "NA"     17959 3  3
11 "20 MICRONS LTD." "04-03-2009" "4.0262"  "0.4995" "4.1482"  "0.5146" "0.0710"  "NA"      "0.1268" "NA"     17960 3  4
11 "20 MICRONS LTD." "05-03-2009" "3.9621"  "0.4915" "4.0702"  "0.5050" "0.0710"  "NA"      "0.1268" "NA"     17961 3  5
11 "20 MICRONS LTD." "06-03-2009" "4.0864"  "0.5070" "4.0590"  "0.5036" "0.0710"  "NA"      "0.1268" "NA"     17962 3  6
11 "20 MICRONS LTD." "09-03-2009" "3.9004"  "0.4839" "3.9548"  "0.4906" "0.0710"  "NA"      "0.1268" "NA"     17965 3  9
11 "20 MICRONS LTD." "12-03-2009" "3.9216"  "0.4865" "3.9488"  "0.4899" "0.0710"  "NA"      "0.1268" "NA"     17968 3 12
11 "20 MICRONS LTD." "13-03-2009" "4.0737"  "0.5054" "3.9511"  "0.4902" "0.0710"  "NA"      "0.1268" "NA"     17969 3 13
11 "20 MICRONS LTD." "16-03-2009" "4.1218"  "0.5114" "4.0945"  "0.5080" "0.0710"  "NA"      "0.1268" "NA"     17972 3 16
11 "20 MICRONS LTD." "17-03-2009" "4.1346"  "0.5129" "4.0659"  "0.5044" "0.0710"  "NA"      "0.1268" "NA"     17973 3 17
11 "20 MICRONS LTD." "18-03-2009" "4.2910"  "0.5324" "4.2773"  "0.5307" "0.0710"  "NA"      "0.1268" "NA"     17974 3 18
11 "20 MICRONS LTD." "19-03-2009" "4.1875"  "0.5195" "4.1459"  "0.5144" "0.0710"  "NA"      "0.1268" "NA"     17975 3 19
11 "20 MICRONS LTD." "20-03-2009" "4.1699"  "0.5173" "4.2682"  "0.5295" "0.0710"  "NA"      "0.1268" "NA"     17976 3 20
11 "20 MICRONS LTD." "23-03-2009" "4.3197"  "0.5359" "4.2779"  "0.5307" "0.0710"  "NA"      "0.1268" "NA"     17979 3 23
11 "20 MICRONS LTD." "24-03-2009" "4.3657"  "0.5416" "4.2398"  "0.5260" "0.0710"  "NA"      "0.1268" "NA"     17980 3 24
11 "20 MICRONS LTD." "25-03-2009" "4.1964"  "0.5206" "4.1410"  "0.5138" "0.0710"  "NA"      "0.1268" "NA"     17981 3 25
11 "20 MICRONS LTD." "26-03-2009" "4.0534"  "0.5029" "4.1648"  "0.5167" "0.0710"  "NA"      "0.1268" "NA"     17982 3 26
11 "20 MICRONS LTD." "27-03-2009" "4.0951"  "0.5081" "4.1369"  "0.5132" "0.0710"  "NA"      "0.1268" "NA"     17983 3 27
11 "20 MICRONS LTD." "30-03-2009" "4.0932"  "0.5078" "4.1345"  "0.5129" "0.0710"  "NA"      "0.1268" "NA"     17986 3 30
11 "20 MICRONS LTD." "31-03-2009" "4.4730"  "0.5986" "4.5028"  "0.6026" "0.0658"  "0.0627"  "0.1213" "0.1182" 17987 3 31
11 "20 MICRONS LTD." "02-03-2010" "9.0108"  "1.3793" "8.9996"  "1.3776" "0.0967"  "0.0687"  "0.1652" "0.1372" 18323 3  2
11 "20 MICRONS LTD." "03-03-2010" "9.3160"  "1.4260" "9.3836"  "1.4364" "0.0967"  "0.0687"  "0.1652" "0.1372" 18324 3  3
11 "20 MICRONS LTD." "04-03-2010" "9.3097"  "1.4251" "9.3322"  "1.4285" "0.0967"  "0.0687"  "0.1652" "0.1372" 18325 3  4
11 "20 MICRONS LTD." "05-03-2010" "9.3404"  "1.4298" "9.4082"  "1.4402" "0.0967"  "0.0687"  "0.1652" "0.1372" 18326 3  5
11 "20 MICRONS LTD." "08-03-2010" "9.8904"  "1.5140" "9.8448"  "1.5070" "0.0967"  "0.0687"  "0.1652" "0.1372" 18329 3  8
11 "20 MICRONS LTD." "09-03-2010" "9.5826"  "1.4669" "9.6167"  "1.4721" "0.0967"  "0.0687"  "0.1652" "0.1372" 18330 3  9
11 "20 MICRONS LTD." "10-03-2010" "9.4507"  "1.4467" "9.4620"  "1.4484" "0.0967"  "0.0687"  "0.1652" "0.1372" 18331 3 10
11 "20 MICRONS LTD." "11-03-2010" "8.7332"  "1.3368" "8.7786"  "1.3438" "0.0967"  "0.0687"  "0.1652" "0.1372" 18332 3 11
11 "20 MICRONS LTD." "12-03-2010" "8.8508"  "1.3548" "8.8508"  "1.3548" "0.0967"  "0.0687"  "0.1652" "0.1372" 18333 3 12
11 "20 MICRONS LTD." "15-03-2010" "10.0166" "1.5333" "10.0280" "1.5350" "0.0967"  "0.0687"  "0.1652" "0.1372" 18336 3 15
11 "20 MICRONS LTD." "16-03-2010" "9.7898"  "1.4986" "9.7898"  "1.4986" "0.0967"  "0.0687"  "0.1652" "0.1372" 18337 3 16
11 "20 MICRONS LTD." "17-03-2010" "9.5531"  "1.4624" "9.5987"  "1.4693" "0.0967"  "0.0687"  "0.1652" "0.1372" 18338 3 17
11 "20 MICRONS LTD." "18-03-2010" "9.4340"  "1.4441" "9.5022"  "1.4546" "0.0967"  "0.0687"  "0.1652" "0.1372" 18339 3 18
11 "20 MICRONS LTD." "19-03-2010" "9.4247"  "1.4427" "9.3565"  "1.4323" "0.0967"  "0.0687"  "0.1652" "0.1372" 18340 3 19
11 "20 MICRONS LTD." "22-03-2010" "9.4454"  "1.4459" "9.5250"  "1.4580" "0.0967"  "0.0687"  "0.1652" "0.1372" 18343 3 22
11 "20 MICRONS LTD." "23-03-2010" "9.1472"  "1.4002" "9.2153"  "1.4106" "0.0967"  "0.0687"  "0.1652" "0.1372" 18344 3 23
11 "20 MICRONS LTD." "25-03-2010" "9.0085"  "1.3790" "9.0878"  "1.3911" "0.0967"  "0.0687"  "0.1652" "0.1372" 18346 3 25
11 "20 MICRONS LTD." "26-03-2010" "9.0319"  "1.3826" "9.1117"  "1.3948" "0.0967"  "0.0687"  "0.1652" "0.1372" 18347 3 26
11 "20 MICRONS LTD." "29-03-2010" "9.0496"  "1.3853" "9.1069"  "1.3941" "0.0967"  "0.0687"  "0.1652" "0.1372" 18350 3 29
11 "20 MICRONS LTD." "30-03-2010" "8.9282"  "1.3667" "8.9972"  "1.3773" "0.0967"  "0.0687"  "0.1652" "0.1372" 18351 3 30
11 "20 MICRONS LTD." "31-03-2010" "9.0718"  "1.3455" "9.1421"  "1.3559" "0.0946"  "0.0957"  "0.1675" "0.1685" 18352 3 31
11 "20 MICRONS LTD." "01-03-2011" "9.6171"  "1.2135" "9.6774"  "1.2212" "0.0918"  "0.0958"  "0.1722" "0.1761" 18687 3  1
11 "20 MICRONS LTD." "03-03-2011" "9.6271"  "1.2148" "9.5908"  "1.2102" "0.0918"  "0.0958"  "0.1722" "0.1761" 18689 3  3
11 "20 MICRONS LTD." "04-03-2011" "9.5602"  "1.2064" "9.5844"  "1.2094" "0.0918"  "0.0958"  "0.1722" "0.1761" 18690 3  4
11 "20 MICRONS LTD." "07-03-2011" "9.4822"  "1.1965" "9.4581"  "1.1935" "0.0918"  "0.0958"  "0.1722" "0.1761" 18693 3  7
11 "20 MICRONS LTD." "08-03-2011" "9.5154"  "1.2007" "9.4308"  "1.1900" "0.0918"  "0.0958"  "0.1722" "0.1761" 18694 3  8
11 "20 MICRONS LTD." "09-03-2011" "9.2515"  "1.1674" "9.2756"  "1.1705" "0.0918"  "0.0958"  "0.1722" "0.1761" 18695 3  9
11 "20 MICRONS LTD." "10-03-2011" "9.3537"  "1.1803" "9.3416"  "1.1788" "0.0918"  "0.0958"  "0.1722" "0.1761" 18696 3 10
11 "20 MICRONS LTD." "11-03-2011" "9.1764"  "1.1579" "9.1885"  "1.1595" "0.0918"  "0.0958"  "0.1722" "0.1761" 18697 3 11
11 "20 MICRONS LTD." "14-03-2011" "8.9836"  "1.1336" "9.0681"  "1.1443" "0.0918"  "0.0958"  "0.1722" "0.1761" 18700 3 14
11 "20 MICRONS LTD." "15-03-2011" "8.9117"  "1.1245" "8.8877"  "1.1215" "0.0918"  "0.0958"  "0.1722" "0.1761" 18701 3 15
11 "20 MICRONS LTD." "16-03-2011" "8.8451"  "1.1161" "8.8210"  "1.1131" "0.0918"  "0.0958"  "0.1722" "0.1761" 18702 3 16
11 "20 MICRONS LTD." "17-03-2011" "8.8575"  "1.1177" "8.7612"  "1.1055" "0.0918"  "0.0958"  "0.1722" "0.1761" 18703 3 17
11 "20 MICRONS LTD." "18-03-2011" "8.8145"  "1.1123" "8.7300"  "1.1016" "0.0918"  "0.0958"  "0.1722" "0.1761" 18704 3 18
11 "20 MICRONS LTD." "21-03-2011" "8.6652"  "1.0934" "8.6773"  "1.0950" "0.0918"  "0.0958"  "0.1722" "0.1761" 18707 3 21
11 "20 MICRONS LTD." "22-03-2011" "8.7896"  "1.1091" "8.7048"  "1.0984" "0.0918"  "0.0958"  "0.1722" "0.1761" 18708 3 22
11 "20 MICRONS LTD." "23-03-2011" "8.7431"  "1.1033" "8.6825"  "1.0956" "0.0918"  "0.0958"  "0.1722" "0.1761" 18709 3 23
11 "20 MICRONS LTD." "24-03-2011" "8.9869"  "1.1340" "8.9504"  "1.1294" "0.0918"  "0.0958"  "0.1722" "0.1761" 18710 3 24
11 "20 MICRONS LTD." "25-03-2011" "8.9989"  "1.1355" "9.0111"  "1.1371" "0.0918"  "0.0958"  "0.1722" "0.1761" 18711 3 25
11 "20 MICRONS LTD." "28-03-2011" "9.0457"  "1.1415" "8.9971"  "1.1353" "0.0918"  "0.0958"  "0.1722" "0.1761" 18714 3 28
11 "20 MICRONS LTD." "29-03-2011" "9.5068"  "1.1996" "9.4336"  "1.1904" "0.0918"  "0.0958"  "0.1722" "0.1761" 18715 3 29
11 "20 MICRONS LTD." "30-03-2011" "9.4369"  "1.1908" "9.4247"  "1.1893" "0.0918"  "0.0958"  "0.1722" "0.1761" 18716 3 30
11 "20 MICRONS LTD." "31-03-2011" "9.9526"  "1.2028" "9.9526"  "1.2028" "0.0836"  "0.0929"  "0.1663" "0.1756" 18717 3 31
11 "20 MICRONS LTD." "01-03-2012" "15.9434" "2.1806" "15.8932" "2.1738" "0.1012"  "0.0850"  "0.1869" "0.1707" 19053 3  1
11 "20 MICRONS LTD." "02-03-2012" "17.0602" "2.3334" "17.0102" "2.3265" "0.1012"  "0.0850"  "0.1869" "0.1707" 19054 3  2
11 "20 MICRONS LTD." "03-03-2012" "17.2605" "2.3608" "17.2304" "2.3567" "0.1012"  "0.0850"  "0.1869" "0.1707" 19055 3  3
11 "20 MICRONS LTD." "05-03-2012" "16.9061" "2.3123" "16.8862" "2.3096" "0.1012"  "0.0850"  "0.1869" "0.1707" 19057 3  5
11 "20 MICRONS LTD." "06-03-2012" "16.2358" "2.2206" "16.2457" "2.2220" "0.1012"  "0.0850"  "0.1869" "0.1707" 19058 3  6
11 "20 MICRONS LTD." "07-03-2012" "16.4728" "2.2530" "16.5021" "2.2570" "0.1012"  "0.0850"  "0.1869" "0.1707" 19059 3  7
11 "20 MICRONS LTD." "09-03-2012" "16.4564" "2.2508" "16.3872" "2.2413" "0.1012"  "0.0850"  "0.1869" "0.1707" 19061 3  9
11 "20 MICRONS LTD." "12-03-2012" "16.1463" "2.2084" "16.1562" "2.2097" "0.1012"  "0.0850"  "0.1869" "0.1707" 19064 3 12
11 "20 MICRONS LTD." "13-03-2012" "16.1458" "2.2083" "16.2052" "2.2164" "0.1012"  "0.0850"  "0.1869" "0.1707" 19065 3 13
11 "20 MICRONS LTD." "14-03-2012" "16.0801" "2.1993" "16.0702" "2.1980" "0.1012"  "0.0850"  "0.1869" "0.1707" 19066 3 14
11 "20 MICRONS LTD." "15-03-2012" "15.8497" "2.1678" "15.9087" "2.1759" "0.1012"  "0.0850"  "0.1869" "0.1707" 19067 3 15
11 "20 MICRONS LTD." "16-03-2012" "16.0079" "2.1895" "15.9588" "2.1827" "0.1012"  "0.0850"  "0.1869" "0.1707" 19068 3 16
11 "20 MICRONS LTD." "19-03-2012" "16.1672" "2.2112" "16.1179" "2.2045" "0.1012"  "0.0850"  "0.1869" "0.1707" 19071 3 19
11 "20 MICRONS LTD." "20-03-2012" "16.3319" "2.2338" "16.2925" "2.2284" "0.1012"  "0.0850"  "0.1869" "0.1707" 19072 3 20
11 "20 MICRONS LTD." "21-03-2012" "16.1830" "2.2134" "16.2026" "2.2161" "0.1012"  "0.0850"  "0.1869" "0.1707" 19073 3 21
11 "20 MICRONS LTD." "22-03-2012" "15.8387" "2.1663" "15.7902" "2.1597" "0.1012"  "0.0850"  "0.1869" "0.1707" 19074 3 22
11 "20 MICRONS LTD." "23-03-2012" "15.8193" "2.1637" "15.8387" "2.1663" "0.1012"  "0.0850"  "0.1869" "0.1707" 19075 3 23
11 "20 MICRONS LTD." "26-03-2012" "15.7249" "2.1507" "15.6767" "2.1442" "0.1012"  "0.0850"  "0.1869" "0.1707" 19078 3 26
11 "20 MICRONS LTD." "27-03-2012" "15.7028" "2.1477" "15.6931" "2.1464" "0.1012"  "0.0850"  "0.1869" "0.1707" 19079 3 27
11 "20 MICRONS LTD." "28-03-2012" "15.5542" "2.1274" "15.5736" "2.1301" "0.1012"  "0.0850"  "0.1869" "0.1707" 19080 3 28
11 "20 MICRONS LTD." "29-03-2012" "15.4843" "2.1178" "15.4746" "2.1165" "0.1012"  "0.0850"  "0.1869" "0.1707" 19081 3 29
11 "20 MICRONS LTD." "30-03-2012" "15.5295" "2.1240" "15.5102" "2.1214" "0.1012"  "0.0850"  "0.1869" "0.1707" 19082 3 30
11 "20 MICRONS LTD." "01-03-2013" "10.7510" "1.5192" "10.4004" "1.4696" "0.0550"  "0.0601"  "0.0969" "0.1020" 19418 3  1
11 "20 MICRONS LTD." "04-03-2013" "10.3753" "1.4661" "10.3588" "1.4637" "0.0550"  "0.0601"  "0.0969" "0.1020" 19421 3  4
11 "20 MICRONS LTD." "05-03-2013" "9.9853"  "1.4110" "9.9354"  "1.4039" "0.0550"  "0.0601"  "0.0969" "0.1020" 19422 3  5
11 "20 MICRONS LTD." "06-03-2013" "10.2736" "1.4517" "10.3068" "1.4564" "0.0550"  "0.0601"  "0.0969" "0.1020" 19423 3  6
11 "20 MICRONS LTD." "07-03-2013" "10.5171" "1.4861" "10.5338" "1.4885" "0.0550"  "0.0601"  "0.0969" "0.1020" 19424 3  7
11 "20 MICRONS LTD." "08-03-2013" "10.7835" "1.5238" "10.7835" "1.5238" "0.0550"  "0.0601"  "0.0969" "0.1020" 19425 3  8
11 "20 MICRONS LTD." "11-03-2013" "10.5876" "1.4961" "10.5876" "1.4961" "0.0550"  "0.0601"  "0.0969" "0.1020" 19428 3 11
11 "20 MICRONS LTD." "12-03-2013" "10.8791" "1.5373" "10.8624" "1.5349" "0.0550"  "0.0601"  "0.0969" "0.1020" 19429 3 12
11 "20 MICRONS LTD." "13-03-2013" "10.3371" "1.4607" "10.3034" "1.4559" "0.0550"  "0.0601"  "0.0969" "0.1020" 19430 3 13
11 "20 MICRONS LTD." "14-03-2013" "10.3579" "1.4636" "10.4247" "1.4731" "0.0550"  "0.0601"  "0.0969" "0.1020" 19431 3 14
11 "20 MICRONS LTD." "15-03-2013" "10.2939" "1.4546" "10.3275" "1.4593" "0.0550"  "0.0601"  "0.0969" "0.1020" 19432 3 15
11 "20 MICRONS LTD." "18-03-2013" "10.2860" "1.4535" "10.2358" "1.4464" "0.0550"  "0.0601"  "0.0969" "0.1020" 19435 3 18
11 "20 MICRONS LTD." "19-03-2013" "10.2414" "1.4472" "10.2079" "1.4424" "0.0550"  "0.0601"  "0.0969" "0.1020" 19436 3 19
11 "20 MICRONS LTD." "20-03-2013" "10.1519" "1.4345" "10.1687" "1.4369" "0.0550"  "0.0601"  "0.0969" "0.1020" 19437 3 20
11 "20 MICRONS LTD." "21-03-2013" "10.1371" "1.4324" "10.1371" "1.4324" "0.0550"  "0.0601"  "0.0969" "0.1020" 19438 3 21
11 "20 MICRONS LTD." "22-03-2013" "10.0757" "1.4237" "10.2598" "1.4498" "0.0550"  "0.0601"  "0.0969" "0.1020" 19439 3 22
11 "20 MICRONS LTD." "25-03-2013" "10.1372" "1.4324" "10.1372" "1.4324" "0.0550"  "0.0601"  "0.0969" "0.1020" 19442 3 25
11 "20 MICRONS LTD." "26-03-2013" "10.1222" "1.4303" "10.1390" "1.4327" "0.0550"  "0.0601"  "0.0969" "0.1020" 19443 3 26
11 "20 MICRONS LTD." "28-03-2013" "10.3842" "1.4673" "10.4678" "1.4791" "0.0550"  "0.0601"  "0.0969" "0.1020" 19445 3 28
11 "20 MICRONS LTD." "03-03-2014" "NA"      "1.3736" "NA"      "1.3668" "-0.0204" "0.0145"  "0.0249" "0.0599" 19785 3  3
11 "20 MICRONS LTD." "04-03-2014" "NA"      "1.3660" "NA"      "1.3660" "-0.0204" "0.0145"  "0.0249" "0.0599" 19786 3  4
11 "20 MICRONS LTD." "05-03-2014" "NA"      "1.3626" "NA"      "1.3626" "-0.0204" "0.0145"  "0.0249" "0.0599" 19787 3  5
11 "20 MICRONS LTD." "06-03-2014" "NA"      "1.3971" "NA"      "1.3948" "-0.0204" "0.0145"  "0.0249" "0.0599" 19788 3  6
11 "20 MICRONS LTD." "07-03-2014" "NA"      "1.4049" "NA"      "1.3934" "-0.0204" "0.0145"  "0.0249" "0.0599" 19789 3  7
11 "20 MICRONS LTD." "10-03-2014" "NA"      "1.4112" "NA"      "1.3998" "-0.0204" "0.0145"  "0.0249" "0.0599" 19792 3 10
11 "20 MICRONS LTD." "11-03-2014" "NA"      "1.4274" "NA"      "1.4366" "-0.0204" "0.0145"  "0.0249" "0.0599" 19793 3 11
11 "20 MICRONS LTD." "12-03-2014" "NA"      "1.4206" "NA"      "1.4138" "-0.0204" "0.0145"  "0.0249" "0.0599" 19794 3 12
11 "20 MICRONS LTD." "13-03-2014" "NA"      "1.3971" "NA"      "1.3994" "-0.0204" "0.0145"  "0.0249" "0.0599" 19795 3 13
11 "20 MICRONS LTD." "14-03-2014" "NA"      "1.3721" "NA"      "1.3744" "-0.0204" "0.0145"  "0.0249" "0.0599" 19796 3 14
11 "20 MICRONS LTD." "18-03-2014" "NA"      "1.3918" "NA"      "1.3873" "-0.0204" "0.0145"  "0.0249" "0.0599" 19800 3 18
11 "20 MICRONS LTD." "19-03-2014" "NA"      "1.3816" "NA"      "1.3838" "-0.0204" "0.0145"  "0.0249" "0.0599" 19801 3 19
11 "20 MICRONS LTD." "20-03-2014" "NA"      "1.3809" "NA"      "1.3809" "-0.0204" "0.0145"  "0.0249" "0.0599" 19802 3 20
11 "20 MICRONS LTD." "21-03-2014" "NA"      "1.3964" "NA"      "1.3964" "-0.0204" "0.0145"  "0.0249" "0.0599" 19803 3 21
11 "20 MICRONS LTD." "22-03-2014" "NA"      "1.3804" "NA"      "1.3804" "-0.0204" "0.0145"  "0.0249" "0.0599" 19804 3 22
11 "20 MICRONS LTD." "24-03-2014" "NA"      "1.3861" "NA"      "1.3884" "-0.0204" "0.0145"  "0.0249" "0.0599" 19806 3 24
11 "20 MICRONS LTD." "25-03-2014" "NA"      "1.3909" "NA"      "1.3932" "-0.0204" "0.0145"  "0.0249" "0.0599" 19807 3 25
11 "20 MICRONS LTD." "26-03-2014" "NA"      "1.4006" "NA"      "1.4006" "-0.0204" "0.0145"  "0.0249" "0.0599" 19808 3 26
11 "20 MICRONS LTD." "27-03-2014" "NA"      "1.3992" "NA"      "1.3992" "-0.0204" "0.0145"  "0.0249" "0.0599" 19809 3 27
11 "20 MICRONS LTD." "28-03-2014" "NA"      "1.4231" "NA"      "1.4162" "-0.0204" "0.0145"  "0.0249" "0.0599" 19810 3 28
11 "20 MICRONS LTD." "31-03-2014" "NA"      "1.4464" "NA"      "1.4372" "-0.0040" "-0.0101" "0.0448" "0.0388" 19813 3 31
11 "20 MICRONS LTD." "02-03-2015" "NA"      "1.6356" "NA"      "1.6379" "-0.0172" "-0.0099" "0.0291" "0.0364" 20149 3  2
11 "20 MICRONS LTD." "03-03-2015" "NA"      "1.6605" "NA"      "1.6513" "-0.0172" "-0.0099" "0.0291" "0.0364" 20150 3  3
11 "20 MICRONS LTD." "04-03-2015" "NA"      "1.6417" "NA"      "1.6510" "-0.0172" "-0.0099" "0.0291" "0.0364" 20151 3  4
11 "20 MICRONS LTD." "05-03-2015" "NA"      "1.6325" "NA"      "1.6394" "-0.0172" "-0.0099" "0.0291" "0.0364" 20152 3  5
11 "20 MICRONS LTD." "09-03-2015" "NA"      "1.6261" "NA"      "1.6284" "-0.0172" "-0.0099" "0.0291" "0.0364" 20156 3  9
11 "20 MICRONS LTD." "10-03-2015" "NA"      "1.6103" "NA"      "1.6149" "-0.0172" "-0.0099" "0.0291" "0.0364" 20157 3 10
11 "20 MICRONS LTD." "11-03-2015" "NA"      "1.6116" "NA"      "1.6025" "-0.0172" "-0.0099" "0.0291" "0.0364" 20158 3 11
11 "20 MICRONS LTD." "12-03-2015" "NA"      "1.6412" "NA"      "1.6251" "-0.0172" "-0.0099" "0.0291" "0.0364" 20159 3 12
11 "20 MICRONS LTD." "13-03-2015" "NA"      "1.6363" "NA"      "1.6157" "-0.0172" "-0.0099" "0.0291" "0.0364" 20160 3 13
11 "20 MICRONS LTD." "16-03-2015" "NA"      "1.6141" "NA"      "1.6095" "-0.0172" "-0.0099" "0.0291" "0.0364" 20163 3 16
11 "20 MICRONS LTD." "17-03-2015" "NA"      "1.6403" "NA"      "1.6129" "-0.0172" "-0.0099" "0.0291" "0.0364" 20164 3 17
11 "20 MICRONS LTD." "18-03-2015" "NA"      "1.6317" "NA"      "1.6043" "-0.0172" "-0.0099" "0.0291" "0.0364" 20165 3 18
11 "20 MICRONS LTD." "19-03-2015" "NA"      "1.6084" "NA"      "1.6153" "-0.0172" "-0.0099" "0.0291" "0.0364" 20166 3 19
11 "20 MICRONS LTD." "20-03-2015" "NA"      "1.6043" "NA"      "1.6089" "-0.0172" "-0.0099" "0.0291" "0.0364" 20167 3 20
11 "20 MICRONS LTD." "23-03-2015" "NA"      "1.5888" "NA"      "1.5865" "-0.0172" "-0.0099" "0.0291" "0.0364" 20170 3 23
11 "20 MICRONS LTD." "24-03-2015" "NA"      "1.6049" "NA"      "1.5980" "-0.0172" "-0.0099" "0.0291" "0.0364" 20171 3 24
11 "20 MICRONS LTD." "25-03-2015" "NA"      "1.5852" "NA"      "1.5668" "-0.0172" "-0.0099" "0.0291" "0.0364" 20172 3 25
11 "20 MICRONS LTD." "26-03-2015" "NA"      "1.5563" "NA"      "1.5494" "-0.0172" "-0.0099" "0.0291" "0.0364" 20173 3 26
11 "20 MICRONS LTD." "27-03-2015" "NA"      "1.5509" "NA"      "1.5532" "-0.0172" "-0.0099" "0.0291" "0.0364" 20174 3 27
11 "20 MICRONS LTD." "30-03-2015" "NA"      "1.6144" "NA"      "1.5801" "-0.0172" "-0.0099" "0.0291" "0.0364" 20177 3 30
11 "20 MICRONS LTD." "31-03-2015" "NA"      "1.7432" "NA"      "1.7238" "-0.0277" "-0.0211" "0.0170" "0.0236" 20178 3 31
11 "20 MICRONS LTD." "01-03-2016" "34.6844" "1.1679" "34.6844" "1.1679" "0.0114"  "-0.0185" "0.0502" "0.0202" 20514 3  1
11 "20 MICRONS LTD." "02-03-2016" "35.2434" "1.1867" "35.1141" "1.1824" "0.0114"  "-0.0185" "0.0502" "0.0202" 20515 3  2
11 "20 MICRONS LTD." "03-03-2016" "35.0859" "1.1814" "35.4758" "1.1945" "0.0114"  "-0.0185" "0.0502" "0.0202" 20516 3  3
11 "20 MICRONS LTD." "04-03-2016" "35.3385" "1.1899" "35.4687" "1.1943" "0.0114"  "-0.0185" "0.0502" "0.0202" 20517 3  4
11 "20 MICRONS LTD." "08-03-2016" "35.3668" "1.1909" "35.3668" "1.1909" "0.0114"  "-0.0185" "0.0502" "0.0202" 20521 3  8
11 "20 MICRONS LTD." "09-03-2016" "35.1092" "1.1822" "34.8496" "1.1735" "0.0114"  "-0.0185" "0.0502" "0.0202" 20522 3  9
11 "20 MICRONS LTD." "10-03-2016" "34.8016" "1.1718" "34.9321" "1.1762" "0.0114"  "-0.0185" "0.0502" "0.0202" 20523 3 10
11 "20 MICRONS LTD." "11-03-2016" "34.9766" "1.1777" "34.5198" "1.1624" "0.0114"  "-0.0185" "0.0502" "0.0202" 20524 3 11
11 "20 MICRONS LTD." "14-03-2016" "35.7317" "1.2032" "36.0583" "1.2142" "0.0114"  "-0.0185" "0.0502" "0.0202" 20527 3 14
11 "20 MICRONS LTD." "15-03-2016" "35.8805" "1.2082" "35.9456" "1.2104" "0.0114"  "-0.0185" "0.0502" "0.0202" 20528 3 15
11 "20 MICRONS LTD." "16-03-2016" "37.0407" "1.2472" "37.2356" "1.2538" "0.0114"  "-0.0185" "0.0502" "0.0202" 20529 3 16
11 "20 MICRONS LTD." "17-03-2016" "37.3120" "1.2564" "37.7702" "1.2718" "0.0114"  "-0.0185" "0.0502" "0.0202" 20530 3 17
11 "20 MICRONS LTD." "18-03-2016" "37.5947" "1.2659" "37.3975" "1.2593" "0.0114"  "-0.0185" "0.0502" "0.0202" 20531 3 18
11 "20 MICRONS LTD." "21-03-2016" "37.1302" "1.2503" "37.6569" "1.2680" "0.0114"  "-0.0185" "0.0502" "0.0202" 20534 3 21
11 "20 MICRONS LTD." "22-03-2016" "36.9105" "1.2429" "37.4369" "1.2606" "0.0114"  "-0.0185" "0.0502" "0.0202" 20535 3 22
11 "20 MICRONS LTD." "23-03-2016" "36.7339" "1.2369" "37.2577" "1.2545" "0.0114"  "-0.0185" "0.0502" "0.0202" 20536 3 23
11 "20 MICRONS LTD." "28-03-2016" "36.9042" "1.2426" "36.1819" "1.2183" "0.0114"  "-0.0185" "0.0502" "0.0202" 20541 3 28
11 "20 MICRONS LTD." "29-03-2016" "35.9786" "1.2115" "35.9128" "1.2093" "0.0114"  "-0.0185" "0.0502" "0.0202" 20542 3 29
11 "20 MICRONS LTD." "30-03-2016" "36.3895" "1.2253" "36.2576" "1.2209" "0.0114"  "-0.0185" "0.0502" "0.0202" 20543 3 30
11 "20 MICRONS LTD." "31-03-2016" "10.0064" "1.1756" "10.1690" "1.1947" "0.0417"  "0.0487"  "0.0811" "0.0880" 20544 3 31
11 "20 MICRONS LTD." "01-03-2017" "9.1599"  "1.3994" "9.1720"  "1.4013" "0.0618"  "0.0486"  "0.1000" "0.0868" 20879 3  1
11 "20 MICRONS LTD." "02-03-2017" "8.8478"  "1.3517" "8.8963"  "1.3592" "0.0618"  "0.0486"  "0.1000" "0.0868" 20880 3  2
11 "20 MICRONS LTD." "03-03-2017" "8.7377"  "1.3349" "8.7135"  "1.3312" "0.0618"  "0.0486"  "0.1000" "0.0868" 20881 3  3
11 "20 MICRONS LTD." "06-03-2017" "8.8694"  "1.3550" "8.8330"  "1.3495" "0.0618"  "0.0486"  "0.1000" "0.0868" 20884 3  6
11 "20 MICRONS LTD." "07-03-2017" "8.8502"  "1.3521" "8.8624"  "1.3540" "0.0618"  "0.0486"  "0.1000" "0.0868" 20885 3  7
11 "20 MICRONS LTD." "08-03-2017" "8.7761"  "1.3408" "8.8489"  "1.3519" "0.0618"  "0.0486"  "0.1000" "0.0868" 20886 3  8
11 "20 MICRONS LTD." "09-03-2017" "8.6742"  "1.3252" "8.7348"  "1.3345" "0.0618"  "0.0486"  "0.1000" "0.0868" 20887 3  9
11 "20 MICRONS LTD." "10-03-2017" "8.6482"  "1.3213" "8.6725"  "1.3250" "0.0618"  "0.0486"  "0.1000" "0.0868" 20888 3 10
11 "20 MICRONS LTD." "14-03-2017" "8.7149"  "1.3314" "8.7393"  "1.3352" "0.0618"  "0.0486"  "0.1000" "0.0868" 20892 3 14
11 "20 MICRONS LTD." "15-03-2017" "8.6716"  "1.3248" "8.6716"  "1.3248" "0.0618"  "0.0486"  "0.1000" "0.0868" 20893 3 15
11 "20 MICRONS LTD." "16-03-2017" "8.8834"  "1.3572" "8.8834"  "1.3572" "0.0618"  "0.0486"  "0.1000" "0.0868" 20894 3 16
11 "20 MICRONS LTD." "17-03-2017" "8.6889"  "1.3275" "8.7382"  "1.3350" "0.0618"  "0.0486"  "0.1000" "0.0868" 20895 3 17
11 "20 MICRONS LTD." "20-03-2017" "8.7101"  "1.3307" "8.6359"  "1.3194" "0.0618"  "0.0486"  "0.1000" "0.0868" 20898 3 20
11 "20 MICRONS LTD." "21-03-2017" "8.5461"  "1.3057" "8.5832"  "1.3113" "0.0618"  "0.0486"  "0.1000" "0.0868" 20899 3 21
11 "20 MICRONS LTD." "22-03-2017" "8.4238"  "1.2870" "8.4361"  "1.2889" "0.0618"  "0.0486"  "0.1000" "0.0868" 20900 3 22
11 "20 MICRONS LTD." "23-03-2017" "8.4823"  "1.2959" "8.5070"  "1.2997" "0.0618"  "0.0486"  "0.1000" "0.0868" 20901 3 23
11 "20 MICRONS LTD." "24-03-2017" "8.7489"  "1.3366" "8.6871"  "1.3272" "0.0618"  "0.0486"  "0.1000" "0.0868" 20902 3 24
11 "20 MICRONS LTD." "27-03-2017" "8.7490"  "1.3366" "8.7365"  "1.3347" "0.0618"  "0.0486"  "0.1000" "0.0868" 20905 3 27
11 "20 MICRONS LTD." "28-03-2017" "8.7365"  "1.3347" "8.7241"  "1.3328" "0.0618"  "0.0486"  "0.1000" "0.0868" 20906 3 28
11 "20 MICRONS LTD." "29-03-2017" "8.6046"  "1.3146" "8.6668"  "1.3241" "0.0618"  "0.0486"  "0.1000" "0.0868" 20907 3 29
11 "20 MICRONS LTD." "30-03-2017" "8.7581"  "1.3380" "8.6708"  "1.3247" "0.0618"  "0.0486"  "0.1000" "0.0868" 20908 3 30
11 "20 MICRONS LTD." "31-03-2017" "9.6867"  "1.0735" "9.6591"  "1.0704" "0.0559"  "0.0672"  "0.0945" "0.1058" 20909 3 31
11 "20 MICRONS LTD." "01-03-2018" "12.6584" "1.3608" "12.6458" "1.3595" "0.0608"  "0.0688"  "0.1005" "0.1086" 21244 3  1
11 "20 MICRONS LTD." "05-03-2018" "12.4406" "1.3374" "12.3142" "1.3238" "0.0608"  "0.0688"  "0.1005" "0.1086" 21248 3  5
11 "20 MICRONS LTD." "06-03-2018" "11.9333" "1.2829" "11.9459" "1.2842" "0.0608"  "0.0688"  "0.1005" "0.1086" 21249 3  6
11 "20 MICRONS LTD." "07-03-2018" "11.4577" "1.2317" "11.4324" "1.2290" "0.0608"  "0.0688"  "0.1005" "0.1086" 21250 3  7
11 "20 MICRONS LTD." "08-03-2018" "11.3634" "1.2216" "11.3381" "1.2189" "0.0608"  "0.0688"  "0.1005" "0.1086" 21251 3  8
11 "20 MICRONS LTD." "09-03-2018" "10.8300" "1.1643" "10.7542" "1.1561" "0.0608"  "0.0688"  "0.1005" "0.1086" 21252 3  9
11 "20 MICRONS LTD." "12-03-2018" "11.7760" "1.2660" "11.8519" "1.2741" "0.0608"  "0.0688"  "0.1005" "0.1086" 21255 3 12
11 "20 MICRONS LTD." "13-03-2018" "13.0276" "1.4005" "13.0402" "1.4019" "0.0608"  "0.0688"  "0.1005" "0.1086" 21256 3 13
11 "20 MICRONS LTD." "14-03-2018" "12.9583" "1.3931" "12.9583" "1.3931" "0.0608"  "0.0688"  "0.1005" "0.1086" 21257 3 14
11 "20 MICRONS LTD." "15-03-2018" "13.2469" "1.4241" "13.1709" "1.4159" "0.0608"  "0.0688"  "0.1005" "0.1086" 21258 3 15
11 "20 MICRONS LTD." "16-03-2018" "12.7160" "1.3670" "12.8428" "1.3807" "0.0608"  "0.0688"  "0.1005" "0.1086" 21259 3 16
11 "20 MICRONS LTD." "19-03-2018" "12.4931" "1.3431" "12.3919" "1.3322" "0.0608"  "0.0688"  "0.1005" "0.1086" 21262 3 19
11 "20 MICRONS LTD." "20-03-2018" "12.5003" "1.3438" "12.2859" "1.3208" "0.0608"  "0.0688"  "0.1005" "0.1086" 21263 3 20
11 "20 MICRONS LTD." "21-03-2018" "12.2443" "1.3163" "12.2190" "1.3136" "0.0608"  "0.0688"  "0.1005" "0.1086" 21264 3 21
11 "20 MICRONS LTD." "22-03-2018" "11.7940" "1.2679" "11.8699" "1.2761" "0.0608"  "0.0688"  "0.1005" "0.1086" 21265 3 22
11 "20 MICRONS LTD." "23-03-2018" "11.8697" "1.2760" "11.8571" "1.2747" "0.0608"  "0.0688"  "0.1005" "0.1086" 21266 3 23
11 "20 MICRONS LTD." "26-03-2018" "12.3534" "1.3280" "12.3154" "1.3240" "0.0608"  "0.0688"  "0.1005" "0.1086" 21269 3 26
11 "20 MICRONS LTD." "27-03-2018" "12.2221" "1.3139" "12.2221" "1.3139" "0.0608"  "0.0688"  "0.1005" "0.1086" 21270 3 27
11 "20 MICRONS LTD." "28-03-2018" "12.3540" "1.3281" "12.4172" "1.3349" "0.0608"  "0.0688"  "0.1005" "0.1086" 21271 3 28
11 "20 MICRONS LTD." "01-03-2019" "6.7257"  "0.8922" "6.8434"  "0.9078" "0.0778"  "0.0641"  "0.1148" "0.1011" 21609 3  1
11 "20 MICRONS LTD." "05-03-2019" "7.2178"  "0.9575" "7.2359"  "0.9599" "0.0778"  "0.0641"  "0.1148" "0.1011" 21613 3  5
11 "20 MICRONS LTD." "06-03-2019" "7.4637"  "0.9901" "7.3818"  "0.9792" "0.0778"  "0.0641"  "0.1148" "0.1011" 21614 3  6
11 "20 MICRONS LTD." "07-03-2019" "7.2655"  "0.9638" "7.2380"  "0.9602" "0.0778"  "0.0641"  "0.1148" "0.1011" 21615 3  7
11 "20 MICRONS LTD." "08-03-2019" "7.0383"  "0.9337" "7.0383"  "0.9337" "0.0778"  "0.0641"  "0.1148" "0.1011" 21616 3  8
11 "20 MICRONS LTD." "11-03-2019" "7.1840"  "0.9530" "7.2299"  "0.9591" "0.0778"  "0.0641"  "0.1148" "0.1011" 21619 3 11
11 "20 MICRONS LTD." "12-03-2019" "7.3206"  "0.9711" "7.2653"  "0.9638" "0.0778"  "0.0641"  "0.1148" "0.1011" 21620 3 12
11 "20 MICRONS LTD." "13-03-2019" "7.1606"  "0.9499" "7.2068"  "0.9560" "0.0778"  "0.0641"  "0.1148" "0.1011" 21621 3 13
11 "20 MICRONS LTD." "14-03-2019" "7.1463"  "0.9480" "7.1831"  "0.9529" "0.0778"  "0.0641"  "0.1148" "0.1011" 21622 3 14
11 "20 MICRONS LTD." "15-03-2019" "7.1288"  "0.9457" "7.1938"  "0.9543" "0.0778"  "0.0641"  "0.1148" "0.1011" 21623 3 15
11 "20 MICRONS LTD." "18-03-2019" "7.2660"  "0.9639" "7.2567"  "0.9626" "0.0778"  "0.0641"  "0.1148" "0.1011" 21626 3 18
11 "20 MICRONS LTD." "19-03-2019" "7.3910"  "0.9805" "7.4378"  "0.9867" "0.0778"  "0.0641"  "0.1148" "0.1011" 21627 3 19
11 "20 MICRONS LTD." "20-03-2019" "7.2210"  "0.9579" "7.1930"  "0.9542" "0.0778"  "0.0641"  "0.1148" "0.1011" 21628 3 20
11 "20 MICRONS LTD." "22-03-2019" "7.1859"  "0.9532" "7.2140"  "0.9570" "0.0778"  "0.0641"  "0.1148" "0.1011" 21630 3 22
11 "20 MICRONS LTD." "25-03-2019" "6.9094"  "0.9166" "6.9280"  "0.9190" "0.0778"  "0.0641"  "0.1148" "0.1011" 21633 3 25
11 "20 MICRONS LTD." "26-03-2019" "7.2314"  "0.9593" "7.2314"  "0.9593" "0.0778"  "0.0641"  "0.1148" "0.1011" 21634 3 26
11 "20 MICRONS LTD." "27-03-2019" "6.8905"  "0.9141" "6.9091"  "0.9165" "0.0778"  "0.0641"  "0.1148" "0.1011" 21635 3 27
11 "20 MICRONS LTD." "28-03-2019" "7.1970"  "0.9547" "7.1691"  "0.9510" "0.0778"  "0.0641"  "0.1148" "0.1011" 21636 3 28
11 "20 MICRONS LTD." "29-03-2019" "7.0865"  "0.9401" "7.0957"  "0.9413" "0.0778"  "0.0641"  "0.1148" "0.1011" 21637 3 29
11 "20 MICRONS LTD." "02-03-2020" "4.3184"  "0.6382" "4.2840"  "0.6331" "0.1007"  "0.1357"  "0.1430" "0.1780" 21976 3  2
11 "20 MICRONS LTD." "03-03-2020" "4.2673"  "0.6306" "4.2401"  "0.6266" "0.1007"  "0.1357"  "0.1430" "0.1780" 21977 3  3
11 "20 MICRONS LTD." "04-03-2020" "4.0789"  "0.6028" "4.0857"  "0.6038" "0.1007"  "0.1357"  "0.1430" "0.1780" 21978 3  4
11 "20 MICRONS LTD." "05-03-2020" "4.1825"  "0.6181" "4.1757"  "0.6171" "0.1007"  "0.1357"  "0.1430" "0.1780" 21979 3  5
11 "20 MICRONS LTD." "06-03-2020" "4.0125"  "0.5930" "3.9991"  "0.5910" "0.1007"  "0.1357"  "0.1430" "0.1780" 21980 3  6
11 "20 MICRONS LTD." "09-03-2020" "3.7415"  "0.5529" "3.7214"  "0.5499" "0.1007"  "0.1357"  "0.1430" "0.1780" 21983 3  9
11 "20 MICRONS LTD." "11-03-2020" "3.5939"  "0.5311" "3.6141"  "0.5341" "0.1007"  "0.1357"  "0.1430" "0.1780" 21985 3 11
11 "20 MICRONS LTD." "12-03-2020" "3.1211"  "0.4612" "3.0341"  "0.4484" "0.1007"  "0.1357"  "0.1430" "0.1780" 21986 3 12
11 "20 MICRONS LTD." "13-03-2020" "3.2729"  "0.4837" "3.2394"  "0.4787" "0.1007"  "0.1357"  "0.1430" "0.1780" 21987 3 13
11 "20 MICRONS LTD." "16-03-2020" "3.1101"  "0.4596" "3.0700"  "0.4537" "0.1007"  "0.1357"  "0.1430" "0.1780" 21990 3 16
11 "20 MICRONS LTD." "17-03-2020" "3.2880"  "0.4859" "3.2947"  "0.4869" "0.1007"  "0.1357"  "0.1430" "0.1780" 21991 3 17
11 "20 MICRONS LTD." "18-03-2020" "3.0607"  "0.4523" "3.0875"  "0.4563" "0.1007"  "0.1357"  "0.1430" "0.1780" 21992 3 18
11 "20 MICRONS LTD." "19-03-2020" "2.9650"  "0.4436" "2.9452"  "0.4407" "0.1007"  "0.1357"  "0.1430" "0.1780" 21993 3 19
end
format %td a_date

      Comment

      Previous Next
      Working...
      X