Bitcoin Forum

I have asked this question on stack overflow but no one replied so this is my last hope...

"I have created a profitability calculator for alternative currency trading in excel, which does the simple math (adds fees, sub fees etc) for me as a hobby on the website www.cryptsy.com. The problem I am having is I want to learn how would be the best way in this communities opinion to automate ONLY the buy and sell price from the website into my excel sheet? I have been told API would be the best way but I am not sure. Also please keep in mind programming experience is very little but willing to learn everything.

Thank you for your help"

Does this sound good? pretty much I have a calculator in excel i have built and i want to bring only specific data from cryptsy.com into the excel sheet so it is automated at all times and feeding data.

Sounds good.

Show us how does it work,.

I would like to see the answer, when it comes.

where are you op ? please answer us we all are waiting for you answer :) hope you make our heart happy with good answer :)

To me it sounds like you're looking for a web query using Excel. You might want to start there if you haven't already.

As a note, you may need to set the web query columns as hidden columns and use a formula to set a different cell equal to the constantly updating cells and assign that copy cell as a different data type.

you would get more help in some more appropriate thread, I don't think these off-topicers will help you with such matter :D

mee too

I wish i could help it sounds interesting. Is this something your trying to do for the general public or just yoursefl?

People acting in their own self interest often help the general public without intending to.  :D

So I uh said earlier to try using the web query functionality in Excel...Wonder if the OP read that post (or if anyone else for that matter). Or is he/she talking about something completely different?

Should mention, that it looks like using a web query against Cryptsy will require something slightly dynamic. So either use an iqy file in conjunction with the connection properties in Excel or set up some VBA code to set up several dynamic parameters and initiate the web query through the macro. Either way should work.

As a note, API would work great also, but why try to incorporate that with Excel when it already has its own type of web functionality?

sounds like an interesting tool.  I'm sure others around here can give you advice or be wilting to help you put this together.  Some good folks around here I have the feeling you'll get the help you seek.

I think you need use the excel built in macro or winautomation.com tool to scrape data from cryptsy. But why you need this on excel? This could be great if this on an online website.

so sorry for the late response work had sent me out of town and i have read all your responses but i havent made the macro yet but i can post pictures of the excel sheet if you guys want? and i am back in town will be answering faster very sorry for the late response

looks good, can show how it works?

https://i.imgur.com/ZgAghIB.png

**Everything in red needs to be inputed**
**Blue is profit relative to how many BTC you have at USD rate so if blue is higher than cell D2 then profit**

I buy BTC then I convert it to LTC (cell B24 tells how many LTC to buy) then depending on the profit table to the left I convert my LTC to the currency listed (B26-41 tell me how many of that currency to buy) then I immediately go and sell the new currency back into BTC (cells D26-41 tell how many BTC i will be left with after the transaction, if it is less than BTC you originally started with then it is a loss).

I want the currency column automated pretty much

I hope someone can point me the right direction

Thank you

what do you guys think can someone help me?

oh come on people someone has to know

Why do you want this tool to work, i don't get it realy.

I want it to work so it tells me how much money in dollars i make per transaction I want it automated so I can trade faster and make more money very simple and I can explain it to you if you would like just PM me

I only know a tiny bit about this but I think in order to have the USD prices update automatically you'd need to connect whatever you're doing to an exchange's API, https://www.bitstamp.net/api/, this is how the Bitcoin store's get their data for the current USD Bitcoin price. That's as much as I know about this kind of thing though, you'd have to get some code together to connect to the API and then have your client run its' USD calculations off that.

Every exchange operates individually and can have a variance in price bear in mind, there's no one global USD price for Bitcoin like in global financial markets.

Edit: Sorry, I hadn't double checked your post, if you don't have any programming experience you'd probably need to pay a programmer to do what you're asking for.

So you want some sort of alarm when price hits certain point? On big exchanges you have option to order sell at certain point...

Really need more elaboration on how it should be working.

I found this which might help you get in the right direction, it's only a small bit of documentation though: https://poloniex.com/api - read through 'Trading API methods'

Best thing you can do really is go find some programmers or something and pay them for their time perhaps, you could also try contacting exchanges and asking them how to do it as well.