RE: [amibroker] Re: Amibroker file format?

["Richard Dale" <richard@xxxxxxxxxxxxxxx>]

Hi Andy,

 

You could use the new watchlist format available in v4.96 that allows you to store an unlimited amount of watchlists as .tls files – just convert your CSV files into one file per sector.  Then you could write some simple AFL to figure out which watchlist(s) the security is a member of.

 

Alternatively, you could reformat the CSV file and import it into AmiBroker in the form of:

$NOQUOTES 1

$OVERWRITE 1

$AUTOADD 0

$SEPARATOR ,

$FORMAT Ticker,Industry

Then each subsequent line has the ticker and industry ID on it.

 

Lastly, you could consider using a data vendor that does all of this for you automagically within AmiBroker.

 

Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
  markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net

 

From: foginthehills [mailto:andrewdelin@xxxxxxxxxxx]
Sent: Thursday, 31 May 2007 7:16 AM
To: amibroker@xxxxxxxxxxxxxxx
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)

__._,_.___

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.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html

SPONSORED LINKS

Investment management software	Investment property software	Investment software
Investment tracking software	Return on investment software

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___