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

[amibroker] Re: Cumulative Profits Column



PureBytes Links

Trading Reference Links

Dale,

When I open the *.csv in XL, "Profit" is in Column G rather than
column H. (That raises another issue since I am developing a Trade
Analyzer system for AB *.csv export files, and I assumed that the
*.csv file format would be the same everywhere.)

But back to the subject...

1st row of a backtest that included 7900+ trades:

Ticker	Trade	Date	Price	Ex. date   Ex. Price  % chg.	Profit	AA     
Short 8/28/2002	15.26	9/10/2002   14.62     -4.20%    814.6	

% Profit Shares	Position value	Cum. Profit	# bars	
4.00%	  1310	19990.6	         1370.21	9

I don't know how the above will appear in the message board post, but
the Profit column has 814.6, while the Cum. Profit column had 1370.21.

So the Profit and Cum.Profit columns are not the same.

Phsst
--- In amibroker@xxxxxxxxxxxxxxx, "dingo" <dingo@xxxx> wrote:
> It's the sum of column H ( the column with the heading "profit") if you
> load the csv into Xl.
> 
>  
> 
> d
> 
>  
> 
> -----Original Message-----
> From: phsst [mailto:phsst@x...] 
> Sent: Thursday, April 10, 2003 9:00 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Cumulative Profits Column
> 
>  
> 
> When you "Export" the trades from a backtest to an *.csv file there is
> a column within that *.csv file called "Cum. Profits".
> 
> Does anyone know what that figure really represents?
> 
> Phsst
> 
> 
> 
> 
> 
> 
> Yahoo! Groups Sponsor
> 
> 
> 
> Advertisement
>  
> <http://rd.yahoo.com/M=234802.3136267.4457259.1769302/D=egroupweb/S=1705
> 632198:HM/A=1517805/R=0/*http:/www.scottrade.com/index.asp?supbid=16013>
> No Fee IRAS!
> 
> 
>  
> <http://us.adserver.yahoo.com/l?M=234802.3136267.4457259.1769302/D=egrou
> pmail/S=:HM/A=1517805/rand=754621894> 
> 
> 
> Send BUG REPORTS to bugs@xxxx
> Send SUGGESTIONS to suggest@xxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
> 
> Your use of Yahoo! Groups is subject to the Yahoo!
> <http://docs.yahoo.com/info/terms/>  Terms of Service.


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get a FREE REFINANCE QUOTE - click here!
http://us.click.yahoo.com/2CXtTB/ca0FAA/i5gGAA/GHeqlB/TM
---------------------------------------------------------------------~->

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

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