Find Jobs
Hire Freelancers

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

£20-250 GBP

Completed
Posted about 6 years ago

£20-250 GBP

Paid on delivery
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
Project ID: 16200464

About the project

14 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 hired me again.
£155 GBP in 4 days
5.0 (128 reviews)
6.6
6.6
14 freelancers are bidding on average £152 GBP for this job
User Avatar
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 MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you. Please pay me once job is 100% done.
£250 GBP in 4 days
5.0 (717 reviews)
8.4
8.4
User Avatar
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
4.8 (92 reviews)
6.7
6.7
User Avatar
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
4.9 (130 reviews)
6.2
6.2
User Avatar
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. 3. Can complete on time with good quality and on time. 4. Experienced MBA Finance as well.
£150 GBP in 3 days
4.8 (63 reviews)
5.6
5.6
User Avatar
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 Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC -- JS,Google extensions and google scripts I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
£150 GBP in 3 days
4.9 (62 reviews)
5.6
5.6
User Avatar
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 day
5.0 (6 reviews)
4.1
4.1
User Avatar
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 - with custom interval) or not ## seems like karaken provides exactly what we need Thanks, Ramesh
£88 GBP in 3 days
5.0 (5 reviews)
2.9
2.9
User Avatar
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
0.0 (1 review)
0.0
0.0
User Avatar
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 already looking at th kraken api and hope we can come to an agreement.
£133 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
1
Payment method verified
Member since Feb 1, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.