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

Concluído
Publicado há quase 7 anos

€30-250 EUR

Pago na 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 do Projeto: 14531299

Sobre o projeto

37 propostas
Projeto remoto
Ativo há 7 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
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 em 3 dias
4,8 (81 avaliações)
5,9
5,9
37 freelancers estão ofertando em média €103 EUR for esse trabalho
Avatar do Usuário
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 em 2 dias
5,0 (838 avaliações)
9,0
9,0
Avatar do Usuário
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 em 2 dias
4,9 (415 avaliações)
8,2
8,2
Avatar do Usuário
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 em 3 dias
4,9 (454 avaliações)
8,3
8,3
Avatar do Usuário
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 em 2 dias
5,0 (205 avaliações)
7,4
7,4
Avatar do Usuário
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 em 3 dias
5,0 (183 avaliações)
7,3
7,3
Avatar do Usuário
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 em 3 dias
4,9 (172 avaliações)
6,9
6,9
Avatar do Usuário
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 em 1 dia
4,9 (59 avaliações)
6,0
6,0
Avatar do Usuário
- 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 em 3 dias
4,6 (49 avaliações)
6,1
6,1
Avatar do Usuário
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 em 1 dia
4,9 (31 avaliações)
5,5
5,5
Avatar do Usuário
A proposal has not yet been provided
€242 EUR em 1 dia
5,0 (4 avaliações)
3,3
3,3
Avatar do Usuário
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 em 1 dia
5,0 (5 avaliações)
2,7
2,7
Avatar do Usuário
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 em 3 dias
5,0 (1 avaliação)
2,6
2,6
Avatar do Usuário
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 em 0 dia
5,0 (6 avaliações)
2,2
2,2
Avatar do Usuário
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 em 1 dia
4,9 (3 avaliações)
2,4
2,4
Avatar do Usuário
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 em 1 dia
5,0 (4 avaliações)
1,9
1,9
Avatar do Usuário
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 em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
€166 EUR em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
€165 EUR em 6 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
€44 EUR em 5 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) CANADA
Coquitlam, Canada
5,0
1
Método de pagamento verificado
Membro desde jul. 2, 2017

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.