JSON API to Excel

[SimonPee]

Hi,

I'm trading crypto's and want to build an Excel spreadsheet to monitor marketmovements for analyzing.
I can do so by using the API offered by the exchange; https://api.mintpal.com/v1/market/trades/MINT/BTC.
Now I have never used VBA and find it really hard to find any tutorials for less-advanced people like me.

What do I want exactly?

I want cells to automaticly populate based on the info provided by the API.
I want data to be stored before refreshing.


Example;


{"time":"1401295828.2992","type":1,"price":"0.00000005","amount":"22285.35197204","total":"0.00111426"},{"time":"1401295828.2878","type":1,"price":"0.00000005","amount":"2867371.92211680","total":"0.14336859"},


[TABLE="width: 500"]
<tbody>[TR]
[TD]1401295828.2992[/TD]
[TD]1[/TD]
[TD]0.00000005[/TD]
[TD]22285.35197204[/TD]
[TD]0.00111426[/TD]
[/TR]
[TR]
[TD]1401295828.2878[/TD]
[TD]1[/TD]
[TD]0.00000005[/TD]
[TD]2867371.92211680[/TD]
[TD]0.14336859[/TD]
[/TR]
</tbody>[/TABLE]


Please let me know if this is even possible in Excel? And if so, perhaps show an example which a user like me can understand.

Thanks.

 

[florencemcdonald]

You can just paste the JSON into json-csv.com and then you can open it up in a spreadsheet.