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.

API	Communication	Description
RESTful	Request-response	Stateless API providing the widest range of data, not capable of streaming, only pooling.
WebSocket	Publish-subscribe	Stateful API providing streaming of realtime market data.
FIX	Publish-subscribe	Stateful API providing streaming of realtime market data, widely adopted by the finance industry.

<thead>
</thead><tbody>
</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.