Quote Spreadsheet Settings


Quote Spreadsheet Settings

The Quote Spreadsheet Settings window is for specifying the fields to display for a Quote Request on a Spreadsheet and the order of those fields.

For more information about Quote Requests on Spreadsheets, refer to Quotes on Spreadsheets.

The settings in this window apply to all Quote Request lines in all open Spreadsheets.

Color Settings and Sort Settings are also set through this window.

To display this window, select Global Settings >> Quote Spreadsheet Settings on the menu.

Configuring Quote Request Line Fields

Fields Available (list box)

Lists all the available fields other than the ones already added.

Add (button)

Adds the selected field in the Fields Available list to the Fields to Display list.

Remove (button)

Removes a field from the Fields to Display list and adds it to the fields available list

Fields to Display (list box)

Lists the fields to display in a quote line on a Spreadsheet. The order they appear in the list is the order in which they will be displayed.

Move Up (button)

Moves the selected field up.

Move Down (button)

Moves the selected field down.

OK (button)

Save changes you have made and closes the window. Changes will only be displayed on the spreadsheets when you are connected to the data feed.

Cancel (button)

Cancels changes and closes the window.

Field Descriptions

Symbol:The symbol. This will be an abbreviation used by your Data or Trading service to represent the stock, futures contract, index, Forex market, CFD, option contract,....

Last: The last trade price.

LastSize: The volume of the last trade.

LastTime: The time of the last trade.

LastTick: The direction of the last trade. + = Trade was at a higher price than the previous trade. - = Trade was at a lower price than the previous trade

NetChange: The daily net change. This is simply the current price minus the previous days closing price.

Bid: The current Bid price.

Ask: The current Ask price.

BidSize: The size of the Bid.

AskSize: The size of the Ask.

High: The daily high price.

Low: The daily low-price.

Open: The opening price for the current day.

Volume: The current days volume.

NumTrades: This field indicates the number of trades for the symbol. If this data is available from your data service, then it indicates the number of trades since the start of the trading day. Most services do not provide this data. Therefore, it is the number of trades received from the data feed since you last connected to the data feed.

TradeIndicator: If the data feed provides a trade indicator, it will be displayed in this field. This is data feed specific.

OpenInterest: The open interest. This applies to futures and options only.

NetChange%: The daily net change as a percentage.

PreviousClose: Previous days closing price. Depending upon the particular data feed being used, if there is a settlement price provided, this is going to be the settlement price. The settlement price is calculated by the exchange using a formula. It is not the final last trade price of the trading session.

SettlementPrice:Previous days closing price. Depending upon the particular data feed being used, if there is a settlement price provided, this is going to be the settlement price. The settlement price is calculated by the exchange using a formula. It is not the final last trade price of the trading session.

StrikePrc: Strike price for options.

Name: This is a description for the symbol. Such as a company name or a futures contract name.

EPS: Earnings-per-share.

P/E: Price of a stock divided by its earnings per share.

Buy Rollover Interest: Rollover interest for a long position. Only applies to the Forex and CFD markets.

Sell Rollover Interest: Rollover interest for a short position. Only applies to the Forex and CFD markets.

Color Settings

Sort Settings

For the documentation for Sort Settings, refer to the Sorting section on the Getting Quotes page.


*Last modified Friday, 12th August, 2016.