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
Topic: Help Please: Bittrex API Get Ticker to Excel Live + HitBTC + Binance (Read 120 times)
September 22, 2018, 05:43:03 PM
September 22, 2018, 02:53:41 PM
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!
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!
Jump to: