Streaming Quotes

Add a Quote

Click on the Quote icon in the Barchart for Excel ribbon and the Insert Quotes dialogue will display as shown below.

Here you can search for symbols by type and source in the left panel or via the exchange and instrument type drop downs to the right.

If you already know the ticker or symbol name, you can type into the search box and a list of suggested symbols will automatically display.

You can remove any previously typed search text by clicking on the ‘x' or the '<-' icons in the search box or by simply highlighting and deleting.

Once the desired symbol(s) are displayed you can double click or click and drag the symbol to the insert pane to the right of the search pane.

By holding down the Shift key and using the arrow keys or mouse, you can select multiple symbols at one time. You can also hold Ctrl + A to select all symbols displayed in the search.

To view multiple futures expirations at one time, enter in the contract’s root symbol followed by *.

To quickly add multiple futures contracts at once time, enter in the root followed by the pound sign '#' or #n for the number of contracts you want to add.

For multi-symbol entry, place a comma (without space) between each symbol. Once all symbols are entered, click on the symbol grouping (enclosed with brackets) or hit enter when the grouping is highlighted.

Once you have selected all of the desired instruments and moved them to the pane on the right, you should have a window that looks like below.

Select your Fields

Next, you will want to select the fields (data columns) you wish to display in your spreadsheet.

By clicking on the down arrow next to each field category, all of the fields specific to that category will display.

Check the box next to the field to add the field to your view. If you wish to add all fields in the category, check the box next to the category name. Uncheck any or all boxes to remove from the view.

If you wish to display all fields in all categories, click on the All ▼ button located in the upper right corner of the Fields drop down. Click the All ▲ to minimize all categories.

When you use the search field, use text to describe what data you want to add. For example, to find Moving Averages fields, start typing "mov" and possible matches will display.

To add a field from the results list, drag or check the field. The field is added to the bottom of the selected fields, where you can drag and drop it to a new position, if desired.

If you would like to add all the fields within a category, check the box next to the category’s name. A black checkmark will display and all fields in that grouping will be added to the Selected Columns section of the dialogue.

To remove all fields added to the Selected Columns, simply click the clear button located directly below custom views.

Any Custom Views created on Barchart.com and save in your My Barchart account can be applied to a Quote query by clicking on the 'Custom Views' button.

Once a view is selected the view’s name will display in Quote dialogue and editing an existing Quote query.

You can reposition the fields by dragging and dropping them to their desired position on the Insert Quotes dialog. Once the necessary fields are selected, click insert and all symbols and their corresponding fields will display like below.

Quote Fields

