Web scraping using excel vba jobs

I'm seeking an experienced developer to create an advanced price monitoring/alert system that targets Amazon, via the Keepa API Key Requirements include: - Ability to monito...not being prioritized. - Automatic alert system for price changes. Frequency of alerts is to be confirmed, as this feature needs to be customizable. - Highly preferred for the system to be capable of tracking a variety of product categories such as Electronics, Fashion and Home Appliances. Ideal Candidate should possess: - Proficiency in Amazon's API (and Keepa API) and other relevant Web Scraping tools. - Previous Experience in developing price comparison or price monitoring tools. - Strong understanding of Data Processing and management. - Ability to deliver on time and maintain goo...

I require a python code developer who can create an automation program for my trading activities. The primary objective of this project is to automate the trade execution process. Key requirements: - Simply copy the provided code from the broker website and execute the trades(Code already available) - Integration with brokers: The automation tool should directly interface with my broker, Angel one. - Financial instruments: The system should be able to trade stocks, options, and futures. Ideal skills and experience: - Proficient in Python: The candidate should have a strong background in writing automation scripts in Python. - Knowledge of trading APIs: Experience in working with broker APIs, particularly with Angel one, is highly desirable. - Understanding of financial instruments: A ...

...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA &...

I am looking for a developer who can create a custom search to return only custom post types of a specific type without the using of pluging. Specific Requirements: I have a search results page at It lists all of Japan's ski resorts (post type = fs_ski_resorts). At the top of the page is a search box. When searched, it returns all of the fs_ski_resorts but it uses the search template. I need it to use a custom results layout like search-fs_ski_resorts but I cannot figure out how to do.

I'm looking for a skilled individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in ha...individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in handling PDF documents. Experience with Microsoft Excel...

I need to scrape data from the website Transfermarkt.com. For specific football clubs and seasons, i need all arrivals and departures, including their name, age, position, transfer fee and sending/receiving club. I only need a generic code, where i can manually insert the club and year myself. I want the data to be transferred and appended in one excel file

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentatio...

I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions

I'm in need of a data entry freelancer with a good command of Microsoft Excel. The task involves inputting data into a spreadsheet. The data is simple and involves just a few columns. This is an ideal project for a freelancer who is available to work from home. Ideal skills for this job include: - Proficiency in Microsoft Excel - Attention to detail - Ability to maintain accuracy while working with data Please note that I don't require any specific software knowledge other than Microsoft Excel. Looking forward to working together.

I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions

I'm seeking an experienced professional who excels in sophisticated data analysis, chart creation and process automation using Excel. You'll need to leverage data visualization techniques to deliver insightful dashboards, with a key focus on developing pie charts for clear, concise, and impactful data representation. Your responsibilities will include: - Analyzing and interpreting complex data sets - Crafting well-structured and insightful pie charts - Automating repetitive processes to improve productivity Core competencies required for this role include a strong background in Excel and data analytics, proficiency in dashboard creation, a keen understanding of automation processes, and the ability to logically interpret and visualize data.

I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘Inventory data’ and project sch...

...workforce. Key Responsibilities: - Develop a structured sales training program encompassing various selling techniques, customer service, and product knowledge reinforcement. - Create engaging and interactive product training sessions that educate employees about our offerings, benefits, and unique selling points. - Implement a series of on-the-job training modules that help employees grasp and excel in their roles, while aligning their efforts with organizational goals. Ideal Candidate: - Experience in designing and delivering comprehensive sales and product training programs. - Proven track record in conducting engaging and effective online and offline training sessions. - A solid understanding of adult learning principles, particularly in a corporate setting. - Excellent com...

I'm leading the development of a cutting-edge video streaming app using Flutter. Our aim is to provide users with a seamless entertainment experience, offering a wide range of content including novels, series, and movies. Key Responsibilities: As the Backend Developer for this project you will: 1. Design and develop scalable server-side applications. 2. Implement robust APIs for seamless communication with the Flutter client. 3. Integrate third-party services to enhance platform features. 4. Manage data storage solutions and optimize database performance. 5. Ensure server-side code is optimized for performance and reliability. 6. Implement security measures to protect user data. Requirements: To excel in this role, you should: 1. Have proven backend d...

Need to open port 25 and 53 using VPN.

I need a Python script that will create an endpoint for a Prometheus scraper to pull data from. I have the data already prepared, and it's ready to be pulled. Key Points: - The data to be pulled is in an unspecified format, so the script will need to be able to handle various data formats. - T...ready to be pulled. Key Points: - The data to be pulled is in an unspecified format, so the script will need to be able to handle various data formats. - The specific data fields the script should include in the endpoint for the Prometheus scraper are not defined. I'm looking for an experienced Python developer who has worked with Prometheus in the past and has a good understanding of data scraping. Knowledge of various data formats and the ability to handle dynamic data fields...

