In the manual:
Returns the number of the first record at
or before the given Date in wdate format...
I have problem, I have 4 dataset where time to time missing data. I want to exact value or -1 if this candle not exist. Is a possible? and how?
I have this FCE:
int findRow(var dDate,const int nHandle){
int Row = dataFind(nHandle,dDate);
if (dataVar(nHandle,Row,0) != dDate){
print(TO_LOG,"\n>> %f | %f = %d / %d",dDate,dataVar(nHandle,Row,0),nHandle,Row);
}
return Row;
}
a) dataVar(nHandle,Row,0) != dDate ... false only in 0:0 hour ( 44147.000000 == 2020-11-12 00:00 )
with diferent time is true ( 44147.166667 == 20-11-12 04:00 )
out: 44147.166667 | 44147.166667 = 1 / 248
in the other case I must be make workaroud ( repare input dataset in pandas
)
edit:there is work fce:
int findRow(var dDate,const int nHandle){
int Row = dataFind(nHandle,dDate);
if (utm(dataVar(nHandle,Row,0)) == utm(dDate)){
return Row;
}
return -1;
}