Topic: Help with Calculating Hash for Bittrex/Poloniex API - Bounty - 50 mBTC (Read 3998 times)
June 09, 2016, 11:13:29 AM
SOLVED! Here your solution for using Google script and Google spreadsheet with the Poloniex API POST &/OR GET Method with secret key ecc http://pastebin.com/TXB7Ed7W --> tips and donation are welcome!**
July 26, 2014, 06:38:46 PM
Are you trying to calculate URLs using Docs scripting, or using google/excel spreadsheet formulas?
Edit: This is not possible with a "simple URL" as Poloniex requires POST requests with custom headers, and Bittrex requires custom headers. Neither exchange's API calls can be represented as a simple URL. I would be happy to implement this on another platform such as Google App Engine to act as an intermediary, or as a library for Java, Python, or PHP.
You're also going to need a lot of script engine work to calculate the HMACs as they involve heavy crypto that is not available as a GDocs spreadsheet or Excel formula.
Edit: This is not possible with a "simple URL" as Poloniex requires POST requests with custom headers, and Bittrex requires custom headers. Neither exchange's API calls can be represented as a simple URL. I would be happy to implement this on another platform such as Google App Engine to act as an intermediary, or as a library for Java, Python, or PHP.
You're also going to need a lot of script engine work to calculate the HMACs as they involve heavy crypto that is not available as a GDocs spreadsheet or Excel formula.
Thanks Rarkenin.
Yes, you understood perfectly. Please contact me directly or PM your contact info so we can work together. I have budget for this and am not in a hurry.
July 26, 2014, 05:07:05 PM
Are you trying to calculate URLs using Docs scripting, or using google/excel spreadsheet formulas?
Edit: This is not possible with a "simple URL" as Poloniex requires POST requests with custom headers, and Bittrex requires custom headers. Neither exchange's API calls can be represented as a simple URL. I would be happy to implement this on another platform such as Google App Engine to act as an intermediary, or as a library for Java, Python, or PHP.
You're also going to need a lot of script engine work to calculate the HMACs as they involve heavy crypto that is not available as a GDocs spreadsheet or Excel formula.
Edit: This is not possible with a "simple URL" as Poloniex requires POST requests with custom headers, and Bittrex requires custom headers. Neither exchange's API calls can be represented as a simple URL. I would be happy to implement this on another platform such as Google App Engine to act as an intermediary, or as a library for Java, Python, or PHP.
You're also going to need a lot of script engine work to calculate the HMACs as they involve heavy crypto that is not available as a GDocs spreadsheet or Excel formula.
July 26, 2014, 12:43:43 PM
Hi all,
I currently import various altcoin exchange APIs into Gdocs via Json call. Essentially, I'm trying to import my open orders to Gdocs/Excel.
the Public apis not requiring API key great via public calls easy to enter into a URL. However, private API now require a "nonce" and "signature" for their new API's requiring your key.
I will pay a 0.05 btc bounty to anyone who tells me what this URL needs to look like exactly including the key and nonce/signature. I can do any calculations in Gdocs/Excel and build a URL. The answer must be a simple URL.
My goal is essentially to calculate the URL in excel then retrieve the result via webpage/json.
Bittrex:
'https://bittrex.com/api/v1.1/market/getopenorders?apikey='.$apikey.'&nonce='.$nonce;
Poloniex:
Trading API Methods
To use the trading API, you will need to create an API key.
All calls to the trading API are sent via HTTP POST to https://poloniex.com/tradingApi and must contain the following headers:
Key - Your API key.
Sign - The query's POST data signed by your key's "secret" according to the HMAC-SHA512 method.
Additionally, all queries must include a "nonce" POST parameter. The nonce parameter is an integer which must always be greater than the previous nonce used.
All responses from the trading API are in JSON format. In the event of an error, the response will always be of the following format:
{"error":""}
returnOpenOrders
Bittrex:
General
We provide a simple RESTful API. All calls are GETs and should be called via https. We will support n-1 versions of the API. Our current stable API is v1 and v1.1 is currently in testing. The endpoints have a standard format as follows:
https://bittrex.com/api/{version}/{method}?param=value
I currently import various altcoin exchange APIs into Gdocs via Json call. Essentially, I'm trying to import my open orders to Gdocs/Excel.
the Public apis not requiring API key great via public calls easy to enter into a URL. However, private API now require a "nonce" and "signature" for their new API's requiring your key.
I will pay a 0.05 btc bounty to anyone who tells me what this URL needs to look like exactly including the key and nonce/signature. I can do any calculations in Gdocs/Excel and build a URL. The answer must be a simple URL.
My goal is essentially to calculate the URL in excel then retrieve the result via webpage/json.
Bittrex:
'https://bittrex.com/api/v1.1/market/getopenorders?apikey='.$apikey.'&nonce='.$nonce;
Poloniex:
Trading API Methods
To use the trading API, you will need to create an API key.
All calls to the trading API are sent via HTTP POST to https://poloniex.com/tradingApi and must contain the following headers:
Key - Your API key.
Sign - The query's POST data signed by your key's "secret" according to the HMAC-SHA512 method.
Additionally, all queries must include a "nonce" POST parameter. The nonce parameter is an integer which must always be greater than the previous nonce used.
All responses from the trading API are in JSON format. In the event of an error, the response will always be of the following format:
{"error":"
returnOpenOrders
Bittrex:
General
We provide a simple RESTful API. All calls are GETs and should be called via https. We will support n-1 versions of the API. Our current stable API is v1 and v1.1 is currently in testing. The endpoints have a standard format as follows:
https://bittrex.com/api/{version}/{method}?param=value
Jump to: