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 Strategy Indicator - Percent winning trades for a trading rule 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 create a correlation matrix of several securities How to drag & drop indicators in charts How to create a moving average of an indicator How to use a custom drawing tool How to create a strategy-based portfolio
Related Forum Threads Force Index Testing intraday strategy , but couldn't replicate thru formula. Trouble with GetSeries Rankings Manager Improvement filter formulas	Blog Posts Example of advanced rule QuantShare Trading Software: New Features in the 3.3.2 Version Different Ticker Symbols for Each Data Source How to use QuantShare screener to trade penny stocks Custom Indicator: Moving average spread