krijnsent
commented
2 years ago Hi Carlos,
if step 1 fails that means that the main issues is in ModWeb and has nothing to do with your authentication as that's only used in step 4. (Basically: the tests in that sheet build up from a simple raw reply to an authenticated processed one.). Somehow your connection to Coinbase doesn't resolve quickly, so it fails. You could try to use the alternative method: go to WebRequestURL (in ModWeb) and uncomment 'Set objHTTP = CreateObject("MSXML2.XMLHTTP") and outcomment the 3 active lines above that. For me the CoinBase sheet works with my credentials, so I can't really reproduce your error :-(.
There is no real guide document, the main documentation is in the readme in this Github combined with the comments I put in the code.
In concept, the code works as follows for every exchange:
- from the sheet, mainly the PublicExchangeName & PrivateExchange functions are called (both placed in ModExchExchangeName). As the name suggests, Public is the public part of the API (no credentials needed) and Private the private part (with credentials).
- those functions in turn do some stuff, mainly building up the right API call info and are supported by a couple of blocks: -- ModJson & JsonConverter to process Json info -- ModWeb (function: WebRequestURL ) to send out information to the web call & receive a reply (raw JSON) -- sometimes ModHash for signing a request
Hope that helps, otherwise use F8 to step through the code and see where it crashes/goes to the wrong side of an IF statement. Koen
Hello
thanks for this fantastic work , I have copied API key and secret key and have press F8 (run macro), I get an error msg "type miss match" on Step 1: "Raw JSON data" is shown the following error :
{"error_nr":-2147483638,"error_txt":"The data necessary to complete this operation is not yet available. ","response_txt":0}
I don't understand why to me is also not clear, do I have to do something else apart from entering API KEY and SECRET KEY ??
do you have a guide document ?
I just want to get my cryptocurrencies from my account.
thanks for your support.
Regards Carlos