Hi,
I have an afl to generate signals when the close price crosses prev_day_high/prev_day_low and if ROC_Daily is > 0 (for Buy) and ROC_Daily < 0 (For sell). ROC daily is calculated for period of 5. Since i run the exploration at fixed interval of 15 mins on last 2 bars, to get the ROC_Daily I am using timeframeset and restore functions. Now the challenge is, during live market exploration, the daily close is equal to interval close (obviously) at the time of exploration and the timeframeset/restore/expand functions calculates the ROC as per the last close value. But, when I run the exploration at the end of the day, ROC is changed because Timeframeset/restore/expand calculates ROC based of Close of the Day so the ROC_daily value is same for all 15 min bars of the day.. Because of this, the live exploration result counts and end of day result counts differs. For example, yesterday, during live exploration at 15 mins interval, the number of trades were 30 for a day, but when I ran the exploration at the end of the day(recent days =1), the results were 54. I know the difference is due to change in ROC condition because of timerameset/restore/expand. My question is how do I make sure that the end of the day exploration results are also same. I need to work on this because I want to optimize ROC days parameter and I know historical exploration data may have additional extra results which did not occur during the live 15 min exploration so, if I optimize it based on historical data, I will not get the correct optimized setting.
In short, the condition should be buy when Cross(C, prev_day_high) and when this condition is true , the corresponding ROC value which is coming from ROC function used with Timeframeset/restore/expand should be > 0 (for Buy) and <0 (for sell). I do not know how to get the ROC value at the time of signal generation especially when it coming from higher timeframe using timeframeset/restore/expand.
Plz note, that I am using free trial version 6 and not a paid customer of Amibroker as of now. I tried searching for topics on the same but could not find it.
_SECTION_BEGIN("Logic");
XDA_Setting=Per =9;
tick_size=0.05;
TimeFrameSet(inDaily);
ROC_d=ROC(C,Per);
TimeFrameRestore();
ROC_Daily=TimeFrameExpand(ROC_d,inDaily,expandFirst);
prev_day_high=TimeFrameGetPrice("H",inDaily,-1);
prev_day_low=TimeFrameGetPrice("L",inDaily,-1);
ADX_=ADX(14);
EurekaBuy= Cross(C, prev_day_high) AND ROC_Daily > 1 ;
EurekaSell= Cross(prev_day_low,C) AND ROC_Daily < -1 ;
Buy=Cover=EurekaBuy;
Sell=Short=EurekaSell;
Buy=ExRem(Buy,Sell);
Sell=ExRem(Sell,Buy);
Short=ExRem(Short,Cover);
Cover=ExRem(Cover,Short);
BSG = IIf(Buy, colorPaleGreen, IIf(Sell, colorRose, colorDefault));
BSFG = IIf(Buy, colorDarkGreen, IIf(Sell, colorDarkRed, colorDefault));
PlotShapes(Buy*shapeUpArrow, colorGreen, 0, Low);
PlotShapes(Sell*shapeDownArrow, colorRed, 0, Low);
if((Status("action") == actionExplore) OR (Status("action") == actionScan))
{
Filter = Buy or Filter = Sell;
SetOption("NoDefaultColumns", True);
AddTextColumn(Name(), "Symbol", 77, BSFG, BSG, 120);
AddColumn(DateTime(), "Date", formatDateTime, BSFG, BSG, 100);
AddColumn(TimeNum()/100 ,"Time",1,BSFG, BSG, 100);
AddColumn(IIf( Buy, 'B', 'S'), "Trade",formatChar);
AddColumn( C, "Trade_Price", 1.2,BSFG, BSG, 100 );
AddColumn( round(IIf(Buy,C*0.9875,1.0125*C)/tick_size)*tick_size, "Stop_Price", 1.2,BSFG, BSG, 100 );
AddColumn( round(IIf(Buy,C*1.03,0.97*C)/tick_size)*tick_size, "Target_Price", 1.2,BSFG, BSG, 100 );
AddColumn( Buy, "Buy", 1,BSFG, BSG, 50);
AddColumn( Sell, "Sell", 1,BSFG, BSG, 50 );
AddColumn( ADX_, "ADX", 1.2,BSFG, BSG, 50 );
//AddColumn( ADX_15min, "ADX_15min", 1,BSFG, BSG, 50 );
AddColumn( prev_day_high, "prev_day_high", 1.2,BSFG, BSG, 100 );
AddColumn( prev_day_low, "prev_day_low", 1.2,BSFG, BSG, 100 );
AddTextColumn(Now() ,"Current_Time",formatDateTime,BSFG, BSG, 100);
AddColumn(ROC_Daily,"ROC_Daily",1.2);
AddColumn(xda_Setting,"XDA_Setting",1);
SetSortColumns(-2);
}