Easy ADE Problem

[bigboy]

Hello,

I'm thinking this is an easy answer for someone more familiar with Elcollections and ADE than I am. Anyway, I have this written to a file by an external dll.

Date,Time,mdindex,mdbidvo l,mdaskvol,mdopen,mdhigh, mdlow
02/04/2008,1744,499,1,0,13780.0 00000,13785.000000,13775. 000000
02/04/2008,1744,500,0,2,13780.0 00000,13785.000000,13775. 000000
02/04/2008,1744,501,25,0,13780. 000000,13785.000000,13775 .000000
02/04/2008,1745,499,1,1,13795.0 00000,13805.000000,13790. 000000
02/04/2008,1745,500,34,11,13795 .000000,13805.000000,1379 0.000000
02/04/2008,1745,501,11,167,1379 5.000000,13805.000000,137 90.000000
02/04/2008,1745,502,0,3,13795.0 00000,13805.000000,13790. 000000
02/04/2008,1746,497,41,0,13795. 000000,13795.000000,13780 .000000
02/04/2008,1746,498,20,107,1379 5.000000,13795.000000,137 80.000000
02/04/2008,1746,499,23,18,13795 .000000,13795.000000,1378 0.000000
02/04/2008,1746,500,68,0,13795. 000000,13795.000000,13780 .000000

I'm trying to make a map of a map I guess so that I can read in the values but there is not a one to one correspondence with the bar. Instead each bar has variable amount of data depending upon the number of price movemements in the bar. I need to somehow read this in from a file and store it in a map or list to operate on and print out. I need a map or list that is created from this that has variable number of members keyed by the minute bar id somehow.

Here's the contents of what I have in my ADC.GetMDELTA function
Inputs:
Sym(StringSimple),
Interval(NumericSimple),
BarID(NumericSimple),
vmdeltaindexlist(NumericR ef),
vbidList(NumericRef),
vaskList(NumericRef),
vmdopenList(NumericRef),
vmdhighList(NumericRef),
vmdlowList(NumericRef);

Vars:
LastSym(""),
LastInterval(-1),
Index(0),
DataMap(0),
BarList(0),
mdeltaindexlist(0),
bidList(0),
askList(0),
mdopenList(0),
mdhighList(0),
mdlowList(0);

if Sym <> LastSym or Interval <> LastInterval then begin
LastSym = Sym;
LastInterval = Interval;

DataMap = ADE.GetRequiredMap("MDELT A", Sym, Interval);
BarList = MapSC.Get(DataMap, ":Bar");

mdeltaindexlist = MapSC.Get(DataMap, "mdindex");
bidList = MapSC.Get(DataMap, "mdbidvol");
askList = MapSC.Get(DataMap, "mdaskvol");
mdopenList = MapSC.Get(DataMap, "mdopen");
mdhighList = MapSC.Get(DataMap, "mdhigh");
mdlowList = MapSC.Get(DataMap, "mdlow");



end;

if ListN.IsSorted(BarList) = false then
Value1 = ADE.SortDataMap(DataMap);

if ListN.Lookup(BarList, BarID, Index) = false then
Index = Index - 1;

if Index <> 0 then begin
vmdeltaindexlist = ListN.Get(mdeltaindexlist , Index);
vbidList = ListN.Get(bidList, Index);
vaskList = ListN.Get(askList, Index);
vmdopenList = ListN.Get(mdopenList, Index);
vmdhighList = ListN.Get(mdhighList, Index);
vmdlowList = ListN.Get(mdlowList, Index);
end;

ADC.GetMDELTA = Index;

Since these do not match up with individual ticks either, the zerobar stuff doesn't work for this.

Any help appreciated.
Bigboy

[bigboy]

Hmmm, guess I've got the pros stumped here!
bigboy