Explore Error with past day

Hi,

I want Explore with signal Buy/Sell. I used function AddTextColumn with Signal text. when I explore, this column show Signal with current day and not show Signal with past day. How to fix this error?? Tks all!

//////Signal////////////////////////
Muabatday=(BuyslopWma1 OR BuyslopWma2) AND Ref(Buy_kama,-1) AND dongtien;
Muadoday= ((BuyslopWma1 OR BuyslopWma2) AND Ref(Buy_kama,-1) AND NOT dongtien) OR 
          (Ref(Buy_kama,-1) AND (dongtien OR Buy2 OR Lvtbar2 OR stdn2 OR stdn1 or eftup));

BigBuy=(vuotwma40 AND NOT BroadeningWedge and (buy1 OR Buy2 OR Lvtbar2 OR stdn2 OR stdn1 or eftup)) OR 
       ((Buy2 OR Lvtbar2 OR stdn2 OR stdn1 or eftup) AND wm>Ref(wm,-1) AND BuyslopWma AND NOT BroadeningWedge);
MediumBuy=NOT vuotwma40 AND (Buy2 OR Lvtbar2 OR stdn2 OR stdn1 or eftup) AND wm>Ref(wm,-1);
SmallBuy=NOT vuotwma40 AND Buy1 AND wm>Ref(wm,-1);

FilterBuy=Muabatday OR Muadoday OR BigBuy OR MediumBuy OR SmallBuy;

SignalText=WriteIf( (BuyslopWma1 OR BuyslopWma2) AND Ref(Buy_kama,-1), WriteIf(dongtien,"1.Mua Bat Day","2.Mua do Day"),
           WriteIf(Ref(Buy_kama,-1) AND (dongtien OR Buy2 OR Lvtbar2 OR stdn2 OR stdn1 or eftup),"2.Mua do Day",
           WriteIf((vuotwma40 AND NOT BroadeningWedge AND (buy1 OR Buy2 OR Lvtbar2 OR stdn2 OR stdn1 or eftup)) OR ((Buy2 OR Lvtbar2 OR stdn2 OR stdn1 or eftup) AND wm>Ref(wm,-1) AND BuyslopWma AND NOT BroadeningWedge) ,"3.Big Buy",
           WriteIf(NOT vuotwma40 AND (Buy2 OR Lvtbar2 OR stdn2 OR stdn1 or eftup) AND wm>Ref(wm,-1),"4.Medium Buy",
           WriteIf(NOT vuotwma40 AND Buy1 AND wm>Ref(wm,-1),"5.Small Buy",
           "")))));

Filter=(FilterBuy AND V>500000 AND MA(V,20)>400000);
//Filter=(Buy AND V>100000 AND MA(V,20)>100000 AND NOT DK_Day) or actualBars<5 OR (Quansat_Traingle AND V>500000 AND MA(V,20)>400000);
//Filter=BuyslopWma AND V>500000 AND MA(V,20)>400000;

AddTextColumn(Nganh, "Nganh", 1);
AddColumn(C, "Close", 1.2,colorWhite,CloseColor1);
AddColumn(V,"    VOLUME    ",1);
AddColumn(ROC(C,1),"    %P    ");
AddColumn(ROC(V,1),"    %V    ");
AddTextColumn(SignalText,"Signal");
AddColumn(TotalScore,"    Score    ",1.1);
AddColumn(IIf(dongtien,1,0)," Dongtien   ",1);
AddColumn(IIf(bullishbreakout,1,0)," bullish   ",1);
AddColumn(IIf(Buytrendline,1,0)," Trendline   ",1);
if(showredVSA)  {
AddColumn(IIf(Buy2 OR Lvtbar2 OR stdn2 OR stdn1 or eftup,1,0),"VSA",1);
AddColumn(IIf(Buy1,1,0),"VSA+",1);
AddColumn(IIf(BuyslopWma1,1,IIf(BuyslopWma2,2,0)),"slopWma",1);
}
if(showKamaSystem)  {
AddColumn(NgayKama, "Kama",1);
}

AddTextColumn(WriteIf(ascendingtriangle,"Ascending Triangle",WriteIf(decendingtriangle,"Decending Triangle",WriteIf(Wedge,"Wedge",WriteIf(DownChannel,"Down Channel",WriteIf(UpChannel,"Up Channel",WriteIf(BroadeningWedge,"Broadening Wedge","")))))),"Pattern");


1
2

There is no error!

WriteIf returns just single string representing current SelectedValue.

Use AddMultiTextColumn.

@TrendSurfer Thanks so much!

This topic was automatically closed 100 days after the last reply. New replies are no longer allowed.