Amibroker Date Search

[stevecar144]

Hi All,
In the below I am trying to return the shares outstanding as of June 2018 and July 2014. The exploration returns the same data for both years??? Obviously I am missing something...help appreciated. I have tried to use a start date and end date with lookup...not sure if thats the right approach.

StartDate = "2014-01-07" ;
StartClose = Lookup( C, _DT( StartDate ), 1 ) ;
Buy = Close > ( startclose * 5) AND DateTime() >= StrToDateTime( StartDate ) ;
Sell = Close > ( startclose * 100000 ) AND DateTime() >= StrToDateTime( StartDate ) ;

sharesout2014 = GetFnData("sharesout");
sharesout2018 = GetFnData("sharesout");
enddate = "2018-30-06" ;
sharesout2018 = Lookup( sharesout2018, _DT( enddate ), 1 );
sharesout2014 = Lookup( sharesout2014, _DT( startdate ), 1 );

Buy = ExRem(Buy,Sell);
Sell = ExRem(Sell,Buy);
targetprice = GetFnData("oneyeartargetprice");
Filter = Buy;// AND StrLen( Name () ) == 3;
AddColumn(C > startclose * 5,"fivetimes",5);
AddColumn(C,"Close 30/6/2018",1.4);
AddColumn(startclose,"close 1/7/2014",1.4);
AddColumn(startclose*5,"start * 5",1.4);
AddColumn(targetprice,"target price",1.4);
AddColumn(sharesout2018,"shares out 18",1.4);
AddColumn(sharesout2014,"shares out 14",1.4);
AddColumn(sharesout2014-sharesout2018,"shares diff",1.4);