Find Jobs
Hire Freelancers

Simple Excel VB Macro to get JSON data from website - 30/04/2018 09:57 EDT

$10-30 USD

Completed
Posted almost 6 years ago

$10-30 USD

Paid on delivery
Hi I will need simple VB Macro which will be taking into excel JSON data from website api. Requairements are: How Often data will be refreshed (excel cell value ) (Start/Stop) button. Data to be addet to spredsheet continusly up to 10000 records ( FIFO - once number of rows hit 10000 oldest records are deleted to make a space for new ones ). Only UNIQUE records without duplications. Data source is in Json format undel below url: [login to view URL]
Project ID: 16835545

About the project

11 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
Please open a chat with me so we may discuss your requirements. I have over 24 years of experience developing MS Office solutions.
$35 USD in 2 days
3.2 (4 reviews)
4.0
4.0
User Avatar
I am proficient with excel macro/VBA development, I can write the API macro to pull JSON data per your specification, if you are interested feel free to message me, looking forward to chat further for a quick turnaround solution and work on your project.
$25 USD in 1 day
5.0 (17 reviews)
3.8
3.8
11 freelancers are bidding on average $42 USD for this job
User Avatar
Hi, I have developed similar scraper/crawler and data/web automation projects. Please let me know if you are interested and I am available to start right away.
$35 USD in 2 days
4.6 (15 reviews)
5.4
5.4
User Avatar
hi Just now i did a small project where i read Json output in macro. I have library components to convert JSON to exce,l sheet values. One question i have 1) When you say duplicates should not be considered I assume you are referring to the to the time stamp value. Can you please confirm it? Thanks Regards Vaidy
$133 USD in 2 days
5.0 (10 reviews)
4.3
4.3
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
4.5 (4 reviews)
4.1
4.1
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$30 USD in 1 day
4.9 (22 reviews)
3.8
3.8
User Avatar
Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions and Macros using VB, the most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.
$30 USD in 1 day
5.0 (7 reviews)
3.0
3.0
User Avatar
Hello sir, I have reviewed your project details and understood your requirements as mentioned above. We have team of experienced developers who can get your project done. we believe in quality work with ontime delivery. Kindly initiate chat to discuss more Thanks Avinav
$25 USD in 1 day
5.0 (1 review)
1.6
1.6
User Avatar
Hello, I have experience in VB Macro and json data. II can work on this task. Thanks. pay only when you are satisfied with my work.
$40 USD in 3 days
5.0 (1 review)
1.2
1.2
User Avatar
Dear Sir/Madam: I am able to write your macro. I am working from 90s with macro, lately with 365/2016/AutohotKey and Basic. Form finance, inventory to chemistry and ETL ASAP. I am a software developer, doing desktop, web and cloud programming. Software architecture and engineering. Personalized service, full back-end and front-end programming. Background Samples at my portfolio tsftportfolio wordpress com, Office apps VBA, ERPs, scripting, ETL, DBA, SysAdmin, Wordpress, Python, .NET, Clarion, PHP are part of my skills and experience, including UML, BPMN as well as GIMP for graphic design. PROCEDURES Remote Work -Online distance working -Online collaboration: easier system for you. -Daily communication automatized workflow. -Extreme programming, Agile methods. I look forward to work with you, Kind regards.
$30 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Birmingham, United Kingdom
4.7
5
Payment method verified
Member since May 2, 2013

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.