|
Sebastian:
I've used CSV (comma separated variable) files to be
read by an AFL routine and
you probably know that Excel files can be saved as
CSV.
There are file functions in AB that are 'callable' from
your AFL
(saying callable dates me as a dinosaur doesn't
it?)
Hope this helps
Joe Landry
----- Original Message -----
Sent: Wednesday, January 11, 2006 5:16
PM
Subject: [amibroker] Re: Signals on daily
charts from data ONLY available monthly.
Well, it sounds cool, but I have one last semi-embarrassing
question: How does one convert data from Excel into an ASCII or text
file useable by AB? Are there conversion tools available to do that,
should I write a macro that will do it for me or
what?
Luck,
Sebastian
--- In amibroker@xxxxxxxxxxxxxxx, "Terry"
<MagicTH@x...> wrote:
>
>
Yes. Works great. I suggest 1 for Long, 2 for Short, 0 for Cash. I
used
> to use -1 for short and I still convert it in AFL, but you
cannot
ADD a
> negative price using Quote Editor.
> --
>
Terry
>
> -----Original Message-----
> From:
amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx]
On
>
Behalf Of sebastiandanconia
> Sent: Wednesday, January 11, 2006
11:12
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Re:
Signals on daily charts from data ONLY
> available monthly.
>
> Fabulous, Terry, thanks.:)
>
> Re: TimingCube, you
mean like if I took the dates on which they
> (claim to have) made
trades, I could use them to run a test in AB?
> If so, just add a
"1" or a "0" in one of the data-fields (or
> something along that line)
for the signals?
>
>
> S.
>
> ---
In amibroker@xxxxxxxxxxxxxxx, "Terry" <MagicTH@xxxx> wrote:
>
>
> > AB will fill all "holes" with the most recent value,
provided you
> don't
> > disable this option in
Foreign.
> >
> > This also works great if importing a
foreign timing signal to test
> > (e.g., TimingCube).
> >
--
> > Terry
> > -----Original Message-----
> >
From: amibroker@xxxxxxxxxxxxxxx
[mailto:amibroker@xxxxxxxxxxxxxxx]
> On
> > Behalf Of sebastiandanconia
> > Sent:
Wednesday, January 11, 2006 08:42
> > To:
amibroker@xxxxxxxxxxxxxxx
> > Subject: [amibroker] Signals on daily
charts from data ONLY
> available
> > monthly.
> >
> > If a piece of data that is only available monthly (like CPI,
> > unemployment rate, etc.) is imported into AB, is it possible to
use
> > it as-is for system tests/chart signals on daily
data?
> >
> > Example: I have CPI, PPI, unemployment
rate, etc., in Excel with
> > monthly data-points of 1/1/05, 2/1/05,
3/1/05, 4/1/05, etc. Can
I
> > import this data in monthly
format and will AB simply pick up the
> > last appropriate
data-point for month and year on any system
tests?
> > Or should
I artificially "expand" my data in Excel, such that
> 1/1/05,
>
> 1/2/05, 1/3/05, 1/4/05, etc., all have the same monthly value?
>
>
> > Or can FIXUP be used to solve this disparity in the
periodicity
of
> > the data?
> >
> > If
anyone knows of any systems in the library that address this,
or
>
> of any discussion here that does so, I'd be grateful if they
could
> > point me there. Or if AB automatically takes care of this
issue,
> > that would be helpful to know, also, LOL!
> >
> >
> > Luck to all,
> >
> >
Sebastian
> >
> >
> >
> >
> >
> >
> > 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 other support material please
check also:
> > http://www.amibroker.com/support.html
>
>
> >
> > Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
> 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 other
support material please check also:
> http://www.amibroker.com/support.html
>
>
> Yahoo! Groups
Links
>
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 other support material please check also:
http://www.amibroker.com/support.html
SPONSORED LINKS
YAHOO! GROUPS LINKS
|