[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [amibroker] Help on importing data.



PureBytes Links

Trading Reference Links

 Dingo,
I think I understand what you are saying. I don't quite understand where the
IndustryID goes. I am using the Hemscott Industries broker.industries and
broker.sectors. Looking at these files in NotePad it appears that all broker
industries does is assign a number 0 thru 9 that corresponds to one of the
10 sectors in broker.sector. OK so far. My problem is this - the Industry ID
numbers that I get from Yahoo are not just 0 thru 9. They are unique numbers
that correspond to one of 213 IndustryID's. I know that AmiBroker uses these
numbers somehow and stores them in the symbol database.  If I look at the
AmiBroker Symbol tree, under Sectors there are some of the correct
catagories (Industries) showing up, but the stocks are not being assigned
correctly. I have looked at the name/ number combination that I have
downloaded and the assignments are correct, but they are not getting into
AmiBroker correctly.
 
At this point I don't even know if I am making sense, but if I am, can you
give any explanation for the mix-up?
 
Thanks, 
Don Lindberg
 
-------Original Message-------
 
From: dingo
Date: 08/20/06 17:09:22
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Help on importing data.
 
Amibroker gets bases its assignments on the files broker.industries and
broker.sectors located in your AB directory. The 0 based number used to
represent the industry and sector is the n-1th line number in these files. 
(As far as I can remember - its n-1)
 
 




From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf
Of Don Lindberg
Sent: Sunday, August 20, 2006 7:58 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Help on importing data.


 Well, I fixed one problem, now I have another. I got the script
PopulateIndustriesAndTickers_v3_0.js to work, by deleteting and recreating
my database. The script then populated it with the data in my csv file,
however it populated it with the wrong data. The script got the correct
market ID but the industry data is wrong. I created my industry info from
Yahoo. I have a spreadsheet program that goes out and grabs the Industry
number from yahoo. I then create my csv file with this downloaded data. When
I look at the Symbol Information screen, there is no information in the
industry box, however AmiBroker has assigned the stocks to various Industry
groups, unfortunately they are the wrong groups. Can someone explain to me
what is happening? Is it possible that this script which was last updated
July, 2002 is not compatible with the newest version of AmiBroker? 
 
Please help.
 
Don Lindberg
 
-------Original Message-------
 
From: Don Lindberg
Date: 8/20/2006 12:54:25 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Help on importing data.
 
Hello Group,
I am attempting to import data from a csv file in the following
format: ticker, full name, industry id
using the ImportIndustryTicker.js
that is in AmiBroker. I have also tried using the
PopulateIndustriesAndTickers_v3_0.js that is in the files section.
(for this one I adjust my data to include market Id.) In both
scripts I
have changed the name of the data file to match mine.
 
I have created a new, empty database, and run these scripts from
within this new database. In both cases, the script starts, and
finishes without any errors, but nothing comes into my database!
Where is it going? I assume since the script runs it must be writing
something somewhere but I haven't a clue. I have looked at the
script to see if I could get a clue, but I am not a programmer so it
didn't make a lot of sense to me.
 
Can anyone give me a clue to what is happening?
 
Thanks,
Don Lindberg
 
 
 
 
 
 
Please note that this group is for discussion between users only.
 
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
 
For other support material please check also:
http://www.amibroker.com/support.html
 
 
Yahoo! Groups Links
 
 
 
 
 
 




--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.3/423 - Release Date: 8/18/2006