Excel vba code download historical data yahooJobs
...have over the next 7 days. This data will be used to find a historical time series from the past that had percentage fluctuations (not based on price levels) as similar as possible. Once the most similar 7-day historical series to the predicted future series is found, the date of the historical series should be displayed on the screen. The entire software must be fully "commented" and explained in every function and calculation, clarifying the practicality and utility of each element within the model and highlighting the added value it provides. Data Requirements The software will be based on the BTC-USD price history from the past 5 years. The data should be continuously updated, and a daily granularity is recommended. It is preferabl...
...looking for a skilled developer to help optimize or rewrite a script for data scraping from allegro.pl. The goal is to scrape item URLs and download their HTML content efficiently while ensuring smooth operation. Current Situation: I have a JavaScript-based script that navigates to specific categories on Allegro, scrapes item URLs across multiple pages, and downloads their HTML files in a predefined structure (example attached). The script is slow due to delays between requests. Reducing these delays causes challenges with Allegro's security mechanisms, making the process less reliable. What I Need: A robust and reliable solution for faster and more efficient scraping without interruptions. The ability to download HTML files in the required structure. Ideall...
I need to work in a excel doc to do a macro to calculate new prices and add some other information.
*this task is for beginner level person only I am looking for beginner level Excel expert only. Please note that this is fixed price project and not per hour. Please no place holder bid. Please bid with your final price only. I'm looking for a professional to help me format a large Excel sheet and assist with some data analysis tasks.
Project Description for Freelancer Platform Interior Design Options for a 1920s Tuscan Villa We are seeking talented, enthusiastic, and creative interior designers to provide design options for a single-family home built in 1920, located in a Tuscan city. This project is ideal for young professionals looking to showcase their design skills while respecting the unique historical character of the home. Scope of Work: 1. Rooms to be Redesigned: • Living Room • Kitchen • Bedroom 2. Design Goals: • Style: Modern design with a respectful nod to the traditional architecture of the villa. • Provide at least two distinct design options: • One leaning more modern. • One leaning more classical. • Incorporate practical and functional solution...
I'm having trouble with my iOS app's backend logic, preventing me from uploading it to the App Store. I need an expert who can not only fix these code errors but also teach me how to rectify such issues in the future. Ultimately, I would like to learn the process of uploading to the App Store. Key requirements: - Expertise in iOS app development - Proficient in identifying and fixing code errors, particularly in backend logic - Experience with App Store submission process - Ability to explain complex technical issues in a simple, understandable manner - Patient and effective teacher
I'm seeking a talented miniature painter to assist with a luxury jewelry project. This opportunity involves creating intricate, fine art pieces on metal that will ultimately serve as pendants. Ideal Skills and Experience: - Expertise in detailed painting, with a strong portfolio of miniature artwork. - Proven ability to interpret and depict complex themes, specifically mythology, historical scenes, and cultural motifs. - Exceptional attention to detail and a dedication to top-notch craftsmanship. - Experience working with metal as a painting surface. The artwork should be painted in an Impressionist style. If you're passionate about creating intricate, detailed artwork and have the skills and experience we're looking for, we'd love to see your bid.
I'm looking for a script or API that can export my Active Campaign Deal Notes into a CSV/Excel file. Key Requirements: - The script/API must export the Deal Notes in a CSV/Excel format. - The output should include the note content, the date created, and the username of the note creator. Ideal Skills: - Proficient in scripting and API integrations, especially with Active Campaign. - Strong understanding of data export and manipulation. - Experience in generating CSV files from API data. Please, do not apply if you do not have the required skills and experience.
Russian Recording Project We need Freelancers for long term Project. We have a project, that needs Native Russian speakers, we will give you the text, and you need to record 66 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without echo. 2. Each person is $3 dollar for 66 sentences record. If you are interested please let me know sure.I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :
I need an AI model that can assist with various decision-making processes. The model should be designed to provide a decision for any question posed...model should be designed to provide a decision for any question posed to it, regardless of the context. Key Requirements: - The model will primarily utilize user input data to make decisions. Therefore, it should have the capacity to process and learn from a wide range of inputs. - Given that the specific format of historical data hasn't been determined, the model should be flexible and adaptable to different data formats as needed. Ideal Skills and Experience: - Proficiency in AI and machine learning - Experience in building user-interactive AI models - Ability to create adaptable AI systems - Knowledge o...
I need a cartoonist to create an 800 px x 800 px panel depicting a classroom at "Truth Matters University", where a course titled "Celebrating Israel: Pioneering Innovations and Jewish Contributions to Global Progress" is being taught. The specific class is focused on Jonas Salk and his unpatented legacy of the polio vaccine. The panel's goal is...the mood should be inspirational. After this initial panel, I am looking to hire the same artist for creating between 100 to 500 additional panels for the series. Ideal Skills and Experience: - Cartooning and illustration - Understanding of the 'cartoony' art style - Ability to convey an inspirational tone through artwork - Experience with educational content - Interest in global health and historical c...
...deep learning stock program. The ideal candidate will have relevant experience in stock program development and deep learning. Key Requirements: - Proven track record in AI and deep learning applications, particularly in stock market - Excellent programming skills - Ability to integrate various data sources Ideal Skills: - Proficiency in Python with TensorFlow, R with Keras, or C++ with PyTorch - Strong understanding of stock market dynamics - Experience with real-time market data, historical stock data, and news and social media feeds Please note, only developers with relevant experience in AI deep learning stock program development are allowed to participate. Explaining how to create an **AI-based stock prediction program** to a developer who is a begin...
Pull all data of each publisher as we discussed + create an excel file as you did in the previous job. Delivery in on january 20th
I'm looking to build a no-code web platform that connects influencers from both YouTube and Instagram with brands. The platform should have features tailored for both user types, with a particular focus on usability and seamless interaction. Influencer Features: - Self-listing capability - Comprehensive dashboard for tracking follower growth and engagement rates - Content calendar for managing posts ( In a form of a calendar, where they will able to keep links of reference videos & script, notes & Final Video with a summary of the a content with scheduled time) Brand Features: - Campaign creation and influencer proposal sending - Automated billing and contract signing upon influencer acceptance - Review system for submitted campaign content - ROI calculation provided...
I'm in need of a Virtual Assistant to help with remote admin tasks. This role primarily involves data entry of customer information and some spreadsheet work. The ideal candidate must have an intermediate understanding of Microsoft Excel, as tasks will include the use of pivot tables and advanced functions. Additionally, the assistant will be tasked with managing my email. Key Responsibilities: - Data entry of customer information - Email management - Spreadsheet work, including the use of pivot tables and advanced functions in Excel Ideal Candidate: - Familiar with MS Excel and Outlook - Capable of handling basic to intermediate data entry tasks - Able to manage emails efficiently Please provide your hourly rate, inclusive of all fees. Th...
I am seeking a Mail Merge expert to assist with document creation from Excel or CSV files. The project involves: - Utilizing a non-specific mail merge platform to execute the task efficiently. - Creating a variety of documents using Mail Merge. - Working primarily with data sourced from Excel or CSV files. Ideal candidates should have extensive experience with Mail Merge, particularly with non-Microsoft or non-Google platforms. Proficiency in handling Excel and CSV files is essential.
I have multiple CSV files containing data downloaded from an SAP tool. The primary focus is on extracting specific sales data from these files. Ultimately, I need someone to create a chart or dashboard based on this data, comparing sales across different regions. Key Requirements: - Extract specific sales data from multiple CSV files - Create a chart or dashboard comparing regional sales - Use either Power BI or Excel for the analysis and visualization Ideal Skills: - Proficient in data extraction from CSV files - Experienced in using Power BI or Excel for data visualization - Able to create insightful and easy-to-understand charts or dashboards. Please note, the purpose of this project is to visualize regional sales comparisons...
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
I have a PDF file containing financial data that needs to be converted into an Excel spreadsheet. The data is structured in tables within the document. Ideal Skills: - Proficiency in Excel - Data conversion from PDF - Attention to detail Experience: - Prior projects involving financial data preferred - Experience with PDF to Excel conversion
I'm seeking an Excel expert to enhance a self-grading Excel sheet for beginner students. The goal is to make it more visually appealing and user-friendly based on an example file I have. Key Requirements: - Quick turnaround time (within 2 hours) - Experience in Excel - Ability to implement visual improvements such as color coding, formatting, and graphical elements - Potential for future projects if work is satisfactory The primary function of the Excel sheet will be visual data representation. Please apply if you can meet the requirements and deliver promptly.
I'm seeking a skilled graphic designer to create an image for a LinkedIn post. The image needs to display our new product brochure so customers click on the link to download the product. Needs to reflect the Company Colours Key aspects of the project include: - Understanding of LinkedIn's audience and content style - Ability to create informative and educational visuals - Experience designing for social media - Graphic design skills with a professional and corporate focus. Freelancers with experience in creating social media content for LinkedIn, especially within an informative and educational context, are particularly encouraged to bid.
I'm in need of a freelancer who can extract text from a PDF into an Excel Spreadsheet. The job requires basic cleaning and formatting of the data in the spreadsheet. Key Tasks: - Text extraction from PDF - Inputting data into Excel - Basic cleaning and formatting of the data Ideal Skills: - Proficient in Excel - Attention to detail - Previous experience with data extraction from PDF Looking forward to your bids.
Hi there, I need someone to manually copy and paste text and numbers from tables in a 90-page PDF document into an Excel template with five predefined columns. Key Requirements: - Combine split sentences into a single line. - Leave a blank line between paragraphs. - Adhere to specific formatting requirements as per the predefined template. Ideal Skills: - Excellent attention to detail. - Proficient in Excel. - Able to follow specific instructions meticulously. Flat rate 5 NZD Bonus: 5 NZD bonus for error-free, on-time delivery. Deadline - one day i.e. 15 Jan 25 Please start your bid "5NZD" I appreciate you reading my post
I'm in need of a professional data scraper to extract contact information from 1400 profiles on a particular website and import it into an Excel CSV file. Key Requirements: - Scraping of 7 specific fields of contact information from each profile, including: - First name - Last name - Email address - Phone numbers - Social media links - Opponent - Win or loss/method Ideal Skills: - Proficient in web scraping tools and techniques. - Excellent attention to detail to ensure data accuracy. - Experience with data processing and Excel. Please bid if you have prior experience in this type of project.
Job Title: Power BI Freelancer Needed for Data Visualization and Reporting Job Description: We are looking for a skilled Power BI freelancer to assist with creating interactive dashboards, reports, and data visualizations. The ideal candidate will have a strong understanding of Power BI, data modeling, and business intelligence tools, with the ability to turn complex data into clear insights. Key Responsibilities: Design and develop Power BI dashboards and reports. Connect to various data sources (SQL, Excel, cloud databases, etc.) and transform data for reporting purposes. Implement DAX queries and functions for calculated measures and columns. Ensure data accuracy and troubleshoot issues within the data model. Optimize dash...
I am looking for a way to automatically export and sort timesheet data from Microsoft Teams/Shifts. The timesheet needs to be exported weekly based on our pay period (Friday - Thursday). A new Excel document should be created for each supervisor or team leader, and each staff member should have their own sheet within their teams relevant Excel document. All data in the supervisor documents should be easily readable. If automatic exporting is not possible, the minimum requirement is for someone to manually export the timesheet and copy it into a location where it can be automatically processed, with no additional input required from the staff member exporting the timesheets. The data that needs to be extracted from the timesheet export includes: Date ...
...developer to help me retrieve historical data for 10 cryptocurrencies using the LunarCrush API and export this information into Google Sheets. The data should be structured and organized for easy analysis. Key requirements: - Fetch all data endpoints available for 10 selected cryptocurrencies. - Ensure the data is presented in a systematic manner for future analysis in Google Sheets. - The date range should cover all available data since the launch of each cryptocurrency. Ideal skills and experience: - Proficient in using APIs, particularly the LunarCrush API. - Experience with REST, Python, Google Sheets Integration, API Rate Limit Management and GraphQL (optional) - Experienced in working with Google Sheets and structuring data. - Pri...
Im seeking a developer who has expertise in Oracle Fusion. My company is migrating from an Oracle Fusion instance to another ERP. We need a developer to write a SOAP query that captures all of the AP invoices in Fusion with Invoice # and Doc ID. There are approximately 38,000 files. We need a bulk export to PDF so that we can reference for historical purposes. Our partner has said that there is no easy way to export all of these attachments and associations from the Fusion front end.
...expert in data research who can help me investigate customer data. The primary focus will be on gathering staff contact information for 250 companies. I want the entire staff contact list with email and phone. This is the list of the 250 companies with their website links. Example of the staff list for first company CRMLS The ideal freelancer for this project should have: - Proven experience in market research, particularly customer data. - Strong analytical skills to interpret complex data sets. - Proficiency in Excel to organize and present the data. The final deliverable should be in the form of detailed Excel spreadsheets that clearly present the researched customer data. Provide
I need a visual dashboard created from my Excel financial data. This dashboard will primarily be used by executives, so it needs to clearly display cash flow and ROI information. Key Requirements: - Proficient in Excel and dashboard creation - Ability to visualize complex data simply and effectively - Prior experience working with financial data Ideal Skills: - Data analysis - Financial literacy - Excel expert - Dashboard design
We are looking for a profes...looking for a professional who can assist with the maintenance of our Terra platform including integration of both real-time and historical data through the Terra APIs. This project primarily focuses on data integration from various sources including databases, APIs, and wearables. Key Requirements: - Experience with data integration and APIs - Familiarity with handling both real-time and historical data - Proficiency in working with databases and wearables - Excellent problem-solving skills and attention to detail Ideal Skills and Experience: - Previous projects involving Terra APIs or similar - Strong programming background - Expertise in data analytics and visualization - Ability to work under tight deadl...
I'm seeking a skilled professional to perform a detailed takeoff from my bluepr...comprehensive material list of quantities and costs breakdown for all trades, including electrical, plumbing, and carpentry. The final output should be an Excel spreadsheet, as I prefer this format for data analysis and budgeting. Key Requirements: - Proficient in reading and interpreting blueprints - Experience with construction material takeoffs - Familiarity with costs associated with various trades - Excel spreadsheet creation and data organization skills I do not have a specific template for you to follow, so creativity and an understanding of how to best structure the data will be key to your success in this project. Please ensure the Excel document is c...
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
I'm looking for a skilled Excel professional to help automate my spreadsheet, which I've been manually updating with annual measurement data (3D coordinates). The spreadsheet involves regression analysis and generating charts. Key tasks that need automation: - Updating formulas: Currently, I have to re-input the formula to accommodate the new data each year. - Data input: I want it to be as simple as entering the new data and the spreadsheet updates itself. - Chart generation: The spreadsheet produces various charts from the data, which currently requires manual intervention. - Running regression analysis: The spreadsheet includes regression analysis which needs to be automated as well. Ideal skills for this project include: - Proficien...
We have a platform in PHP and MySQL to manage the services we provide but we have never used it. Currently we manage everything with Excel but there are already many records and various people who work on the file. I need to load our excel database into the MySQL database and start using the tool. The excel database has 20.440 rows and 43 columns.
I'm seeking an expert in financial modeling with Excel to help construct a comprehensive analysis model for a retail center development project. This project will involve a construction loan, refinancing, and utilizing land equity from the landowner. Key Requirements: - Develop cash flow projections on a monthly basis. - Include critical financial components such as the Profit and Loss statement and Loan amortization schedule. - Conduct sensitivity analyses for interest rate changes, construction cost variations, and market rental rate fluctuations. Ideal Skills: - Proficiency in Excel, with advanced financial modeling skills. - Experience in retail development project analysis. - Ability to conduct and interpret sensitivity analyses.
...Ayurvedic significance of the Vijaya plant (cannabis) and its role in the Indian medicinal system, while incorporating worldwide news, breakthroughs, and developments in the medicinal cannabis industry. The content will be designed to inform, educate, and build credibility for Cannacraft as a leader in Ayurvedic medicinal cannabis. Blog Categories: 1. Ayurvedic Significance of Vijaya Plant: • The historical and cultural importance of Vijaya in Ayurveda. • Ancient Ayurvedic formulations involving Vijaya and their uses. • Therapeutic benefits of Vijaya for conditions like pain, inflammation, insomnia, and anxiety. • The role of Vijaya in Panchakarma and other Ayurvedic treatments. • Ethical and legal considerations under Ayurveda for medicinal cannab...
I have an Excel sheet containing financial data including income and expense ledgers, as well as indicators of the company's growth. I need someone to transform this data into detailed management accounts. The project requires the creation of clear and insightful charts, as well as the data being presented in an easy-to-read format. Key Requirements: - Bar charts, Pie charts, and Line charts to be created from the data - Focus of the charts on income and expenses - Data presented in a Quarterly comparison format. - profit growth Ideal Skills: - Proficiency in Excel - Experience in financial analysis and creating management accounts - Ability to create clear and insightful charts and graphs - Skills in presenting data in an eas...
I'm seeking a skilled Excel developer to enhance my "Employee Attendance Record" template. The purpose of this project is to add specific tracking capabilities to the template. Key Modifications: - Change Calendar View closed dates from Sat,Sun to Sat,Wed. - Add HRs row to List of Employee TAB and display hrs on Calendar View - Track lateness by add to List of Employee TAB, display on Calendar View Ideal Skills: - Proficiency in Excel - Experience with customizing Excel templates - Ability to implement specific tracking features I need someone who's detail-oriented and understands how to improve an Excel template for specific HR tracking needs. Please, provide examples of similar work you've done.
I'm seeking a freelancer to enhance the functionality and design of my e-commerce website, focusing on improving the product page layout, user experience, and dynamic functionality. Specific tasks: Expanding the product description layout to span the full page width. Adding a "Download" section for file downloads beneath the description. Implementing dynamic product variation options with updated images and details. Centering the main product image and adding a scrollable image gallery. Translating key terms into German (e.g., Quantity → Menge, Description → Beschreibung). Reinstating sorting options with German labels. Ensuring consistent product size and price alignment across the site. Redesigning the product description format for a polished, visually ...
...of website. Page Relationship Review - Analyze the connection between the private group and its owning business page (1,500 followers, inactive since 2021). - Advise on whether to revive, replace, or phase out the business page. - Clarify the role of a business page in monetizing the private group. Membership Insights & Analytics - Analyze member stats (active vs. inactive percentages) and historical join request trends (currently 2,200 requests/month). - Identify the most engaged posts from the past 12 months and suggest how to repurpose this content (e.g., newsletters, tips). - Provide recommendations on third-party tools for better insights (e.g., analytics beyond what Facebook provides). Re-Engagement Strategy - Develop strategies to re-engage inactive members (e.g., ...
I need a professional with experience in data conversion to help me transform a mixed content PDF form document into an Excel file. The document contains both text and tables, but the text formatting is simple, consisting of plain text without any complex elements. Key Requirements: - Converting mixed content (text and tables) from PDF to Excel - Maintaining specific formatting from the PDF in the Excel file Ideal Skills: - Proficiency in Excel - Experience with data conversion from PDF to Excel - Attention to detail to ensure accurate formatting
Hello, I currently have a JavaScript scr...Issues: • The script is too slow because of the delays added between requests. • If I reduce or remove the delays, Allegro’s security mechanisms detect and block the script. • I’ve tried switching to Python, but Selenium and similar libraries face issues with Allegro’s automated access restrictions. What I Need: 1. A solution to bypass Allegro’s security mechanisms and scrape data faster. 2. A way to efficiently download HTML files in the desired structure without being blocked. 3. Preferably, transition to a Python-based solution for better performance and flexibility. If you are confident you can help me optimize or rewrite the script to meet these requirements, please let me know. Wr...
I'm on a journey to become a certified Microsoft Office Specialist in Excel at the Associate level and I need your expertise. Ideal skills: - Proficient in Microsoft Excel - Familiar with GMetrix testing platform - Experience in teaching or coaching - Ability to create a tailored study plan - Knowledge of Microsoft Office Specialist certification process What I need: Someone to do it all for me Your role will be to get me certified and ensure I pass the tests with flying colors.
I'm looking for a data analyst who can dive deep into my transactional data in Excel to understand gender-wise market trends. The primary focus will be on: - Gender-based purchasing patterns - Product preference differences between genders - Profitability analysis based on gender demographics Your expertise in data analysis and familiarity with Excel will be crucial for the success of this project. Please be ready to provide insights that can help shape our marketing strategies and product development.
I need an Odoo expert to customize my Odoo system. The project involves calculating prices based on length and width using an external Excel sheet. Specific requirements include: - Importing data from an Excel sheet into Odoo. This sheet contains length and width values that will be used to calculate prices. - The customization is a one-off task; there's no need for ongoing updates or changes to the data. - The freelancer should have extensive experience with Odoo and be able to ensure that the system accurately calculates prices based on the provided dimensions. Ideal skills for the job: - Odoo customization - Excel data manipulation - Price calculation algorithms I look forward to your proposals.
i have a website that i want to download all content files from it (pdf's). ** step 1/ scrap all links (1.4 millions), 15 links of pdfs files in same page then "see more" to show more 15 more links pdf pages, till complete. ** step 2/ open links one by one (simultaneously for rapidity), wait 10 sec for every page... click download button (with the help of chrome extension). ***: My budget for this simple task 20 no more, looking for long term partnership python related project :)
I'm seeking a USA-based virtual assistant to support me with order processing for my Amazon project. Tasks include: - Order Entry: You'll be responsible for accurately entering orders into the system. Skills and experience required: - Must be a resident of the USA - Proficient in Excel/Google Sheets - Previous experience with Amazon order processing is a plus - Attention to detail and ability to work independently
I'm looking for an expert in data analysis to help me identify trends within my transactional data sourced from our CRM system. The main focus will be on understanding patterns, customer behaviors, and overall business trends. Ideal Skills: - Proficient in data analysis tools (e.g., Python, R, Excel) - Experienced in working with CRM data - Strong understanding of transactional data - Excellent at identifying trends and patterns Please provide examples of previous similar projects you have completed.
I'm in need of a comprehensive list of NGOs, primarily located in Europe, USA, and Australia, that frequently require translation and interpretation services. Key Requirements:...include contact details of these NGOs. - The focus is on NGOs that need services in French, German, Russian, Spanish, Chinese, English as these are the languages of interest for this project. Ideal Skills and Experience: - Prior experience in research, especially in identifying NGOs, is highly desirable. - Understanding of the translation and interpretation industry. - Proficiency in data gathering and Excel. - Excellent attention to detail to ensure the accuracy of contact details. This project is a great opportunity for freelancers who have the right experience and skills to deliver a tar...