i have a website (coinbase.com) that i want to scrape the dashboard webpage so i can get the current prices of selected cryptocurrencies. i have tried the get external from webpage but can't get it to work (on windows 7 here and windows 10 at home). I also tried to do the web API but can't get that to work either. does anyone have experience with API's and getting info into excel?
What is the URL for the dashboard page? I could not find that page on the site you mentioned.
There are couple of ways to do it.
1. Using PowerQuery (Get & Transform) and use "From Web"->Advanced to set all necessary parameters and any header (API Key etc).
Still could be done for OAuth2, but again, quite a bit more involved than simple API Key.
2. Using VBA, utilizing xmlhttp to send request (setting all parameters & headers as needed).
Edit: Looks like coinbase.com uses OAuth2 for authentication, it's bit more involved than single step API key. Have a read of... It's specifically for Google OAuth2 but same principle applies.
http://ramblings.mcpher.com/Home/exc...s/googleoauth2
https://gist.github.com/brucemcpherson/6937174
Or just use their library for Python or other programming language.It will be easier I'd imagine.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
sorry for not including that. it is coinbase.com/dashboard
there are two ways into coinbase, one gives the api key, the other is oauth2 (which i haven't done yet). i will read the links and see if i can get by. thanks for responding.
@CK76 - so i read the Oauth2 and i don't think that i have enough experience/ability to do that.
im gonna ping the support desk at coinbase and see what they recommend. I'll come back and update this post.
Oath2 is required if you want to access third party wallets (i.e. creating an application for others to use). For your needs (as described, accessing your own account) API key should be sufficient.
If you are pleased with a member's answer then use the Star icon to rate it.
@buran
I tried with the key but was unsuccessful, is that something you can try? i put in the key but it wouldn't accept it.
I don't know what you are doing, and I have no intention to register with this site in order to be able to test However I see thay have certain requirements https://developers.coinbase.com/api/v2#api-key
yah, i just got that page from coinbase, i will have to read it and see what i can do.
as for what i am doing, i want the value of bitcoin so that i can update excel with the current price (i have formula's).
Originally Posted by dmcgov
I mean I don't know how you try with the key and fail as you don't post any code
so now that i am trying this again, i lost my way to the api section. how do i get back to the menu where i can put in the api key to get the error code?
Here's what query using PowerQuery->From Web should look like.
Fill header value with your actual Key, Sig & current Timestamp.
0.JPG
Typically speaking, you'd want to use Timestamp value from another query (to time API endpoint)
thanks @ck76, only have a couple of questions for you.
what would/might a Signature sample value look like?
do i have to get timestamp from another query or can i just input one? if yes, what would a sample look like?
As side note, have a read of links below to create "SIGN" header with sha256 HMAC
Where message is prehash string timestamp + method + requestPath + body
https://stackoverflow.com/questions/...macro-in-excel
http://www.vbforums.com/showthread.p...ing-Crypto-API
http://community.powerbi.com/t5/Desk...eys/m-p/111052
Or just leverage Python or other programming language that has modules to handle it.
@ck76,
left you a PM, let me know what you think?
Closed at dmcgov's request to post in commercial services.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks