Posted By: Grat
dataFind - how to? - 02/01/21 16:39
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:
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:
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:
Code
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:
Code
int findRow(var dDate,const int nHandle){ int Row = dataFind(nHandle,dDate); if (utm(dataVar(nHandle,Row,0)) == utm(dDate)){ return Row; } return -1; }