Find Jobs
Hire Freelancers

Build an Excel macro to pull data from a website. Needs to extract data 5-10 times a day automatically

€30-250 EUR

Terminado
Publicado hace casi 7 años

€30-250 EUR

Pagado a la entrega
Hello, I have been manually pulling data from a website to see how often a parking spot is utilized (data is from car2go's API that shows how many car2go vehicles are parked at a particular car2go parking lot). I can't do this manually anymore and I was hoping to find a solution that is more automated. I think the easiest solution would be to build a macro but open to hear opinions if there's a better way. Data is pulled from this website: [login to view URL]
ID del proyecto: 14531299

Información sobre el proyecto

37 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
I have excellent command on MS Excel and know how to pull data from a website using VBA Relevant Skills and Experience Few of my past projects - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API - Built a complex shift allowance calendar and calculator Proposed Milestones €100 EUR - Completion of work
€100 EUR en 3 días
4,8 (81 comentarios)
5,9
5,9
37 freelancers están ofertando un promedio de €103 EUR por este trabajo
Avatar del usuario
Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - 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 give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample work before you may please consider awarding me the project. Thanks, Jay
€150 EUR en 2 días
5,0 (838 comentarios)
9,0
9,0
Avatar del usuario
I've read your brief and can see that you'd like to have an Excel spreadsheet to pull data from the web. Relevant Skills and Experience I have 7 years experience designing and developing Excel spreadsheets filled with formulas and VBA code. Proposed Milestones €150 EUR - I would approach your project by creating a draft spreadsheet and send it to you for review. When can we chat or talk? I am online from 3pm to 11pm Mon-Fri and 8am to 11pm Sat-Sun (GMT+3).
€150 EUR en 2 días
4,9 (415 comentarios)
8,2
8,2
Avatar del usuario
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
€120 EUR en 3 días
4,9 (454 comentarios)
8,3
8,3
Avatar del usuario
Hi sir, I am scraping expert, I have did more than 350+ scraping project, please check my feedback then you will know. Can we discuss more details about this project? then I will provide example data/script for you. Thanks, Kimi
€100 EUR en 2 días
5,0 (205 comentarios)
7,4
7,4
Avatar del usuario
Hello Sr. Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I could help you with a MAcro Building or WinAutomation program. Relevant Skills and Experience Experience building solutions like: scrapers apps, scrape services, automation programs/bots, web apps, and more. Proposed Milestones €150 EUR - Program/Macro built and delivered. Would be great to chat with you to understand all the requirements. Message me.
€150 EUR en 3 días
5,0 (183 comentarios)
7,3
7,3
Avatar del usuario
Hello, I am interested for your project. Please let me know more details about your project. Kind Regards, Nabila Relevant Skills and Experience data entry Proposed Milestones €150 EUR - na
€150 EUR en 3 días
4,9 (172 comentarios)
6,9
6,9
Avatar del usuario
I can do it for you so fast, automatically scraping the data directly from the site to your excel al in a excel program. I am really an expert doing it almost daily. Relevant Skills and Experience Have experience pulling data from different sites. Please read teh comments from my clients as a reference. I am sure I can guide to your success with it. Proposed Milestones €100 EUR - when you feel satisfied.
€70 EUR en 1 día
4,9 (59 comentarios)
6,0
6,0
Avatar del usuario
- Can get the parking data for the city of choice as listed and have it automatically pulled every 10mts. - On click of the button, the data would be pulled into the excel format. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio. - University, US - Scoring the answer sheets based on keyword and number of occurences.
€100 EUR en 3 días
4,6 (49 comentarios)
6,1
6,1
Avatar del usuario
Yes you have heard right.. Macro is an excellent option to automate this process. I can develop for you. You can check my past working and client feedback about my work on my profile Relevant Skills and Experience Excel, VBA Proposed Milestones €108 EUR - Full Coverage Looking for your response
€108 EUR en 1 día
4,9 (31 comentarios)
5,5
5,5
Avatar del usuario
A proposal has not yet been provided
€242 EUR en 1 día
5,0 (4 comentarios)
3,3
3,3
Avatar del usuario
Hi, you can end the file and we can disscus exactly what you need , I can do it 1 ot in 2 days maximum . Relevant Skills and Experience I am an excel and vba specialist , I see what you want , I can do it by the way you want . I can create connection and set time how ofthen update data . or I can create a macro. Proposed Milestones €100 EUR - afther complete the project
€100 EUR en 1 día
5,0 (5 comentarios)
2,7
2,7
Avatar del usuario
Let's discuss about a solution, What do you need to do with the data, as I am able to import the data to an excel sheet,but what is Expected to do with it ? Relevant Skills and Experience Skilled in Excel, SQL, data, web, etc :) check my reviews Proposed Milestones €100 EUR - File is completed Additional Services Offered €50 EUR - Hourly Payment for future work, as said : OPTIONAL :) Can you provide an excel file where there is the "format" of the data to be "stored" ? Thanks
€100 EUR en 3 días
5,0 (1 comentario)
2,6
2,6
Avatar del usuario
as i got you need to add this link at a Excel sheet i will do it for you with formula so if you changed the numbers the formula will be done automatically and will deliver same day award me Relevant Skills and Experience 0% Errors Efficient Rapid Accurate Proposed Milestones €34 EUR - Data Entry in case you need the whole site plz update me
€34 EUR en 0 día
5,0 (6 comentarios)
2,2
2,2
Avatar del usuario
I am a Microsoft Certified Programmer (MCP),I have extensive experience developing,I can realize the application you need,if you observe I have 100% of my work completed and with 5 stars,best regards. Relevant Skills and Experience Excel Proposed Milestones €30 EUR - Project Finished
€30 EUR en 1 día
4,9 (3 comentarios)
2,4
2,4
Avatar del usuario
Build a macro to scrape data from requested website - macro will have to be initialised manually for each scrape (can be done via button click for example). Relevant Skills and Experience Over 5 years experience with Excel VBA. Proposed Milestones €30 EUR - Complete working Excel macro to scrape and format data as required
€30 EUR en 1 día
5,0 (4 comentarios)
1,9
1,9
Avatar del usuario
I will make you a custom desktop application. This application will pull data on a schedule that you set. This application will output the data in any format we decide upon. I am VERY good at this. Relevant Skills and Experience I have 15 years experience as a developer, I also have a bachelors degree in computer sciences with an emphasis on application design. I can and will deliver this very fast and make you happy. Proposed Milestones €111 EUR - Job is completed May I please so this work for you? This sounds like a fun project.
€111 EUR en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
€166 EUR en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
€165 EUR en 6 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Systems Engineer with more than 9 years of work experience with capacity to give a fast and timely response to the requirements of this project Relevant Skills and Experience Systems Engineer with more than 9 years of work experience with capacity to give a fast and timely response to the requirements of this project Proposed Milestones €34 EUR - Complete this project in the estimated time and even long before
€34 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
€44 EUR en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Coquitlam, Canada
5,0
1
Forma de pago verificada
Miembro desde jul 2, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.