2 replies to this topic

[lscharpen]

I've had a data problem and need a couple of numbers to tide me over. I'd like to get the open/high/low numbers for ES M7 and NQ M7 for April through yesterday's close. I've got data again for today. Thanks to some kind soul! Lee Scharpen

[skott]

"Date","Time","Open","High","Low","Close","Vol","OI","AvgExp","Pivot"
03/20/2007,1515,1415.50,1424.00,1412.50,1423.50,1064641,1692585,0.00,0.00
03/21/2007,1515,1423.50,1449.75,1421.00,1445.00,1609256,1723300,0.00,-1.00
03/22/2007,1515,1445.00,1451.00,1441.00,1445.00,1136059,1739937,0.00,1438.58
03/23/2007,1515,1444.75,1451.00,1443.50,1447.00,785022,1743745,1447.00,1445.67
03/26/2007,1515,1446.25,1449.25,1433.75,1445.25,1153326,1760404,1446.96,1447.17
03/27/2007,1515,1445.00,1446.00,1436.00,1440.50,911001,1735358,1446.82,1442.75
03/28/2007,1515,1440.50,1440.75,1424.25,1429.50,1446110,1766859,1446.43,1440.83
03/29/2007,1515,1429.75,1438.25,1423.25,1431.50,1331006,1789567,1446.10,1431.50
03/30/2007,1515,1431.75,1439.75,1418.00,1431.25,1399338,1814966,1445.77,1431.00
04/02/2007,1515,1431.75,1436.00,1425.75,1433.25,904543,1826878,1445.49,1429.67
04/03/2007,1515,1433.50,1450.50,1433.25,1447.25,1008408,1864921,1445.53,1431.67
04/04/2007,1515,1447.00,1450.00,1444.25,1448.50,753211,1872145,1445.60,1443.67
04/05/2007,1515,1448.00,1454.75,1446.25,1452.75,520584,1865124,1445.76,1447.58
04/06/2007,1515,1452.50,1459.00,1452.00,1452.70,46227,1861234,1445.91,1451.25
04/09/2007,1515,1457.25,1459.00,1452.50,1454.50,576687,1853806,1446.10,1454.57
04/10/2007,1515,1454.50,1458.25,1451.25,1456.00,712441,1877264,1446.32,1455.33
04/11/2007,1515,1455.75,1458.25,1444.50,1448.50,1156391,1888913,1446.37,1455.17
04/12/2007,1515,1448.50,1457.00,1442.25,1455.50,1168430,1860077,1446.57,1450.42
04/13/2007,1515,1455.25,1461.75,1452.25,1461.25,975395,1860771,1446.90,1451.58
04/16/2007,1515,1461.50,1477.25,1461.00,1475.50,1204460,1906040,1447.53,1458.42
04/17/2007,1515,1474.75,1482.75,1471.25,1479.00,1300312,1934706,1448.23,1471.25
04/18/2007,1515,1478.75,1484.50,1473.00,1480.25,1097360,1953100,1448.95,1477.67
04/19/2007,1515,1480.50,1481.75,1468.25,1480.25,1198217,1954508,1449.64,1479.25
04/20/2007,1515,1479.75,1493.50,1478.75,1493.00,1345302,2030270,1450.60,1476.75
04/23/2007,1515,1492.75,1494.75,1487.00,1488.25,847905,2040881,1451.44,1488.42
04/24/2007,1515,1488.00,1491.50,1480.25,1488.50,1202067,2024380,1452.26,1490.00
04/25/2007,1515,1488.25,1503.50,1486.75,1500.75,1220950,2017788,1453.34,1486.75
04/26/2007,1515,1500.75,1505.00,1497.25,1502.75,972312,2019883,1454.44,1497.00
04/27/2007,1515,1502.00,1503.75,1494.50,1502.00,980642,2019082,1455.50,1501.67
04/30/2007,1515,1501.00,1505.00,1488.00,1488.50,1188232,2019082,1456.23,1500.08
05/01/2007,1515,1489.25,1489.25,1488.00,1488.50,7894,2019082,1456.95,1493.83


[b]Sorry this is the best I can do. will this work?

[ecpinto]

