{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Disclaimer","Trade","account","config"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Trade","index":1,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["OpenAPI Trading Tool"]
[]
["Search keyword","EURUSD"]
["AssetType","FxSpot"]
["Results shown (max=10)",10]
[]
["Select account:","9073876"]
["Cash available:",{"$f":"IFERROR(account!I9,\"Please log in.\")","v":376833.24},{"$f":"IFERROR(account!J9,\"\")","v":"EUR"}]
[]
["Symbol","AssetType","Identifier","Description","CurrencyCode","PrimaryListing","Action"]
[{"$f":"_xll.OpenAPIGetAutoResize(\"/openapi/ref/v1/instruments/?$top=\"&top&\"&Keywords=\"&Trade!B3&\"&AssetTypes=\"&Trade!B4&\"\",A10&\",\"&B10&\",\"&C10&\",\"&D10&\",\"&E10&\",\"&F10)","v":"EURUSD"},"FxSpot",21,"Euro/US Dollar","USD"," ",{"$f":"IF(ISNUMBER(C11),\"TRADE\",\"\")","v":"TRADE"}]
[null,null,null,null,null,null,{"$f":"IF(ISNUMBER(C12),\"TRADE\",\"\")","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
["Trade Messages",null,null,null,null,null,""]
[{"$f":"_xll.OpenAPISubscribe(\"/openapi/trade/v1/messages/subscriptions\",\"\",\"\",\"DateTime,MessageHeader,MessageBody\")","v":"DateTime"},"MessageHeader","MessageBody",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217704568_0\")","v":"18/07/2019 07:38:05"},"Order placed","You placed order to sell  50,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 78364696\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22212016\")","v":"18/07/2019 07:38:05"},"Trade confirmation","You sold 50,000 EURUSD @ 1.12387 for value date 22-Jul-2019  commission 3 USD\r\nFront office position id: 234410763\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215840\")","v":"18/07/2019 12:35:26"},"Trade confirmation","You bought 1,500 EURUSD @ 1.12139 for value date 22-Jul-2019  commission 3 USD\r\nFront office position id: 234419435\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721650_0\")","v":"18/07/2019 12:35:26"},"Order placed","You placed order to buy  1,500 EURUSD spot @ market D.O.   .\r\nFront office order id: 78374617\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215844\")","v":"18/07/2019 12:35:35"},"Trade confirmation","You sold 1,500 EURUSD @ 1.12140 for value date 22-Jul-2019  commission 3 USD\r\nFront office position id: 234419443\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721663_0\")","v":"18/07/2019 12:35:35"},"Order placed","You placed order to sell  1,500 EURUSD spot @ market D.O.   .\r\nFront office order id: 78374618\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215857\")","v":"18/07/2019 12:37:22"},"Trade confirmation","You sold 100,000 EURDKK @ 7.46727 for value date 22-Jul-2019  commission 37.34 DKK\r\nFront office position id: 234419469\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721754_0\")","v":"18/07/2019 12:37:22"},"Order placed","You placed order to sell  100,000 EURDKK spot @ market D.O.   .\r\nFront office order id: 78374632\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215872\")","v":"18/07/2019 12:38:37"},"Trade confirmation","You bought 15,000 EURUSD @ 1.12171 for value date 22-Jul-2019  commission 3 USD\r\nFront office position id: 234419499\r\nAccount: 9073876_USD"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721804_0\")","v":"18/07/2019 12:38:37"},"Order placed","You placed order to buy  15,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 78374644\r\nAccount: 9073876_USD"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215874\")","v":"18/07/2019 12:38:44"},"Trade confirmation","You bought 15,000 EURUSD @ 1.12169 for value date 22-Jul-2019  commission 3 USD\r\nFront office position id: 234419503\r\nAccount: 9073876_USD"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215875\")","v":"18/07/2019 12:38:47"},"Trade confirmation","You sold 100,000 GBPUSD @ 1.24850 for value date 22-Jul-2019  commission 6.24 USD\r\nFront office position id: 234419505\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215876\")","v":"18/07/2019 12:38:50"},"Trade confirmation","You sold 10,000 EURUSD @ 1.12154 for value date 22-Jul-2019  commission 3 USD\r\nFront office position id: 234419507\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721811_0\")","v":"18/07/2019 12:38:44"},"Order placed","You placed order to buy  15,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 78374648\r\nAccount: 9073876_USD"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721813_0\")","v":"18/07/2019 12:38:47"},"Order placed","You placed order to sell  100,000 GBPUSD spot @ market D.O.   .\r\nFront office order id: 78374649\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721815_0\")","v":"18/07/2019 12:38:50"},"Order placed","You placed order to sell  10,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 78374650\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215877\")","v":"18/07/2019 12:38:53"},"Trade confirmation","You sold 751 VOD:xlon shares @ 127.06 commission 8 GBP \r\nIn total you receive 946.22 GBP, value date 22-Jul-2019. \r\nFront office position id: 234419509\r\nAccount: 9073876_AUD"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215878\")","v":"18/07/2019 12:38:55"},"Trade confirmation","You sold 10,000 EURUSD @ 1.12155 for value date 22-Jul-2019  commission 3 USD\r\nFront office position id: 234419511\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215879\")","v":"18/07/2019 12:38:58"},"Trade confirmation","You sold 100,000 EURUSD @ 1.12145 for value date 22-Jul-2019  commission 5.61 USD\r\nFront office position id: 234419513\r\nAccount: 9073876_USD",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215881\")","v":"18/07/2019 12:39:00"},"Trade confirmation","You sold 1,000,000 EURUSD @ 1.12163 for value date 22-Jul-2019  commission 56.08 USD\r\nFront office position id: 234419517\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721818_0\")","v":"18/07/2019 12:38:53"},"Order placed","You placed order to sell  751 VOD:xlon shares @ market D.O.   .\r\nFront office order id: 78374651\r\nAccount: 9073876_AUD",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721820_0\")","v":"18/07/2019 12:38:55"},"Order placed","You placed order to sell  10,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 78374652\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721823_0\")","v":"18/07/2019 12:38:58"},"Order placed","You placed order to sell  100,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 78374653\r\nAccount: 9073876_USD",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721827_0\")","v":"18/07/2019 12:39:00"},"Order placed","You placed order to sell  1,000,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 78374655\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215882\")","v":"18/07/2019 12:39:04"},"Trade confirmation","You sold 100,000 EURGBP @ 0.89824 for value date 22-Jul-2019  commission 4.49 GBP\r\nFront office position id: 234419519\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215883\")","v":"18/07/2019 12:39:06"},"Trade confirmation","You bought 15,000 EURUSD @ 1.12182 for value date 22-Jul-2019  commission 3 USD\r\nFront office position id: 234419521\r\nAccount: 9073876_USD",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721829_0\")","v":"18/07/2019 12:39:04"},"Order placed","You placed order to sell  100,000 EURGBP spot @ market D.O.   .\r\nFront office order id: 78374656\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217721831_0\")","v":"18/07/2019 12:39:06"},"Order placed","You placed order to buy  15,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 78374657\r\nAccount: 9073876_USD",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217722373_0\")","v":"18/07/2019 12:44:36"},"Order placed","You placed order to buy  50,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 78373559\r\nAccount: 9073876_AUD",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215962\")","v":"18/07/2019 12:44:36"},"Trade confirmation","You bought 50,000 EURUSD @ 1.12184 for value date 22-Jul-2019  commission 3 USD\r\nFront office position id: 234419679\r\nAccount: 9073876_AUD",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"217722823_0\")","v":"18/07/2019 12:49:35"},"Order placed","You placed order to sell  1,500 EURUSD spot @ market D.O.   .\r\nFront office order id: 78373564\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_93ef04e5-e288-4ba8-bed3-02d864b9fdda\",\"MessageId\",\"0_22215990\")","v":"18/07/2019 12:49:35"},"Trade confirmation","You sold 1,500 EURUSD @ 1.12153 for value date 22-Jul-2019  commission 3 USD\r\nFront office position id: 234419735\r\nAccount: 9073876",null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]

{"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(Trade!B7,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",376962.27,"EUR"]
[null,null,null,null,null,null,null,"TransactionsNotBooked",{"$f":"_xll.OpenAPIGet(\"/openapi/port/v1/balances/?ClientKey=\"&I3&\"&AccountKey=\"&I4,\"TransactionsNotBooked\")","v":-129.03},{"$f":"J7","v":"EUR"}]
[null,null,null,null,null,null,null,"Cash available",{"$f":"I7+I8","v":376833.24},{"$f":"J8","v":"EUR"}]

{"sheet":"config","index":3,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["AssetType","Results"]
["Bond",1]
["CfdIndexOption",2]
["CfdOnFutures",3]
["CfdOnIndex",4]
["CfdOnStock",5]
["FxSpot",6]
["ManagedFund",7]
["MutualFund",8]
["Stock",9]
["StockIndex",10]