Contents
|
Trading and Account Actions Using Spreadsheet View Add or Edit Trades to Create a Custom Strategy |
Introduction
Spreadsheet view on the Rebalance Summary page allows you to review and build your proposed trades for an account or group while seeing cash, drift, and tax implications in an interactive grid.
To view similar information across all accounts, use the Trade Review page.
From the Rebalance Summary page, you can switch between standard view and spreadsheet view. To switch between these views, turn on Spreadsheet view at the top of the report:
When you're working in Spreadsheet view, you retain the features of the Rebalance Summary page you're on. For example, you can:
- Switch your view between a group and its accounts.
- Go to the next or previous group or account's Rebalance Summary page and retain the spreadsheet view.
- Set rebalance settings.
- See columns of calculated data sets.
For more about these features, including column definitions and calculations, see Reading the Rebalance Summary.
Spreadsheet View Widgets
For your reference, when you're working in Spreadsheet view, the same informational widgets remain on the Rebalance Summary page:
- Allocation Pie Charts
- Account Information
- YTD Realized Gain/Loss
- Cash Information
- Cash Reserve Detail
For more information on each Rebalance Summary widget, see Widgets on the Rebalance Summary.
Additionally, in Spreadsheet view you'll find a Cash Above Reserves widget that adjusts interactively as you adjust trades.
Trading and Account Actions Using Spreadsheet View
In addition to seeing recommended trades and cash information for the account or group, you can take the following actions with Spreadsheet view.
See Trading Alerts
If there's an account with a current trading note, you'll see a banner warning at the top of the Rebalance Summary with a link to download a bulk report that shows:
- Active trading alerts
- Pending order notes
- Restriction override notes
This banner gives you access to current trading notes without having to leave the report of view individual accounts.
Approve Trades
Select Approve Trades for the individual account or rebalancing group. If an account is in a rebalancing group, you must approve trades for the group.
For more information, see Approve Trades.
If required, you can also approve non-discretionary trades in spreadsheet view.
For more information, see Discretionary Account Setting.
Add Notes
Trade notes allow you to add information about the trade, such as trade instructions, background information, or the reason for a trade. This allows you to document information about trades, orders, client wishes, or other information you will need to see in the future. These are the ways you can add documentation in spreadsheet view:
- Add a trade-specific note. From Actions, select Enter reason for trade to add a trade-specific note.
- Add a general note. From Actions, select Add account note to add other information to the account or group you're viewing.
- Add an order note. On the More options menu for individual trades, use Add/Edit order note to add details for specific trades.
You can see these notes anywhere you can view account notes as well as in various bulk reports. For more information, see Overview of Notes in Tamarac Trading.
Add or Edit Trades to Create a Custom Strategy
After a rebalance, spreadsheet view lists the ideal recommended trades for the account or group. However, there are cases where you'll want to change the recommended trades.
In spreadsheet view, you can edit details about a trade:
- Change the amount of the trade in Dollars, Shares, or % of Account Value.
- Change the trade action to None to remove the recommended buy or sell.
- Select specific tax lots to sell.
For more information, see Manual Trades.
You can add a trade that isn't recommended in spreadsheet view using Create Quick Trade.
You can then add details about the security and the trade you'd like to add.
For more information, see Create a Quick Trade.
Add or Update an Order's Order Instructions
At times, you may want to place order instructions to establish price and time in force conditions on your trade orders. Those who use the FIX Flyer interface can create a Conditional Order by adding or updating Order Instructions.
For more information, see Add or Update Order Instructions.
Hold Trades
Place Specific trades on hold
You can place specific trades on hold, allowing you to save the details of the trade for future execution. This allows you to save trade details overnight, whereas trades not place on hold will not be saved until the next day. When you need to place a specific trade on hold, you can do so from the spreadsheet view actions menu.
Place all trades on hold
When you need to place all trades on hold, you can do so from the spreadsheet view actions menu.
For more information, see Trades on Hold.
Remove Rebalance
If you decide an account or group no longer needs to be rebalanced, you can remove all recommended trades. To remove trades, in the spreadsheet view actions menu, select Remove Rebalance.
Work with Columns
Sort Columns
Sort data in columns by ascending or descending order. For more information, see Sort and Filter Columns on Pages in Tamarac.
