Use floor() function instead of round().

http://www.amibroker.com/f?floor

Best regards,
Tomasz Janeczko
amibroker.com
  ----- Original Message ----- 
  From: Markus Witzler 
  To: [email protected] 
  Sent: Wednesday, July 22, 2009 7:17 PM
  Subject: [amibroker] Still - using CBT the first time





  Hello all,

  I intend to use CBT to compute proprietary position size (number shares 
instead of percentage of equity or amount of money) as I wrote before.

  Now that AB has been told (thru assistance of Bruce, Mike and TJ ) to use 
"number of shares", I still don´t know why it doesn´t output the proper size:

  The formula for computing sharesize is as follows (entire code see further 
below):

  sharesize=round(((Heat*bo.cash)/(y*ATRmultiplier))/250)*250

  According to my data, I read for a specific day

  where y=3.115     ATR multiplier=5    heat=0.1    bo.cash=1000000.00

  which should result in a sharesize of 6,500. But instead, AB computes a 
sharesize of 6,750. Thus, I´m off by one unit of 250 lots.

  Maybe it´s due to the calculation of y? Could someone please help me with 
this? It probably caused by the AB´s rounding but I just can´t figure it out.

  If so, I will provide the data for the S&P contract I use so that the results 
I get could be reproduced.

  Thanks very much

  Markus

  - - - - - - - - - - - - - - - - - - - - - - - - - -

  /*Setting different options to clarify or override backtester settings*/

  //SetOption("InitialEquity", 1000000.00);

  SetOption("UsePrevBarEquityForPosSizing", True);

  //SetOption("MinShares", 250);

  SetOption("CommissionMode", 2); //$$ per trade

  SetOption("Marginrequirement", 100);

  SetOption("InterestRate",0); // account doesn´t earn interest for cash 
balance!

  SetTradeDelays( 1, 1, 1, 1 );



  //RoundLotSize = 250;

  Heat= 0.1; // provided by ED

  ATRMultiplier=5; //provided by ED

  TC150=150;

  TC15=15;

  n=20; // Time Constant used in ATR lag computation

  x=(n+1)/2;



  /* Calculation of TC150 EMA and TC15 EMA*/

  SetBarsRequired( sbrAll, sbrAll ); 

  EMA150[0]=Close[0]; 

  EMA15[0]=Close[0];

  for( i = 1; i < BarCount; i++ ) 

  { 

  EMA150[i]=EMA150[i-1]+(Close[i]-EMA150[i-1])*2/(TC150+1); 

  EMA15[i]=EMA15[i-1]+(Close[i]-EMA15[i-1])*2/(TC15+1);



  } 



  /* Controlling trade price*/

  BuyPrice=Open+(High-Open)/2; //i.e. 50% slippage

  SellPrice=Open-(Open-Low)/2; //i.e. 50% slippage 



  /*Trading rules and optimization*/



  Buy= Cum(1)>=25 AND Cross(EMA15, EMA150);

  Sell= Cross(EMA150, EMA15);

  /* Graphic output*/

  Plot(EMA150, "My expon. Lag 150", colorGreen, styleLine);

  Plot(EMA15, "My expon. Lag 15", colorRed, styleLine);

  Plot (Close, "Bar Chart", colorBlue, styleBar);

  EMA15 = Optimize("EMASlow", 50, 1, 150, 1 ); 

  EMA150 = Optimize("EMAFast", 150, 20,400, 1); 

  Buy = ExRem( Buy, Sell ); // to exclude redundant signals

  Sell = ExRem( Sell, Buy );// to exclude redundant signals



  /* Position sizing - volatility based*/

  trhelp[0]=0; // trhelp is being initialized

  TRcombined[0]=0; // TRcombined is being initialized

  ATRExpLag[0]=High[0]-Low[0]; // ATRExpLag is being initialized; seed value is 
the 1st day´s high-low range per Ed´s definition



  for( i = 1; i < BarCount; i++ ) // here, the Average True Range (20 days) is 
coded by using a loop

  { 

  trhelp[i]= Max(High[i]-Low[i],High[i]-Close[i-1]); //trhelp is a helping 
variable for calculating ATRcombined. ATR() function cannot be used.

  TRcombined[i]= Max(Close[i-1]-Low[i],trhelp[i]); //TRcombined is the actual 
TrueRange. 

  ATRExpLag[i]=ATRExpLag [i-1]+ (TRcombined[i]-ATRExpLag[i-1])/x; // This is 
the 20-day expon. moving average of the ATR



  }

  ATRExpLagRounded=round(ATRExpLag*1000)/1000; //here, I round on the 3rd digit.

  AddToComposite(ATRExpLagRounded, "~ATRExpLagRounded_"+Name(), "V", 
atcFlagDefaults | atcFlagEnableInBacktest);



  Filter = GroupID() != 253; // Exclude "group 253" in which composites are 
