APi to excel | Bitcointalksearch.org

TinaK

hero member

Activity: 1106

Merit: 527

Quote from: dehhh on November 16, 2014, 11:07:13 PM

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

dehhh

newbie

Activity: 9

Merit: 0

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

Sampey

legendary

Activity: 2632

Merit: 1040

Quote from: semajjames on November 15, 2014, 09:34:42 AM

Quote from: Sampey on November 15, 2014, 08:06:02 AM

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)

semajjames

hero member

Activity: 528

Merit: 500

Quote from: Sampey on November 15, 2014, 08:06:02 AM

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

legendary

Activity: 2632

Merit: 1040

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

hero member

Activity: 528

Merit: 500

Quote from: Sampey on November 14, 2014, 10:16:47 PM

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

legendary

Activity: 2632

Merit: 1040

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

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

semajjames

hero member

Activity: 528

Merit: 500

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

cheers

Topic: APi to excel (Read 1392 times)