Đã hoàn thành

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 [login to view URL] (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: [login to view URL]

This is not the Kraken API, but could probably work as well: [login to view URL]

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!


Kĩ năng: API, Excel, Programming, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: 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 paste adjacent column, paste excel vba macro, excel vba macro databases, historical price data, excel vba macro programming bids, excel vba code pull internet data, excel macro yahoo historical price, download historical stock data excel vba macro, excel vba macro copy columns data, excel vba macro download yahoo stock data, excel vba code download historical data yahoo, read webpage data excel vba macro

Về Bên Thuê:
( 1 Nhận xét ) London, United Kingdom

ID dự án: #16200464

Được trao cho:


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 Thêm

£155 GBP trong 4 ngày
(125 Đánh Giá)

15 freelancer đang chào giá trung bình £152 cho công việc này


Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) I am an Engineering Graduate with an MB Thêm

£250 GBP trong 4 ngày
(600 Nhận xét)

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 trong 3 ngày
(56 Nhận xét)

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

£250 GBP trong 3 ngày
(121 Nhận xét)

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

£110 GBP trong 3 ngày
(69 Nhận xét)

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 [login to view URL] near Thêm

£244 GBP trong 7 ngày
(1 Nhận xét)

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 Thêm

£150 GBP trong 3 ngày
(60 Nhận xét)

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. Thêm

£150 GBP trong 3 ngày
(48 Nhận xét)

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 trong 3 ngày
(35 Nhận xét)

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 trong 0 ngày
(6 Nhận xét)

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 Thêm

£88 GBP trong 3 ngày
(5 Nhận xét)

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 trong 3 ngày
(1 Nhận xét)

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 Thêm

£133 GBP trong 3 ngày
(0 Nhận xét)
£150 GBP trong 1 ngày
(0 Nhận xét)

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 Thêm

£150 GBP trong 10 ngày
(0 Nhận xét)