export of equity

immy

New Member
#1
I see no option to export backtest equity to other programs like excel. I mean day by day data of equity value.
Is it any way to do it or I need special code in AFL formula?

thanks!
 

trash

Well-Known Member
#2
The Analysis result list can be exported by copying and pasting it directly into Excel or any text editor. Besides that there is an option to save the result as csv or html. In new auto analysis go to File->Export HTML/CSV. In old auto analysis go to File -> Export button
 

immy

New Member
#3
I'm not sure if I was understood right.
I don't want to copy/paste backtest report.

What I need to export is equity appearing under main chart after each backtest. It's given day by day. If I try to use right mouse button but there is no option to copy. Using file->export also doesn't work.
 

trash

Well-Known Member
#4
In the backtest report there is a column "Cum Profit". If you add that to the initial equity you have the overall equity! All other columns copied to excel can be deleted if you don't need them.

File -> Export does work! You just don't know what you are doing.
And as already explained you don't need csv export. Just copy and paste the result list directly into Excel and then as explained add initial equity to each cum profit cell.

But of course there is another way if you just need daily Equity then use this code in Exploration.
Code:
format   = 1.2; 
Colfont  = colorLightGrey;
Colcell  = colorDarkGrey; 

SetOption("NoDefaultColumns", True);
SetSortColumns( 2 );
AddTextColumn(Name(),"Ticker", 1.0, Colfont, Colcell, 65);
AddColumn(DateTime(), "Date/Time", formatDateTime, Colfont, Colcell, 115);
AddColumn(C, "Close", format, Colfont, Colcell, 65);

Filter = 1;
and as symbol choose ~~~EQUITY and in backtest preferences choose Daily periodicity
Then again copy and paste the result list into Excel. If you are capable enough to understand what I'm talking about.
 

immy

New Member
#5
In the backtest report there is a column "Cum Profit". If you add that to the initial equity you have the overall equity! All other columns copied to excel can be deleted if you don't need them.
"Cum profit" gives equity vaules only during days of the closing of the trades, not day by day.

But of course there is another way if you just need daily Equity then use this code in Exploration.
Perfect! That's what I was looking for - equity vaules day by day.
Many thanks Trash!
 

immy

New Member
#6
Trash,

If you are so kind, let me ask you one more question:
do you know how to combine P/L from 2 systems in one equity under ~~~EQUITY?
I mean I backtest Donchian CHannel and Open Range Breakout on same one stock and in same time (50% of equity to each system). And want to see one combined equity from both to know combined drawdown and total P/L.

Many thanks for your time and kindness anyway!