{"id":95,"date":"2023-01-16T07:20:00","date_gmt":"2023-01-16T07:20:00","guid":{"rendered":"https:\/\/algomojo.com\/blog\/?p=95"},"modified":"2023-09-13T04:31:31","modified_gmt":"2023-09-13T04:31:31","slug":"how-to-send-orders-from-google-spreadsheets-using-algomojo-api","status":"publish","type":"post","link":"https:\/\/algomojo.com\/blog\/how-to-send-orders-from-google-spreadsheets-using-algomojo-api\/","title":{"rendered":"How to Send Orders from Google SpreadSheets using Algomojo API"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

You might think “Is it really possible to send automated orders from Google Sheets? Are you crazy?” but hey thanks to Google Appscript<\/strong> which is an alternative to VBscript to automate your tasks in your Google Excel Sheets.<\/p>\n\n\n\n

What is Google AppScript<\/strong>?<\/p>\n\n\n\n

Apps Script lets you do more with Google Spreadsheets and with other Google Products, all on a modern JavaScript platform<\/a> in the cloud. Build solutions to boost your collaboration and productivity.<\/p>\n\n\n\n

You access the Appscript Editor from Extensions->AppScript Editor from your Google Spreadsheet.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Creating Button Controls<\/strong><\/p>\n\n\n\n

The Next Step is to Create the Datasheet that you want to transmit and PlaceOrder button to send and transmit those orders to the Algomojo Platform as shown below.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Button Controls can be created by goto Insert Menu -> Drawings<\/strong> and create a Button Control with \u201cPlaceOrder\u201d as text in the button.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Writing the Google Appscript<\/strong><\/p>\n\n\n\n

Open the Script Editor and Paste the below appscript code and save the code as Algomojo Buttons<\/strong>.<\/p>\n\n\n\n

Get the API Key and API Secret Key from Algomojo Platform and replace the apikey and apisecret key in the below code with yours.<\/p>\n\n\n\n

function Algomojo() {\n\n\nvar apikey = "af672a6019523acd27bc4d48ca12cb73";\nvar apisecret = "8b5befaa9ff7e0269326170ac572b67c";\nvar Version = "v1";\nvar broker =  SpreadsheetApp.getActiveSheet().getRange('B3').getValue();\nvar strategy = "Google Sheet";\nvar exchange = SpreadsheetApp.getActiveSheet().getRange('C3').getValue();\nvar symbol = SpreadsheetApp.getActiveSheet().getRange('D3').getValue();\nvar action = SpreadsheetApp.getActiveSheet().getRange('E3').getValue();\nvar pricetype = SpreadsheetApp.getActiveSheet().getRange('F3').getValue();\nvar quantity = SpreadsheetApp.getActiveSheet().getRange('G3').getValue();\nvar price = SpreadsheetApp.getActiveSheet().getRange('H3').getValue();\nvar trigger_price = SpreadsheetApp.getActiveSheet().getRange('I3').getValue();\nvar product = SpreadsheetApp.getActiveSheet().getRange('J3').getValue();\nvar splitorder = SpreadsheetApp.getActiveSheet().getRange('K3').getValue();\nvar split_quantity = SpreadsheetApp.getActiveSheet().getRange('L3').getValue();\n\n\nvar response = PlaceOrder(apikey, apisecret, Version, broker, strategy, exchange, symbol, action, pricetype, quantity, price, trigger_price, product, splitorder,split_quantity);\nSpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getRange('C9').setValue(response);\n}\n\n\nfunction PlaceOrder(apikey, apisecret, Version, broker, strategy, exchange, symbol, action, pricetype, quantity, price, trigger_price, product, splitorder,split_quantity){\n  \n    \n    var amo = "NO";\n    var disclosed_quantity = "0"\n\n    var InTD = "{\\"" \n            + "broker" + "\\":\\"" + broker + "\\",\\""\n            + "strategy" + "\\":\\"" + strategy + "\\",\\"" + "exchange" + "\\":\\"" + exchange + "\\",\\"" \n            + "symbol" + "\\":\\"" + symbol + "\\",\\"" + "action" + "\\":\\"" + action + "\\",\\""  \n            + "product" + "\\":\\"" + product + "\\",\\"" + "pricetype" + "\\":\\"" + pricetype + "\\",\\"" \n            + "quantity" + "\\":\\"" + quantity + "\\",\\"" + "price" + "\\":\\"" + price + "\\",\\"" \n            + "disclosed_quantity" + "\\":\\"" + disclosed_quantity + "\\",\\"" + "trigger_price" + "\\":\\"" + trigger_price + "\\",\\"" \n            + "amo" + "\\":\\"" + amo + "\\",\\"" + "splitorder" + "\\":\\"" + splitorder + "\\",\\"" \n            + "split_quantity" + "\\":\\"" + split_quantity + "\\"}";\n   \n           \n    var result = AMConnect(apikey, apisecret, "am", Version, "PlaceOrder", InTD);\n    return result;\n}\n\n\nfunction AMConnect(api_key, api_secret, Broker, Version, api_name, InTD){\n    \n    var BaseURL = "https:\/\/" + Broker.toLowerCase() + "api.algomojo.com\/" + Version + "\/";\n    var postdata = "{\\"" + "api_key" + "\\":\\"" + api_key + "\\",\\"" \n                    + "api_secret" + "\\":\\"" + api_secret + "\\",\\""\n                    + "data" + "\\":" + InTD + "}";\n  \n\n \n    \n    var Url = BaseURL + api_name;\n  \n     \n  \n  var raw = postdata;\n  Logger.log(raw);\n  \n    var options = {\n      'method' : 'post',\n      'contentType': 'application\/json',\n      \/\/ Convert the JavaScript object to a JSON string.\n      'payload' : raw\n    };\n    var result = UrlFetchApp.fetch(Url, options);\n    return result.getContentText();\n    \n}\n\n\n<\/code><\/pre>\n\n\n\n
Run the code.gs with code execution set to Algomojo() function. There should not be any errors and you should be able to see the executions happening in your trading terminal.<\/p>\n\n\n\n
Assigning the Button Controls to Google Appscript Function<\/strong><\/p>\n\n\n\n
1)Now right-click over the button and click on the triple dots and select the Assign script<\/strong> option<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
2)Enter the Function Name as Algomojo <\/strong>in the Assign Script<\/strong> Popup Dialog box<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Now come back to Google Spreadsheets and click on the Place Order button and check the orders got executed in the Algomojo Order Log section in realtime.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Access the Algomojo Google Spreadsheet – Public View<\/a><\/div>\n<\/div>\n\n\n\n
For sending a different type of orders in your Google Appscript kindly check with the latest algomojo API documentation<\/a><\/p>\n\n\n\n
The possibilities of creating a Automated Trading task is endless creativity. Playaround with Google Appscript and if in case you are able to build something interesting with google appscript let us know here in the comment section.<\/p>\n\n\n\n
Happy Spreadsheet Trading!<\/p>\n","protected":false},"excerpt":{"rendered":"
You might think “Is it really possible to do send automated orders from Google Sheets? Are you crazy?” but hey thanks to Google Appscript which is an alternative to VBscript to automate your tasks in your Google Excel Sheets.<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[38],"tags":[4,34,58,56,59,57,46],"_links":{"self":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts\/95"}],"collection":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/comments?post=95"}],"version-history":[{"count":8,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"predecessor-version":[{"id":594,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts\/95\/revisions\/594"}],"wp:attachment":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/tags?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}