How to use quantmod for large dataframe of stock exchande other country

TICKER.pdf (239.0 KB)
,,,,,,
ACTU,02/01/12,0.48,0.48,0.48,0.48,60
AER,02/01/12,4.95,5.17,4.76,5.17,208
ALBZ,02/01/12,0.1849,0.1877,0.18,0.18,1082713
ALR,02/01/12,3.29,3.33,3.29,3.31,900
ALT,02/01/12,0.0844,0.0904,0.0844,0.0904,79000
ALU,02/01/12,1.199,1.2,1.181,1.181,3592
AMO,02/01/12,0.0137,0.0139,0.0137,0.0139,236500
AMPL,02/01/12,3.16,3.16,3.16,3.16,1
APC,02/01/12,0.6755,0.746,0.6755,0.746,1000
ARAX,02/01/12,9.18,9.2,8.9,9,312949
ARCO,02/01/12,0.08,0.08,0.08,0.08,15028
ARCV,02/01/12,0.3647,0.3682,0.355,0.3682,60626
ARM,02/01/12,0.12,0.12,0.12,0.12,15301
ARMT,02/01/12,1.7,1.7,1.7,1.7,1
ARS,02/01/12,0.7846,0.7846,0.7846,0.7846,800
ART,02/01/12,1.36,1.424,1.351,1.424,500
ARTE,02/01/12,2.198,2.22,2.198,2.22,1300
ASCE,02/01/12,17.89,17.89,14.02,17.8,130
ATB,02/01/12,0.3434,0.3465,0.3402,0.3427,43040
ATRA,02/01/12,7.5,7.5,7.5,7.5,10
AUR,02/01/12,22.5,23,22.5,23,1322
AVIO,02/01/12,5,5.3,5,5.3,329
AVZU,02/01/12,0.0333,0.0337,0.033,0.033,25500
AZO,02/01/12,1.427,1.465,1.425,1.46,223212
AZUR,02/01/12,3.52,3.52,3.52,3.52,7892
B1410A,02/01/12,98.8721,98.8721,98.8721,98.8721,1
B1604A,02/01/12,96.716,96.751,96.716,96.751,20
BAYN,02/01/12,237.2,237.2,237.2,237.2,1
BAZV,02/01/12,0.07,0.07,0.07,0.07,2819
BCC,02/01/12,0.16,0.1637,0.1571,0.1585,141100
BIO,02/01/12,0.1998,0.1998,0.1951,0.1985,321551
BRD,02/01/12,11.21,11.35,11.2,11.34,1333750
BRK,02/01/12,0.1137,0.115,0.1126,0.1135,1041724
BRM,02/01/12,0.942,0.949,0.942,0.949,1000
BRNA,02/01/12,4,4,4,4,500
BUCS,02/01/12,0.8,0.8,0.8,0.8,38
BUCU,02/01/12,2.5,2.5,2.5,2.5,5450
BUCV,02/01/12,0.283,0.2835,0.283,0.2835,5000
BVB,02/01/12,33.4,34,33.16,33.5,35146
CAOR,02/01/12,2.12,2.36,2.1,2.36,1104
CARS,02/01/12,0.31,0.31,0.31,0.31,2000
CBC,02/01/12,4.6726,4.6726,4.6726,4.6726,100
CCOL,02/01/12,1.01,1.01,1,1,376
CEON,02/01/12,0.0085,0.0087,0.0085,0.0087,2000
CERE,02/01/12,0.722,0.76,0.72,0.76,4500
CFED,02/01/12,0.7,0.7,0.7,0.7,2525
CLEL,02/01/12,0.0459,0.0462,0.0457,0.0461,64202
CMF,02/01/12,2.07,2.07,2.07,2.07,1000
CMGJ,02/01/12,0.13,0.14,0.13,0.14,550
CMP,02/01/12,0.44,0.4695,0.44,0.4695,36500
CNTE,02/01/12,37,38.9,37,38.7,1424
COAU,02/01/12,6.5,6.5,6.5,6.5,3750
COBS,02/01/12,2,2,1.985,2,620
COBU,02/01/12,0.25,0.25,0.25,0.25,150
COFI,02/01/12,0.021,0.023,0.0206,0.0217,4213000
COMI,02/01/12,0.22,0.22,0.21,0.214,316000
COSC,02/01/12,0.44,0.44,0.44,0.44,2
COTR,02/01/12,24.5,24.5,24.5,24.5,10
DAFR,02/01/12,0.0745,0.0745,0.072,0.073,482000
DAI,02/01/12,185.2,187.8,185,187.8,141
DTE,02/01/12,37.61,37.61,37.59,37.59,2
EBDAXTL10,02/01/12,69,73.8,69,73.8,392
EBDAXTL11,02/01/12,58,63.6,57.4,63,5767
EBDAXTL7,02/01/12,95,95,95,95,5
EBDAXTL9,02/01/12,82.4,82.4,82.4,82.4,125
EBDAXTS7,02/01/12,22.6,22.6,16.8,17,177599
EBEBSTL1,02/01/12,3.25,3.45,3.25,3.4,258
EBFPTL3,02/01/12,19.92,19.92,18.77,19.1,11065
EBFPTS2,02/01/12,8.03,8.03,8.03,8.03,5
EBGLD,02/01/12,578,578.5,578,578.5,21
EBGLDTL6,02/01/12,104,105,103,103,1021
EBGLDTL7,02/01/12,135.5,135.5,135.5,135.5,15
EBGLDTS8,02/01/12,95,95,93,93.5,31
EBS,02/01/12,72.65,75.2,72.65,75.15,4916
EBSLVTL3,02/01/12,30.25,30.25,30.25,30.25,3
EBSLVTS5,02/01/12,26.75,26.75,25,25,112
EBWTITL4,02/01/12,102.25,102.25,102.25,102.25,5
EBWTITL5,02/01/12,116.75,117.25,116.75,117.25,439
EBWTITL6,02/01/12,66,66.5,65.25,65.75,28
EBWTITL7,02/01/12,31.25,32.5,29,29.5,19413
EBWTITS9,02/01/12,62.5,63.5,61.75,63.5,247
EEAI,02/01/12,0.8947,0.8947,0.8947,0.8947,1
EFO,02/01/12,0.0788,0.0789,0.0775,0.0775,12500
ELGS,02/01/12,0.3327,0.34,0.321,0.3335,93000
ELJ,02/01/12,0.1429,0.16,0.1429,0.16,1500
ELMA,02/01/12,0.2956,0.296,0.2904,0.2904,87712
ELNG,02/01/12,2.4,2.4,2.4,2.4,200
ELTR,02/01/12,0.6,0.6,0.6,0.6,1000
ELZY,02/01/12,2.61,2.61,2.61,2.61,300
EOAN,02/01/12,72.8,73.8,72.8,73.65,11
EPT,02/01/12,0.052,0.052,0.051,0.051,1000
EVER,02/01/12,1.41,1.429,1.375,1.4,4876616
FACY,02/01/12,3.4,3.4,3.4,3.4,660
FIMD,02/01/12,8.9,8.9,8.9,8.9,10000
FMAR,02/01/12,0.04,0.04,0.04,0.04,1000
FOSB,02/01/12,0.21,0.21,0.21,0.21,6000
FOSP,02/01/12,50,50,50,50,15
FP,02/01/12,0.485,0.4903,0.4832,0.486,51253211
IARV,02/01/12,1.58,1.59,1.58,1.59,300
IFG,02/01/12,124.9,130,124.9,125,122
IFR,02/01/12,158.95,170,158.9,170,111
ILFO,02/01/12,0.4,0.4,0.4,0.4,1
IMP,02/01/12,0.0303,0.0321,0.0303,0.0321,13000
IPRO,02/01/12,5.8,5.8,5.8,5.8,6000
IPRU,02/01/12,0.6098,0.6109,0.6098,0.6109,2000
LMRU,02/01/12,0.59,0.6,0.59,0.6,503
MARD,02/01/12,0.85,0.85,0.85,0.85,50
MEAN,02/01/12,15,15,15,15,50
MECF,02/01/12,0.1175,0.124,0.1175,0.124,24000
METY,02/01/12,0.08,0.08,0.08,0.08,44
MODY,02/01/12,0.29,0.3,0.29,0.29,27000
MOIB,02/01/12,0.21,0.24,0.21,0.22,24489
MPN,02/01/12,0.27,0.27,0.27,0.27,500
NACH,02/01/12,0.123,0.123,0.1,0.1,2471691
NAPO,02/01/12,1.69,1.69,1.6,1.66,6122
OIL,02/01/12,0.1371,0.1378,0.1344,0.1378,5500
OLT,02/01/12,1.249,1.265,1.192,1.2,116480
PBK,02/01/12,0.265,0.2712,0.2603,0.2626,141100
PEI,02/01/12,19.99,19.99,19.99,19.99,1
PREB,02/01/12,0.204,0.204,0.2,0.2,3000
PRMT,02/01/12,30,30,28,30,57
PRSN,02/01/12,0.2046,0.207,0.202,0.206,81800
PTR,02/01/12,0.314,0.319,0.314,0.319,3000
PTRO,02/01/12,1.8,1.8,1.72,1.72,500
RCFPTL4,02/01/12,21.4,21.4,21.2,21.2,5070
RCFPTL5,02/01/12,16.28,16.61,16.11,16.21,1461
RCFPTS2,02/01/12,14,14,14,14,50
RCSNPTL1,02/01/12,1.59,1.64,1.58,1.62,2097
RCTLVTL1,02/01/12,3.61,3.61,3.57,3.57,246
REFE,02/01/12,17.6,18.9,17.5,18.9,20200
RMAH,02/01/12,0.2298,0.23,0.204,0.204,3000
RPH,02/01/12,0.3514,0.3514,0.3423,0.348,41200
RRC,02/01/12,0.072,0.074,0.0689,0.071,95000
RTRA,02/01/12,0.2644,0.2644,0.2644,0.2644,500
SAHE,02/01/12,1.02,1.02,1,1,3767
SCD,02/01/12,1,1,0.95,0.987,71000
SCDE,02/01/12,8.45,8.9,8.3,8.9,196
SCTBR01,02/01/12,2.04,2.04,1.7,2.01,1827800
SCTO,02/01/12,50,50,50,50,40
SIF1,02/01/12,1.04,1.04,1,1.033,1696426
SIF2,02/01/12,0.705,0.7145,0.6875,0.7,4876616
SIF3,02/01/12,0.32,0.3225,0.3137,0.3217,7735648
SIF4,02/01/12,0.666,0.678,0.66,0.673,2326558
SIF5,02/01/12,1.25,1.268,1.24,1.268,3469372
SLBB,02/01/12,40,41,40,41,70
SNO,02/01/12,2.71,2.71,2.71,2.71,300
SNP,02/01/12,0.315,0.3247,0.3146,0.3196,4668942
SPCU,02/01/12,0.2379,0.238,0.215,0.215,66500
SRT,02/01/12,0.016,0.0164,0.016,0.0162,54500
STK,02/01/12,36.2,37.5,36.2,37.5,529
STRO,02/01/12,0.12,0.13,0.12,0.13,12915
TBM,02/01/12,0.052,0.0525,0.05,0.0519,19375
TEL,02/01/12,18.4686,18.8679,18.4386,18.8679,2116
TGN,02/01/12,240.8,247,237,246.6,4326
TLV,02/01/12,2.8195,2.8195,2.7534,2.7589,641270
TPRO,02/01/12,0.1312,0.1312,0.1312,0.1312,8
TRANSI,02/01/12,0.64,0.645,0.6275,0.6435,7735648
TUFE,02/01/12,0.165,0.165,0.165,0.165,1500
TUSI,02/01/12,0.05,0.07,0.05,0.07,1800
UNIO,02/01/12,3.4,3.4,3.4,3.4,8
UNISEM,02/01/12,0.03,0.03,0.03,0.03,79
UNVR,02/01/12,12.5,12.5,12.5,12.5,420
VAC,02/01/12,1.11,1.12,1.06,1.12,479
VESY,02/01/12,0.0599,0.0627,0.0599,0.0627,24400
VNC,02/01/12,0.0675,0.0678,0.0675,0.0678,3500
WRO,02/01/12,190.5,191.2,190.5,191.2,2
AER,02/02/12,5.17,5.17,5.17,5.17,1
ALBZ,02/02/12,0.181,0.184,0.18,0.184,195566
ALR,02/02/12,3.3,3.3,3.25,3.3,6000
ALT,02/02/12,0.0904,0.0936,0.0847,0.0863,151000
ALU,02/02/12,1.19,1.19,1.105,1.105,2050
AMO,02/02/12,0.0139,0.015,0.0137,0.0142,2934000
AMPL,02/02/12,3.09,3.09,3.09,3.09,1
AMY,02/02/12,0.27,0.32,0.27,0.29,15234
APC,02/02/12,0.744,0.7465,0.744,0.7465,6500
APRB,02/02/12,0.41,0.41,0.4,0.4,3000
ARAX,02/02/12,9.01,9.25,9.01,9.2,287239
ARCO,02/02/12,0.09,0.09,0.09,0.09,11
ARCV,02/02/12,0.3647,0.3779,0.362,0.3735,172500
ARM,02/02/12,0.127,0.127,0.127,0.127,3000
ARMT,02/02/12,1.69,1.69,1.69,1.69,1
ARS,02/02/12,0.7923,0.7923,0.7923,0.7923,8500
ARTE,02/02/12,2.2,2.2,2.101,2.101,1100
ASCE,02/02/12,15,15,15,15,10
ATB,02/02/12,0.3428,0.3638,0.3428,0.3554,220185
ATRD,02/02/12,8.65,8.65,8.65,8.65,50
AVIO,02/02/12,4.8,6,4.8,5,460
AVSL,02/02/12,4.5,4.5,4.5,4.5,1
AVZU,02/02/12,0.032,0.032,0.032,0.032,500
AZO,02/02/12,1.459,1.485,1.455,1.47,897118
AZUR,02/02/12,3.6,3.6,3.6,3.6,555
B1210A,02/02/12,103.6184,103.6184,103.6184,103.6184,5
BATV,02/02/12,36.95,36.95,36.95,36.95,5
BAYN,02/02/12,237.7,237.7,237.7,237.7,10
BAZV,02/02/12,0.08,0.08,0.07,0.07,112
BCC,02/02/12,0.1574,0.1608,0.1571,0.16,175673
BCM,02/02/12,0.0755,0.0755,0.0755,0.0755,500
BIO,02/02/12,0.1961,0.199,0.194,0.199,168306
BRCR,02/02/12,0.32,0.34,0.0504,0.34,52500
BRD,02/02/12,11.33,11.6,11.33,11.51,586730
BRK,02/02/12,0.1137,0.1159,0.113,0.1147,1711550
BRM,02/02/12,0.98,0.99,0.98,0.98,19500
BRNA,02/02/12,4,4,4,4,10
BUCU,02/02/12,2.5,2.5,2.5,2.5,25533
BUCV,02/02/12,0.2835,0.2888,0.2835,0.2888,3000
BVB,02/02/12,33.4,33.99,33.11,33.4,17384
CBC,02/02/12,6.3,6.3,6.3,6.3,8
CEON,02/02/12,0.009,0.009,0.009,0.009,1000
CERE,02/02/12,0.78,0.78,0.78,0.78,500
CFED,02/02/12,0.35,0.35,0.35,0.35,105
CFES,02/02/12,0.04,0.04,0.04,0.04,84
CHOB,02/02/12,0.23,0.23,0.23,0.23,200
CLEL,02/02/12,0.0464,0.0524,0.0463,0.0524,7000
CMF,02/02/12,1.76,1.76,1.76,1.76,1000
CMP,02/02/12,0.46,0.465,0.4565,0.4565,22500
CNTE,02/02/12,37.32,38.7,37.32,38,22
COBS,02/02/12,2,2.22,1.99,1.99,4240
COBU,02/02/12,0.24,0.26,0.24,0.26,2627
COFI,02/02/12,0.0223,0.0224,0.0216,0.0217,2615100
COMI,02/02/12,0.213,0.213,0.2012,0.205,53167
CONY,02/02/12,2.85,2.85,2.85,2.85,1
COS,02/02/12,0.805,0.805,0.805,0.805,500
COSC,02/02/12,0.44,0.44,0.44,0.44,120
COTE,02/02/12,38.5,38.5,38.5,38.5,40
CRC,02/02/12,0.23,0.23,0.23,0.23,200
DAFR,02/02/12,0.073,0.0735,0.0718,0.073,403500
DAI,02/02/12,188,189,187.8,189,277
EBDAXTL10,02/02/12,73,75,73,75,150
EBDAXTL11,02/02/12,62.4,65.2,62.2,65.2,513
EBDAXTL7,02/02/12,97,97,97,97,6
EBDAXTL9,02/02/12,85.2,85.6,84.8,85.6,207
EBDAXTS7,02/02/12,17.2,18,15,15,33325
EBEBSTL1,02/02/12,3.65,3.75,3.55,3.75,198
EBFPTL3,02/02/12,18.91,20,18.86,20,12826
EBGLD,02/02/12,579,581,579,581,2969
EBGLDTL6,02/02/12,104,106,104,106,22
EBGLDTL7,02/02/12,136,139,136,139,2
EBGLDTS7,02/02/12,132,132,131.5,131.5,3
EBGLDTS8,02/02/12,94.5,95.25,91,91,44
EBS,02/02/12,75.4,79.15,75.4,79,15420
EBSLVTL3,02/02/12,29.25,31,29.25,31,68
EBSLVTS5,02/02/12,25.5,25.75,25,25,6512
EBWTITL4,02/02/12,94.75,94.75,94,94,6
EBWTITL5,02/02/12,116.5,116.5,113.75,113.75,25
EBWTITL6,02/02/12,61.75,61.75,56.75,56.75,516
EBWTITL7,02/02/12,27.5,27.5,22.25,22.5,13259
EBWTITS10,02/02/12,104.25,104.25,104.25,104.25,1
EBWTITS9,02/02/12,66.25,69.25,66.25,68,3187
ECT,02/02/12,0.0365,0.0365,0.0365,0.0365,1000
EFO,02/02/12,0.0787,0.0869,0.076,0.076,906398
ELGS,02/02/12,0.337,0.337,0.3271,0.3345,25000
ELJ,02/02/12,0.1498,0.1498,0.1498,0.1498,2506
ELJM,02/02/12,4.4,4.4,4.4,4.4,500
ELMA,02/02/12,0.2908,0.2911,0.29,0.29,144500
ELTR,02/02/12,0.6,0.6,0.6,0.6,3702
ELZY,02/02/12,2.66,2.68,2.66,2.68,300
EOAN,02/02/12,73.2,73.25,73.15,73.25,271
EVER,02/02/12,1.41,1.42,1.4,1.42,3303793
FACY,02/02/12,3.5,3.5,3.5,3.5,220
FEL,02/02/12,0.59,0.59,0.59,0.59,10
FMAR,02/02/12,0.04,0.05,0.04,0.05,25290
FOSP,02/02/12,50,50,50,50,1
FP,02/02/12,0.4907,0.4945,0.486,0.4926,43045182
IARV,02/02/12,1.55,1.55,1.5,1.5,600
ICEF,02/02/12,1.5,1.6,1.5,1.6,49
IFR,02/02/12,168.9,168.9,168.9,168.9,5
IMP,02/02/12,0.0309,0.0315,0.0297,0.0297,28560
IPRU,02/02/12,0.6109,0.6109,0.6109,0.6109,1316

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.