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

Completato
Pubblicato quasi 7 anni fa

€30-250 EUR

Pagato al completamento
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]
Rif. progetto: 14531299

Info sul progetto

37 proposte
Progetto a distanza
Attivo 7 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 in 3 giorni
4,8 (81 valutazioni)
5,9
5,9
37 freelance hanno fatto un'offerta media di €103 EUR
Avatar dell'utente
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 in 2 giorni
5,0 (838 valutazioni)
9,0
9,0
Avatar dell'utente
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 in 2 giorni
4,9 (415 valutazioni)
8,2
8,2
Avatar dell'utente
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 in 3 giorni
4,9 (454 valutazioni)
8,3
8,3
Avatar dell'utente
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 in 2 giorni
5,0 (205 valutazioni)
7,4
7,4
Avatar dell'utente
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 in 3 giorni
5,0 (183 valutazioni)
7,3
7,3
Avatar dell'utente
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 in 3 giorni
4,9 (172 valutazioni)
6,9
6,9
Avatar dell'utente
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 in 1 giorno
4,9 (59 valutazioni)
6,0
6,0
Avatar dell'utente
- 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 in 3 giorni
4,6 (49 valutazioni)
6,1
6,1
Avatar dell'utente
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 in 1 giorno
4,9 (31 valutazioni)
5,5
5,5
Avatar dell'utente
A proposal has not yet been provided
€242 EUR in 1 giorno
5,0 (4 valutazioni)
3,3
3,3
Avatar dell'utente
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 in 1 giorno
5,0 (5 valutazioni)
2,7
2,7
Avatar dell'utente
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 in 3 giorni
5,0 (1 valutazione)
2,6
2,6
Avatar dell'utente
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 in 0 giorno
5,0 (6 valutazioni)
2,2
2,2
Avatar dell'utente
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 in 1 giorno
4,9 (3 valutazioni)
2,4
2,4
Avatar dell'utente
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 in 1 giorno
5,0 (4 valutazioni)
1,9
1,9
Avatar dell'utente
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 in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
€166 EUR in 5 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
€165 EUR in 6 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
€44 EUR in 5 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: CANADA
Coquitlam, Canada
5,0
1
Metodo di pagamento verificato
Membro dal lug 2, 2017

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.