|
PureBytes Links
Trading Reference Links
|
the
answer to your first question: Go into the settings and on the report tab
uncheck the the formula box in the Reporting options. That will prevent the
formula from being emitted.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>d
<FONT
face=Tahoma size=2>-----Original Message-----From: jnk1997
[mailto:jnk1997@xxxxxxxxx] Sent: Saturday, May 31, 2003 1:21
PMTo: amibroker@xxxxxxxxxxxxxxxSubject: [amibroker] Re:
Walt: Question on Sharing AB Database (File
Splitter)OK, I figured it out. When I export from AB
to the alldata.csv file I get the following (opened with
notepad):Formula used:,"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;"Scan/Exploration
Results:Ticker,Date/Time,open,high,low,close,volume,INSP,05/01/2003,12.3600,13.4500,12.3500,12.8900,1194300INSP,05/02/2003,11.5500,12.0900,11.1500,11.8500,1619200INSP,05/05/2003,11.9000,12.3500,11.4500,11.5600,834700INSP,05/06/2003,11.5000,11.8400,11.2100,11.5200,449300INSP,05/07/2003,11.4000,11.8300,11.4000,11.5900,463400INSP,05/08/2003,11.5900,11.8100,11.5200,11.5900,357800INSP,05/09/2003,11.5600,11.8500,11.5500,11.7000,272000INSP,05/12/2003,11.7000,12.0000,11.7000,11.9100,385400...............................................................When
I remove everything except the lines of data prefixed by the ticker, you
file splitter works perfectly and has created the correct
files.Questions:1) How do I get AB to export just the
ticker and data (without the formula)?2) Since I will be doing
this everyday in order to update this "outside" database, I imagine I will
have to repeat the entire process (historical range to today) and then
"overwrite the existing alldata.csv file (historical range to yesterday)
before splitting with your formula?3) When I use your splitting
formula in Indicator builder, we must click on apply, then a blank
indicator pane opens up on the screen (no problem) I just delete that
pane. I assume this is normal (as the proper .csv files have been
created).Many thanks Walt,
Jim--- In
amibroker@xxxxxxxxxxxxxxx, walt <WSCHWARZ@xxxx> wrote:> Just
tried it again and it seems to work...> > Make sure that the
file spec and the directory exists.> > If the directory is not
there or if the directory spec is not correct,> pehaps missing a
slash, the file cannot be opened...> > Also if the ticker has an
odd character that I did not replace, it will also> fail...>
>
Walt> -----Original Message-----> From:
jnk1997 [mailto:jnk1997@xxxx]> Sent: Saturday, May 31, 2003
12:25 PM> To: amibroker@xxxxxxxxxxxxxxx>
Subject: [amibroker] Re: Walt: Question on Sharing AB Database
(File> Splitter)> > >
Walt,> > When I click apply in Indicator Builder I
get> > Source: Microsoft VBScript runtime
error> Line: 99 Char:
1> Error: 0 - Object required: 'lo_txt'>
> Jim> > > >
> --- In amibroker@xxxxxxxxxxxxxxx, walt
<WSCHWARZ@xxxx> wrote:> > Yes, and you can set
"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...> >>
> Walt>
> -----Original Message----->
> From: jnk1997 [mailto:jnk1997@xxxx]>
> Sent: Saturday, May 31, 2003 12:04 PM>
> To: amibroker@xxxxxxxxxxxxxxx>
> Subject: [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.csv> >>
> If I understand correctly I change the following in your
formula:> >> >
as_filename = "c:\out.csv" becomes
"c:\StockData\alldata.csv"> >>
> and> >>
> as_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.>
>> >>
> 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.
|