|
PureBytes Links
Trading Reference Links
|
Sebastian
If you have the data set up in columns in excel then save as .CSV file
Only the first worksheet will save to the CSV file and no fancy
formatting as it is only a text file
--
Cheers
Graham
AB-Write >< Professional AFL Writing Service
Yes, I write AFL code to your requirements
http://e-wire.net.au/~eb_kavan/ab_write.htm
On 1/12/06, cstrader <cstrader232@xxxxxxxxxxxx> wrote:
>
> Sebastian.
>
> What you should do is to create a "fake" "symbol" file that has your buy and sell signals. Put them in as either HLO or C. Use the import command to read it in (if you use -1 to indicate a sell then be sure to allow negative prices). Give it a name like 'buysellsignals'. Then you can read those signals in using the foreign() function. This has been discussed a few times in the past.
>
> chuck
>
> ----- Original Message -----
> From: Joe Landry
> To: amibroker@xxxxxxxxxxxxxxx
>
> Sent: Wednesday, January 11, 2006 6:26 PM
> Subject: Re: [amibroker] Re: Signals on daily charts from data ONLY available monthly.
>
>
> 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 -----
> From: sebastiandanconia
> To: amibroker@xxxxxxxxxxxxxxx
> 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@xxxx> 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
> Investment management software Real estate investment software Investment property software
> Software support Real estate investment analysis software Investment software
>
> ________________________________
YAHOO! GROUPS LINKS
>
>
> Visit your group "amibroker" on the web.
>
> To unsubscribe from this group, send an email to:
> amibroker-unsubscribe@xxxxxxxxxxxxxxx
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> To unsubscribe from this group, send an email to:
> amibroker-unsubscribe@xxxxxxxxxxxxxxx
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> ________________________________
------------------------ Yahoo! Groups Sponsor --------------------~-->
Try Online Currency Trading with GFT. Free 50K Demo. Trade
24 Hours. Commission-Free.
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/GHeqlB/TM
--------------------------------------------------------------------~->
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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> 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/
|