Fields

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