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 Word Occurrence in News Titles - Quantitative Trading Analysis Market Rule based on the Crossover Between Stock Close prices and... Consolidation Breakout and Congestion Index Percentile Rank of PEG, Price/Free Cash Flow and Price/Sales Technical Analysis Continuation Pattern: Descending Triangle Indi...	How-to Lessons How to quickly select stocks based on the last value of a databas... How to download new quotes when selecting a chart How to add trades from one portfolio to another one How to create a mobile database/account How to create a composite index/indicator
Related Forum Threads about macd? Modification required to Clipboard change in account downloaded item can's see Data feed Intraday INTRADAY VERSION AND SIZE OF DATA BASE	Blog Posts Beta release Day Trading: A trading system that combines intraday and EOD data Download Trading Data using the Post-Script Automated Parsing in QS Trading Software Create a trading strategy using the money management tool - Part ...