APi to excel

[semajjames]

Hi
is it possible to use API to feed a coin price into microsoft excel cell ?

cheers 

[Sampey]

Yes of course, but you must write a code in the middle

API PRICE <------ YOUR CODE --------> XLS Output

[semajjames]

Yes of course, but you must write a code in the middle

API PRICE <------ YOUR CODE --------> XLS Output

Ok Great and Thanks

So could you point me to where i could find out how to do this,,,

 Or could you show me a code that will do... for instance BTC/USD on Cryptsy 

I dont want to get it out of excel i just want to be able to use  it inside excel to work out most profitable coins/pool's ect 

thanks again

[Sampey]

I'm a Java programmer, so i know how to do it in Java

These are the Library to Write/Read Excel files :

http://poi.apache.org/

And for the Price Part, you must create an HTTP Call according to the site API Interface.
I Mean, if you call Cryptsy, you  must follow this guide : https://www.cryptsy.com/pages/privateapi

[semajjames]

I'm a Java programmer, so i know how to do it in Java

These are the Library to Write/Read Excel files :

http://poi.apache.org/

And for the Price Part, you must create an HTTP Call according to the site API Interface.
I Mean, if you call Cryptsy, you  must follow this guide : https://www.cryptsy.com/pages/privateapi

Thanks I think I can get the cryptsy API side sorted but the Java side i have know idea at all


would it be possible for you to make a basic flow chart with words  like this to show me the process :-

fill kettle with water/boil water/put teabag in cup/pour water in cup/ ect/ect

LOL very basic will do for a start ,,,,, I am guessing the Java bit what tells excel where to put the data ?

Thanks

[Sampey]

I'm a Java programmer, so i know how to do it in Java

These are the Library to Write/Read Excel files :

http://poi.apache.org/

And for the Price Part, you must create an HTTP Call according to the site API Interface.
I Mean, if you call Cryptsy, you  must follow this guide : https://www.cryptsy.com/pages/privateapi

Thanks I think I can get the cryptsy API side sorted but the Java side i have know idea at all


would it be possible for you to make a basic flow chart with words  like this to show me the process :-

fill kettle with water/boil water/put teabag in cup/pour water in cup/ ect/ect

LOL very basic will do for a start ,,,,, I am guessing the Java bit what tells excel where to put the data ?

Thanks

Well steps are :

Make An Http Call to the Site (i'm sure you'll find some code on the net to call an API Method)
Parse the Response (usually JSON) and get the Data you need
Write on the Excel using the POI Library.
Here you can find an example
http://www.avajava.com/tutorials/lessons/how-do-i-write-to-an-excel-file-using-poi.html

It's very simple, you create a file, a sheet and after that you will only need to write the values (From the Java point of view, an XLS Sheet is a 2 dimension array)

[dehhh]

Take a look here, it will certainly help you out: http://www.mrexcel.com/forum/excel-questions/753144-visual-basic-applications-post-hashing-problem-btc-e.html

[TinaK]

Take a look here, it will certainly help you out: http://www.mrexcel.com/forum/excel-questions/753144-visual-basic-applications-post-hashing-problem-btc-e.html

great share, thx