API call help in excel!!!!

[kevin1234a]

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  

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

[1715393475]

1715393475

[1715393475]

1715393475

[neoneros]

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]

You could actually develop software products which can assist you in this task.

[frogCorporation]

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]

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]

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