coinbase error about crypto_vba HOT 1 OPEN

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

from crypto_vba.