{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Disclaimer","Trader","account"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Disclaimer","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,15,3],[17,1,24,3]]}
[]
[null,"Copyright © 2019 Saxo Bank A/S\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nYou may not use this file except in compliance with the License.\nYou may obtain a copy of the License at\n\nhttp://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and limitations under the License."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WARNING:\n\nThis tool sends trades AUTOMATICALLY to Saxo's OpenAPI and should only be used for demonstration purposes.\n\nDO NOT USE IN LIVE ENVIRONMENT.\n\n"]

{"sheet":"Trader","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["OpenAPI AutoTrader Tool"]
[]
["Select your account from the dropdown. Update price & choose trading rules before activating."]
[]
["Select account:","9073876"]
["Cash available:",{"$f":"account!I9","v":482352.7},{"$f":"account!J7","v":"EUR"}]
[]
["Trader status","Paused"]
["Last update","10:20:23"]
["Update interval",5,"Sec"]
[]
["Target instrument"]
["UIC","Exchange","Description","Price","Symbol","Currency"]
[21,{"$f":"_xll.OpenAPIGetAutoResize(\"/openapi/ref/v1/instruments/details/\"&A14&\"/FxSpot/?FieldGroups=\",\"Exchange.ExchangeId,Description\",FALSE)","v":"SBFX"},"Euro/US Dollar",1.138855,{"$f":"_xll.OpenAPIGetAutoResize(\"/openapi/trade/v1/infoprices/?AssetType=FxSpot&FieldGroups=DisplayAndFormat&Uic=\"&A14,\"DisplayAndFormat.Symbol,DisplayAndFormat.Currency\",FALSE)","v":"EURUSD"},"USD"]
[]
["Trading rule"]
["short if","price >",1.1499999999999999]
["long if","price <",1.1299999999999999]
[]
["Order"]
["Amount",10000,{"$f":"C14","v":"Euro/US Dollar"}]
[]
["Current posititon","Long",10000]
[]
[]
["Order log"]

{"sheet":"account","index":2,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Account overview for drop-down selection. Works for up to 5 accounts.",null,null,null,null,null,null,"ClientKey and account details."]
[{"$f":"_xll.OpenAPIGetAccountList()","v":"AccountId"},"AccountKey","AccountGroupName","AccountGroupKey","ClientId","ClientKey"]
["9073876","X1JlUyeXTMK3mBxzd-D2UA=="," ","X1JlUyeXTMK3mBxzd-D2UA==","9073876","X1JlUyeXTMK3mBxzd-D2UA==",null,"ClientKey",{"$f":"_xll.OpenAPIGetClientKey()","v":"X1JlUyeXTMK3mBxzd-D2UA=="}]
["9073876_AUD","Nr0wsPGUYZCD4yIkFDGa4A=="," ","X1JlUyeXTMK3mBxzd-D2UA==","9073876","X1JlUyeXTMK3mBxzd-D2UA==",null,"Selected AccountKey",{"$f":"VLOOKUP(Trader!B5,A3:B7,2,FALSE)","v":"X1JlUyeXTMK3mBxzd-D2UA=="}]
["9073876_DKK","KMgyuRfY-yDoSzDmdK-HZQ=="," ","X1JlUyeXTMK3mBxzd-D2UA==","9073876","X1JlUyeXTMK3mBxzd-D2UA=="]
["9073876_JPY","MXt3pDqb5VEujcdqBV1cmQ=="," ","X1JlUyeXTMK3mBxzd-D2UA==","9073876","X1JlUyeXTMK3mBxzd-D2UA==",null,null,{"$f":"_xll.OpenAPIGetAutoResize(\"/openapi/port/v1/balances/?AccountKey=\"&I4&\"&ClientKey=\"&I3,\"CashBalance,Currency\",TRUE)","v":"CashBalance"},"Currency"]
["9073876_USD","hR3h0OwLknemBKHq6khSww=="," ","X1JlUyeXTMK3mBxzd-D2UA==","9073876","X1JlUyeXTMK3mBxzd-D2UA==",null,"Account balance",482423.03,"EUR"]
[null,null,null,null,null,null,null,"TransactionsNotBooked",{"$f":"_xll.OpenAPIGet(\"/openapi/port/v1/balances/?ClientKey=\"&I3&\"&AccountKey=\"&I4,\"TransactionsNotBooked\")","v":-70.33},{"$f":"J7","v":"EUR"}]
[null,null,null,null,null,null,null,"Cash available",{"$f":"I7+I8","v":482352.7},{"$f":"J8","v":"EUR"}]