Ticker Date/Time Open high Low close Volume Open Interest @ES07M 4/2/2007 143175.00 143600.00 142575.00 143350.00 903907.00 1814966.00 @ES07M 4/3/2007 143350.00 145025.00 143325.00 144700.00 1007327.00 1826878.00 @ES07M 4/4/2007 144700.00 145000.00 144425.00 144850.00 753211.00 1864921.00 @ES07M 4/5/2007 144800.00 145475.00 144625.00 145275.00 520584.00 1872145.00 @ES07M 4/9/2007 145725.00 145900.00 145250.00 145450.00 576687.00 1861234.00 @ES07M 4/10/2007 145450.00 145825.00 145125.00 145575.00 712441.00 1853806.00 @ES07M 4/11/2007 145575.00 145825.00 144450.00 144875.00 1156391.00 1877264.00 @ES07M 4/12/2007 144850.00 145700.00 144225.00 145525.00 1168430.00 1888913.00 @ES07M 4/13/2007 145525.00 146175.00 145225.00 146150.00 975395.00 1860077.00 @ES07M 4/16/2007 146150.00 147725.00 146100.00 147525.00 1204460.00 1860771.00 @ES07M 4/17/2007 147475.00 148275.00 147125.00 147900.00 1299496.00 1906040.00 @ES07M 4/18/2007 147875.00 148450.00 147300.00 148000.00 1097360.00 1934706.00 @ES07M 4/19/2007 148050.00 148175.00 146825.00 148050.00 1198217.00 1953100.00 @ES07M 4/20/2007 147975.00 149350.00 147875.00 149325.00 1341129.00 1954508.00 @ES07M 4/23/2007 149275.00 149475.00 148700.00 148825.00 837566.00 2030270.00 @ES07M 4/24/2007 148800.00 149150.00 148025.00 148850.00 1200592.00 2040881.00 @ES07M 4/25/2007 148825.00 150350.00 148675.00 150100.00 1220950.00 2024380.00 @ES07M 4/26/2007 150075.00 150500.00 149725.00 150250.00 972312.00 2017788.00 @ES07M 4/27/2007 150200.00 150375.00 149450.00 150225.00 972642.00 2019883.00 @ES07M 4/30/2007 150100.00 150500.00 148800.00 148925.00 1188232.00 2019082.00 Ticker Date/Time Open high Low close Volume Open Interest @NQ07M 4/2/2007 179175.00 179725.00 177825.00 179000.00 206177.00 341370.00 @NQ07M 4/3/2007 179050.00 181900.00 178975.00 181425.00 272457.00 338768.00 @NQ07M 4/4/2007 181400.00 182125.00 181100.00 181925.00 180953.00 350081.00 @NQ07M 4/5/2007 181825.00 183150.00 181450.00 182800.00 143464.00 351449.00 @NQ07M 4/9/2007 183975.00 183975.00 182050.00 182425.00 170599.00 356690.00 @NQ07M 4/10/2007 182375.00 183325.00 182225.00 183000.00 179370.00 361856.00 @NQ07M 4/11/2007 183000.00 183375.00 180725.00 181300.00 324334.00 379102.00 @NQ07M 4/12/2007 181200.00 183000.00 180225.00 182750.00 308978.00 379194.00 @NQ07M 4/13/2007 182725.00 183325.00 181550.00 183200.00 232369.00 376919.00 @NQ07M 4/16/2007 183200.00 185050.00 182950.00 184800.00 234011.00 377223.00 @NQ07M 4/17/2007 184750.00 185500.00 184275.00 185200.00 231696.00 388897.00 @NQ07M 4/18/2007 185250.00 185300.00 183650.00 184750.00 263930.00 392302.00 @NQ07M 4/19/2007 184925.00 185375.00 183125.00 184900.00 290014.00 398864.00 @NQ07M 4/20/2007 184850.00 187025.00 184675.00 186225.00 308485.00 403225.00 @NQ07M 4/23/2007 186250.00 186725.00 185675.00 186275.00 201344.00 426392.00 @NQ07M 4/24/2007 186225.00 187675.00 185575.00 187025.00 326961.00 423712.00 @NQ07M 4/25/2007 187025.00 189675.00 186925.00 189425.00 321892.00 429683.00 @NQ07M 4/26/2007 189350.00 190900.00 189350.00 190575.00 262449.00 435184.00 @NQ07M 4/27/2007 190450.00 190725.00 189450.00 190675.00 234061.00 447544.00 @NQ07M 4/30/2007 190550.00 190775.00 187850.00 188175.00 259708.00 450147.00