I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.

I'm seeking a freelancer who can develop an automated system in Excel to manage backorders. This system must create new data for efficient backorder handling. Specific requirements include: • Creation of an automation tool that handles numeric values, text strings, and dates and times. • The system should adequately track product lead times and inventory levels, despite not automatically generating reports. Please note, having prior experience in backorder management and Excel automation will be advantageous for this project. The ideal freelancer should have strong data handling capabilities and excellent knowledge of Excel. Proven experience in similar projects is preferred.

I'm looking for a proficient web developer to create a cutting-edge web app tailored for educational institutions. The main features of the app should revolve around seamless video communication between users. Key Features: - One-to-One Video Calling: Implementing a robust video calling functionality that can support both one-to-one sessions. - Live Chat: A real-time chat room integrated within the app for additional interaction. - Screen Sharing: Facilitating screen sharing among the participants. Customization Level: - The primary focus of this project is on basic video call functionality. No need for advanced features such as filters, effects, or custom backgrounds. The emphasis is on providing a stable, user-friendly video calling experience. Ideal Skills: - Pr...

I need an experienced freelancer to create a chart with interest rat...freelancer to create a chart with interest rates in Canada for every month between January 2015 and the current month. Key Requirements: - The chart should accurately reflect the fluctuation in interest rates over the specified time period. - The format must be an excel which is easy to read and interpret. - No additional analytics features such as trend lines or forecasts are necessary, the primary focus is to clearly display interest rates by month. Ideal Skills: - Research historical interest rates in canada - Proficient in Excel and creating line graphs. - Strong understanding of financial data, specifically interest rates. - Eye for detail and ability to ensure the data is clearly presented for ea...

Hi Berty J. I hope you are fine. Remember the Skyscanner project you did? I need a cmd tool to get parcel tracking histories from where the last number is the parameter I need to call the tool and I expect a JSON on stdout with either the list of events (shipmentCourse entries) or anything they want to tell me like "expecting your shipment data soon." pls check and let's discuss availability and effort.

I need an experienced freelancer who can convert Excel data to 2D DWG files on an urgent basis. Key Requirements: - Utilize the Excel data to create 2D contour plots, specifically representing the height distribution on a bridge surface and the riverbed levels. - Create these contour plots in a DWG format. - Accuracy and precision are crucial for this project. Ideal Skills and Experience: - Proficiency in AutoCAD for DWG creation. - Prior experience with data visualization from Excel. - Immediate availability to start and complete the project as soon as possible. Please include any relevant portfolio items or examples of similar projects you've done in the past. I am looking for a quick turnaround without compromising on quality.

I need someone to add a total of 50 bookmarks to my Word document. Essential Requirements: - Add 50 bookmarks to the document - create a excel; audit xls with 50 rows listing the bookmark name and the section text name (we use that as quality control and testing)

I'm looking for a skilled programmer who can quickly correct the issues in my web scraping project in python. The task involves scraping data from Website A. Specifically, I need to retrieve player, tournament, records and runs and bowlers information. Ideal Skills and Experience: - Proficient in web scraping techniques - Experience working with CSV format - Familiarity with data extraction from dynamic sources - Ability to troubleshoot and fix existing code - Strong attention to detail and accuracy Please note that I need this task completed urgently within few hours as base code is already written, need to fix details, so quick turnaround time is essential. Thank you!

I'm seeking a proficient freelancer who can handle all aspects of setting up, running, and ensuring the success of my Shopify dropshipping account. My business focuses on a specific nich...SEO: I prefer to attract customers to my store through organic SEO strategies. Practical knowledge of SEO tools and techniques is a must. 3. Social Media Proficiency: In addition to SEO, I'd like to integrate targeted advertising on Facebook and Instagram into my marketing strategy. Ideally, the freelancer should have a track record of optimizing Shopify stores for effective dropshipping. To excel in this task, the freelancer should possess excellent SEO skills, social media advertising knowledge, and a clear understanding of dropshipping mechanics. Your bids should reflect your compet...

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp

I am seeking a proficient web scraper to extract specific data from The data I need includes venue details and contact information. I require the end product to be delivered as a well-organised Excel file. Key aspects to focus on: * Meticulous detail on venue data * Comprehensive contact information * High level data formatting skills The ideal candidate has demonstrated experience in web scraping, data management and Excel. A background in music or event-based data is a plus. Efficiency, precision and respect for the source website's terms of service are crucial for this project.

I’m in need of an Excel specialist who is adept at enhancing operational efficiency through the automation of repetitive tasks, namely the creation of reports utilizing sales and operational data. Key Requirements: - Creating a system for report generation on Excel, extracting key insights from extensive datasets. - Reports should conveniently display revenue, profit margins, sales growth, as well as production metrics and efficiency metrics. Ideal skills: - Proficiency in Excel and data analysis - Experience with big data and automating report generation - Strong attention to detail and the ability to make data actionable.

