Find Jobs
Hire Freelancers

Easy VBA: Create an Excel function to pull data from API and parse JSON

£20-250 GBP

Imefungwa
Imechapishwa over 5 years ago

£20-250 GBP

Kulipwa wakati wa kufikishwa
I am looking for the exact VBA code that will allow me to do the following in Excel: I want to have a custom function in Excel that references two other cells, one with the ticker of a stock eg AAPL and one with a date. The function should then pull the closing price of the stock on that date. The API I want to use for the code is AlphaVantage, they have a full documentation here: [login to view URL] Everything is explained well in the documentation, but to be clear I want the function to return just the "close" price from the TIME_SERIES_DAILY API at a given date that is somewhere on spreadsheet and nothing else. This should take no time at all for someone who knows what they're doing, unfortunately I have no experience with parsing JSON. If there are any questions please let me know! I'll give a good tip if someone can do it quickly, thanks!
Kitambulisho cha mradi: 18208902

Kuhusu mradi

26 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
26 wafanyakazi huru wana zabuni kwa wastani £103 GBP kwa kazi hii
Picha ya Mtumiaji
Hello, Hope you are doing well. I can help with you in your project Easy VBA: Create an Excel function to pull data from API and parse JSON. I can assure you the quality job. I have good experience in Excel, Excel VBA, Finance, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
£250 GBP ndani ya siku 4
4.9 (491 hakiki)
8.4
8.4
Picha ya Mtumiaji
Hi, I ll code the VBA macro and parse the Json file. Need just to undersand the part where you are talking about close price... Thanks
£60 GBP ndani ya siku 1
5.0 (327 hakiki)
7.9
7.9
Picha ya Mtumiaji
I am proficient with excel macro/VBA development, I can write the marco to pull close price through API as requested, if you are interested feel free to message me, I am available to start your project immediately, looking forward to chat further and work on your project.
£100 GBP ndani ya siku 3
5.0 (145 hakiki)
7.5
7.5
Picha ya Mtumiaji
I can provide you simple VBA function that will read two values (stock symbol and date) from two cells and next get close price from JSON API. I can complete it in couple of hours for just £50.
£50 GBP ndani ya siku 0
5.0 (159 hakiki)
6.8
6.8
Picha ya Mtumiaji
Hi I can start now to work in this
£150 GBP ndani ya siku 3
4.9 (178 hakiki)
6.7
6.7
Picha ya Mtumiaji
Hi, I am an excel expert and a forex trader, I trade forex and fetching pairs data to excel for my analysis. I can pull data for any stock or forex pair for any time period. On excel there will be drop down you can select any stock or forex pair and the time period and date. Please contact me in chat I have the template already. Thanks
£50 GBP ndani ya siku 3
4.9 (102 hakiki)
6.3
6.3
Picha ya Mtumiaji
Hello, I am Excel and VBA expert. I can do this project. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
£100 GBP ndani ya siku 3
5.0 (97 hakiki)
6.2
6.2
Picha ya Mtumiaji
I have extensive experience with Direct HTTP methods and JSON parsing. I have previously worked on extracting Stock Open, High, Low, Close data in order to plot them on candlestick charts. I will use these methods to achieve your desire. I will easily be able to extract the Daily values having looked at the API and the output JSON string from those.
£55 GBP ndani ya siku 3
5.0 (43 hakiki)
6.1
6.1
Picha ya Mtumiaji
Hey? How are you? I have reviewed "Easy VBA: Create an Excel function to pull data from API and parse JSON" .I have good skills for these (Excel, Excel VBA, Finance, Visual Basic, Visual Basic for Apps). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
£155 GBP ndani ya siku 3
4.8 (103 hakiki)
5.9
5.9
Picha ya Mtumiaji
Hi, I can create a macro to parse JSON data or any string and extract desired data into specific format. My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
£120 GBP ndani ya siku 3
4.8 (129 hakiki)
6.1
6.1
Picha ya Mtumiaji
1. I am an 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. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
£150 GBP ndani ya siku 3
4.6 (96 hakiki)
6.3
6.3
Picha ya Mtumiaji
am not a random bidder.. Please ping me if you are interested wit hmy prposla and share more detail.. thank you...
£200 GBP ndani ya siku 3
4.9 (34 hakiki)
5.2
5.2
Picha ya Mtumiaji
Hi - I have libraries that will invoke a REST API and get a JSON response onto a excel with a specific structure. The data can then be manipulated using simple VBA. Please do let me know if you are interested. This is easy stuff using what i already have. For someone to build this afresh is going to be time consuming. Regards, Gana
£112 GBP ndani ya siku 3
4.9 (26 hakiki)
4.9
4.9
Picha ya Mtumiaji
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
£100 GBP ndani ya siku 5
5.0 (18 hakiki)
4.3
4.3
Picha ya Mtumiaji
Dear Client, Greetings. I would absolutely love the opportunity to build a fully automated data scraping system as per the requirement outlined in the job description. This requirement is similar to a few of my recent projects that I built using stock data sources such as Finviz and Gurufocus. I have done a large number of excel and google sheets automation models in my past assignments. Please send me a message and I will share my works samples for your reference. Price listed is negotiable. I can start working on this project immediately and can dedicate to it full time. Thank you for your consideration. I look forward to the opportunity. Regards, Ajit
£220 GBP ndani ya siku 10
5.0 (3 hakiki)
3.8
3.8
Picha ya Mtumiaji
"Greetings! According to your stated project description you need an Google sheet and excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just send me all of your requirements to start your project. I think no need to talk about the quality because I think provided work will proved it. I will be in touch with you any time you need. Looking forward to hearing you. Waiting for your kind response. Best Regards."
£100 GBP ndani ya siku 3
5.0 (2 hakiki)
0.0
0.0
Picha ya Mtumiaji
Dear Sir/Madam, I would be glad to assist you on this project. I am fully qualified for this bid and deliver quality on time.I am an experienced IT consultant and have done many development projects with all of the latest technologies. I own a SANS GSEC security certification. I am a US citizen and graduate with over 20 years of IT experience.
£50 GBP ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Well, I am currently using that function in my work. Based on the API, it's similar to what I do using Bloomberg.
£20 GBP ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I am and experienced Excel VBA user with proven skills. I believe that i can do the work that you propose
£88 GBP ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED KINGDOM
London, United Kingdom
0.0
0
Mwanachama tangu Nov 21, 2018

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.