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

RE: [amibroker] Re: Cumulative Profits Column



PureBytes Links

Trading Reference Links









What version of Amibroker are you running
and is it the realtime version?  I don’t know why you don’t
have the symbol in the first column of the CSV file.  Did you run a back
test and then click the export button to create it?

 

As to Cum Profit.  The Letters Cum
mean Cumulative or Sum.

 

go down the Profit column keep a running
total of the profits. That running total is what is in the Cum profit
column.  

 

I can’t tell from what you posted
what you’ve got. Why don’t you use a text editor and cut the first
10 data lines from the csv file (starting at line number 4) and attach them to
a msg and I’ll take a look at it.

 

d

 

<span
>-----Original Message-----
From: phsst
[mailto:phsst@xxxxxxxxx] 
Sent: Thursday, April 10, 2003
10:12 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re: Cumulative
Profits Column

<span
> 

<span
>Dale,<span
>

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@xxxx] 
> 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
>  
> <<a
href="">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!
> 
> 
>  
> <<a
href="">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: <a
href="">http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at:
> <a
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html

> 
> Your use of Yahoo! Groups is subject to the
Yahoo!
> <<a
href="">http://docs.yahoo.com/info/terms/> 
Terms of Service.





<font size=2
face="Courier New">Send BUG REPORTS to
bugs@xxxxxxxxxxxxx<span
>
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to:
amiquote@xxxxxxxxxxxxxxx 
(Web page: <a
href="">http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: <a
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html


Your use of
Yahoo! Groups is subject to the Yahoo!
Terms of Service. 










Yahoo! Groups Sponsor


  ADVERTISEMENT









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 the Yahoo! Terms of Service.