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

Re: Re[2]: [amibroker] Re: How to copy indicator values to Excel



PureBytes Links

Trading Reference Links

Herman,

Thanks, but I'm afraid I don't follow you.

To clarify, what I'd like to do is take the equity curve data
(primarily total portfolio value)  from portfolio backtests of multiple
different systems and then import that data Excel so I can plot those equity
curves together and compare them or blend the curves.

Does that make sense?

Thanks.


On 2/12/07, Herman <psytek@xxxxxxxx> wrote:
>
>    Running your system from an indicator and plotting all equities
> simultaneously on your chart is far easier.
>
>
> best regards,
> herman
>
>
> Monday, February 12, 2007, 1:42:35 PM, you wrote:
>
>
>    >
>
> Lester,
>
>
>
> Thanks.
>
>
>
> Now...what I'd really like to do, is get the daily values for the equity
> graph out of AB and into Excel, so I can compare equity graphs between
> different systems, or even combine them to see how the blended systems
> equity graph would look.
>
>
>
> I can run the backtests and export the cumulative profit to Excel and plot
> the graph of the equity growth, but the data points won't necessarily line
> up.
>
>
>
> I would really like to be able to get the equity graph values out of AB
> and into Excel and I have the notion that this should not be hard to do, but
> I have yet to see how it can be done.
>
>
>
> Any other ideas?
>
>
>
> Thanks!
>
>
>
>
> On 2/12/07, Lester Vanhoff <ebsn247lsm@xxxxxxxxxxxxx> wrote:
>
> Automatic Analysis - run your exploration - hit Export button - then
> import the CSV file to Excel.
>
>
> Lester
>
>
> --- In amibroker@xxxxxxxxxxxxxxx <amibroker%40yahoogroups.com>, "ges"
> <ges8ges@xxx> wrote:
>
> >
>
> > I have a feeling this is a stupid question as I think it must be easy
>
> > to do, but I can't figure it out...
>
> >
>
> > How can I copy the values for an indicator (or more to the point, the
>
> > values for an equity graph) to Excel for further analysis?
>
> >
>
> > I want to get the numeric values out of AB and copy them over to the
>
> > spreadsheet.
>
> >
>
> > Thanks,
>
> >
>
> > ges
>
> >
>
>
>
>
>
> 
>

Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.17.37/682 - Release Date: 2/12/2007 1:23 PM