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

[amibroker] Re: How to Backtest Signals Imported from External File?



PureBytes Links

Trading Reference Links

Joel,

>From memory the plugin is not so good with CSV files but no harm in 
trying - it is recommended to use Access or SQL.

There was some talk of another CSV plugin - re an earlier message 
from Patrick who put the push behind the plugins:

"The CSV plug-in" ....was developed by TJ at my request, and was kind 
of the front-runner for the current ODBC plugin. Ask support for 
details.

If you get it working OK with CSV and can fit in a quick report back 
here that would be good.

Also there was talk of the ODBC being able to access only one field - 
Tomasz said the next version of it would improve on that - I'm not 
sure if that happened yet.

Cheers,

Brian_z



--- In amibroker@xxxxxxxxxxxxxxx, "onlyobsession2k3" <jmpatton@xxx> 
wrote:
>
> Thanks. I'm already actually using the OI field for other data. Plus
> this is for more of a side experiment so I want to keep my main data
> clean.
> 
> I wasn't aware of the ODBC plugin. I think that will suit my needs,
> especially since I can connect it directly to .csv files.
> 
> Thanks for the info!
> 
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "brian_z111" <brian_z111@> wrote:
> >
> > Hello Joel,
> > 
> > Another way?
> > If you are adventurous! (I don't give money back guarantees 
though).
> > 
> > Add a third column to your signal as data e.g. 1 or a value that 
> > quantifies the strength of your signal.
> > 
> > ASCII import the 'data' into the OI field (the data will enter as 
> > symbol specific and only have a value for the symbol on the day 
of 
> > your signal).
> > 
> > (The OI field has no use outside of futures trading - for equity 
> > traders it is a 'spare' field - lots of traders stuff things into 
it).
> > 
> > If it is a long term ongoing project, with your signals 
continually 
> > updating, the ODBC plug in should give you dynamic access to your 
> > signal from an external file (Access or SQL).
> > 
> > Cheers,
> > 
> > Brian_Z
> > 
> > --- In amibroker@xxxxxxxxxxxxxxx, "onlyobsession2k3" <jmpatton@> 
> > wrote:
> > >
> > > Hello, does anyone know how to do this?
> > > 
> > > I have an externally-generated list of Trades in a .csv file, 
e.g.:
> > > 
> > > Signal Date,Symbol
> > > 2007-11-01,GOOG
> > > 2007-11-02,AAPL
> > > 2007-11-03,INTC
> > > 
> > > I'd like to import these signals into the backtester so that I 
test
> > > the performance of entering trades only on these dates for 
those 
> > symbols.
> > > 
> > > I'm guessing I need some method of converting the file into an
> > > Amibroker signal variable/array for each symbol, but I have no 
idea
> > > where to start for this.
> > > 
> > > Any help is greatly appreciated,
> > > 
> > > Joel
> > >
> >
>




Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

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

For other support material please check also:
http://www.amibroker.com/support.html
 
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:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto: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/