While blanks can simply mean there is No data
Available, there are some things to be aware of:
Make sure you only use CAPITAL letters
in the macro dialog box as the majority of symbols are always in
capital letters. There are some exceptions to this rule and
symbols which use lowercase letters, specifically the Comstock
symbols for International Exchanges (i.e. 1tFB, 2sSF, etc.)
Make sure you use the appropriate
Symbol Format Prefix. For example:
/CLZ8 instead of CLZ8 (for Light, Sweet crude)
#PCACG00 not PCACG00 (etc.)
Use "/" for Future Symbols, "#" for
Spot prices, "-" for Options, and "$" for Index
Symbols. There are some symbols which do not have a
Symbol Format Prefix, specifically the ComStock symbols for
International Exchanges (i.e. 1tFB, 2sSF, etc.)
Back to Top