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

RE: [amibroker] Re: Signals on daily charts from data ONLY available monthly.



PureBytes Links

Trading Reference Links

It works on my system 4.70.5 or 4.75.12

See screen shots.

 

After the above screen I see the filename listed as C:\Program Files\Amibroker\filename.csv. Clicking next gets this screen.

 

--

Terry

-----Original Message-----
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of sebastiandanconia
Sent: Thursday, January 12, 2006 08:11
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re: Signals on daily charts from data ONLY available monthly.

 

I appreciate the help, Terry (Joe and Graham, as well), and I've been

trying to use the import wizard, but after I select the file and

click to open it, it doesn't show up in the box "You have selected

the following file(s):".  Instead, a black cursor flashes in the box,

but doesn't allow me to do anything.  I seem to be following both

your instructions and the instructions in "Help," but the process

just stops dead right there.  Did I miss a step?  Do I need to save

the source file in a particular place, and not just on my Desktop (or

wherever)?  Or do you think I've run into something I should elevate

to Support?

 

 

Luck,

 

Sebastian

 

 

--- In amibroker@xxxxxxxxxxxxxxx, "Terry" <MagicTH@xxxx> wrote:

>

> All you need is the signals in an Excel file.

>

> Name the excel file something appropriate for a symbol name.

>

> In the case of Timing Cube, I used TCube

>

> Column A has your dates

>

> Column B has 0, 1 or 2

>

> Save As and choose .csv file.

>

> In AB choose Import Wizard under File

>

> Select TCube.csv, make the first column the date in M/D/Y or

however you

> saved it.

>

> Make the 2nd column the Close

>

> Make all other columns = Skip

>

> If you made a header line like Date, Close skip the first 1 lines of

> data.

>

> Finish.

>

>

> Here's my Timing Cube file. I used -1 for Shorts. There are no Cash

> signals. Just match your AB code accordingly.

>

>

> Date

>

> Trade

>

>

> 3/10/1999

>

> 1

>

>

> 3/29/2000

>

> -1

>

>

> 5/30/2000

>

> 1

>

>

> 9/22/2000

>

> -1

>

>

> 1/10/2001

>

> 1

>

>

> 2/2/2001

>

> -1

>

>

> 4/10/2001

>

> 1

>

>

> 6/15/2001

>

> -1

>

>

> 10/3/2001

>

> 1

>

>

> 1/11/2002

>

> -1

>

>

> 5/14/2002

>

> 1

>

>

> 5/28/2002

>

> -1

>

>

> 10/17/2002

>

> 1

>

>

> 1/16/2003

>

> -1

>

>

> 3/13/2003

>

> 1

>

>

> 3/28/2003

>

> -1

>

>

> 4/2/2003

>

> 1

>

>

> 4/29/2004

>

> -1

>

>

> 10/27/2004

>

> 1

>

>

> 3/16/2005

>

> -1

>

>

> 5/11/2005

>

> 1

>

>

> 10/11/2005

>

> -1

>

>

> 10/19/2005

>

> 1

>

>

> --

>

> Terry

>

>

> -----Original Message-----

> From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx]

On

> Behalf Of sebastiandanconia

> Sent: Wednesday, January 11, 2006 16:16

> To: amibroker@xxxxxxxxxxxxxxx

> 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

>

>

>

> Yahoo! Groups Links

>

>

>     http://groups.yahoo.com/group/amibroker/

>

>

>     amibroker-unsubscribe@xxxxxxxxxxxxxxx

>

>

>     http://docs.yahoo.com/info/terms/

>

 

 

 

 

 

 

 

------------------------ 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/

 

 



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