Completed

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

Pierre

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

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

Project ID: #16200464

Awarded to:

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 More

£155 GBP in 4 days
(125 Reviews)
6.5

15 freelancers are bidding on average £152 for this job

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 More

£250 GBP in 4 days
(600 Reviews)
8.3
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 in 3 days
(56 Reviews)
6.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 in 3 days
(121 Reviews)
6.2
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 More

£110 GBP in 3 days
(69 Reviews)
5.8
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 More

£244 GBP in 7 days
(1 Review)
5.6
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 More

£150 GBP in 3 days
(60 Reviews)
5.6
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. More

£150 GBP in 3 days
(48 Reviews)
5.2
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 in 3 days
(35 Reviews)
4.8
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 in 0 days
(6 Reviews)
4.1
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 More

£88 GBP in 3 days
(5 Reviews)
2.9
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 in 3 days
(1 Review)
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 More

£133 GBP in 3 days
(0 Reviews)
0.0
£150 GBP in 1 day
(0 Reviews)
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 More

£150 GBP in 10 days
(0 Reviews)
0.0