Adaptable Blotter allows you to use the + and - keys on the keyboard to increment or decrement the value of a numerical cell.
Using the Plus/Minus Function, you can:
Set your own default plus/minus amount (called a Nudge Value) for the entire blotter.
Set a different default Nudge Value for each numerical column.
Create bespoke rules so that the Nudge Value amount for a cell will be different, depending on the values in other cells in the row.
When you press the + or - key on a numerical cell, Adaptable Blotter figures out which Nudge Value to use as follows:
If the column has Custom Plus/Minus Rules, the Nudge Value is the amount set in the rules. This is only used if the values in the row match all of conditions set in the query. If the values in the row do not match, Adaptable Blotter will continue to Step 2.
If there are no matching Custom Plus/Minus Rules, Adaptable Blotter will use the Default Nudge value for the column if one has been set. If there is no Column Nudge Value Adaptable Blotter will continue to Step 3.
If the column does not have a Default Nudge value, Adaptable Blotter will use the Default Nudge Value for Blotter amount as the Nudge Value. By default, this is 1, but you can change it.
All numeric columns use the Blotter's default Nudge Value to determine how cell values will change when you press + or - keys on the keyboard.
If you have set up your own default Nudge Value for that column - or created a Nudge Value query that applies - than they will take precedence over the Blotter's default Nudge Value
If the blotter's default Nudge Value (usually set to 1) is inappropriate for your grid, you can change it to another amount in the Plus / Minus screen.
By default, every column inherits the Nudge Value that has been set for the blotter. If you want a column to use a different Nudge Value, you need to create a Column Rule. This is a simple rule that tells Adaptable Blotter to use a Nudge Value that you define.
To change the default Nudge Value for a Column, click 'New' in the Plus/Minus screen to open the Plus/Minus wizard. Select the Column from the dropdown, enter the Nudge Value you require and check the 'Default Nudge Value for Column' checkbox.
The default Nudge Value for the column will be used if the column has no custom rules.
You can edit, delete and share Cell Validation rules as you can with all Adaptable Blotter Objects.
Sometimes you might want to change the Nudge Value for a column depending on the values in other columns. For example, you may want the nudge value for the Bid Offer Spread column to be 4 when the Currency is EUR or GBP, but 3 when the Currency is USD. To set up these relationships, you need to create a Nudge Value with Custom Rules.
When you create a Nudge Value with custom rules, you set a custom Nudge Value and then define the rules by building a query. Adaptable Blotter only uses the custom Nudge Value if a row's values match all of the conditions set in your query.
If a row's values do not match the query conditions, the custom Nudge Value is not used. Instead, Adaptable Blotter uses the default Nudge Value for the row or the default Nudge Value for the grid.
To create a Custom Plus/Minus Rule, click 'New' in the Plus/Minus popup to open the Plus/Minus wizard. Select the Column from the dropdown, enter the Nudge Value you require and check the 'Custom Plus/Minus Rule' checkbox. Click 'Next' to create a Query for the Plus Minus Rule. For more information on building and editing Queries using multiple Conditions and Criteria see Queries.
You can edit, delete and share Plus / Minus rules as you can with all Adaptable Blotter Objects.