Excel vba scraping website data jobs
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good ...
I'm looki...Telegram group via API integration but currently, it isn't purchasing as expected. Specifically, I'd require someone who could: - Identify and fix the issues that prevent it from purchasing and selling the scraped coins. - Make sure the bot interacts properly with the Latoken cryptocurrency exchange. This task would suit someone with a strong background in bot programming, API operations, web scraping, and experience dealing with cryptocurrency exchanges, particularly Latoken. Knowledge of crypto trading bots' operational peculiarities would be a major plus. Your task would be to get it back to working condition, ensuring all functions operate as they should. This job will evolve into continuous maintenance and development of bot's features. T...
I'm looki...Telegram group via API integration but currently, it isn't purchasing as expected. Specifically, I'd require someone who could: - Identify and fix the issues that prevent it from purchasing and selling the scraped coins. - Make sure the bot interacts properly with the Latoken cryptocurrency exchange. This task would suit someone with a strong background in bot programming, API operations, web scraping, and experience dealing with cryptocurrency exchanges, particularly Latoken. Knowledge of crypto trading bots' operational peculiarities would be a major plus. Your task would be to get it back to working condition, ensuring all functions operate as they should. This job will evolve into continuous maintenance and development of bot's features. T...
...address, phone number, etc. Most search results will include a link to the company’s website. For example, when I search on Google for… Jake The Plumber Minneapolis, MN … I see a link to Jake The Plumber’s website. Your script(s) will not submit the forms; rather, I will review each form and then manually submit each myself. In other words, I will click on, for example, the “Send” or “Submit” button. If I were to loop your script(s) X times, then your script(s) would open X tabs in Google Chrome. Each tab would contain a website for a particular business. For example, if I were to loop your script(s) 89 times, then your script(s) would open 89 tabs in Google Chrome. Each tab would contain a website for a ...
I'm in need of a skilled data miner who can help to extract certain details from a vast range of Shopify products. Your mission, if you choose to accept it, is as follows: - list products that contain non-English writing or words in text and videos - Organise and sort these findings for simple review - Identify and list any products filled with non-English language in the description, pictures or images - Compile lists of products that aren’t currently making top-seller lists - List any products can not be delivered in eight days or less. Please note that tractors and food vans may take up to two months to deliver. - List any products that are not suitable for industrial purposes/non-commercial products. Ensure that the products you are considering are meant for commerci...
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Pro...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportuni...opportunities; * Comprehensive knowledge of research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Exce...
...able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual representations of data. - ...
...someone experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure ac...
...Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS O...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight meas...for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of sto...
I need a fully bilingual professional (I will interview in English) to do some tasks for my agency such as: PR Outreach Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Wordpress And others You must be a fast learner, attentive, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes. This job will start part-time as a test period, after that it will be full-time. Payment for part-time during trial period: Fee: 250 USD Performance bonus: 50 USD Results bonus: 50 USD If your work complies with my quality requirements and you give more than asked, you’ll get performance and results bonuses each month. After a tw...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and ...
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
I'm looking for a talented freelancer who can assist with scraping automobile ads from website. Key Requirements: - Scraping specific automobile ads. - Extracting ad titles, descriptions and prices. The ideal candidate should have: - Experience in web scraping. - A strong understanding of data collection from websites. - Attention to detail to ensure accurate extraction of data. Please note that the exact websites and the car details are not provided yet, so the freelancer should be able to work with changing parameters.
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
Create an executable scraper in Python that can extract the SKU (product) list from the following Indonesian online grocery apps: - Astro - Sayurbox - Segari The scraper must be IP-block tolerant, meaning if the scraper gets blocked, execution can be continued from the point where the last row of data was successfully extracted. Scraper Functions Function: list_category_tree Input: competitor_name(astro | sayurbox | segari), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocomplete place from google maps API), ca...
...operating in the healthcare sector, committed to leveraging data to enhance our services and support for medical professionals. Our focus is on identifying and connecting with newer medical professionals and travel nurses to offer them tailored opportunities and support. What We Need: We're seeking a talented web scraper who can help us gather specific data on medical professionals with new NPI numbers. Your task will involve targeting individuals in specific states and collecting their information accurately and efficiently. Your Responsibilities: Develop a web scraping solution capable of targeting specific states and names of medical professionals with new NPI numbers. Ensure the accuracy and reliability of the scraped data. Customize the scraper t...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create u...
Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm
...in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel docu...
...operating in the healthcare sector, committed to leveraging data to enhance our services and support for medical professionals. Our focus is on identifying and connecting with newer medical professionals and travel nurses to offer them tailored opportunities and support. What We Need: We're seeking a talented web scraper who can help us gather specific data on medical professionals with new NPI numbers. Your task will involve targeting individuals in specific states and collecting their information accurately and efficiently. Your Responsibilities: Develop a web scraping solution capable of targeting specific states and names of medical professionals with new NPI numbers. Ensure the accuracy and reliability of the scraped data. Customize the scraper t...
I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.
I’m looking for an experienced programmer who can create an automation script for a website. Key Requirements: - Automation Tasks: Your main job would be to automate various tasks on a website. This could involve anything from data entry to form submissions, and possibly content scraping. The specific tasks will be shared with you in detail. - Python Expertise: Given the nature of this task, your proficiency in Python is a must. If you have experience with automating websites using Python, that would be a huge plus. - Experience: Your application should showcase your relevant experiences and past projects. I’m looking for someone who has a proven track record in this field. Please include relevant examples of your past work in your application. Loo...
we need a Web Scraping expert for a long term. will give you 1 site a day. per site $15. It's all about scraping product data like product title, description, image link etc.
I have a series of PDFs with text that needs to be typed into an Excel sheet. The data is mainly textual in nature. Key Requirements: - Data Entry: You'll be responsible for accurately inputting the text from PDFs into the corresponding cells in Excel. Ideal Skills: - Proficiency in Excel: You should be comfortable using Excel and have experience with data entry. - Typing Skills: Fast and accurate typing skills are essential. - Attention to Detail: The data needs to be entered accurately to ensure the integrity of the information. - Familiarity with PDFs: Experience working with PDFs is beneficial. Please note, there are no specific formatting requirements beyond accurate data entry.
...tool developed that can accurately scrape specific data from Airbnb and AirDna. The aim is to retrieve information about rental prices, occupancy rates, and property descriptions, etc. Key Features: - Efficient data scraping: The tool should successfully extract rental prices, occupancy rates, and property descriptions from Airbnb and AirDna. - Localized scraping: The data scraping should be focused on a specific city, which will be revealed once the project commences. Use of Data: The scraped information will be primarily used for market analysis purposes. The data will be instrumental in helping me understand the dynamics of the rental market within the specific city. Skills & Experience Required: - Proven experience in ...
...search of a skilled freelancer proficient in web scraping with Scrapy to extract product data from This project involves scraping the Category page to retrieve product details including name, price, SKU, URL, breadcrumb, currency, and brand. Targeted webpage: Category page of Required data: Product name, price, SKU, URL, breadcrumb, currency, and brand Experience: Prior experience in scraping product-related information from e-commerce sites is essential, with proficiency in Scrapy being crucial for accurate and efficient data extraction. Data Handling: Ability to ensure accuracy and consistency of extracted data. Familiarity with different data formats is advantageous. Dynamic Scraping: Navigation logic for all ca...
I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.
I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.
I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload
I'm looking for an experienced API developer to help with syncing and scraping data from Confluence. Ideal Skills and Experience: - Proficient in Confluence API - Expertise in data synchronization and data scraping - Knowledge of handling Confluence pages, spaces, attachments, and content images - Able to preserve formatting and filter by date Key Responsibilities: - Develop an API integration for data synchronization - Implement scraping functionality for Confluence pages, spaces, and attachments - Ensure the scraped content maintains original formatting - Implement filtering logic to sort data by date
I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.
...individual to scrape data from the online gaming industry and compile a list of email contacts for companies outside the U.S. and preferrably in Cyprus Malta U.K. and LATAM Brazil Key Requirements: - Focus on the Online Gaming Industry: The primary focus of this data scraping project is the online gaming sector specifically. All data should be relevant to companies operating within this industry. - Company Contact Information: The main data that I'm seeking here are Marketing manager and Business development email contacts for companies within the online gaming sector. This could include CEO founder and other decision-makers within these companies. Skills and Expertise: - Proficient in Data Scraping: The ideal candidate should ha...
I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.
I'm looking for a detail-oriented researcher to help me gat...- charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be ref...
I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.
I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...
...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally....
need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided
I am seeking an expert in email scraping for the purpose of building a marketing database. The ideal candidate can efficiently scrape emails and the company names. Key Aspects: - Attention to detail to ensure all relevant emails are scraped accurately and company name is also with. - Quick turn around, the project should be completed within a month. - Extensive experience in email scraping and database construction. I need this in a google sheet document. The approx amount of names/emails is 12.000 - 14.000 on the website. I need a fixed price offer and also time frame for this.
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.
I need a database for the UK market, with a foc...database for the UK market, with a focus on company names and Email ID. Key Points: - The project primarily involves creating a comprehensive database for the UK market - The main data points to be included are company names and Email ID's - Information can be extracted from Yellow Pages, Business Pages, Associations, Business Chambers and similar. - Accuracy of data, specially Emails - Sample File of Required database is attached - To start with we require 10,000 records. - Will pay INR 0.60 per record. Ideal Freelancer: - Prior experience in creating detailed databases - Proficiency in data gathering, scraping and organization - Familiarity with the UK market would be a plus Please include your rele...
Join our team as a Python Selenium Web Scraper responsible for developing scraping scripts using Python and Selenium. You'll gather data from diverse websites, utilizing your expertise in web technologies, HTML, CSS, and JavaScript. Key responsibilities include analyzing website structures, extracting and cleaning data, and collaborating with team members to integrate data into existing systems. Ideal candidates possess proficiency in Python, experience with Selenium, and a strong understanding of web technologies. This role offers competitive compensation, flexible work hours, health benefits, and opportunities for career growth in a dynamic, collaborative environment