General Symbol Info
Symbol	Name	Short Name	Futures Contract Name	Contract Date	UnderlyingFuture	Exchange
ExchangeName	Industry	Sector	Barchart SIC Symbol	SIC Description	Expiration Date	DTE
OpenInterest	Timestamp	Has Options	First Notice Date	DTFN
Prices & Volume
Open	High	Low	Last	LastSize	TickDirection	Change
Close	PercentChange	Bid	BidSize	Size x Bid	Ask	AskSize
Size x Ask	Settle	PrevSettle	Previous	Previous High Price	Previous Low Price	Previous Open Price
2-Days Ago Last Price	2-Days Ago High Price	2-Days Ago Low Price	2-Days Ago Open Price	Volume	Volume % Change	VolumeTimestamp
Last (Ext)	Change (Ext)	% Chg (Ext)	Last (Available)	Last Size (Available)	Last Time (Available)
Yesterday’s Volume	Price Volume	Gap Up	Gap Up Percent	Gap Down	Gap Down Percent	Range %
Pivot Point	1st Resistance Point	2nd Resistance Point	1st Support	2nd Support	Fibonacci 38.2%	Fibonacci 50%
Fibonacci 61.8%	Last (Ext)	Change (Ext)	% Chg (Ext)	Last (Available)	Last Size (Available)	Last Time (Available)
End of Day Prices
Daily Last	Daily Open	Daily High	Daily Low	Daily Change	Daily % Change	Daily Volume
Daily Trade Date	Daily Opinion	Daily 20-Day Relative Strength	Daily 20-Day Historic Volatility	Daily 20-Day Avg Volume	Daily 52-Week Low	Daily 52-Week High
Daily Weighted Alpha	Daily YTD % Change	Daily 1-Month % Change	Daily 3-Month % Change	Daily 52-Week % Change	Daily Std Dev	Daily Date
Daily Previous Opinion	Daily Last Week's Opinion	Daily Last Month's Opinion
Weekly Prices
Weekly Last	Weekly Open	Weekly High	Weekly Low	Weekly Change	Weekly % Change	Weekly Volume
Weekly Std Dev	Weekly Date
Monthly Prices
Monthly Last	Monthly Open	Monthly High	Monthly Low	Monthly Change	Monthly % Change	Monthly Volume
Monthly Std Dev	Monthly Date
Price and Percent Change
5-Day Change	20-Day Change	1-Month Change	50-Day Change	3-Month Change	100-Day Change	6-Month Change
9-Month Change	200-Day Change	52-Week Change	YTD Change	2-Year Change	3-Year Change	5-Year Change
10-Year Change	20-Year Change	5-Day % Change	20-Day % Change	1-Month % Change	50-Day % Change	3-Month % Change
100-Day % Change	6-Month % Change	9-Month % Change	200-Day % Change	52-Week % Change	YTD % Change	2-Year % Change
3-Year % Change	5-Year % Change	10-Year % Change	20-Year % Change
Technical Analysis
1-Month Moving Average	3-Month Moving Average	6-Month Moving Average	9-Month Moving Average	52-Week Moving Average	YTD Moving Average	5-Day Moving Average
5-Day Moving Average	5-Day Moving Average	100-Day Moving Average	200-Day Moving Average	1-Month Average Volume	3-Month Average Volume	6-Month Average Volume
9-Month Average Volume	52-Week Moving Average	YTD Average Volume	5-Day Average Volume	20-Day Average Volume	50-Day Average Volume	100Day Average Volume
200-Day Average Volume	9-Day Raw Stochastic	14-Day Raw Stochastic	20-Day Raw Stochastic	50-Day Raw Stochastic	100-Day Raw Stochastic	9-Day Stochastic %K
14-Day Stochastic %K	20-Day Stochastic %K	50-Day Stochastic %K	100-Day Stochastic %K	9-Day Stochastic %D	14-Day Stochastic %D	20-Day Stochastic %D
50-Day Stochastic %D	100-Day Stochastic %D	9-Day Average True Range	14-Day Average True Range	20-Day Average True Range	50-Day Average True Range	100-Day Average True Range
9-Day Average Directional Index	14-Day Average Directional Index	20-Day Average Directional Index	50-Day Average Directional Index	100-Day Average Directional Index	9-Day +Directional Index	14-Day +Directional Index
20-Day +Directional Index	50-Day +Directional Index	100-Day +Directional Index	9-Day -Directional Index	14-Day -Directional Index	20-Day -Directional Index	50-Day -Directional Index
100-Day -Directional Index	9-Day Relative Strength	14-Day Relative Strength	20-Day Relative Strength	50-Day Relative Strength	100-Day Relative Strength	9-Day Percent R
14-Day Percent R	20-Day Percent R	50-Day Percent R	100-Day Percent R	9-Day Historic Volatility	14-Day Historic Volatility	20-Day Historic Volatility
50-Day Historic Volatility	100-Day Historic Volatility	9-Day MACD Oscillator	14-Day MACD Oscillator	20-Day MACD Oscillator	50-Day MACD Oscillator	100-Day MACD Oscillator
Weighted Alpha	Std Dev	Average Volume
Historical Highs and Lows
5-Day High	5-Day High Date	5-Day Low	5-Day Low Date	5-Day Change	5-Day % Change	5-Day # Highs
5-Day % High	5-Day # Lows	5-Day % Low	1-Month High	1-Month High Date	1-Month Low	1-Month Low Date
1-Month Change	1-Month % Change	1-Month # Highs	1-Month % High	1-Month # Lows	1-Month % Low	3-Month High
3-Month High Date	3-Month High Date	3-Month Low	3-Month Low Date	3-Month Change	3-Month % Change	3-Month # Highs
3-Month % High	3-Month # Lows	3-Month % Low	6-Month High	6-Month High Date	6-Month Low	6-Month Low Date
6-Month Change	6-Month % Change	6-Month # Highs	6-Month % High	6-Month # Lows	6-Month % Low	YTD High
YTD High Date	YTD Low	YTD Low Date	YTD Change	YTD % Change	YTD # Highs	YTD % High
YTD # Lows	YTD % Low	52-Week High	52-Week High Date	52-Week Low	52-Week Low Date	52-Week Change
52-Week Percent	52-Week # Highs	52-Week % High	52-Week # Lows	52-Week % Low	2-Year High	2-Year High Date
2-Year Low	2-Year Low Date	2-Year Change	2-Year % Change	2-Year # Highs	2-Year % High	2-Year # Lows
2-Year % Low	3-Year High	3-Year High Date	3-Year Low	3-Year Low Date	3-Year Change	3-Year % Change
3-Year # Highs	3-Year % High	3-Year # Lows	3-Year % Low	5-Year High	5-Year High Date	5-Year Low
5-Year Low Date	5-Year Change	5-Year % Change	5-Year # Highs	5-Year % High	5-Year # Lows	5-Year % Low
10-Year High	10-Year High Date	10-Year Low	10-Year Low Date	10-Year Change	10-Year % Change	10-Year # Highs
10-Year % High	10-Year # Lows	10-Year % Low	20-Year High	20-Year High Date	20-Year Low	20-Year Low Date
20-Year Change	20-Year % Change	20-Year # Highs	20-Year % High	20-Year # Lows	20-Year % Low
Portfolio Specific
Qty	Action