{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":3,"n_cols":44,"rows_kept":3,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44]
["Account Number","Account Type","Order Action","Quantity","Symbol/CUSIP ","Price Type","Time In Force","Stop Price/Limit Price","Quantity Type","Exchange to Symbol","Block Indicator","Block ID","NAV","Misc. Fee","Sol/Unsol","NAV Reason","Rep of Entry","Trade Away ID","Price/Share","Commission Amount","Trade Date","Settlement Date","Vs. Purchase Date","Client Confirm Note","Order Routing","Trailing Value Indicator","Trail Amount","Conditions","CDSC Fee Waiver","Redemption Fee Waiver","Transaction Fee Waiver","TPA Order ID","Transaction Disposal Method (Override)","Foreign Equity and FX Indicator","To/From Currency Indicator","Alternative Settlement Currency","From Quantity","From Currency","To Quantity","To Currency","Special Instructions","<BLANK>","Stop Price","Based On"]
["Displays the number of the account involved in the order.","Displays the type of account involved in the order; selections are: 0-DVP/RVP, 1-Cash, 2-Margin, 3-Short/Cover, or <Blank>-Auto. NOTE: Auto does not apply to international allocations.","Displays the type of order; selections are: Equity Orders: B-Buy, S-Sell, or SH-Sell Short Equity. NOTE: When using B-Buy, the Action is Buy to Cover for Account Type 3. Option Orders: BCO-Buy Calls to Open, BCC-Buy Calls to Close, BPO-Buy Puts to Open, BPC-Buy Puts to Close, SCO-Sell Calls to Open, SCC- Sell Calls to Close, SPC-Sell Puts to Close, or SPO-Sell Puts to Open.  Fund Orders: B-Buy, S-Sell, BF-Buy Fund, SF-Sell Fund, EF-Exchange Fund, or CF-Cross Fund Family.   Foreign Currency: FX-Foreign Exchange. ","Displays the numeric quantity or amount of the order - out to five decimal places. Equity Orders: Displays in Shares and must be a whole number greater than 0. Option Orders: Displays in Contracts and must be a whole number greater than 0. ","Displays the symbol or CUSIP of the security associated with the order. International Equity symbols include a colon followed by a country code. This field is blank (<null>) for Currency Exchanges.","Displays only when adding Equity and Option orders and selects the price type for the order; selections are: Equity Orders: M-Market, L-Limit, S-Stop Loss, SL-Stop Limit, TS-Trailing Stop Loss by % and $, or TL -Trailing Stop Limit by % and $. International Equity Orders: M-Market or L-Limit. Option Orders: M-Market, L-Limit, S-Stop Loss, or SL-Stop Limit.","Displays how long the order should remain in the market place seeking the specified price type; options are: D-Day, G-Good Til Canceled, F-Fill or Kill, I-Immediate or Cancel, O-On the Open, or C-On the Close. International Equity Orders: D-Day only. NOTE: Good Til Canceled orders are good for up to 120 days.","Displays the Stop Price/Limit Price out to five decimal places. NOTE: Required if the Price Type is Limit, Stop Loss, or Stop Limit. Use the alternate Stop Price field if the Stop and Limit Prices differ. ","Associated with the Quantity field; Equity and Option Orders can only be S-Shares/Contracts. ","NOTE: This field is Required for orders with an order action of Exchange Fund or Cross Fund Family orders.\nDisplays the Fund ID of the second security in an exchange order.","Displays only when creating block or allocation orders; options are: Y-Yes (Block), N-Indicates an Allocation if a Block Indicator is provided (otherwise an order), T-Prime Brokerage Order, A-Prime Brokerage Allocation, S-Step In Order, or I-Step In Allocation.","NOTE: This field is Required for Prime Brokerage and Step In orders (4 Character DTC Number if Block Indicator = T or S).","N/A\n","NOTE: This field is Optional and only applicable to Correspondent orders. Displays any fees associated with the order. ","NOTE: This field is Optional and only applicable to Correspondent orders. Indicates how the order was taken; options are: <>-Blank, S-Solicited, U-Unsolicited, or D-Discretionary. \n\n","N/A","NOTE: This field is Optional and used for single broker/dealer orders only. Displays the ID of the person who created the order.","NOTE: This field is Required for Advent Moxy Prime Brokerage Orders and Allocations (Block Indicator =T) and Step In Orders and Allocations (Block Indicator=S) only, where the Allocation order Action is blank. Used to match Allocations to Prime Brokerage and Step In orders. \n","NOTE: This field is Required for Prime Brokerage Orders (Block Indicator=T) and Step In Orders (Block Indicator=S) only. Displays the price per share out to five decimal places. ","NOTE: This field is Required for Prime Brokerage Orders (Block Indicator=T) only. Displays the commission per share out to two decimal places.","NOTE: This field is Required for Prime Brokerage Orders (Block Indicator=T) and Step In Orders (Block Indicator=S) only. Format is MMDDYYYY. Displays the date of the trade. ","NOTE: This field is Required for Prime Brokerage Orders (Block Indicator=T) and Step In Orders (Block Indicator=S) only. Format is MMDDYYYY. Displays the date that the trade settles. ","NOTE: This field is Optional. Displays the versus purchase date of the order for tax lot accounting purposes. NOTE: Format is MMDDYYYY. ","NOTE: This field is Optional. Designates the power of discretion for this action; selections are: 1-Cross Trade, 2-Client Requested, or 3-Advisor Directed.","Used to enable order routing for Global Equities; the only selection is TQ-FCMS Global Trading Desk, otherwise the routing will be Auto. NOTE: This field only applies to Global Equities and should be left blank in all other cases. It is used with the Special Instructions field. \n","NOTE: This field is Required for TS-Trailing Stop Loss by % or $, or TL-Trailing Stop Limit by % or $ orders only. Used with the Trail Amount field and specifies whether this amount should be treated as a P-Percentage or a D-Dollar amount.","NOTE: This field is Required for TS-Trailing Stop Loss by % or $, or TL-Trailing Stop Limit by %, $ orders only. Used with the Trailing Value Indicator field and specifies the amount that a trailing stop order “trails” the current market; may be either a P-Percentage or a D-Dollar amount.","NOTE: This field is Optional. Displays special order conditions; selections are: A-All or None, R-Do Not Reduce, AR-All or None/Do Not Reduce, or H-Not Held.","N/A","N/A","Optionally displays the reason for waiving the transaction fee.","Displays an optional TPA Order ID Number that can be used as a reference.","Displays the designated disposal method for the order; selections are: C–FIFO (First In, First Out), D–HICO (High Cost In, First Out), E–HICL (High Cost In, First Out, Long Term), F–HICS (High Cost In, First Out, Short Term), G– LIFO (Last In, First Out), H- LOCO (Low Cost In, First Out), I–LOCL (Low Cost In, Long Term), J–LOCS (Low Cost In, Short Term), K–INFI (Intraday First In, First Out), M–STTS (Short Term Tax Sensitive), or L– TXSN (Tax Sensitive). NOTE: This selection is Optional and overrides the established account-level transaction disposal method.","Indicates if the order is domestic or international; selections are: Y-Global Equity or Currency Exchange, <Null> or N-Domestic Equity. NOTE: This field is required for Global Equity and Currency Exchange orders and allocations.","Indicates the direction of the currency exchange; selections are: T-If the To Quantity field is populated or F-If the From Quantity field is populated. NOTE: This field is Required for Currency Exchange orders and allocations.","Optionally displays the currency in which the trade will settle. NOTE: If this field is not populated, the order defaults to the local currency. Global Block trades and Allocations always settle in the local currency.","Indicates the quantity of the From Currency. NOTE: If <Null>, the To Quantity field must be populated. If populated, the To Quantity field must be <Null>.\n","Displays the currency of the From Quantity. NOTE: This field is Required for Currency Exchange orders","Indicates the quantity of the To Currency.  NOTE: If <Null>, the From Quantity field must be populated. If populated, the From Quantity field must be <Null>.\n","Displays the currency of the To Quantity.  NOTE: This field is Required for Currency Exchange orders","Optionally displays any special instructions associated with the order. NOTE: This field is required only for Routed international orders; it is blank (<Null>) for all other orders.","NOTE: This field should be left blank.","NOTE: This field is required for Stop Limit orders to designate the Stop Price. If this field is left blank, the Stop Price / Limit Price field will be used for both the Stop Price and the Limit Price.","Designates the price used as the trigger value for a Trailing Stop order; selections are: T-Last, B-Bid, and A-Ask. NOTE: Only displays if the Price Type is Trailing Stop Loss (% or $) or Trailing Stop Limit (% or $). If this field is left blank, the default value (T-Last) is used.\n\n\n"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}