RE: [amibroker] Help on importing data.

[Don Lindberg]

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@yahoogroups.com 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@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Don Lindberg Sent: Sunday, August 20, 2006 7:58 PM To: amibroker@yahoogroups.com 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@yahoogroups.com 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   <*> To visit your group on the web, go to:     http://groups.yahoo.com/group/amibroker/   <*> To unsubscribe from this group, send an email to:     [EMAIL PROTECTED]   <*> Your use of Yahoo! Groups is subject to:     http://docs.yahoo.com/info/terms/       -- 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   __._,_.___ 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 SPONSORED LINKS Software support Small business finance Business finance online Business finance training Business finance course YAHOO! GROUPS LINKS  Visit your group "amibroker" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. __,_._,___