Retrieving data from api

[mike4777]

I was wondering if someone could help me retrieve data from an api from http://www.coinapi.io

Does this require VBA? If not, will VBA cause data retrieval to be less sluggish?

I have tried looking online for the answer, but keeping running across complicated vba explanations.

 

[John_w]

Yes, this requires VBA, using their REST API. There should be examples of similar API calls on this forum - search for XMLhttp GET POST JSON. You'll also need a VBA JSON parser/converter.

 

[mike4777]

Yes, this requires VBA, using their REST API. There should be examples of similar API calls on this forum - search for XMLhttp GET POST JSON. You'll also need a VBA JSON parser/converter.

Thanks for your reply.

What do you suppose they mean with the other two options? I'm guessing it is for websites and such. I'm trying to pull price data from a particular cryptocurrency at a particular minute whenever I type a new trade into excel. I'm wanting to pull the data into a sheet and then index/match it into place.

<thead>
[TH="align: left"]API[/TH]
[TH="align: left"]Communication[/TH]
[TH="align: left"]Description[/TH]

</thead><tbody>
[TD="bgcolor: #F9FBFC"]RESTful[/TD]
[TD="bgcolor: #F9FBFC"]Request-response[/TD]
[TD="bgcolor: #F9FBFC"]Stateless API providing the widest range of data, not capable of streaming, only pooling.[/TD]

[TD="bgcolor: #F3F7FA"]WebSocket[/TD]
[TD="bgcolor: #F3F7FA"]Publish-subscribe[/TD]
[TD="bgcolor: #F3F7FA"]Stateful API providing streaming of realtime market data.[/TD]

[TD="bgcolor: #F9FBFC"]FIX[/TD]
[TD="bgcolor: #F9FBFC"]Publish-subscribe[/TD]
[TD="bgcolor: #F9FBFC"]Stateful API providing streaming of realtime market data, widely adopted by the finance industry.[/TD]

</tbody>

 

[John_w]

The other two options provide realtime streaming for applications. You subscribe to specific data element(s) (currencies, etc.) and it sends updates as they occur.