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