Bitcoin Forum
June 17, 2024, 03:49:02 PM *
News: Voting for pizza day contest
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Help with api and excel  (Read 1438 times)
sacskate (OP)
Hero Member
*****
Offline Offline

Activity: 994
Merit: 500



View Profile
June 26, 2015, 07:57:30 PM
 #1

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.
freigeist
Hero Member
*****
Offline Offline

Activity: 1107
Merit: 534


View Profile
June 28, 2015, 12:26:50 PM
 #2

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.





sacskate (OP)
Hero Member
*****
Offline Offline

Activity: 994
Merit: 500



View Profile
June 29, 2015, 02:01:41 AM
 #3

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.
freigeist
Hero Member
*****
Offline Offline

Activity: 1107
Merit: 534


View Profile
June 29, 2015, 11:32:50 PM
 #4

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! Wink

sacskate (OP)
Hero Member
*****
Offline Offline

Activity: 994
Merit: 500



View Profile
July 01, 2015, 07:49:14 PM
 #5

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.
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!