|
PureBytes Links
Trading Reference Links
|
Edit for typo which I thought I fixed ...
> I'm emailing you a modified script file with your file name
inserted
> into it. Save this file to the same directory where your data file
> exists. My script looks for the following data: Ticker, marketID,
> fullname, industryID. The ID's are integers starting with 0.
>
> Example: MCOM,3,Metricom,78 The 3 puts in market ID 3 which I've
> called NASDAQ and the 78 would put into the industry group
> represented by 78 in the broker.industries file.
>
> Brett
>
>
> --- In amibroker@xxxx, acs64@xxxx wrote:
> > Brett,
> >
> > No luck. I've got the script file setup but when I try to run it
I
> > keep getting errors. First time it was ';' was expected......so
I
> > added it where I thought it might go, then it was '{' was
expected,
> > but I dont have any idea where it is missing....I dont have any
> > experience with writing this script, so I'm way in over my head.
> I'm
> > not importing from TC2000 (is that metastock or something?),
maybe
> > that has something to do with it? The name of my file to import
is
> > Tick_Mkt_Name_Ind_Sect.csv. I changed the script where I thought
> > this had to be inserted, there was also another reference to
> > filename....should I put my file name here also?
> >
> > Confused,
> >
> > Larry
> >
> > --- In amibroker@xxxx, brett_f1@xxxx wrote:
> > > Yes, I update at night. I export two data files out of TC2000
> > > into .csv files and then run two scripts from within Ami to get
> the
> > > data into it. The exports from TC2000 take about 2 minutes and
> the
> > > imports even less than that. Saving the database though takes
> > around
> > > 5 minutes. My current difficulty is assigning new tickers from
> > > TC2000 to the correct Markets and industries. I've asked
Tomasz
> if
> > > he can help me with a script to move the tickers out of Group
255
> > > into a .csv file. If I can get that, I can go through several
> > other
> > > steps to get them assigned correctly...I hope to get it all
> > automated
> > > soon!
> > >
> > > Brett
> > >
> > > --- In amibroker@xxxx, acs64@xxxx wrote:
> > > > Hey Brett,
> > > >
> > > > Yeah, it does help. When I get home I'll try it out.
There's
> a
> > > lot
> > > > of ins and outs to the program, but thanks to help from
people
> > like
> > > > you, others and Tomasz, it's a lot easier than it could be.
> Have
> > > you
> > > > updated quotes into the database? It must take awhile to do
> that
> > > > every night, or are you doing it on weekends? Thanks for the
> > help.
> > > >
> > > > Larry
> > > >
> > > > --- In amibroker@xxxx, brett_f1@xxxx wrote:
> > > > > Hi Larry,
> > > > >
> > > > > I'm new to AmiBroker as well. I guess I've just been
> pounding
> > on
> > > > my
> > > > > head a bit harder. Come to think of it now, I do have a
bit
> of
> > a
> > > > > headache today <g>.
> > > > >
> > > > > The .js file can be run from within AmiBroker or not. It
> > really
> > > > does
> > > > > not matter (if I recall correctly). To run it in
Amibroker,
> > save
> > > > the
> > > > > file in the scripts folder of Ami. Then go to tools,
> > customize.
> > > > > Click New. Give it a name. On the command line, browse to
> the
> > > > > script file you saved and highlight it. Close out. The
next
> > > time
> > > > > you go Tools menu there will be a new item listed with the
> name
> > > you
> > > > > assigned to the script file!
> > > > >
> > > > > The two broker files (sector and industries) that you
create
> > must
> > > > > first exist in the new workspace before you create the
> > database.
> > > > > There is a way around this by deleting a file but I do not
> > recall
> > > > the
> > > > > name right now...
> > > > >
> > > > > If the database is created this way, the assignments you
made
> > in
> > > > > sectors and industries will govern the setup up the
database
> > and
> > > > the
> > > > > subsequent population of the tickers and data.
> > > > >
> > > > > Does this help?
> > > > >
> > > > > Brett
> > > > >
> > > > > --- In amibroker@xxxx, acs64@xxxx wrote:
> > > > > > Hi Brett,
> > > > > >
> > > > > > I'm afraid I dont know enough about about this now to be
> able
> > > to
> > > > do
> > > > > > the import....You said the code that you supplied should
be
> > cut
> > > > and
> > > > > > paste into a .js file. How is this file started from
> within
> > > > > > Amibroker? Also, the broker.sector and broker.market
> > > files....do
> > > > > the
> > > > > > categories from within them need to match the setup in
the
> > > > database
> > > > > > file exactly? I assume they do, but not sure. I have
> setup
> > a
> > > > new
> > > > > > blank workspace. It appears the data I downloaded is the
> > same
> > > as
> > > > > the
> > > > > > file that you uploaded to the files area of this group.
I
> > can
> > > > > > understand why one wouldnt need the industry and sector
> since
> > > > they
> > > > > > are similar to each other.
> > > > > >
> > > > > > I'm new to Amibroker, so I probably need to have the most
> > basic
> > > > of
> > > > > > steps explained along the way, otherwise I'll miss
> > something.
> > > > > Thanks
> > > > > > for the help.....
> > > > > >
> > > > > > Larry
> > > > > >
> > > > > > --- In amibroker@xxxx, brett_f1@xxxx wrote:
> > > > > > > I can relate to that! I ported over my entire TC2000
> > > database
> > > > > over
> > > > > > > several times before i got it right.
> > > > > > >
> > > > > > > I suggest you first be sure that you have your
> > broker.sectors
> > > > and
> > > > > > > broker.industries files set up correctly and working in
a
> > > fresh
> > > > > > > workspace (database). Then set up your Markets by
> setting
> > up
> > > > the
> > > > > > > market names in Stock, Categories.
> > > > > > >
> > > > > > > Then cut and paste the following text into a file and
> give
> > it
> > > a
> > > > > > name
> > > > > > > with a .js extension - perhaps
ImportTickers&Industries.js
> > > > > > >
> > > > > > > /*
> > > > > > > ** AmiBroker/Win32 scripting Example
> > > > > > > **
> > > > > > > ** File: Industries.js
> > > > > > > ** Created: Tomasz Janeczko, November 26th, 2000
> > > > > > > ** Last updated: Tomasz Janeczko, December 17th, 2000
> > > > > > > ** Purpose: Import industy assignments
> > > > > > > ** Language: JavaScript (Windows Scripting Host)
> > > > > > > **
> > > > > > > ** The data is stored in lines with following format
> > > > > > > ** <ticker>,<full name>,<industry number>
> > > > > > > **
> > > > > > > ** Modified 5/6/2001 by Brett Forrester
> > > > > > > */
> > > > > > >
> > > > > > > /* script for importing TC2000 ticker, market, full
name,
> > and
> > > > > > > industry assignment number */
> > > > > > >
> > > > > > > WScript.Echo( "Script Started" );
> > > > > > >
> > > > > > > /* change this line according to your data file name */
> > > > > > > ImportStocks("tick_mkt_name_ind.csv");
> > > > > > >
> > > > > > > WScript.Echo( "Finished" );
> > > > > > >
> > > > > > > function ImportStocks( filename )
> > > > > > > {
> > > > > > > var fso, f, r;
> > > > > > > var ForReading = 1;
> > > > > > > var AmiBroker;
> > > > > > > var fields;
> > > > > > > var stock;
> > > > > > >
> > > > > > >
> > > > > > > /* Create AmiBroker app object */
> > > > > > > AmiBroker = new ActiveXObject( "Broker.Application" );
> > > > > > >
> > > > > > > /* ... and file system object */
> > > > > > > fso = new ActiveXObject
> > > ( "Scripting.FileSystemObject" );
> > > > > > >
> > > > > > > /* open ASCII file */
> > > > > > > f = fso.OpenTextFile( filename, ForReading);
> > > > > > >
> > > > > > > i = 1;
> > > > > > > /* read the file line by line */
> > > > > > > while ( !f.AtEndOfStream )
> > > > > > > {
> > > > > > > r = f.ReadLine();
> > > > > > >
> > > > > > > /* split the lines using comma as a separator
> > > */
> > > > > > > fields = r.split(",");
> > > > > > >
> > > > > > > try
> > > > > > > {
> > > > > > >
> > > > > > > /* add a ticker - this is safe
> > > operation, in
> > > > > > > case that */
> > > > > > > /* ticker already exists, AmiBroker
> > > returns
> > > > > > > existing one */
> > > > > > > stock = AmiBroker.Stocks.Add( fields[
> > > 0 ] );
> > > > > > >
> > > > > > > /* add following line - blf */
> > > > > > > stock.MarketID = parseInt( fields[
> > > 1 ] );
> > > > > > >
> > > > > > > stock.FullName = fields[ 2 ];
> > > > > > >
> > > > > > > stock.IndustryID = parseInt( fields[
> > > 3 ] );
> > > > > > > }
> > > > > > > catch( e )
> > > > > > > {
> > > > > > > WScript.echo( "There is a
> > > problem in
> > > > > > > line no." + i + ".\nThe line looks as follows:\n'" + r
> > > + "'\nIt
> > > > > > will
> > > > > > > be skipped and next lines will be processed as
normal" );
> > > > > > > }
> > > > > > >
> > > > > > > i++;
> > > > > > > }
> > > > > > >
> > > > > > > /* refresh ticker list and windows */
> > > > > > > AmiBroker.RefreshAll();
> > > > > > >
> > > > > > > }
> > > > > > >
> > > > > > > ================End Cut and Paste==============
> > > > > > >
> > > > > > > This script will look for Ticker, MarketID (0 to n),
> Stock
> > > > Name,
> > > > > > and
> > > > > > > Industry ID (0 to n). You do not need the sector ID
> > because
> > > it
> > > > > is
> > > > > > > implied from the industry assignment.
> > > > > > >
> > > > > > > When you're comfortable with this turnout, SAVE your
> > > database.
> > > > > Now
> > > > > > > you have the structure set up and your ready to import
> data.
> > > > > > >
> > > > > > > This worked for me. I'm sure Tomasz will chime in if
I'm
> > > right
> > > > > or
> > > > > > > wrong. I found it best to start with a clean empth
> > database
> > > > > > without
> > > > > > > any sample data existing what so ever.
> > > > > > >
> > > > > > > Brett
> > > > > > >
> > > > > > > --- In amibroker@xxxx, acs64@xxxx wrote:
> > > > > > > > Hello all,
> > > > > > > >
> > > > > > > > I have created a large .csv file with ticker symbols,
> > > market,
> > > > > > > > industry and sector. I would like to be able to load
> the
> > > > whole
> > > > > > > list
> > > > > > > > with all data in one shot into Ami but am not sure
how
> to
> > > do
> > > > > it.
> > > > > > I
> > > > > > > > have tried using the import wizards but the fields do
> not
> > > > seem
> > > > > to
> > > > > > > > fit. Is there some coding required to make it work?
> Any
> > > > help
> > > > > > > would
> > > > > > > > be greatly appreciated. Thanks
> > > > > > > >
> > > > > > > > Larry
|