Đã hoàn thành

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

Hi,

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!

Pierre

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 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

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

ID dự án: #16200464

Được trao cho:

katilinas

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
(111 Đánh Giá)
6.3

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

jaylancer43

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
(562 Nhận xét)
8.2
fatimatuzzohura

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
(106 Nhận xét)
6.0
The24CarrotsInc

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
(63 Nhận xét)
5.7
abhinovpankaj

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
(53 Nhận xét)
5.5
polarjin2017

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
(30 Nhận xét)
5.5
citijayamala

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
(46 Nhận xét)
5.2
Sonia8619

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)
5.3
dongmei1993

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

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

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
(22 Nhận xét)
4.5
uzafar99

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
(4 Nhận xét)
4.0
rameshmahala

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
(4 Nhận xét)
2.8
jackjonson1990

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)
0.0
Gtantse

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)
0.0
£150 GBP trong 1 ngày
(0 Nhận xét)
0.0
tsft

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)
0.0