Bitcoin Forum
March 29, 2024, 02:32:39 AM *
News: Latest Bitcoin Core release: 26.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Help Please: Bittrex API Get Ticker to Excel Live + HitBTC + Binance  (Read 93 times)
justinc1089 (OP)
Newbie
*
Offline Offline

Activity: 18
Merit: 1


View Profile
September 22, 2018, 07:53:41 PM
 #1

Hi first post! Sorry if this belongs better in a different section. I did look around but was not sure if this would fit in with technical or here.

I am trying to create a list in Excel 2016 (pretty certain I'm using 2016 I can check to be sure if it does matter) like this:

Ask     Bid      Last      Pair
1.77   1.79     1.78     ABC/XYZ Bittrex
2.2     2.222   2.22     FGH/NMJ Bittrex



I can pull SINGLE market currency pairs, like ABC/XYZ Bittrex per every ONE web query in Excel using their getticker link: https://bittrex.com/api/v1.1/public/getticker?market=usd-xrp


The problem is, doing it this way requires me to type in usd-xrp hundreds of times for every ABC/XYZ AND puts HUNDREDS of queries in Excel... which Excel wants to load onto a SINGLE SHEET for every single one resulting in hundreds of sheets!

So not only do I have to type in hundreds of links, run hundreds of queries if Excel is even capable of doing that, but I also have to go through and deal with doing something like merging hundreds of sheets into one sheet!

I can append the queries to make an appended query containing all of them on one single table, but the others still exist. I don't see a way to merge all the queries together nor append and then delete the original queries.


What I need to know is this: Is there a way to use the getticker link url https://bittrex.com/api/v1.1/public/getticker?market=usd-xrp to tell the Bittrex API to get ALL of the currency market pairs instead of just usd-xrp?

I am going to be doing this for Hitbtc and Binance as well which I have not even attempted yet, so hopefully they are not dramatically different.

If anyone knows how to do this API stuff and how the url links work and you can give me some help I would be EXTREMELY thankful!
1711679559
Hero Member
*
Offline Offline

Posts: 1711679559

View Profile Personal Message (Offline)

Ignore
1711679559
Reply with quote  #2

1711679559
Report to moderator
Even if you use Bitcoin through Tor, the way transactions are handled by the network makes anonymity difficult to achieve. Do not expect your transactions to be anonymous unless you really know what you're doing.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1711679559
Hero Member
*
Offline Offline

Posts: 1711679559

View Profile Personal Message (Offline)

Ignore
1711679559
Reply with quote  #2

1711679559
Report to moderator
1711679559
Hero Member
*
Offline Offline

Posts: 1711679559

View Profile Personal Message (Offline)

Ignore
1711679559
Reply with quote  #2

1711679559
Report to moderator
1711679559
Hero Member
*
Offline Offline

Posts: 1711679559

View Profile Personal Message (Offline)

Ignore
1711679559
Reply with quote  #2

1711679559
Report to moderator
justinc1089 (OP)
Newbie
*
Offline Offline

Activity: 18
Merit: 1


View Profile
September 22, 2018, 10:43:03 PM
 #2

Here is a video explaining what I am doing:
(I need to pull the entire list of currency pairs not just one like she does/ not just one per web query like she does)




https://www.youtube.com/watch?v=RUrco0uWvMc
Pages: [1]
  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!