[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Probability for the Student t-distribution (TDIST Excel function)


  • Date: Wed, 13 Jan 2010 21:55:03 -0000
  • From: "mkecera" <mkecera@xxxxxxxxx>
  • Subject: [amibroker] Re: Probability for the Student t-distribution (TDIST Excel function)

PureBytes Links

Trading Reference Links

Well, 

I have a custom backtest code with tstat as performance metric. Maybe you can use that as starting point. But check it carefully as I havent used it for a while and just copy/pasted it.

/* First we need to enable custom backtest procedure and 
** tell AmiBroker to use current formula 
*/ 

SetCustomBacktestProc(""); 

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

bo = GetBacktesterObject(); 
bo.Backtest(); // run default backtest procedure 
st = bo.GetPerformanceStats(0); // get stats for all trades 
	
Sumx=0;
smx2=0;

for( trade = bo.GetFirstTrade(); trade; trade = bo.GetNextTrade() ) 
	{ 
	x = trade.GetProfit();
	sumx+=x;
	smx2+=x*x;
	}
	
xpriem=st.GetValue("AllAvgProfitLoss");
x2priem=smx2/st.GetValue("AllQty");
xpriem2=st.GetValue("AllAvgProfitLoss")^2;
standarddeviation=sqrt(x2priem-xpriem2);

tstat = (xpriem/standarddeviation)/sqrt(st.GetValue("AllQty"))*1000000;//multiplied to be seen in report 
//custom = st.GetValue("netprofit")*st.GetValue("kratio");
    
bo.AddCustomMetric( "tstat", tstat );
//bo.AddCustomMetric( "custom", custom ); 
} 

Regards,

MK

// your trading system here 

--- In amibroker@xxxxxxxxxxxxxxx, "diznyc@xxx" <ground@xxx> wrote:
>
> Hello all,
> 
> What is the best (easiest) way to calculate probability for the Student t-distribution in AFL (analog of TDIST Excel function)?
> 
> Is it possible to call Excel function somehow from AFL or other external statistical library?
> 
> Thank you in advance,
> 
> Denis.
>




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

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    amibroker-digest@xxxxxxxxxxxxxxx 
    amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/