Navigation

• Main Page
  • Login to Wiki
• Category List
• Knowledge Base
  • FAQ
  • Errors
  • Open Issues
  • API
• Traders Tips
• Indicator documentation
  • Standard
  • TASC
  • Community
• Addin examples
  • ChartStyles
  • Commissions
  • Components
  • IndexDefinitions
  • Optimizers
  • PosSizers
  • Providers
  • Rules
  • ScoreCard
  • Strategies
  • Visualizers
    

Log in to search

IQFeed Streaming, Static, and Fundamental Data Provider

What it is

The IQFeed provider for Wealth-Lab has streaming, static, and limited fundamental data (v2020.09 and up) by DTN IQFeed for U.S. and Canadian stocks, futures, options, forex and more; Click here for a full list of services. The IQFeed provider supports tick, second, and minute bars. For details on installing the IQFeed client and the Wealth-Lab IQFeed provider, see the IQFeed Extensions Detail page. There you'll find a link to sign up for a free trial.

Data Options

Smart Update
Outside of market hours and when Smart Update is enabled, the IQFeed Provider will check if the symbol/interval data is already up-to-date before making a historical data request. Market hours are 0930-1600 EST by default but can be changed by adding symbols to other markets in the Market Manager. Use this option to comfortably leave the "Update Data On-Demand" option selected while backtesting outside of market hours. Also, this feature will allow the Strategy Monitor to quickly initialize with data you've already updated before the market open.

Regular Session Only (RSO)
With RSO, the IQFeed Provider requests intraday data from 0930 to 1600 only, and therefore it is not required to use the Market Manager to filter data for the regular session, which affects data loading speed. Apart from delivering data only between 0930 and 1600, this setting has several other effects:

1. Bars will be referenced to 0930. Examples: the first 20 minute bar will aggregate trades from 0930 to 0950 and then to 1010, etc. Hourly bars will end at 1030, 1130, ..., 1600.
2. Streaming will only subscribe to regular session trading (no pre/post market stream)
3. The first intraday bar opening price will be replaced with the Daily bars' opening price - but only if the Daily bar is already cached. This feature was implemented because the IQFeed history time filter does not exclude "Form T" (premarket) trades with timestamps after 0930. Often these trades wind up being the opening price of the first intraday bar, so this feature aligns the opening intraday bar trade with the official daily opening trade.
   

In summary, for the Opening Price replacement feature to work, the following conditions must exist:

• Regular Session option must be checked
• Split Adjust Intraday option must be checked
• Daily bars must be updated first. This will occur automatically if you perform an IQFeed Provider update. You must have a Daily symbol that corresponds to each intraday symbol!
• Corrections will be applied only to intraday data that comes in on new download requests.
  

Split Adjust Intraday
Although IQFeed adjusts Daily bars for splits, they do not adjust intraday pricing. With this option selected, the Wealth-Lab IQFeed provider will maintain intraday prices adjusted too. Since IQFeed supplies only the last two splits, the Wealth-Lab provider uses an embedded historical resource of split data in order to adjust all intraday history. For example, as of 8/18/2020, QLD split 4 times since 2012. Without the split resource, intraday data would be adjusted only for the splits in 2020 and 2017, but not for the splits in 2015 and 2012.

Clear IQFeed Data
If you already have downloaded history and have made changes to either of the previous options, you should refresh all IQFeed data by clicking this button and then performing an IQFeed Provider update.

Always Include the current partial bar
This option simply will display all the history, even for the current partial bar for on-demand requests. Although these data are cached, subsequent requests will correct any bars that have changed in the recent history.

60-Minute timestamp
If you do not use the RSO option, hourly (and all others) bars will be referenced to 1200 AM. Therefore, hourly bars will end "on the hour" mark. While that's fine for streaming charts, it is not compatible with the Strategy Monitor, which requires hourly bars to have the 1030, 1130, ... , 1600 timestamp convention. This option will build the hourly bars with the required convention for Strategy Monitor compatibility. If you change this option, click the "Clear 60-Minute Data" button and then update to refresh your 60-Minute DataSets.

