in analysis use Daily periodicity and explore...
Left column date/time will show the last date of data present of previous month...
right columns will show date of high n low but it is in datenum format...
i tried to convert it to string, but was not successful, maybe some senior coders will be able to help...
good luck
View attachment 43064
Left column date/time will show the last date of data present of previous month...
right columns will show date of high n low but it is in datenum format...
i tried to convert it to string, but was not successful, maybe some senior coders will be able to help...
good luck
Code:
TimeFrameSet(inMonthly);
pmh = H;
pml = L;
TimeFrameRestore();
pmh = TimeFrameExpand(pmh,inMonthly,expandFirst);
pml = TimeFrameExpand(pml,inMonthly,expandFirst);
pmh_date = ValueWhen(pmh==H ,DateNum());
pml_date = ValueWhen(pml==l ,DateNum());
Filter = Month()!=Ref(Month(),1);
AddColumn(PMH,"P Month High");
AddColumn(pmh_date,"PMH_date",1.0);
AddColumn(PML,"P Month Low");
AddColumn(pml_date,"PML_date",1.0);
in analysis use Daily periodicity and explore...
Left column date/time will show the last date of data present of previous month...
right columns will show date of high n low but it is in datenum format...
i tried to convert it to string, but was not successful, maybe some senior coders will be able to help...
good luck
View attachment 43064
Left column date/time will show the last date of data present of previous month...
right columns will show date of high n low but it is in datenum format...
i tried to convert it to string, but was not successful, maybe some senior coders will be able to help...
good luck
Code:
TimeFrameSet(inMonthly);
pmh = H;
pml = L;
TimeFrameRestore();
pmh = TimeFrameExpand(pmh,inMonthly,expandFirst);
pml = TimeFrameExpand(pml,inMonthly,expandFirst);
pmh_date = ValueWhen(pmh==H ,DateNum());
pml_date = ValueWhen(pml==l ,DateNum());
Filter = Month()!=Ref(Month(),1);
AddColumn(PMH,"P Month High");
AddColumn(pmh_date,"PMH_date",1.0);
AddColumn(PML,"P Month Low");
AddColumn(pml_date,"PML_date",1.0);
I found a code while surfing... wil it help to conversion of date.... pls have a look
{
dd_ = StrToNum( StrRight( aaaammdd, 2 ) ); //printf(WriteVal(dd_) + " " );
mm_ = StrToNum( StrMid( aaaammdd, 4, 2 ) ); //printf(WriteVal(mm_) + " " );
aa_ = StrToNum( StrLeft( aaaammdd, 4 ) ); //printf(WriteVal(aa_) + " " + "\n" );
Date_Num = ( 10000 * ( aa_ - 1900 ) ) + ( 100 * mm_ ) + dd_;
RESULT = Date_Num;
return RESULT;
}