Description: We are se...understand specific criteria and requirements for the list. Requirements: Proven experience in researching, content writing, and data entry, preferably in a business or professional setting. Excellent attention to detail and accuracy in data collection and entry. Strong organizational skills with the ability to manage multiple tasks and deadlines effectively. Proficiency in using online research tools, databases, and Microsoft Excel or Google Sheets. Exceptional written communication skills with the ability to craft clear and compelling content. Preferred Qualifications: Previous experience working in business consulting or a related industry. Familiarity with CRM systems or other data management software. Knowledge of business terminology and indus...

...Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data The requirements for the applicant include strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). We need fast, accurate and specialized members. It is mandatory to pass a short trial test / finish a task, that could last between 2-4 hours, with the possibility of extension to up to 1 week, if the candidate is involved in other projects, or not available to start immediately....

...to create a comprehensive and highly interactive dashboard that will help track and analyze market data more efficiently. It is important that the dashboard connects to Excel spreadsheets and other Power BI resources to provide an all-round perspective of the metrics. Ideal skills and experience: - Proficient in Power BI - Excellent knowledge of Excel - Deep understanding of retail market data analysis - Excellent in crunching and interpreting numbers - Strong attention to detail Responsibilities: - Gather and interpret market data - Create a user-friendly and highly interactive dashboard - Connect the dashboard to Excel spreadsheets and Power BI resources - Regularly update the dashboard with relevant market data - Identify trends and patterns based on the data...

I'm in need of an advanced Excel VBA specialist with proficiency in data manipulation, particularly data filtering across multiple Excel sheets. The tasks required entail: - High-level manipulation of Excel data; - Expertise in filtering data across multiple sheets; - Strong understanding of data validation; - Experience in report generation. Experience in dealing with large amounts of data and creating user-friendly detailed reports from complex data sets will be crucial for this project. Excel VBA certification and verifiable previous projects in similar tasks are a plus.

I'm in urgent need of someone who can scrape a website for me. So the intent is that we open the first page, and set a filter, and then go to each profile and open the websites/social profiles to see if they have any emails addresses. Output is a spreadsheet with rank, name, socials, website, email address. Skills required: - Web scraping - Ability to deliver results in a timely manner

I am urgently looking for an experienced Python expert with exceptional web scraping skills to extract text content from various sites. Your proficiency in data extraction and handling is paramount for this project. Specifics of the types of websites to be targeted will be discussed later. Ideally, you should have: 1. Proven experience in Python based web scraping. 2. Strong understanding of different types of websites and their structures. 3. Availability to start and complete the job ASAP. Please ensure your bid reflects your strong standing experience and your immediate availability to commence the task. Expect more details upon assignment. Let's get started!

...leads that meet the specified criteria. Delivery Format: Leads must be supplied in an Excel spreadsheet for easy integration into our systems. Timeliness: Prompt delivery of leads is crucial for our business operations. How to Apply: If you're confident in your ability to deliver high-quality leads meeting the outlined criteria, we want to hear from you! Please provide the following information in your application: Experience: Share details of your experience with lead scraping, particularly within the specified industry and geographical location. Methodology: Outline your approach to sourcing and verifying leads to ensure accuracy and reliability. Samples: If available, provide samples of previous lead scraping work demonstrating your capabilities. Timeline:...

I need help browsing the web for text data and organizing it in Excel. - The text data is to be organized in Excel by name and other relevant information. - No specific Excel functions or formulas need to be used, you will simply need to look at the page and type the information into the spreadsheet. Ideal skills: - Proficiency in web browsing - Be very quick - Strong attention to detail - Familiarity with Excel - Time management skills The task is straightforward, but attention to detail, accuracy, and the ability to work efficiently are crucial. Please submit your daily rate.

Hey there! I'm looking for someone to create a model that can identify regular website traffic from bot traffic using two datasets. I have two datasets in the form of JSON array with user analytics (with each dataset containing about 10,000 entries for each.) I prefer to use almost all possible features from these datasets, except confidence feature which can be disregarded. (Please check the dataset so you can get an idea) Datasets: Good Dataset Bad Dataset I have attached a sample from both so you can see. (In this sample, I only have one entry for you from each dataset.) Deliverables: Well documented Jupyter File Notebook (With clear steps, some data visualisation, testing, and also model should be saved in the end) Minimum Accuracy should be at least 90%. Deadline :...

I am looking for an Excel expert who can help me create a dynamic and visually appealing Trend chart that can effectively communicate data composition over time. Key Requirements: - The chart must be able to clearly represent data changes over a period of time, showcasing the shifting proportions of different components. - The data for the chart will be provided in an Excel file. The freelancer will need to effectively structure this data to make it compatible for chart creation. - The chart should be designed with the latest Excel standards to ensure compatibility and ease of use. Ideal Candidate: - Strong proficiency in Excel, with a focus on chart creation. - Experience in creating dynamic and interactive charts in Excel. - Ability to understand and...

We are looking for a highly skilled Lead Generation and Cold Calling Virtual Assistant for our Digital Marketing Agency. As a Cold Calling specialist, you will be...Requirements: 1. Should have basic understanding of Google My Business (formerly GMB Profile), Website Design, SEO, Backlinks etc. (preferred but not mandatory) 2. A big plus if you have 1-2 years of experience selling digital marketing services like Websites, SEO and etc.. 3. Must be good in researching data for companies (business name, contact numbers, emails etc.) 4. Sufficient knowledge of MS Excel for managing the data. 5. Great communication skills (both, verbal and written). Details: 10 Hours a week / 2 hours a day / Monday through Friday If this opportunity interests you, please respond so we can discus...

I'm looking for an expert with significant experience in web scraping and script debugging to help address an issue with one of my scripts. The issue I'm encountering is with Website 1, specifically in relation to URL scraping. Despite providing the necessary command, the script is not collecting URLs as it should be. Ideal candidate: - Experienced in web scraping and script debugging - Proven track record with similar projects - Ability to resolve the issue in a quick, efficient manner Your task will not be deemed complete until the script is able to successfully and accurately scrape URLs from Website 1.

I am seeking a proficient programmer to develop a scraping application for the purpose of extracting text data from websites. This project is sensitive, considering that the targeted websites demand API keys for access. Accordingly, the ideal candidate should be familiar with both GET and POST methods as well as API integration and management. Experience with data extraction and web scraping from API authenticated websites is a must. Skill requirements: • Web scraping • HEADERS • CUSTOM HEADEARS • STRINGS • URLLIB • Working knowledge of GET & POST methods • Experience with API authentication • Exceptional skills in data extraction, especially text. • loliscript • SilverBullet i need to get a netflix ...

I'm currently working on a financial analysis project through Microsoft Excel and require assistance with data structuring specifically for pivot tables. I aim to feed this data into a comprehensive dashboard. The Excel spreadsheet encompasses multiple periods of financial data. Key Aspects: - Data included in the pivot tables are dates of financial periods, types of financial information, and identifiers such as multiple General Ledger accounts, categories and subcategories. - The task involves transforming this spreadsheet data into an appropriate format suitable for creating a pivot table and consequent dashboard. Skills and Experience: - Proficiency in Microsoft Excel, particularly in the handling of complex data and pivot tables. - Experience in financial...

I need help with Excel It is advance level so please be careful when you apply. Thanks.

Cuento con datos operacionales en Excel de mi trabajo, y necesito transformar esa data a dashboards y procesar data en un ambiente web. I have operational data in Excel from my work, and I need to transform that data into dashboards and process data in a web environment.

Hey there! I'm looking for someone to create a model that can identify regular website traffic from bot traffic using two datasets. I have two datasets in the form of JSON array with user analytics (with each dataset containing about 10,000 entries for each.) I prefer to use almost all possible features from these datasets, except confidence feature which can be disregarded. (Please check the dataset so you can get an idea) Datasets: Good Dataset Bad Dataset I have attached a sample from both so you can see. (In this sample, I only have one entry for you from each dataset.) Deliverables: Well documented Jupyter File Notebook (With clear steps, some data visualisation, testing, and also model should be saved in the end) Minimum Accuracy should be at least 90%. Deadline :...

Extract the industry data from the IBIS reports and populate the Excel template

Hey there! I'm looking for someone to create a model that can identify regular website traffic from bot traffic using two datasets. I have two datasets in the form of JSON array with user analytics (with each dataset containing about 10,000 entries for each.) I prefer to use almost all possible features from these datasets, except confidence feature which can be disregarded. (Please check the dataset so you can get an idea) Datasets: Good Dataset Bad Dataset I have attached a sample from both so you can see. (In this sample, I only have one entry for you from each dataset.) Deliverables: Well documented Jupyter File Notebook (With clear steps, some data visualisation, testing, and also model should be saved in the end) Minimum Accuracy should be at least 90%. Deadline :...

I need an Excel sheet that will empower me to manage my call center effectively by providing me with real-time insights into the number of agents needed per hour. Key Requirements: - The sheet should offer a graphical representation of the data, enabling me to quickly understand the changes in agent demand. - It must calculate and display the total call duration per agent,hourly agent demand, and the average wait time for callers. Data should be updated on a daily basis to ensure the most current and accurate information is available. Ideal Skills: - Proficiency in Excel and ability to create dynamic tables and graphs. - Experience in designing forecasting models would be a plus. - Strong understanding of call center operations and key metrics. The ideal freelancer ...

I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.