Steve,
Regarding the TC
industry/sector data, I’ve got that set up now. And, I’ve got the
industries set up and am using “GetBaseIndex()” now. Works
great.
The issue is linking
the Industry Symbols to the Sector Symbols. I like your
solution!
But it also made me
realize something… Now I know why TC has 31 sectors (a
lot). Although there are multiple industry/sector mappings,
only TC has so many Sectors. When I checked your solution to
ensure, I realized that many of the sectors have EXACTLY nine
industries. That is the maximum number possible given their symbol
numbering method! I.e., their sector categories are driven
by their symbol numbering methods!
As a database
architect (my profession) that concept makes me very uncomfortable because
it’s driven by physical constraints, not what’s best for the Industry/Sector
categorization. L But, it does
work fairly well and it makes for easier coding in
AB.
Many thanks for the
great solution.
Best
regards,
Dan.
From:
amibroker@xxxxxxxxxxxxxxx
[mailto:amibroker@xxxxxxxxxxxxxxx]
On Behalf Of Steve
Dugas
Sent: Saturday, July
09, 2005 10:17 AM
To:
amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Challenge -
Best
Ways of Accessing and Using External
Data
All industry/sector data is
already in AB, automatically imported by the TC2K plugin. To link a stock with
its industry/sector requires a one-time setup, but works very well after you
set it up.
Go to Symbol > Categories >
Industries and under Relative Strength, fill in the MGxxx name for each
industry in the list. I believe that the sector is already populated by the
TC2K plugin.
This will link them. After that,
you can retrieve the industry/sector for each ticker like
this:
Industry =
GetBaseIndex();
Sector = StrLeft(
GetBaseIndex(), 4 ) + "0";
----- Original Message -----
Sent:
Saturday, July 09, 2005 10:54 AM
Subject:
[amibroker] Challenge - Best
Ways of Accessing and Using External
Data
Hi,
I’m trying to load, access and
use NON-price external data in AB scans and indicators. Example: I’m
trying to map Telechart Industry Symbols to Sector Symbols, and use these in
AB. What are the best ways of handling
this?
In general, I’m interested in
two types of external data:
1)
Non-price, single value
(current) data – Current values for symbol-related data.
Examples: Current p/e ratio, current shares outstanding,
next earnings date, and Sector to industry symbol
mapping.
2)
Non-price, historical data –
Similar to number two, except historical. Example: P/e ratio by day
week or month, historical shares outstanding.
Here’s a problem I’m trying to
solve…
I use Telechart
data. They provide Stock to Industry to Sector mapping. And,
they provide Industry and Sector symbol data that can be plotted. And,
Stock symbol to Industry symbol mapping is simple in AB.
But…
There appears to be no simple
way of mapping an Industry symbol to a Sector symbol in AB.
I was thinking of using a simple
CSV file (using “fgets”) containing one line for each TC Industry Symbol
with its associated Sector symbol. For example, the
Telechart Specialty Retail symbol is “MG740”. Its Industry
symbols are “MG741” to “MG747”. So the Specialty Retail section
of the mapping file would contain:
MG741,MG740
MG742,MG740
MG743,MG740
MG744,MG740
MG745,MG740
MG746,MG740
MG747,MG740
I think a file approach would
work. But…
Are there better, faster ways of
handling this? Maybe an external database? Setting up some
sort of array in AB?
Please
help.
Thanks and
regards,
Dan.
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
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
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