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

[amibroker] Re: ASCII import, from two files, relational database like



PureBytes Links

Trading Reference Links


Tomasz, I enjoy working with your program tremendously, but I have to 
say, this particular matter is one of the very few nuisances I 
experienced with it.

I just tried to combine specifically the two .csv files mrmurty 
provided using the $HYBRID 1 flag on the second import, then on the 
first import as well, I reversed the import order (second file 
first), even tried adding several combinations of the $NOQUOTES, 
$ALLOWNEG and $STRICT flags, but bottom line: I can't get it
done.  

If you'd be so kind to quote the text of the .format files to be
used 
to merge these two imports I'll take a deep bow and stand
corrected.  

-treliff

--- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <amibroker@xxxx> 
wrote:
> Hello,
> 
> It does EXACTLY what the manual says.
> 
> "0 (off) or 1 (on). When this flag is set, you can combine 
quotations from multiple files - for example one file can contain 
only 
> open prices and volume and the other file can contain 
high/low/close data. Useful especially for Warsaw Stock Exchange for 
combining 
> the data from fixing and later continuous quotations."
> 
> It does what is described and nothing more nothing less.
> 
> Best regards,
> Tomasz Janeczko
> amibroker.com
> ----- Original Message ----- 
> From: "treliff" <treliff@xxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Sunday, February 13, 2005 3:02 AM
> Subject: [amibroker] Re: ASCII import, from two files, relational 
database like
> 
> 
> >
> >
> > I feel your pain. Had a similar issue and after hours wasted
> > combining different flags like $HYBRID (which simply doesn't do as
> > the manual says) finally decided to write a macro to combine the
> > files. Wish I had done that immediately.
> >
> > -treliff
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "mrmurty" <mrmurty@xxxx> wrote:
> >>
> >> I have two  files as shown here. I have to merge them.
> >> Cumbersome  to edit and paste in excel, as several tickers in a 
day.
> >> any idea.
> >>
> >> rgds
> >>
> >>
> >> file1.csv
> >> Ticker Date/Time open high low close volume
> >> ACC 2/7/2005 373.1 376.95 366.2 368.1 9544
> >> ACC 2/8/2005 367.9 375.65 365 371.7 9259
> >> ACC 2/9/2005 372.55 378.45 371.15 377 6882
> >> ACC 2/10/2005 378.5 386.3 377.55 381.85 11614
> >>
> >> file2.csv
> >> Ticker Date/Time oi
> >> ACC 2/7/2005 6511500
> >> ACC 2/8/2005 6687000
> >> ACC 2/9/2005 7029000
> >> ACC 2/10/2005 7456500
> >>
> >> desired file
> >> Ticker Date/Time open high low close volume
> > oi
> >> ACC 2/7/2005 373.1 376.95 366.2 368.1 9544
> >> 6511500
> >> ACC 2/8/2005 367.9 375.65 365 371.7 9259
> >> 6687000
> >> ACC 2/9/2005 372.55 378.45 371.15 377 6882
> >> 7029000
> >> ACC 2/10/2005 378.5 386.3 377.55 381.85 11614
> >> 7456500
> >
> >
> >
> >
> >
> >
> > Check AmiBroker web page at:
> > http://www.amibroker.com/
> >
> > Check group FAQ at: 
http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >





------------------------ Yahoo! Groups Sponsor --------------------~--> 
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.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/