I am looking for someone comfortable with Excel VBA programming and used to working with API to source data from a website. The project is to build a simple spreadsheet that will import the historical prices and volumes from [url removed, login to view] (the cryptocurrency exchange) for any given pair available on the exchange as specify by the user.
The user will have to input three things in the spreadsheet:
- The pair he is interested in (e.g. ETH/EUR, XRP/BTC, etc.) - this is probably two inputs
- The desired time interval between each prices (e.g. 5 minutes, 1 hour, etc.)
- The desired period to cover (e.g. last 24 hours, last month, from 01-Jan-2017 to 31-Dec-2017, etc.)
Then, the user will click on a button that will execute a macro which will pull the corresponding data from Kraken . The output is a spreadsheet that should include the following 6 columns: time, opening price, closing price, high price, low price, volume.
Here is the Kraken API manual: [url removed, login to view]
This is not the Kraken API, but could probably work as well: [url removed, login to view]
If you think you could help with that, that would be super helpful :)
Thank you and do not hesitate to get in touch if you have any question!
17 freelancers are bidding on average £149 for this job
hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard.
Hi, I am an expert in data entry, data processing, web scraping, excel vba. I have many experiences in data entry, data processing, macro, vba, excel. Please contact.