Google Sheets JSON API Javascript 3commas code
$30-250 USD
Maksettu toimituksen yhteydessä
I need code which calls a REST API with a signed JSON payload.
Specifically, it sends a crypto currency smart trade to the online [login to view URL] service. Ultimately I want to integrate this code into Google Sheets. Therefore, the code will need to work with Javascript.
Do not apply for this job if:
1 - Do not read and understand this job fully
2 - You just copy/paste/modify a standard response
3 - Have no experience with Google Sheets, API’s or 3commas
*** PLEASE READ *** - Help me, help you by starting your response with reasons why you are a good fit for the job. Tell me about your experience with 3commas, crypto etc. I want to save your time and my own. I get dozens of replies which don't have the correct experience. I get it, I've been a freelancer. You don't want to spend much time on things at this stage and just play a numbers game and throw out responses. Please don't in this case. :)
API’s
The API’s for the 3commas service are located at [login to view URL] and [login to view URL]
My problem (the reason I’m posing this job)
I can use Postman and a SHA-256 online calculator to successfully create a simple query string. My problem comes when trying to use the
The docs at [login to view URL] show this "Another way to create smart trade v2 is send JSON body with the header”. I’ve been unable to figure out how to include a chunk of JSON which allows a Smart Trade to be created.
Request Digital Signature
Every request being sent needs to be signed using a SHA-256 algorithm. Javascript code for this is available online. In fact there are specific Google sheets examples. Here is one - [login to view URL] For testing with Postman I’ve used services like this - [login to view URL]
Skills and tools needed for this job
Experience with 3commas
Preferably a Pro account with 3commas
If you do not have a 3commas Pro account you could sign up for a free trial. No other account includes access to the API. Please be careful, the pro account is only accessible for 3 days. I will *not* pay for your account or can give you access to my own.
Good Javascript, JSON, REST API knowledge
Basic Google Sheets scripting knowledge
Requirements
A working Google sheets spreadsheet which:
1 - Contains a Google worksheet for all the parameters required for a 3commas Smart Trade (see JSON example below). Includes private/secret keys.
2 - A button on the worksheet which executes Javascript code
3 - Javascript code which successfully places a Smart Trade with 3commas (paper trading account)
I will replace your private/secret with my own and should see the code run correctly.
JSON example
Here’s an example from the 3commas docs which show the type of JSON structure which needs to be passed to the service. This is a good example of what I’ll need. It contains the key elements:
1 - Account ID, pair to buy etc.
2 - The buy position amount, market order type
3 - Take profit
4 - Stop loss
You will need to put all these parameters into a Google sheet and then use Javascript code to pull the parameters from the sheet and use them in Javascript code to call the 3commas Smart Trade service.
SEE THE ATTACHED EXAMPLE FOR MORE INFO.
Projektin tunnus: #31556820
Tietoa projektista
5 freelanceria on tarjonnut keskimäärin $140 tähän työhön
Hi, I'm a full-stack web developer with over 8 years of experience. I saw your article and have a few concerns about your project. I'd be happy to talk more about it. Gratitude!