|
Category
Cross-Sectional Functions
Description
#Pad is a special Data Section tag that looks like a cross-sectional function name but is not one.
This tag specifies that a Data item should replace any NaN values in the calculated data array for this item with zeros. It works on any Data item, whether an ordinary calculated formula or a #DataValueFile item.
#DVFPad is a backward-compatible synonym for #Pad. These tags were originally supported only for DataValueFile items (as #DVFPad and #DVFFill); since version 2.0.31.6 they work for any Data item, and either spelling may be used with either item type.
Example
IndexSignal: #Pad Extern($$SPX, C > MA(C, 200))
If the formula cannot be calculated, e.g. for US holiday bars when calculating it for a non-US symbol, the result will be 0 rather than NaN.
Notes
If #Pad were not specified, this IndexSignal would be NaN on US holiday bars when referencing it from a non-US symbol.
See #Fill for an alternative way to replace NaN values.
See DataValueFile Items for more about using this tag with a DataValueFile item.
|
