I want to exclude the Publicy Traded Partnerships from the database Norgate with Platinum package. In Amibroker, I am trying to access to this field as follows:
But I get an empty variable for all the tickers with both functions. As it is documented in Norgate Data - Data Content Tables I think I can access to this categorization through “SubType3”, but I am not sure if this is a Fundamental field because it is on the Metadata section. How could I get this value?
@EZNeo I did a quick test and imagined you should access this data using the following syntax:
#include_once "Formulas\Norgate Data\Norgate Data Functions.afl"
Filter = 1;
AddColumn(NorgateFundamentals("SharesFloat"), "SharesFloat"); // OK
AddColumn(NorgateFundamentals("SharesOutstanding"), "SharesOutstanding"); // OK
AddColumn(NorgateFundamentals("TickSize"), "TickSize"); // All empty...
// AddColumn(NorgateFundamentals("LastQuotedDate"), "LastQuotedDate", formatDateTime); // All empty...
// These should be strings - but AB complains expecting a number
// AddTextColumn(NorgateFundamentals("Exchange"), "Exchange"); //
// AddTextColumn(NorgateFundamentals("BaseType"), "Base type");
// AddTextColumn(NorgateFundamentals("SubType1"), "Subtype 1");
// AddTextColumn(NorgateFundamentals("SubType2"), "Subtype 2");
// AddTextColumn(NorgateFundamentals("SubType3"), "Subtype 3");
Unfortunately, this seems not to work as expected. A couple of "numeric" metadata are accessible, others return empty values, and the ones listed in the " Security Information - Text" section are disliked by the syntax checker that expects numbers...
Likely something to investigate with the help of Norgate support (@NorgateData).
Some of these have no value (and are provided as nulls), so this is the issue - we'll work on upgrading the NorgateFundamentals function/outputs so it doesn't have this issue.
Regarding PTPs, many brokers these days will have the ability to prevent a non-US account from trading these securities.
Unfortunately these lists from various brokers are woefully out-of-date and/or wrong (eg reference securities that were delisted years ago).
Note that the set of securities we define as Public Limited Partnership are not necessarily the same as a the IRS definition for a PTP. Unfortunately the IRS doesn't provide a list.
