{"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":4,"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":482394.07},{"$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_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015179_0\")","v":"25/06/2019 07:40:59"},"Order placed","You placed order to buy  5,222 EURGBP spot @ market D.O.   .\r\nFront office order id: 77964781\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992552\")","v":"25/06/2019 07:40:59"},"Trade confirmation","You bought 5,222 EURGBP @ 0.89278 for value date 27-Jun-2019  commission 2.35 GBP\r\nFront office position id: 231728123\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015187_0\")","v":"25/06/2019 07:41:11"},"Order placed","You placed order to buy  1,500 EURGBP spot @ market D.O.   .\r\nFront office order id: 77964782\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992555\")","v":"25/06/2019 07:41:12"},"Trade confirmation","You bought 1,500 EURGBP @ 0.89274 for value date 27-Jun-2019  commission 2.35 GBP\r\nFront office position id: 231728129\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015194_0\")","v":"25/06/2019 07:41:28"},"Order placed","You placed order to sell  1,500 EURGBP spot @ market D.O.   .\r\nFront office order id: 77964783\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992558\")","v":"25/06/2019 07:41:28"},"Trade confirmation","You sold 1,500 EURGBP @ 0.89271 for value date 27-Jun-2019  commission 2.35 GBP\r\nFront office position id: 231728135\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015198_0\")","v":"25/06/2019 07:41:35"},"Order placed","You placed order to buy  5,000 EURGBP spot @ market D.O.   .\r\nFront office order id: 77964784\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992560\")","v":"25/06/2019 07:41:35"},"Trade confirmation","You bought 5,000 EURGBP @ 0.89280 for value date 27-Jun-2019  commission 2.35 GBP\r\nFront office position id: 231728139\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015211_0\")","v":"25/06/2019 07:41:54"},"Order placed","You placed order to sell  6,000 EURGBP spot @ market D.O.   .\r\nFront office order id: 77964785\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992564\")","v":"25/06/2019 07:41:54"},"Trade confirmation","You sold 6,000 EURGBP @ 0.89271 for value date 27-Jun-2019  commission 2.35 GBP\r\nFront office position id: 231728147\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015299_0\")","v":"25/06/2019 07:45:04"},"Order placed","You placed order to sell  1,500 EURGBP spot @ market D.O.   .\r\nFront office order id: 77964786\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992590\")","v":"25/06/2019 07:45:04"},"Trade confirmation","You sold 1,500 EURGBP @ 0.89272 for value date 27-Jun-2019  commission 2.35 GBP\r\nFront office position id: 231733999\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015307_0\")","v":"25/06/2019 07:45:20"},"Order placed","You placed order to buy  5,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 77964787\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992595\")","v":"25/06/2019 07:45:20"},"Trade confirmation","You bought 5,000 EURUSD @ 1.13866 for value date 27-Jun-2019  commission 3 USD\r\nFront office position id: 231734009\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015314_0\")","v":"25/06/2019 07:45:38"},"Order placed","You placed order to buy  1,500 EURUSD spot @ market D.O.   .\r\nFront office order id: 77964788\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992598\")","v":"25/06/2019 07:45:38"},"Trade confirmation","You bought 1,500 EURUSD @ 1.13860 for value date 27-Jun-2019  commission 3 USD\r\nFront office position id: 231734015\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015362_0\")","v":"25/06/2019 07:46:32"},"Order placed","You placed order to buy  5,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 77964789\r\nAccount: 9073876"]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992618\")","v":"25/06/2019 07:46:32"},"Trade confirmation","You bought 5,000 EURUSD @ 1.13877 for value date 27-Jun-2019  commission 3 USD\r\nFront office position id: 231734055\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015380_0\")","v":"25/06/2019 07:47:13"},"Order placed","You placed order to sell  15,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 77964790\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992622\")","v":"25/06/2019 07:47:13"},"Trade confirmation","You sold 15,000 EURUSD @ 1.13893 for value date 27-Jun-2019  commission 3 USD\r\nFront office position id: 231734063\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015391_0\")","v":"25/06/2019 07:48:00"},"Order placed","You placed order to sell  6,000 EURHUF spot @ market D.O.   .\r\nFront office order id: 77964791\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992623\")","v":"25/06/2019 07:48:01"},"Trade confirmation","You sold 6,000 EURHUF @ 323.910 for value date 27-Jun-2019  commission 853.28 HUF\r\nFront office position id: 231734065\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015448_0\")","v":"25/06/2019 07:50:29"},"Order placed","You placed order to sell  5,000 VOD:xlon CFDs @ market D.O.   .\r\nFront office order id: 77964792\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992643\")","v":"25/06/2019 07:50:29"},"Trade confirmation","Order  executed to sell 5,000 VOD:xlon CFDs @ 124.300 (share price).\r\nYou sold 5,000 VOD:xlon CFDs @ 124.300 commission 8 GBP\r\nValue date 25-Jun-2019\r\nTotal face value 6,215 GBP\r\nFront office position id: 231739705\r\nAccount: 9073876\r\nWhen short selling CFDs, you can experience forced closure of a position if your CFDs get recalled",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015746_0\")","v":"25/06/2019 08:06:26"},"Order placed","You placed order to buy  5,000 VOD:xlon CFDs @ market D.O.   .\r\nFront office order id: 77964799\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992838\")","v":"25/06/2019 08:06:26"},"Trade confirmation","Order executed to buy 5,000 VOD:xlon CFDs @ 124.640 (share price).\r\nYou bought 5,000 VOD:xlon CFDs @ 124.640 commission 8 GBP\r\nValue date 25-Jun-2019\r\nTotal face value 6,232 GBP\r\nFront office position id: 231750495\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"217015750_0\")","v":"25/06/2019 08:06:47"},"Order placed","You placed order to sell  100,000 EURUSD spot @ market D.O.   .\r\nFront office order id: 77964800\r\nAccount: 9073876",null,null,null,""]
[{"$f":"_xll.OpenAPISubscribeRtd(\"ExcelTrader_251cf5bc-ac6b-41a5-96a7-6666e9676ee6\",\"MessageId\",\"0_21992839\")","v":"25/06/2019 08:06:47"},"Trade confirmation","You sold 100,000 EURUSD @ 1.13870 for value date 27-Jun-2019  commission 5.69 USD\r\nFront office position id: 231750497\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,""]
[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",482423.03,"EUR"]
[null,null,null,null,null,null,null,"TransactionsNotBooked",{"$f":"_xll.OpenAPIGet(\"/openapi/port/v1/balances/?ClientKey=\"&I3&\"&AccountKey=\"&I4,\"TransactionsNotBooked\")","v":-28.96},{"$f":"J7","v":"EUR"}]
[null,null,null,null,null,null,null,"Cash available",{"$f":"I7+I8","v":482394.07},{"$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]