|
PureBytes Links
Trading Reference Links
|
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
|