|
PureBytes Links
Trading Reference Links
|
<FONT
size=2>Yes, and you can set "<FONT face="Courier New"
color=#000000>ab_excludeTick" to true, if you do not need the ticker in the
first column of every line or false to piut the ticker on every
line...
<FONT face="Courier New"
size=2>
<FONT
size=2> <FONT
face="Courier New">Walt
<FONT face=Tahoma
size=2>-----Original Message-----From: jnk1997
[mailto:jnk1997@xxxxxxxxx]Sent: Saturday, May 31, 2003 12:04
PMTo: amibroker@xxxxxxxxxxxxxxxSubject: [amibroker] Re:
TJ or Group: Question on Sharing AB Database (File
Splitter)Ok, I exported data for 4 stocks (for 1
month) into one file to try this out.Data exported to a new folder
& file C:\StockData\alldata.csvIf I understand correctly I
change the following in your formula:as_filename = "c:\out.csv"
becomes "c:\StockData\alldata.csv"andas_directory =
"d:\stocks\" becomes "c:\StockData\"Are these the required
changes?Thanks for your
help!Jim--- In
amibroker@xxxxxxxxxxxxxxx, walt <WSCHWARZ@xxxx> wrote:>
jim,> > after you export the file run this script from the
indicator builder and it> will split the exported file into
separate files for you...> Note: Change the "filename" & directory
to suit...>
>
Walt> >
//*****************************************************>
EnableScript("vbscript");> > <%> >
ab_excludeTick = True> > as_filename = "c:\out.csv">
> as_directory = "d:\stocks\"> > Set io_fso =
CreateObject("Scripting.FileSystemObject")> > Set lo_txtAll =
io_fso.OpenTextFile(as_filename)> > ls_lastTick = "">
> ls_line = lo_txtAll.ReadLine()> > ls_line =
lo_txtAll.ReadLine()> > do while Len(Ls_line)>0>
> ls_items = Split(ls_line, ",")> > if UBound(ls_items) =
6 Then> > if ls_items(0) <> ls_lastTick Then>
> if Len(ls_lastTick) > 0 Then> > lo_txt.Close>
> End if> > ls_curTick = Trim(ls_items(0))>
> ls_curTick = Replace(ls_curTick, "^", "")> > ls_curTick
= Replace(ls_curTick, "$", "")> > ls_curTick =
Replace(ls_curTick, "\", "")> > ls_curTick = Replace(ls_curTick,
"/", "")> > ls_curTick = Replace(ls_curTick, "?", "")>
> Err.Clear> > 'On Error Resume Next> > Set
lo_txt = io_fso.OpenTextFile(as_directory + ls_curTick + ".csv", 2,
-1)> > lb_fileOpen = (Err = 0)> > End if>
> if lb_fileOpen Then> > ls_lastTick = ls_curTick>
> if ab_excludeTick Then> > ls_line = Replace(ls_line,
ls_curTick + ",", "")> > do while NOT IsNumeric(Left(ls_line,
1))> > ls_line = Right(ls_line, Len(ls_line) - 1)>
> Loop> > End if> > lo_txt.writeline
ls_line> > End if> > End if> >
err.Clear> > on error resume next> > ls_line =
lo_txtAll.ReadLine()> > if err=62 then exit do> >
Loop> > lo_txt.Close> > lo_txtAll.Close>
> %>> > -----Original
Message-----> From: jnk1997
[mailto:jnk1997@xxxx]> Sent: Saturday, May 31, 2003 9:41
AM> To: amibroker@xxxxxxxxxxxxxxx>
Subject: [amibroker] Re: TJ or Group: Question on Sharing AB Database
-> Bob> > > I still don't get
it.> > Can I run that exploration on all stocks in
Amibroker database for a> period of 2 years for
example, export to one .csv file named> ALLStocks. Then,
Import that file as my database in the other>
program?> Or do I have to save the data stock by stock
(seperate file for each> stock?)and have all those
individual data files in a folder named> ALLStocks?>
> > Thanks> Jim> >
> > > > > --- In
amibroker@xxxxxxxxxxxxxxx, "Bob Jagow" <bjagow@xxxx>
wrote:> > That's the old form--like using GraphN instead
of plot().> > Easier to use> >
Filter = 1; /* all stocks and quotes accepted */> >
addcolumn(O,"open",1.4);> >
addcolumn(H,"high",1.4);> >
addcolumn(L,"low",1.4);> >
addcolumn(C,"close",1.4);> >
addcolumn(V,"volume",1.0);> >> >
Bob> >> >>
>> > -----Original
Message-----> > From: walt
[mailto:WSCHWARZ@xxxx]> > Sent: Friday, May
30, 2003 5:29 PM> > To:
amibroker@xxxxxxxxxxxxxxx> > Subject: RE:
[amibroker] Re: TJ or Group: Question on Sharing AB>
Database> >> >>
> Jim,> >>
> I found this code in the helpf ile; Run it in the AA
"explore"> and then use the "export" button. Then "import"
it into your> > program...>
>>
>
Walt> >> >>
>> > Filter = 1; /* all stocks and quotes
accepted */> >> >
NumColumns = 5;> >> >
Column0 = Open;> >> >
Column1 = High;> >> >
Column2 = Low;> >> >
Column3 = Close;> >> >
Column4 = Volume;> >>
> Column0Name = "open";>
>> > Column1Name =
"high";> >> >
Column2Name = "low";> >>
> Column3Name = "close";>
>> > Column4Name =
"volume";> >> >
Column0Format = 1.4;> >>
> Column1Format = 1.4;>
>> > Column2Format =
1.4;> >> >
Column3Format = 1.4;> >>
> Column4Format = 1.0;>
>> > -----Original
Message-----> > From: jnk1997
[mailto:jnk1997@xxxx]> > Sent:
Friday, May 30, 2003 6:50 PM> >
To: amibroker@xxxxxxxxxxxxxxx> >
Subject: [amibroker] Re: TJ or Group: Question on Sharing
AB> Database> >>
>> > Sorry,
Right!> > I use AmiQuote to
retreive eod data from Yahoo.> >
Thanks> >
Jim> >> >>
>> > --- In
amibroker@xxxxxxxxxxxxxxx, "Chuck Rademacher">
> <chuck_rademacher@x>
wrote:> > > Jim, you told us
what kind of data Forecaster Plus can read> and
we> > know
what> > > kind of data AB can
read. What we don't know (in order to>
help> > you)
is> > > what kind of data you
already are using.> >
>> > > With that long list
of data types that Forecast Plus is able>
to> > use,
I'm> > > reasonbly sure you
will be able to share data between the two>
> software>
> > packages.>
> > -----Original
Message-----> > >
From: jnk1997 [mailto:jnk1997@xxxx]>
> > Sent: Friday, May 30, 2003 6:17
PM> > > To:
amibroker@xxxxxxxxxxxxxxx> >
> Subject: [amibroker] TJ or Group: Question on Sharing
AB> Database>
> >>
> >>
> > I received an interesting
software CD with my renewal to> TASC.>
> > It is called Pattern Forecaster
Plus by Matheny www.ment.com>
> > The software does not include a
downloader but will read the>
> > following file
types:> >
>> > > How can
I set up AB to share my database?>
> >>
> > Pattern Forecaster Reads the
following data files formats:>
> >>
> > PFP/StockVue File
Types> > >
Technical Tools File Types> >
> FutureSource File Types>
> > FutureLink/SuperCharts File
Types> > >
MetaStock/Computrak File Types>
> > Megatech/Knight Ridder File
Types> > >
Telescan ASCII file Types> >
> DBC Signal File Types>
> > Worden Brothers TC2000 File
Types> > > AIQ
ASCI File Types> >
> Apex (CandlePower) File Types>
> > Aspen Graphics ASCII File
Types> > >
TradeStation ASCII File Types> >
> Live Wire ASCII File Types>
> > Dial Data ASCII File
Types> >
>> > >
Thanks> > >
Jim> > >>
> >>
>
> Yahoo! Groups
Sponsor> >
>> > >>
> >>
> >>
> >>
> > Send BUG REPORTS to
bugs@xxxx> > >
Send SUGGESTIONS to suggest@xxxx>
> >
----------------------------------------->
> > Post AmiQuote-related messages
ONLY to:> amiquote@xxxxxxxxxxxxxxx>
> > (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)>
> >
-------------------------------------------->
> > Check group FAQ
at:> > > <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html>
> >>
> > Your use of Yahoo! Groups is
subject to the Yahoo! Terms of>
> Service.>
>> >> >>
> Send BUG REPORTS to bugs@xxxx>
> Send SUGGESTIONS to
suggest@xxxx> >
----------------------------------------->
> Post AmiQuote-related messages ONLY to:
amiquote@xxxxxxxxxxxxxxx> >
(Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)>
>
-------------------------------------------->
> Check group FAQ at:> <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html>
>> > Your use of Yahoo!
Groups is subject to the Yahoo! Terms of>
Service.> >> >>
> Yahoo! Groups
Sponsor> >> >>
>> > Send BUG REPORTS to
bugs@xxxx> > Send SUGGESTIONS to
suggest@xxxx> >
-----------------------------------------> >
Post AmiQuote-related messages ONLY to:
amiquote@xxxxxxxxxxxxxxx> > (Web page:
<A
href="">http://groups.yahoo.com/group/amiquote/messages/)>
>
-------------------------------------------->
> Check group FAQ at:> <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html>
>> > Your use of Yahoo! Groups is subject
to the Yahoo! Terms of> Service.> >
> Yahoo! Groups
Sponsor> > > > Send BUG REPORTS to
bugs@xxxx> Send SUGGESTIONS to
suggest@xxxx>
-----------------------------------------> Post
AmiQuote-related messages ONLY to:
amiquote@xxxxxxxxxxxxxxx> (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)>
--------------------------------------------> Check group
FAQ at:> <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.Send
BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Yahoo! Groups Sponsor
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|