I was thinking of going that route, though I don't think it would refresh the data in the .csv and I dont think I could get excel to pull that updated .csv either. I can get data from cryptsy into excel with no problem. As a work around I was able to import data from coinmarketcap for that specific coin. Thanks for the reply.
Sorry I have overlooked that you need refresh the data in the cell.
One possible solution to that issue is to set up that php script on a server and using it as a proxy.
What I mean is that you can write a VBA routine that calls the url of your php script on the server or local server
and retrieves the data in csv then parses the data and updates the cells.
To make it update the cells periodically you can set a timer interval in the VBA that will call your routine.
I think this should work even being a trivial solution.
I found also a JSON parser for VBA which I haven't tested
https://github.com/VBA-tools/VBA-JSONbut if this works you don't need to to use the php proxy script to convert JSON to CSV
you could just try to get the data from the source website and use VBA-JSON to
convert the received data and then fill the cells.
I hope you manage something.
Have fun!