being saved/



  SetCustomBacktestProc("");

  if (Status("action") == actionPortfolio)

  {

  bo = GetBacktesterObject(); // Get backtester object

  bo.PreProcess(); // Do pre-processing


  bo.cash=1000000; // muß das hier stehen oder im indexierten loop; dann aber 
wäre doch bei jeder iteration das

  // initial equity UND DAMIT auch das old cash immer wieder 1000000.00!!??

  My_total_equity=0; 

  Value_open_positions=0;

  Heat=0.1;

  ATRmultiplier=5;


  for (i = 0; i < BarCount; i++) // Loop through all bars


  {

  for (sig = bo.GetFirstSignal(i); sig; sig = bo.GetNextSignal(i))

  { // Loop through all signals at this bar

  // Long trades

  ATRexRounded = Foreign("~ATRExpLagRounded_"+sig.Symbol, "V"); // Get symbol's 
AtrExpLagRounded array

  ATRex = ATRexRounded[i]; // Reference a value in the array


  { 

  if (i<=0) 

  y=ATRexRounded[i];

  else 

  y=ATRexRounded[i-1]; 


  }

  if (sig.IsEntry() && sig.IsLong()) // Process long entries


  {

  sharesize=round(((Heat*bo.cash)/(y*ATRmultiplier))/250)*250; // i.e. 
computing # of shares/contracts



  // sig.possize=sharesize*sig.price;


  //Sharesize formula needs to be modified for stocks if lot size differs!!


  sig.possize=-2000 - sharesize; // i.e. setting back # of shares into signal 
object!! Possize must be < "-2000"

  // to mean # of shares (see "Setpositionsize")!!


  bo.EnterTrade(i, sig.Symbol, True, sig.Price, sig.PosSize);

  // wird hier die cash position durch Eingehen des Trades bereits autom. auf 
neuen Stand gebrachtoder muß das eigens codiert werden?

  //Das mittels addcustometric (cash position prüfen)!

  // oder müßten die Adcustommetric erst nach sämtl. long- und short signalen 
stehen??

  /*

  trade.AddCustomMetric("initial equity", initial_equity); //zur Kontrolle und 
graphische Aufbereitung

  trade.AddCustomMetric("Cash position", bo.cash); 

  trade.AddcustomMetric("Position size [shares]", trade.shares);

  trade.AddCustomMetric("Position Value", sig.possize);

  */


  }

  else

  { if (sig.IsExit() && sig.IsLong()) // Process long exits (cover longs)


  //die position size muß doch hier nicht angegeben werden, da vom system 
bekannt, oder?


  bo.ExitTrade(i, sig.Symbol, sig.Price);

  // Achtung, daß bei Exits die Cash position korrekt ausgewiesen wird, oder ob 
man das manuell codieren muß

  }


  // bo.HandleStops(i); // Process programmed stops or applystop at this bar

  } // End of for loop over signals at this bar


  bo.UpdateStats(i, 1); // Update MAE/MFE stats for bar

  bo.UpdateStats(i, 2); // Update stats at bar's end

  } // End of for loop over bars

  bo.PostProcess(); // Do post-processing

  /*AddToComposite( My_total_equity, "~~~My_total_equity", "X", 
atcFlagEnableInPortfolio | atcFlagDefaults );

  AddToComposite( trade.shares,"~~~Position size [shares]", "X", 
atcFlagEnableInPortfolio | atcFlagDefaults );

  AddToComposite( sig.possize, "~~~Position Value", "X", 
atcFlagEnableInPortfolio | atcFlagDefaults );

  AddToComposite( bo.cash, "~~~Cash position", "X", atcFlagEnableInPortfolio | 
atcFlagDefaults );

  AddToComposite( Value_open_positions, "~~~Value of open positions", "X", 
atcFlagEnableInPortfolio | atcFlagDefaults );

  */

  }

  /* Exploration output*/

  AddColumn(ATRExpLagRounded,"ATRExpLagRounded",1.5);




  

Reply via email to