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.