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 *.
To quickly add multiple futures contracts at once time, enter in the root followed by the pound sign '#' or #n for the number of contracts you want to add.
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 |
Last (Ext) | Change (Ext) | % Chg (Ext) | Last (Available) | Last Size (Available) | Last Time (Available) |
|
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 |