Build a Excel VBA macro that pull historical price data from Kraken


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!


Skills: API, Excel, Programming, Visual Basic, Visual Basic for Apps

See more: live bitcoin price in excel, bittrex api vba, bittrex api excel, coinmarketcap excel, coinmarketcap api excel, bittrex excel, excel cryptocurrency, kraken api excel, excel vba macro yahoo finance historical prices, historical stock prices excel vba macro, vba macro pull test cases excel, read webpage data excel vba macro, excel vba code download historical data yahoo, excel vba macro download yahoo stock data, excel vba macro copy columns data

About the Employer:
( 1 review ) London, United Kingdom

Project ID: #16200464

Awarded to:


Dear Employer, I'm ready to work on "excel vba build a simple spreadsheet" project. Relevant Skills Excel, VBA Milestones 124 GBP - code writing 31 GBP - userfriendly interface 30 % of employers hiring me once hir More

£155 GBP in 4 days
(106 Reviews)

17 freelancers are bidding on average £149 for this job


Expert Excel Programmer on and have been featured by the freelancer community I am an Engineering Graduate with an MB More

£250 GBP in 4 days
(560 Reviews)

Hi, I am enough capable for doing this project. Please give me the opportunity to provide my best service to you. Thanks

£250 GBP in 3 days
(103 Reviews)

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME [url removed, login to view] allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL More

£110 GBP in 3 days
(62 Reviews)

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More

£150 GBP in 3 days
(53 Reviews)

Hello? How are you? I have good skills in vba. You can see my reviews. I will never disappoint you. Hope to work with you. you can see my reviews

£150 GBP in 3 days
(27 Reviews)

1. Expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. More

£150 GBP in 3 days
(44 Reviews)

Dear Sir / Ma’am, I am writing a proposal for your job.I have gone through the complete job description and placed bid accordingly.I am really interested for this project as this is area of my [url removed, login to view] near More

£244 GBP in 7 days
(1 Review)

I have many experiences in Excel macro and VBA coding, google sheet. Moreover, I'm familiar with Web development software including HTML, JAVA, JAVASCRIPT, PHP.... And I'm an expert in mathematics. So, I am sure tha More

£150 GBP in 3 days
(6 Reviews)

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.

£150 GBP in 3 days
(19 Reviews)

Hi, I can help you. I do have experience on interacting with APIs from VBA. I understand your requirements and will not waste your time. Please PM.

£100 GBP in 0 days
(4 Reviews)

Hi I'm [url removed, login to view] of InfoSec with good knowledge in excel and vba. I will hope can help you to do your job. Ready to begin.

£100 GBP in 3 days
(14 Reviews)

Hello there, I would like to be considered for this job as I have great working experience in VB macro writing in excel. The only thing I need to check is whether the API provide required data(in required way - w More

£88 GBP in 3 days
(4 Reviews)

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.

£50 GBP in 3 days
(1 Review)

We are team of professional excel + vba users , i personally i am working on a python project to get cryptocurrency data online and display on a widget graph. I will be glad to work on a project like this. I m alread More

£133 GBP in 3 days
(0 Reviews)
£150 GBP in 1 day
(0 Reviews)

Dear Sir or Madam: I am a software developer, doing Office programming since 90s. My experience includes Excel for maths, engineering, finance, accounting, management, ETL, text and image processing as well as scr More

£150 GBP in 10 days
(0 Reviews)