As industry information is static relative to price data. You need to import the industry info once for every stock. Set up a jscript/vbscript to read the CSV file and load the industry information into AB. You can refer the the object model in the help file on how to do that. >From then on, you can use your data feed as per usual. To use the sector or industry information in your afl. use industryID() or sectorID(). Simple. There is no need to use SQL or change your data vendor.
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of foginthehills Sent: Thursday, 31 May 2007 9:16 AM To: [email protected] Subject: [amibroker] Re: Amibroker file format? Thanks very much. I am trying to figure out how to make industry sector available as a field against each stock in Amibroker. My data feed arrives in Metastock format which doesn't have such a field. (I have the industry sector information in Excel/CSV format). I want to be able to determine the sector of any stock from within AFL. Any ideas on how to do this? You mentioned the SQL interface, are there any relevant examples of this for sector or similar? Andy (aka Fog) --- In [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com, "dingo" <[EMAIL PROTECTED]> wrote: > > I seriously doubt TJ would want you mucking around in his database. He HAS > made provisions for getting extra data in various ways. Suggest you look > into the SQL interface, fget and fput, etc. > > d > > > -----Original Message----- > > From: [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com > > [mailto:[EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com] On Behalf Of foginthehills > > Sent: Wednesday, May 30, 2007 4:03 AM > > To: [EMAIL PROTECTED] <mailto:amibroker%40yahoogroups.com> ps.com > > Subject: [amibroker] Amibroker file format? > > > > Hi there, > > > > What is the Amibroker native file format? > > > > Is there a detailed description (spec) of this data format > > (or an API) > > so I can write data to this format for AB to read? > > > > thanks - Andy (aka Fog) > > > > > > > > > > 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: > > http://www.amibroke <http://www.amibroker.com/devlog/> r.com/devlog/ > > > > For other support material please check also: > > http://www.amibroke <http://www.amibroker.com/support.html> r.com/support.html > > > > Yahoo! Groups Links > > > > > > > > >
