Bitcoin Forum
June 25, 2024, 03:52:53 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1] 2 »  All
  Print  
Author Topic: Need help in the right direction  (Read 1172 times)
hankhill69 (OP)
Member
**
Offline Offline

Activity: 70
Merit: 10


View Profile
March 26, 2014, 03:31:10 PM
 #1

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 Offline

Activity: 2212
Merit: 1199


View Profile WWW
March 26, 2014, 04:17:49 PM
 #2

Sounds good.

Show us how does it work,.
Bit_Happy
Legendary
*
Offline Offline

Activity: 2114
Merit: 1040


A Great Time to Start Something!


View Profile
March 26, 2014, 05:22:19 PM
 #3

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

bitkanu
Hero Member
*****
Offline Offline

Activity: 2184
Merit: 513


Moonbet.io | Web3 Casino


View Profile
March 26, 2014, 05:49:01 PM
 #4

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

       ▒▒▒▒▓███▓▒▒▒▒     
    ▓██▓▓█████████▓▓██▒ 
   ███████▓▓░░░▓▓███████
  ▓▓▓██▓          ░███▓▓▓
 ▒▓▒██▒       ░▓█   ██▒▓▒
▒▓▓▓▒       ▓███    ▓▓▓
████     █████░     ████
████▓░  ██████▓      ████
▒▓▓▓██▒    ████▓     ░▓▓▓
 ▒▓▒███▓▒▒▓░ ▓█      ██▒▓░
  ▓▓▓██████▒       ▓██▓▓▓
   ▓████████░░░██▓█████
    ▒██▓▓▓████████▓▓██░ 
       ░▒▒▒▓█▓█▓▒▒▒       
.MOONBET.||       ▒▒▒▒▓███▓▒▒▒▒     
    ▓██▓▓█████████▓▓██▒ 
   ███████▓▓░░░▓▓███████
  ▓▓▓██▓          ░███▓▓▓
 ▒▓▒██▒       ░▓█   ██▒▓▒
▒▓▓▓▒       ▓███    ▓▓▓
████     █████░     ████
████▓░  ██████▓      ████
▒▓▓▓██▒    ████▓     ░▓▓▓
 ▒▓▒███▓▒▒▓░ ▓█      ██▒▓░
  ▓▓▓██████▒       ▓██▓▓▓
   ▓████████░░░██▓█████
    ▒██▓▓▓████████▓▓██░ 
       ░▒▒▒▓█▓█▓▒▒▒       
█▀▀▀











▀▀▀▀
> TWITTER
> MEDIUM
> INSTAGRAM
> TELEGRAM
▀▀▀█











▀▀▀▀
hellscabane
Legendary
*
Offline Offline

Activity: 896
Merit: 1000



View Profile
March 26, 2014, 07:59:14 PM
 #5

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
Full Member
***
Offline Offline

Activity: 196
Merit: 101


View Profile
March 26, 2014, 08:04:06 PM
 #6

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

HungryLaunch
Newbie
*
Offline Offline

Activity: 57
Merit: 0


View Profile
March 27, 2014, 12:59:23 AM
 #7

mee too
durrrr
Sr. Member
****
Offline Offline

Activity: 434
Merit: 251


View Profile
March 27, 2014, 01:20:09 AM
 #8

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 Offline

Activity: 2114
Merit: 1040


A Great Time to Start Something!


View Profile
March 27, 2014, 01:24:51 AM
 #9

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.  Cheesy

hellscabane
Legendary
*
Offline Offline

Activity: 896
Merit: 1000



View Profile
March 27, 2014, 03:15:27 AM
 #10

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
Hero Member
*****
Offline Offline

Activity: 798
Merit: 500


Time is on our side, yes it is!


View Profile
March 27, 2014, 08:49:36 AM
 #11

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
Sr. Member
****
Offline Offline

Activity: 259
Merit: 250



View Profile
March 27, 2014, 12:41:23 PM
 #12

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 Offline

Activity: 70
Merit: 10


View Profile
March 30, 2014, 03:07:44 AM
 #13

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 Offline

Activity: 28
Merit: 0


View Profile
March 30, 2014, 08:30:55 AM
 #14

looks good, can show how it works?
hankhill69 (OP)
Member
**
Offline Offline

Activity: 70
Merit: 10


View Profile
March 31, 2014, 12:05:34 AM
 #15



**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 Offline

Activity: 70
Merit: 10


View Profile
April 12, 2014, 12:47:31 AM
 #16

what do you guys think can someone help me?
hankhill69 (OP)
Member
**
Offline Offline

Activity: 70
Merit: 10


View Profile
April 13, 2014, 01:56:50 PM
 #17

oh come on people someone has to know
cech4204a
Sr. Member
****
Offline Offline

Activity: 252
Merit: 250

12CDKyxPyL5Rj28ed2yz5czJf3Dr2ZvEYw


View Profile WWW
April 13, 2014, 02:07:56 PM
 #18

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

Bitcoin is DEAD
hankhill69 (OP)
Member
**
Offline Offline

Activity: 70
Merit: 10


View Profile
April 13, 2014, 02:10:51 PM
 #19

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 Offline

Activity: 1540
Merit: 1000



View Profile WWW
April 13, 2014, 02:18:36 PM
Last edit: April 13, 2014, 05:09:32 PM by Lethn
 #20

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.
Pages: [1] 2 »  All
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!