Connection Settings
A maximum of 10 threads in parallel are for historical data updates. Generally you don't need to change this setting, but if you have a bad connection, try reducing this number.

Fundamental Items

Although IQFeed isn't really a bonafide Fundamental data provider, it does include some current fundamental and technical data points that could be used in scans. The IQFeed Provider updates the Fundamental message cache any time the message is received for a stock that you request to stream or update from the Data Manager. The full list of items available are identified in the table below and an explanation of how to access the data follows.

How to use

Accessing the fundamental fields from a script is simple. Add the using "WealthLab.DataProviders.IQFeed;" statement and then call the appropriate IQFundamental method for the item's data type. For example, since the "Company Name" data type is a string, call IQFundamental.ValueString(Bars.Symbol, "company name"); Since "Ex-dividend date" is a DateTime call IQFundamental.ValueDateTime(Bars.Symbol, "ex-dividend date"). It's not required to SetContext to get fundamental data for other symbols, just pass the symbol string you want data for. The IQFundamental method will always return a value, but if the data do not exist, strings will be empty, numbers will be 0, DateTime will be 1/1/1900, etc.

/* Note that the item is case insensitive.  "Symbol" is the same as "symboL" or "SYMBol" */
using System;
using System.Collections.Generic;
using System.Text;
using WealthLab;
using WealthLab.Indicators;
using WealthLab.DataProviders.IQFeed;

namespace WealthLab.Strategies
{
	public class IQFundamentalDemo : WealthScript
	{
		protected override void Execute()
		{
			ClearDebug();
			string symbol = Bars.Symbol;
			
			string cname = IQFundamental.ValueString(symbol, "Company Name");
			PrintDebug(String.Format("Company name:\t{0}", cname));
			
			double shrs = IQFundamental.ValueDouble(symbol, "Common shares outstanding");
			PrintDebug(String.Format("Common shrs:\t{0}", shrs));

			double wh = IQFundamental.ValueDouble(symbol, "52 week high");
			PrintDebug(String.Format("52-week high:\t{0}", wh));
			
			int code = IQFundamental.ValueInt(symbol, "NAICS");
			PrintDebug(String.Format("NAICS Code:\t{0}", code));

			DateTime exdiv = IQFundamental.ValueDateTime(symbol, "Ex-dividend date");
			PrintDebug(String.Format("Ex-div date:\t{0:yyyy-MM-dd}", exdiv));
			
			DateTime maturity = IQFundamental.ValueDateTime(symbol, "Maturity Date");
			PrintDebug(String.Format("Ex-div date:\t{0:yyyy-MM-dd}", maturity));
			
			SplitData mostrecentSplit = IQFundamental.ValueSplitData(symbol, "Split Factor 1");
			PrintDebug(String.Format("Most recent split factor from IQFeed: {0:N8}; Ex-date: {1:yyyy-MM-dd}", mostrecentSplit.Factor, mostrecentSplit.Ex_Date ));
			
			SplitData penultimateSplit = IQFundamental.ValueSplitData(symbol, "Split Factor 2");
			PrintDebug(String.Format("Penultimate split factor from IQFeed: {0:N8}; Ex-date: {1:yyyy-MM-dd}", penultimateSplit.Factor, penultimateSplit.Ex_Date ));

			// The list contains all splits in the resource *plus* those from IQFeed *if* the dates don't already exist in the resource
			List<SplitData> lst = IQFundamental.SplitDataList(symbol);
			
			foreach (SplitData sd in lst)
			{
				PrintDebug(string.Format("{0:yyyy-MM-dd}\t{1:N8}", sd.Ex_Date, sd.Factor));
			}

		}
	}
}

Notes

Possible issues and limitations:

• While Streaming is enabled for a symbol, moving it to a different market group in the Market Manager can potentially mix its streaming bars with other symbols' data.
  

• Message dialog: "Unable to load DLL 'IQ32.dll. The specified module could not be found"
  Solution: Reinstall the IQFeed Client.
  

• Message dialog: "Connection to IQFeed can't be established"
  Solution: Close Wealth-Lab, ensure the IQFeed Client closes (could take up to 45 seconds). Restart Wealth-Lab and try again.