EL Collections

March 6th, 2016, 01:16 PM

Well I'm trying to understand EL Collections. I've managed to read in a .csv file and index a specific cell in the matrix (using the examples provided in the documentation).

I understand that Tradestation stores the columns of data in "alpha" order by their header. So I built a "readheadings" ListS collection so I could duplicate the actually input order.

I can find the "row" in the matrix I want the value for but I seem to be currently stumped on how to get the values for each column in that row. The row will have both strings and numbers in it, I actually only want the numbers.

Any help would be greatly appreciated.

Code

using elsystem.collections ;
using elsystem ;
Inputs:

		string SetName ("Testit");
Vars:
	Inputfile("C:\Temp\xx23csv.csv"),
	Outputfile ("C:\Temp\xx25csv.csv"),
	MyMapID (MapSC.New),
	RowMapID (MapSN.New),
	CHID(ListS.New),
	ColList (0), RowNum(0), count (0), IsThere (false), number(0), index(0),rowindex(0),
	elsystem.collections.GlobalDictionary myGridDict(null),
	elsystem.collections.Vector GridName (null),
	SymbolSet(MapSN.share(SetName)), // create map or share it if it exists
	DistMap(MapNN.share("Distribution")), 
	tempList(0),Sym("");
	

	

method void AnalysisTechnique_Initialized( elsystem.Object sender, elsystem.InitializedEventArgs args ) 
begin
	Value1 = MapSc.ReadFile(MyMapID, InputFile);
	IsThere= MapSC.exists(MyMapID,"Symbol");
	Value1 = MapSC.BuildRowMap(MyMapID, RowMapID, "Symbol");
	
	Value1 = ListS.ReadHeadings(CHID, Inputfile);

	isthere=false;
	IsThere= MapSC.exists(MyMapID,"Dip");
	ColList = MapSC.get(MyMapID,"Dip");   // get the Dip column
	isthere=false;
	IsThere= MapSn.exists(RowMapID,"QQQ");
	RowNum = MapSN.get (RowMapID, "QQQ");
	Print ( ListN.get (ColList, RowNum));
	 
			count = ListS.count (CHID);
	
	Value1 = ListS.rewind(CHID);
		
	end;

	

	
method void AnalysisTechnique_UnInitialized( elsystem.Object sender, elsystem.UnInitializedEventArgs args ) 
begin

end;



method void AnalysisTechnique_WorkspaceSaving( elsystem.Object sender, elsystem.WorkspaceSavingEventArgs args ) 
begin


	end;
	
Begin
	// Read the file and the column headings
		// Process data
	
	If templist <1 then begin
	// Write the map to a file using the same column order
	Value1 = MapSC.setcolumnorder(MyMapID, CHID);
	Value1 = MapSC.writeFile(MyMapID, Outputfile);
	tempList = templist +1;
	end;
	end;

EL Collections

Discussion in EasyLanguage Programming

EL Collections