-
Jun 29th, 2017, 03:55 AM
#1
Thread Starter
New Member
GET command to receive information from public API into Excel
Hi all,
I hope I came to the right place for my issue. I am programming a vba macro in excel and are okay-ish with basic commands. However, what I try to achieve this time is beyond my current knowledge.
As part of my macro which runs every 30 minutes I would like to receive some info from a webpage (currency exchange with price tickers, etc.). This webpage offers an API, I am only interested in the public one to receive publicly available data. Once finished I would like to distribute the Excel file to different users / operating systems etc. So whichever libraries, etc. should be required, they should be saveable in the excel sheet so other users don't need to go through a setup process.
Here is the info page of the relevant API: https://bittrex.com/home/api
I am specifically interested in the data of /public/getmarketsummaries. I would then write some code to compare prices, volume, etc. so I need to find out how to address those values and put them into variables once the data is received.
Is this achievable for a fairly unexperienced VBA programmer?
Thanks in advance for your help!
BR
JDot
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|