|
Title: API call help in excel!!!! Post by: kevin1234a on April 07, 2015, 03:32:08 AM 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 ;D
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 (https://www.cryptonator.com/rates/DOGE-BTC) Title: Re: API call help in excel!!!! Post by: neoneros on April 07, 2015, 01:07:12 PM 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 (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. Title: Re: API call help in excel!!!! Post by: kimstone on April 08, 2015, 09:52:16 AM You could actually develop software products (http://blog.veniceconsulting.com) which can assist you in this task.
Title: Re: API call help in excel!!!! Post by: frogCorporation on April 14, 2015, 08:25:49 PM 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. Title: Re: API call help in excel!!!! Post by: tyz on April 16, 2015, 06:43:44 PM 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.
Title: Re: API call help in excel!!!! Post by: kevin1234a on April 16, 2015, 08:30:47 PM 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 :) |