Bitcoin Forum
December 18, 2017, 09:11:55 PM *
News: Latest stable version of Bitcoin Core: 0.15.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: API call help in excel!!!!  (Read 757 times)
kevin1234a
Legendary
*
Offline Offline

Activity: 1162


Decentralizing Jesus on the Blockchain


View Profile WWW
April 07, 2015, 03:32:08 AM
 #1

i want to compare my crypto investment (wihtin various currencies) all over the major exchanges. meaning what is the current market price on exchange A or B or C....... i know it can be done easily by calling/Using API of any exchange site. but i dont know HOW  Grin

i also believe there are few software which would assist you in trading crypto but im more interested in Cryptonator API call in MS excel or online in wordpress blog / site. by this i would be able to compare my cost with the profit/loss at any given time.

i am sure there would be a way but dont know how.

if out there any one knows on how to accomplish this or point me to any software (free); i would appreciate his/her help.

NB: i used cryptonator because it seems that website compare rates (BTC + Alt) from various exchanges i just want to compare my spending from excel sheet with the current rates. i dont have any affiliation with that website and im not promoting it TOO.

i want to get same results for different currencies in excel https://www.cryptonator.com/rates/DOGE-BTC

1513631515
Hero Member
*
Offline Offline

Posts: 1513631515

View Profile Personal Message (Offline)

Ignore
1513631515
Reply with quote  #2

1513631515
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
neoneros
Sr. Member
****
Offline Offline

Activity: 448


I can draw your avatar!


View Profile WWW
April 07, 2015, 01:07:12 PM
 #2

As I see it, you can request the data from the API calls, it returns a JSON string, that string should be read and parsed into the correct excel field.

some info on how to import JSON into excell http://stackoverflow.com/questions/8044423/json-import-to-excel

It is a bit of a hassle and not sure if it is even possible. The API's are meant for web to web communication, not an excell wizard myself.

kimstone
Newbie
*
Offline Offline

Activity: 1


View Profile
April 08, 2015, 09:52:16 AM
 #3

You could actually develop software products which can assist you in this task.
frogCorporation
Full Member
***
Offline Offline

Activity: 126



View Profile
April 14, 2015, 08:25:49 PM
 #4

Good day, kevin1234a,

We are the community of software developers, interested in crypto projects. If you describe more details, we may help. We may provide the special service, which would make API calls to exchanges or trades, to obtain the actual prices, or we may assist you in excel form. To be short, we need more details, as is data source and algorythms you need to implement.
tyz
Legendary
*
Offline Offline

Activity: 1400



View Profile
April 16, 2015, 06:43:44 PM
 #5

Just devleop a small macro using programming language VBA. You need to call an API of one of the major exchange to get the current prices. VBA is not hard to learn and there are many tutorials how to call an API.

kevin1234a
Legendary
*
Offline Offline

Activity: 1162


Decentralizing Jesus on the Blockchain


View Profile WWW
April 16, 2015, 08:30:47 PM
 #6

Just devleop a small macro using programming language VBA. You need to call an API of one of the major exchange to get the current prices. VBA is not hard to learn and there are many tutorials how to call an API.

here is my answer, actually this what im doing now a days refershing my vb after 20 yrs Smiley

Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!