hankhill69 (OP)
Member
Offline
Activity: 70
Merit: 10
|
|
March 26, 2014, 03:31:10 PM |
|
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.
|
|
|
|
roslinpl
Legendary
Offline
Activity: 2212
Merit: 1199
|
|
March 26, 2014, 04:17:49 PM |
|
Sounds good.
Show us how does it work,.
|
|
|
|
Bit_Happy
Legendary
Offline
Activity: 2114
Merit: 1040
A Great Time to Start Something!
|
|
March 26, 2014, 05:22:19 PM |
|
I would like to see the answer, when it comes.
|
|
|
|
bitkanu
|
|
March 26, 2014, 05:49:01 PM |
|
where are you op ? please answer us we all are waiting for you answer hope you make our heart happy with good answer
|
|
|
|
hellscabane
Legendary
Offline
Activity: 896
Merit: 1000
|
|
March 26, 2014, 07:59:14 PM |
|
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. 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.
|
|
|
|
Kiki112
|
|
March 26, 2014, 08:04:06 PM |
|
you would get more help in some more appropriate thread, I don't think these off-topicers will help you with such matter
|
|
|
|
HungryLaunch
Newbie
Offline
Activity: 57
Merit: 0
|
|
March 27, 2014, 12:59:23 AM |
|
mee too
|
|
|
|
durrrr
|
|
March 27, 2014, 01:20:09 AM |
|
I wish i could help it sounds interesting. Is this something your trying to do for the general public or just yoursefl?
|
|
|
|
Bit_Happy
Legendary
Offline
Activity: 2114
Merit: 1040
A Great Time to Start Something!
|
|
March 27, 2014, 01:24:51 AM |
|
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.
|
|
|
|
hellscabane
Legendary
Offline
Activity: 896
Merit: 1000
|
|
March 27, 2014, 03:15:27 AM |
|
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?
|
|
|
|
counter
|
|
March 27, 2014, 08:49:36 AM |
|
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.
|
|
|
|
Tonka Branded Truck
|
|
March 27, 2014, 12:41:23 PM |
|
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.
|
|
|
|
hankhill69 (OP)
Member
Offline
Activity: 70
Merit: 10
|
|
March 30, 2014, 03:07:44 AM |
|
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
|
|
|
|
which2say
Newbie
Offline
Activity: 28
Merit: 0
|
|
March 30, 2014, 08:30:55 AM |
|
looks good, can show how it works?
|
|
|
|
hankhill69 (OP)
Member
Offline
Activity: 70
Merit: 10
|
|
March 31, 2014, 12:05:34 AM |
|
**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
|
|
|
|
hankhill69 (OP)
Member
Offline
Activity: 70
Merit: 10
|
|
April 12, 2014, 12:47:31 AM |
|
what do you guys think can someone help me?
|
|
|
|
hankhill69 (OP)
Member
Offline
Activity: 70
Merit: 10
|
|
April 13, 2014, 01:56:50 PM |
|
oh come on people someone has to know
|
|
|
|
cech4204a
|
|
April 13, 2014, 02:07:56 PM |
|
Why do you want this tool to work, i don't get it realy.
|
Bitcoin is DEAD
|
|
|
hankhill69 (OP)
Member
Offline
Activity: 70
Merit: 10
|
|
April 13, 2014, 02:10:51 PM |
|
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
|
|
|
|
Lethn
Legendary
Offline
Activity: 1540
Merit: 1000
|
|
April 13, 2014, 02:18:36 PM Last edit: April 13, 2014, 05:09:32 PM by Lethn |
|
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.
|
|
|
|
|