Spreadsheet: 1c90214d-639b-4da2-8c90-683d9db9537d
Sheet: Sheet1

NCDEX Margin Based on Yesterday's  ( 31/03/2014Closing Price | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Commodity | [NAME] | LTP | Price Quotation | Lot Size | Margin % | Variant | Lot Value(Rs) | Approx Margin (Rs)
BARLEYJPR | 2014-04-18 00:00:00 | 1327 | Rs/Quintal | 10 | 0.0533 | 100 | 132700 | 7072.91
BARLEYJPR | 2014-05-20 00:00:00 | 1347.5 | Rs/Quintal | 10 | 0.0544 | 100 | 134750 | 7330.4
BARLEYJPR | 2014-06-20 00:00:00 | 1373.5 | Rs/Quintal | 10 | 0.0508 | 100 | 137350 | 6977.38
BARLEYJPR | 2014-07-18 00:00:00 | 1399.5 | Rs/Quintal | 10 | 0.05599999999999999 | 100 | 139950 | 7837.2
BRENTCRUDE | 2014-04-15 00:00:00 | 6625 | Rs/Barrel | 100 | 0.05 | 100 | 662500 | 33125
BRENTCRUDE | 2014-05-15 00:00:00 | 6700 | Rs/Barrel | 100 | 0.05 | 100 | 670000 | 33500
CASTOR1MT | 2014-05-12 00:00:00 | 4224 | Rs/Quintal | 1 | 0.05 | 10 | 42240 | 2112
CASTOR1MT | 2014-06-11 00:00:00 | 4282 | Rs/Quintal | 1 | 0.05 | 10 | 42820 | 2141
CASTOR1MT | 2014-07-11 00:00:00 | 4372 | Rs/Quintal | 1 | 0.05 | 10 | 43720 | 2186
CASTORSEED | 2014-04-18 00:00:00 | 4138 | Rs/Quintal | 10 | 0.05 | 100 | 413800 | 20690
CASTORSEED | 2014-05-20 00:00:00 | 4207 | Rs/Quintal | 10 | 0.05 | 100 | 420700 | 21035
CASTORSEED | 2014-06-20 00:00:00 | 4282 | Rs/Quintal | 10 | 0.05 | 100 | 428200 | 21410
CASTORSEED | 2014-07-18 00:00:00 | 4371 | Rs/Quintal | 10 | 0.05 | 100 | 437100 | 21855
CHANA1MT | 2014-04-11 00:00:00 | 3272 | Rs/Quintal | 1 | 0.08 | 10 | 32720 | 2617.6
CHANA1MT | 2014-05-12 00:00:00 | 3340 | Rs/Quintal | 1 | 0.05 | 10 | 33400 | 1670
CHANA1MT | 2014-06-11 00:00:00 | 3396 | Rs/Quintal | 1 | 0.05 | 10 | 33960 | 1698
CHANA1MT | 2014-07-11 00:00:00 | 3466 | Rs/Quintal | 1 | 0.05 | 10 | 34660 | 1733
CHARJDDEL | 2014-04-18 00:00:00 | 3272 | Rs/Quintal | 10 | 0.05 | 100 | 327200 | 16360
CHARJDDEL | 2014-05-20 00:00:00 | 3331 | Rs/Quintal | 10 | 0.05 | 100 | 333100 | 16655
CHARJDDEL | 2014-06-20 00:00:00 | 3396 | Rs/Quintal | 10 | 0.05 | 100 | 339600 | 16980
CHARJDDEL | 2014-07-18 00:00:00 | 3465 | Rs/Quintal | 10 | 0.05 | 100 | 346500 | 17325
COCUDAKL | 2014-04-18 00:00:00 | 1465 | Rs/Quintal | 10 | 0.0588 | 100 | 146500 | 8614.2
COCUDAKL | 2014-05-20 00:00:00 | 1499 | Rs/Quintal | 10 | 0.0578 | 100 | 149900 | 8664.22
COCUDAKL | 2014-06-20 00:00:00 | 1553 | Rs/Quintal | 10 | 0.0561 | 100 | 155300 | 8712.33
COCUDAKL | 2014-07-18 00:00:00 | 1604 | Rs/Quintal | 10 | 0.0535 | 100 | 160400 | 8581.4
COPPER | 2014-04-30 00:00:00 | 404.15 | RS/KG | 1 | 0.05 | 1000 | 404150 | 20207.5
COPPER | 2014-06-30 00:00:00 | 407.9 | RS/KG | 1 | 0.05 | 1000 | 407900 | 20395
COPPER | 2014-08-29 00:00:00 | 412.2 | RS/KG | 1 | 0.05 | 1000 | 412200 | 20610
COTTONSEED | 2014-04-17 00:00:00 | 1888 | Rs/Quintal | 10 | 0.05 | 100 | 188800 | 9440
COTTONSEED | 2014-05-20 00:00:00 | 1954 | Rs/Quintal | 10 | 0.0508 | 100 | 195400 | 9926.32
COTTONSEED | 2014-06-20 00:00:00 | 1921 | Rs/Quintal | 10 | 0.05 | 100 | 192100 | 9605
CPO | 2014-04-30 00:00:00 | 570.1 | Rs/10Kgs | 10 | 0.05 | 1000 | 570100 | 28505
CPO | 2014-05-30 00:00:00 | 571 | Rs/10Kgs | 10 | 0.0587 | 1000 | 571000 | 33517.7
CPO | 2014-06-30 00:00:00 | 570.6 | Rs/10Kgs | 10 | 0.0564 | 1000 | 570600 | 32181.84
CPO | 2014-07-31 00:00:00 | 575.4 | Rs/10Kgs | 10 | 0.0552 | 1000 | 575400 | 31762.08
CRUDEOIL | 2014-04-21 00:00:00 | 6123 | Rs./Barrel | 100 | 0.05 | 100 | 612300 | 30615
CRUDEOIL | 2014-05-19 00:00:00 | 6107 | Rs./Barrel | 100 | 0.05 | 100 | 610700 | 30535
DHANIYA | 2014-04-18 00:00:00 | 9530 | Rs/Quintal | 10 | 0.0655 | 100 | 953000 | 62421.5
DHANIYA | 2014-05-20 00:00:00 | 9701 | Rs/Quintal | 10 | 0.0654 | 100 | 970100 | 63444.54
DHANIYA | 2014-06-20 00:00:00 | 9894 | Rs/Quintal | 10 | 0.0659 | 100 | 989400 | 65201.46
DHANIYA | 2014-07-18 00:00:00 | 10052 | Rs/Quintal | 10 | 0.0636 | 100 | 1005200 | 63930.72
GOLD | 2014-04-03 00:00:00 | 28530 | RS/10GMS | 1 | 0.14 | 100 | 2853000 | 399420
GOLD | 2014-06-03 00:00:00 | 28135 | RS/10GMS | 1 | 0.05 | 100 | 2813500 | 140675
GOLD | 2014-08-04 00:00:00 | 27716 | RS/10GMS | 1 | 0.05 | 100 | 2771600 | 138580
GOLDH100 | 2014-05-28 00:00:00 | 24961 | Rs/10Gms | 10 | 0.05 | 10 | 249610 | 12480.5
GOLDH100 | 2014-07-29 00:00:00 | 25166 | Rs/10Gms | 10 | 0.0584 | 10 | 251660 | 14696.944
GOLDH100 | 2014-09-26 00:00:00 | 25411 | Rs/10Gms | 10 | 0.05 | 10 | 254110 | 12705.5
[NAME] | 2014-05-28 00:00:00 | 24961 | Rs/10Gms | 1 | 0.05 | 100 | 2496100 | 124805
[NAME] | 2014-07-29 00:00:00 | 25166 | Rs/10Gms | 1 | 0.0583 | 100 | 2516600 | 146717.78
[NAME] | 2014-09-26 00:00:00 | 25411 | Rs/10Gms | 1 | 0.05 | 100 | 2541100 | 127055
GUARGUM | 2014-04-18 00:00:00 | 12610 | Rs/QUINTAL | 1 | 0.1 | 10 | 126100 | 12610
GUARGUM | 2014-05-20 00:00:00 | 12780 | Rs/QUINTAL | 1 | 0.1 | 10 | 127800 | 12780
GUARGUM | 2014-06-20 00:00:00 | 12940 | Rs/Quintal | 1 | 0.1 | 10 | 129400 | 12940
GUARGUM | 2014-07-18 00:00:00 | 13070 | Rs/Quintal | 1 | 0.1 | 10 | 130700 | 13070
GUARSEED | 2014-04-18 00:00:00 | 4730 | RS/QUINTAL | 1 | 0.1 | 10 | 47300 | 4730
GUARSEED | 2014-05-20 00:00:00 | 4790 | RS/QUINTAL | 1 | 0.1 | 10 | 47900 | 4790
GUARSEED | 2014-06-20 00:00:00 | 4855 | Rs/Quintal | 1 | 0.1 | 10 | 48550 | 4855
GUARSEED | 2014-07-18 00:00:00 | 4920 | Rs/Quintal | 1 | 0.1 | 10 | 49200 | 4920
GUARSEED10 | 2014-04-18 00:00:00 | 4730 | RS/QUINTAL | 10 | 0.1 | 100 | 473000 | 47300
GUARSEED10 | 2014-05-20 00:00:00 | 4790 | RS/QUINTAL | 10 | 0.1 | 100 | 479000 | 47900
GUARSEED10 | 2014-06-20 00:00:00 | 4855 | Rs/Quintal | 10 | 0.1 | 100 | 485500 | 48550
GUARSEED10 | 2014-07-18 00:00:00 | 4920 | Rs/Quintal | 10 | 0.1 | 100 | 492000 | 49200
GURCHMUZR | 2014-07-18 00:00:00 | 1230 | Rs/40Kgs | 10 | 0.0561 | 250 | 307500 | 17250.75
GURCHMUZR | 2014-09-19 00:00:00 | 1278.5 | Rs/40Kgs | 10 | 0.0535 | 250 | 319625 | 17099.9375
GURCHMUZR | 2014-11-20 00:00:00 | 1171 | Rs/40Kgs | 10 | 0.0519 | 250 | 292750 | 15193.725
GURCHMUZR | 2014-12-19 00:00:00 | 1150 | Rs/40Kgs | 10 | 0.0575 | 250 | 287500 | 16531.25
JEERAUNJHA | 2014-04-18 00:00:00 | 10025 | Rs/Quintal | 3 | 0.0735 | 30 | 300750 | 22105.125
JEERAUNJHA | 2014-05-20 00:00:00 | 10120 | Rs/Quintal | 3 | 0.0725 | 30 | 303600 | 22011
JEERAUNJHA | 2014-06-20 00:00:00 | 10245 | Rs/Quintal | 3 | 0.0722 | 30 | 307350 | 22190.67
JEERAUNJHA | 2014-07-18 00:00:00 | 10420 | Rs/Quintal | 3 | 0.0677 | 30 | 312600 | 21163.02
KAPASSRNR | 2014-04-30 00:00:00 | 832 | Rs/20Kgs | 1 | 0.0562 | 200 | 166400 | 9351.68
MAIZERABI | 2014-04-18 00:00:00 | 1160 | Rs/Quintal | 10 | 0.0536 | 100 | 116000 | 6217.6
MAIZERABI | 2014-05-20 00:00:00 | 1175 | Rs/Quintal | 10 | 0.05 | 100 | 117500 | 5875
MAIZERABI | 2014-06-20 00:00:00 | 1202 | Rs/Quintal | 10 | 0.0516 | 100 | 120200 | 6202.32
MAIZERABI | 2014-07-18 00:00:00 | 1239 | Rs/Quintal | 10 | 0.05 | 100 | 123900 | 6195
PVC | 2014-04-17 00:00:00 | 73000 | Rs/MT | 5 | 0.05 | 5 | 365000 | 18250
PVC | 2014-05-20 00:00:00 | 73650 | Rs/MT | 5 | 0.05 | 5 | 368250 | 18412.5
RBDPALMOLN | 2014-04-30 00:00:00 | 616 | Rs/10Kgs | 1 | 0.05 | 100 | 61600 | 3080
RBDPALMOLN | 2014-05-30 00:00:00 | 621 | Rs/10Kgs | 1 | 0.05 | 100 | 62100 | 3105
RBDPALMOLN | 2014-06-30 00:00:00 | 626 | Rs/10Kgs | 1 | 0.05 | 100 | 62600 | 3130
RBRRS4KOC | 2014-04-18 00:00:00 | 14950 | Rs/Quintal | 1 | 0.05 | 10 | 149500 | 7475
RBRRS4KOC | 2014-05-20 00:00:00 | 15080 | Rs/Quintal | 1 | 0.05 | 10 | 150800 | 7540
RBRRS4KOC | 2014-06-20 00:00:00 | 15210 | Rs/Quintal | 1 | 0.05 | 10 | 152100 | 7605
RBRRS4KOC | 2014-07-18 00:00:00 | 15330 | Rs/Quintal | 1 | 0.05 | 10 | 153300 | 7665
RMSEED | 2014-04-18 00:00:00 | 3459 | Rs/Quintal | 10 | 0.05 | 100 | 345900 | 17295
RMSEED | 2014-05-20 00:00:00 | 3504 | Rs/Quintal | 10 | 0.05 | 100 | 350400 | 17520
RMSEED | 2014-06-20 00:00:00 | 3552 | Rs/Quintal | 10 | 0.05 | 100 | 355200 | 17760
RMSEED | 2014-07-18 00:00:00 | 3612 | Rs/Quintal | 10 | 0.05 | 100 | 361200 | 18060
SBMEALIDR | 2014-04-17 00:00:00 | 37030 | Rs/MT | 10 | 0.05 | 10 | 370300 | 18515
SBMEALIDR | 2014-05-20 00:00:00 | 37360 | Rs/MT | 10 | 0.05 | 10 | 373600 | 18680
SBMEALIDR | 2014-06-20 00:00:00 | 37670 | Rs/MT | 10 | 0.05 | 10 | 376700 | 18835
SHANKRKPAS | 2014-04-30 00:00:00 | 1051 | Rs/20Kgs | 1 | 0.05 | 200 | 210200 | 10510
SILVER | 2014-05-05 00:00:00 | 42780 | RS/KG | 30 | 0.0703 | 30 | 1283400 | 90223.02
SILVER | 2014-07-03 00:00:00 | 43460 | RS/KG | 30 | 0.0702 | 30 | 1303800 | 91526.76
SILVER | 2014-09-03 00:00:00 | 44530 | RS/KG | 30 | 0.07 | 30 | 1335900 | 93513
SILVER | 2014-12-03 00:00:00 | 45941 | RS/KG | 30 | 0.08109999999999999 | 30 | 1378230 | 111774.453
SILVRHEDGE | 2014-04-28 00:00:00 | 3865 | Rs/100Gms | 15 | 0.05 | 150 | 579750 | 28987.5
SILVRHEDGE | 2014-06-26 00:00:00 | 3873 | Rs/100Gms | 15 | 0.05 | 150 | 580950 | 29047.5
SILVRHEDGE | 2014-08-27 00:00:00 | 3921 | Rs/100Gms | 15 | 0.0501 | 150 | 588150 | 29466.315
STEELLONG | 2014-04-18 00:00:00 | 34560 | Rs/MT | 10 | 0.05 | 10 | 345600 | 17280
STEELLONG | 2014-05-20 00:00:00 | 34870 | Rs/MT | 10 | 0.05 | 10 | 348700 | 17435
STEELLONG | 2014-06-20 00:00:00 | 35170 | Rs/MT | 10 | 0.05 | 10 | 351700 | 17585
STEELLONG | 2014-07-18 00:00:00 | 35440 | Rs/MT | 10 | 0.05 | 10 | 354400 | 17720
SUGARM200 | 2014-04-18 00:00:00 | 3145 | Rs/Quintal | 10 | 0.05 | 100 | 314500 | 15725
SUGARM200 | 2014-05-20 00:00:00 | 3168 | Rs/Quintal | 10 | 0.05 | 100 | 316800 | 15840
SUGARM200 | 2014-06-20 00:00:00 | 3214 | Rs/Quintal | 10 | 0.05 | 100 | 321400 | 16070
SUGARM200 | 2014-07-18 00:00:00 | 3248 | Rs/Quintal | 10 | 0.05 | 100 | 324800 | 16240
SUGARM200 | 2014-08-20 00:00:00 | 3282 | Rs/Quintal | 10 | 0.05 | 100 | 328200 | 16410
SUGARM200 | 2014-09-19 00:00:00 | 3293 | Rs/Quintal | 10 | 0.05 | 100 | 329300 | 16465
SYBEANIDR | 2014-04-18 00:00:00 | 4311.5 | Rs/Quintal | 10 | 0.0537 | 100 | 431150 | 23152.755
SYBEANIDR | 2014-05-20 00:00:00 | 4258.5 | Rs/Quintal | 10 | 0.0534 | 100 | 425850 | 22740.39
SYBEANIDR | 2014-06-20 00:00:00 | 4235.5 | Rs/Quintal | 10 | 0.0551 | 100 | 423550 | 23337.605
SYBEANIDR | 2014-07-18 00:00:00 | 4256 | Rs/Quintal | 10 | 0.0541 | 100 | 425600 | 23024.96
SYOREFIDR | 2014-04-18 00:00:00 | 705.45 | Rs/10Kgs | 10 | 0.05 | 1000 | 705450 | 35272.5
SYOREFIDR | 2014-05-20 00:00:00 | 688.6 | Rs/10Kgs | 10 | 0.05 | 1000 | 688600 | 34430
SYOREFIDR | 2014-06-20 00:00:00 | 677.4 | Rs/10Kgs | 10 | 0.05 | 1000 | 677400 | 33870
SYOREFIDR | 2014-07-18 00:00:00 | 669.9 | Rs/10Kgs | 10 | 0.05 | 1000 | 669900 | 33495
SYOREFIDR | 2014-08-20 00:00:00 | 669.5 | Rs/10Kgs | 10 | 0.05 | 1000 | 669500 | 33475
TMCFGRNZM | 2014-04-18 00:00:00 | 6302 | Rs/Quintal | 5 | 0.09029999999999999 | 50 | 315100 | 28453.53
TMCFGRNZM | 2014-05-20 00:00:00 | 6366 | Rs/Quintal | 5 | 0.0874 | 50 | 318300 | 27819.42
TMCFGRNZM | 2014-06-20 00:00:00 | 6498 | Rs/Quintal | 5 | 0.08070000000000001 | 50 | 324900 | 26219.43
TMCFGRNZM | 2014-07-18 00:00:00 | 6548 | Rs/Quintal | 5 | 0.07139999999999999 | 50 | 327400 | 23376.36
WHEAT | 2014-04-18 00:00:00 | 1572 | Rs/Quintal | 10 | 0.05 | 100 | 157200 | 7860
WHEAT | 2014-05-20 00:00:00 | 1560 | Rs/Quintal | 10 | 0.05 | 100 | 156000 | 7800
WHEAT | 2014-06-20 00:00:00 | 1583 | Rs/Quintal | 10 | 0.05 | 100 | 158300 | 7915
WHEAT | 2014-07-18 00:00:00 | 1603 | Rs/Quintal | 10 | 0.05 | 100 | 160300 | 8015