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

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