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.