Bitcoin Forum

Alternate cryptocurrencies => Altcoin Discussion => Topic started by: sacskate on June 26, 2015, 07:57:30 PM



Title: Help with api and excel
Post by: sacskate on June 26, 2015, 07:57:30 PM
I am trying to import the data from this bittrex public api call:
https://bittrex.com/api/v1.1/public/getticker?market=btc-hyper
into excel and having it refresh. I can save the .json file and have excel see it but it doesnt refresh.
I have tried using this https://github.com/Pathio/excel-json-client with excel-dna but it doesn't seem to work either. Any help will be appreciated.


Title: Re: Help with api and excel
Post by: freigeist on June 28, 2015, 12:26:50 PM
I am trying to import the data from this bittrex public api call:
https://bittrex.com/api/v1.1/public/getticker?market=btc-hyper
into excel and having it refresh. I can save the .json file and have excel see it but it doesnt refresh.
I have tried using this https://github.com/Pathio/excel-json-client with excel-dna but it doesn't seem to work either. Any help will be appreciated.

Working with MS tech stuff is usually a big PITA.
In my opinion you could do it easer trough php by querying the API and convert the data into CSV format
that could be imported into excell or any other spreadsheet.This is if you do not require any automation
otherwise you will have to struggle with MS tech.






Title: Re: Help with api and excel
Post by: sacskate on June 29, 2015, 02:01:41 AM
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.


Title: Re: Help with api and excel
Post by: freigeist on June 29, 2015, 11:32:50 PM
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-JSON

but 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! ;)


Title: Re: Help with api and excel
Post by: sacskate on July 01, 2015, 07:49:14 PM
Sweet, thanks for the reply. I may just try that route for everything as that would be nicer than the way I am doing it.