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 *.

 

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

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

Entry Date

Entry Price

Exit Date

Exit Price

Fees

Market Val

Profit

Total Profit

Total Chg

Total %Chg

 

 

Overall Opinion

 

 

 

 

 

 

Opinion

Opinion Signal

Opinion Percent

Opinion Strength

Opinion Direction

Previous Opinion

Previous Opinion Signal

Previous Opinion Percent

Last Week's Opinion

Last Week's Opinion Signal

Last Week's Opinion Percent

Last Month's Opinion

Last Month's Opinion Signal

Last Month's Opinion Percent

Short Term Opinion

Short Term Opinion Signal

Short Term Opinion Percent

Medium Term Opinion

Medium Term Opinion Signal

Medium Term Opinion Percent

Long Term Opinion

Long Term Opinion Signal

Long Term Opinion Percent

 

 

 

 

 

Opinion Indicators

 

 

 

 

 

 

TrendSpotter Opinion

TrendSpotter Strength

TrendSpotter Direction

20 Day Moving Average

20 Day Mov Avg Strength

20 Day Mov Avg Direction

20-50 Day MACD Oscillator

20-50 Day MACD Osc Strength

20-50 Day MACD Osc Direction

20-100 Day MACD Oscillator

20-100 Day MACD Osc Strength

20-100 Day MACD Osc Direction

20-200 Day MACD Oscillator

20-200 Day MACD Osc Strength

20-200 Day MACD Osc Direction

50 Day Moving Average

50 Day Moving Avg Strength

50 Day Moving Avg Direction

50-100 Day MACD Oscillator

50-100 Day MACD Osc Strength

50-100 Day MACD Osc Direction

50-150 Day MACD Oscillator

50-150 Day MACD Osc Strength

50-150 Day MACD Osc Direction

50-200 Day MACD Oscillator

50-200 Day MACD Osc Strength

50-200 Day MACD Osc Direction

100 Day Moving Average

100 Day Moving Avg Strength

100 Day Moving Avg Direction

150 Day Moving Average

150 Day Moving Avg Strength

150 Day Moving Avg Direction

200 Day Moving Average

200 Day Moving Avg Strength

200 Day Moving Avg Direction

100-200 Day MACD Oscillator

100-200 Day MACD Osc Strength

100-200 Day MACD Osc Direction

7 Day Average Directional Indicator

7 Day Average Directional Strength

7 Day Average Directional Direction

9-18 Day MACD Oscillator

9-18 Day MACD Osc Strength

9-18 Day MACD Osc Direction

10-8 Day Moving Avg Hilo Channel

10-8 Day Mov Avg Hilo Strength

10-8 Day Mov Avg Hilo Direction

20 Day Bollinger Bands®

20 Day Bollinger Bands® Strength

20 Day Bollinger Bands® Direction

40 Day Commodity Channel Index

40 Day CCI Strength

40 Day CCI Direction

50 Day Parabolic Time/Price

50 Day Parabolic Strength

50 Day Parabolic Direction

60 Day Commodity Channel Index

60 Day CCI Strength

60 Day CCI Direction

 

 

 

Options (Equities)

 

 

 

 

 

 

Options Vol

% Put

% Call

Put/Call

Imp Vol

IV Rank

IV Percentile

Call Volume

Call Volume

Put Volume

Call OI

Put OI

Put/Call Volume Ratio

Put/Call Open Interest Ratio

5-Day Imp Vol

5-Day IV Rank

5-Day IV Percentile

5-Day IV High

5-Day IV Low

5-Day Avg Call Volume

5-Day Avg Put Volume

5-Day Avg Call OI

5-Day Avg Put OI

5-Day Put/Call Volume Ratio

5-Day Put/Call Open Interest Ratio

5-Day IV Change

1-Month Imp Vol

1-Month IV Rank

1-Month IV Percentile

1-Month IV High

1-Month IV Low

1-Month Avg Call Volume

1-Month Avg Put Volume

1-Month Avg Call OI

1-Month Avg Put OI

1-Month Put/Call Volume Ratio

1-Month Put/Call Open Interest Ratio

1-Month IV Change

3-Month Imp Vol

3-Month IV Rank

3-Month IV Percentile

3-Month IV High

3-Month IV Low

3-Month Avg Call Volume

3-Month Avg Put Volume

3-Month Avg Call OI

3-Month Avg Put OI

3-Month Put/Call Volume Ratio

3-Month Put/Call Open Interest Ratio

3-Month IV Change

6-Month Imp Vol

6-Month IV Rank

6-Month IV Percentile

6-Month IV High

6-Month IV Low

6-Month Avg Call Volume

6-Month Avg Put Volume

6-Month Avg Call OI

6-Month Avg Put OI

6-Month Put/Call Volume Ratio

6-Month Put/Call Open Interest Ratio

6-Month IV Change

YTD Imp Vol

YTD IV Rank

YTD IV Percentile

YTD IV High

YTD IV Low

YTD Avg Call Volume

YTD Avg Put Volume

YTD Avg Call OI

YTD Avg Put OI

YTD Put/Call Volume Ratio

YTD Put/Call Open Interest Ratio

YTD IV Change

1-Year Imp Vol

IV 1-Year High

IV 1-Year Low

1-Year Avg Call Volume

1-Year Avg Put Volume

1-Year Avg Call OI

1-Year Avg Put OI

1-Year Put/Call Volume Ratio

1-Year Put/Call Open Interest Ratio

1-Year IV Change

Edit a Quote

Edit existing Quotes by highlighting the Quotes anchor cell in the spreadsheet and then clicking the Quotes icon in the ribbon. Make desired changes including the addition, removal or reordering of symbols and fields and then select the Insert button to insert the newly formatted data into the spreadsheet.

 

Favorites

After inserting any symbol, the Favorites tab will save these instruments for easy insertion later.

Upon opening Favorites, you will see a list of the last 20 symbols whose quote data was viewed. Double click, click and drag or highlight a grouping of symbols and click enter to add these symbols to the insert dialogue.

The Favorites dialogue can be enlarged by clicking on the pin icon in the upper right corner and then hidden by clicking the pin icon once again.

 

Data Removal

Quotes inserted into a worksheet can be quickly removed by highlighting the Quotes anchor cell, Clicking on the Quote icon and selecting the Clear button.