title: Pulling data through API into Excel via VBA/Macro?
body: <p>I am trying to use the API on the following site, <a href="https://www.cryptsy.com/pages/api" rel="nofollow">https://www.cryptsy.com/pages/api</a>, to download information to Excel. </p>
  
  <p>I have never worked with JSON before, and I'm confused how to implement this. In particular I am interested in <a href="http://pubapi.cryptsy.com/api.php?method=singlemarketdata&amp;marketid=" rel="nofollow">http://pubapi.cryptsy.com/api.php?method=singlemarketdata&amp;marketid=</a>{MARKET ID}</p>
  
  <p>I need to be signed in I think, so I can generate my own API key. Is it also possible to execute a trade on this API using an Excel macro?</p>