GetData() returning NaNs - Trading Software

GetData() returning NaNs

synhawk
2011-02-26 01:43:20

Hello,

I am using GetData() within a node of a ranking system to pull dividend data from the fundamental database,
but that database appears to contain NaNs for each day except the actual dividend date.

This wreaks havoc on the ranking system. Here is one example formula I tried: GetData("fund_financial", "dividend")

Is there a way to have it use the last known value versus the NaN value? It seems there is that option when you try to pick it with the formula picker, but that
just places: Dividend as the formula and that formula is not valid.

Thank you.

QuantShare
2011-02-26 06:13:40

Best Answer

When you type "GetData" then "(", a tooltip appears. In this tooltip you can see (1 of 2), which means that there are two signatures for this function. Clicking on the tooltip will display the other signatures.

To get the last known value, you should type:
GetData("fund_financial", "dividend", LastData)

Get more messages

No more messages

Back


Trading Items Next Earnings Release In Days Simple Moving Median Indicator Trading Indicator: True between the first and last signal Word Occurrence in News Titles - Quantitative Trading Analysis Market Rule based on the Crossover Between Stock Close prices and...	How-to Lessons How to detect whether price movements are predictable or not How to add trades from one portfolio to another one How to plot arrows below/above candlesticks on a chart How to use the Fibonacci retracement drawing tool How to plot support and resistance lines automatically
Related Forum Threads Force Index Testing intraday strategy , but couldn't replicate thru formula. Trouble with GetSeries Rankings Manager Improvement Error in formula	Blog Posts Ranking System Engine How to Reference Drawing Studies in QS Formulas Update Chart Layout based on Active Ticker Symbol - Part 2 Inverse Fisher Transform: Indicator, composite and trading system 4 original breadth indicators you should consider in your market ...