...
Edit existing Quotes by highlighting the # symbol in the spreadsheet and then clicking the Quotes icon on the ribbon. Make desired changes including the addition, removal or reordering of symbols and fields and then select the Insert button to insert the newly formatted data into the spreadsheet.
...
Quote Fields
A Quote link can contain any of the following fields:
Field | Description |
---|---|
% Change | The percent change from the Open Price. |
Ask | The last Ask Price from the exchange floor, indicating a willingness to sell at that price. |
Ask x Size | Contains both the last Ask Price and the number of contracts offered at that price. |
Ask Size | The total number of contracts offered at the current Ask Price. |
Bid | The last Bid Price from the exchange floor, indicating a willingness to purchase at that price. |
Bid x Size | Contains both the last Bid Price and the number of contracts offered at that price. |
Bid Size | The total number of contracts offered at the current Bid Price. |
Change | The difference between the Last Price and the Close Price from the previous day or session. |
Expiration Date | For futures symbols, the expiration month and year. |
High | The highest price paid during the current trading session. |
Last | The last price paid during the current trading session. |
Low | The lowest price paid during the current trading session. |
Month | For futures, the month represented by the futures contract. |
Name | The full name of the symbol. |
Open | The first price paid during the current trading session. |
Open Interest | The total number of futures contracts traded that have not yet been liquidated either by an offsetting futures transaction or by delivery. |
Previous | The previous trading session's Closing Price. |
Previous Open | The previous trading session's Open Price. |
Previous High | The previous trading session's High Price. |
Previous Low | The previous trading session's Low Price. |
Previous Settle | The previous trading session's Settlement Price. |
Previous Volume | The previous trading session's Volume. |
Settle | The current session's Settlement Price. |
Symbol | The ticker symbol. |
Time | Time of the last trade. |
Time Zone | The time zone used for the time stamp. |
Volume | The total number of contracts traded during the current trading session. |
Tick Dir | The last traded price in relation to the previous traded price. Up pointing triangle ( ▲ ) for a up tick, down pointing triangle ( ▼ ) for a down tick and ( - ) for unchanged from previous tick. |
Exchange | The exchange on which the commodity or security is traded. |
Extended Hours Last | The last traded price, using data from extended hours (equities only). |
Extended Hours Change | The difference from the last traded price and the previous day’s settlement, using data from extended hours (equities only). |
Extended Hours Percent Change | The difference from the last traded price and the previous day’s settlement expressed as a percentage, using data from extended hours (equities only). |
Contract Date | The commodity’s expiration month and year. |
Favorites
After inserting any symbol, the Favorites tab will save these instruments for easy insertion later.
...
Upon opening Favorites, you will see a list of the last 20 symbols whose quote data was viewed. Double click, click and drag or highlight a grouping of symbols and click enter to add these symbols to the insert dialogue.
...
The Favorites dialogue can be enlarged by clicking on the pin icon in the upper right corner and then hidden by clicking the pin icon once again
...