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 |