Author

Topic: API call help in excel!!!! (Read 869 times)

legendary
Activity: 1162
Merit: 1000
Decentralizing Jesus on the Blockchain
April 16, 2015, 04: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
tyz
legendary
Activity: 3346
Merit: 1530
April 16, 2015, 02: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.
full member
Activity: 124
Merit: 100
April 14, 2015, 04: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.
newbie
Activity: 1
Merit: 0
April 08, 2015, 05:52:16 AM
#3
You could actually develop software products which can assist you in this task.
sr. member
Activity: 462
Merit: 250
I can draw your avatar!
April 07, 2015, 09:07:12 AM
#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.
legendary
Activity: 1162
Merit: 1000
Decentralizing Jesus on the Blockchain
April 06, 2015, 11:32:08 PM
#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
Jump to: