Fields

Below are all of the fields currently supported in Barchart for Excel.

 

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)

LastAvailable

LastSizeAvailable

LastTimeAvailable

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