Google Sheets JSON API Javascript 3commas code

Suoritettu Julkaistu 2 vuotta sitten Maksettu toimituksen yhteydessä
Suoritettu 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.

JSON Google Sheets API JavaScript Trading

Projektin tunnus: #31556820

Tietoa projektista

5 ehdotusta Etäprojekti Aktiivinen 2 vuotta sitten

Myönnetty käyttäjälle:

Iamtazy

Hi! I'll be honest with you, I don't have experience in Google Sheets specifically, but it's standard JS, so shouldn't be a problem. I also don't have experience with 3commas (kind of a specific thing to ask on this si Lisää

$110 USD 4 päivässä
(0 Arvostelua)
0.0

5 freelanceria on tarjonnut keskimäärin $140 tähän työhön

NextYoo

⭐️Hi There⭐️ I am confident for the project ⭐️GUARANTEE:- WORK DONE OR FULL REFUND ⭐️WHY ME :- I have 100% complete rate because I have good Respect for clients and i always try to make good communication to clear th Lisää

$170 USD 5 päivässä
(7 arvostelua)
4.7
Fayyaz03

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!

$140 USD 1 päivässä
(0 arvostelua)
0.0