Excel vba code download historical data yahoopráce

...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...

K zobrazení podrobností se zaregistrujte nebo přihlaste.

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...

I need an Excel spreadsheet specifically designed for data entry and storage of inventory lists. The file should be user-friendly with clearly defined sections for different aspects of inventory management. It's for a property company, simple schedule of type-rents etc. Based near Chelsea.

I need assistance with an Excel formula that's getting an error. I'm trying to get a cell to populate with the next date, but I need it to ignore certain instances. I am unsure which specific lookup function I am using. - Ideal Skills: Proficient in Excel, experienced in complex formula creation and troubleshooting. - Experience: Prior experience with date manipulation in Excel is preferred.

...to assist with data entry and creating a customized Excel worksheet. The project involves: - Total no. 600 restaurants. The online ordering Menu of these restaurants is to be copied into an Excel CSV sheet, from the website ( provided after the award ) and then arranged in a predefined header format which will be as attached. Images of the dishes where available are to be saved in jpeg format for each restaurant in a folder The Excel CSV menu sheet and downloaded image folder shall comprise a single separate folder named for the restaurant Creating Excel worksheets with predefined headers for a system database - Storing mixed data types in the worksheet - Utilizing a provided list of specific headers and column names Ideal candidat...

I'm looking for a creative graphic designer to design a new logo for our Christian school, Northside Christian Warriors. The current logo is outdated and needs a modern touch. - Warrior Style: The logo should feature a fantasy warrior. This could be inspired by mythical or imaginative combatants, rather than historical knights or contemporary soldiers. The aim is to create a unique and eye-catching representation of a warrior. - Logo Elements: The logo should include a shield, sword, and helmet. These elements should be integrated in a way that is visually pleasing and represents the spirit of our school - strength, courage, and faith. - Color Scheme: The primary colors of the logo should be Blue and Gold. These colors are not only the school colors but also represent trust, l...

I'm seeking an Excel specialist to analyze my survey results and create a PowerPoint presentation from the findings. Requirements: - Expert-level Excel skills, particularly with pivot charts - Proficient in PowerPoint - Able to analyze survey data comparing year-to-year numbers to illustrate growth by different categories - Able to conduct a demographic breakdown based on location and occupation

I need an experienced JavaScript developer to create for me funny js code in 1 h maximum the code should be hard to read from non developer , with no alert or console log or comments the result should be Glory()= great so the funny thing in the code is about finding the value of great and when dev start reading the code should not expect that the value will be great Glory is company name which combine mutiple teams and teams will collaborate with each other to reach that value this info help you to express that in the code can you share example of your code related and can do that Please no use AI for that the code should be a abit long to make reader not understand it quickly or expect the result please do it in funny and creativ...

K zobrazení podrobností se zaregistrujte nebo přihlaste.

I need a QuickSight dashboard that connects to both databases and CSV/Excel files. The dashboard should be able to display data using tables, pivots and filters. Ideal skills for this project include: - Proficiency with Amazon QuickSight - Experience with database and CSV/Excel file integration - Ability to create and manipulate tables, pivots, and filters - Strong understanding of data visualization techniques

I have a master Excel spreadsheet filled with various product-related information. I'm looking to create ten additional tabs that all pull filtered data from the master sheet, organized by product categories. Key Requirements: - Experience in Excel is a must. - Ability to create interconnected tabs that update in real-time with the master sheet. - Strong communication skills for regular updates and clarifications. Please note, the data on the additional tabs will be filtered by category. It's important that you understand product categorization and can effectively segregate the data. Your attention to detail and ability to manage complex data sets will be key to the success of this project.

I need help finding high-quality, freely available downloadable dataset/links on consumer behavio...ready-to-eat or cooked food. Also, I need assistance in creating related questions on which the dataset is based. The datasets/questions should be in Excel format. Key Aspects of Consumer Behaviour to Explore: - Purchase frequency - Brand preference - Consumption patterns - Additional parameters for in-depth analysis Other Considerations: - Demographic information - Spending habits - Product satisfaction - Sustainability considerations - Customer satisfaction The freelancer will also be required to assist in formulating relevant questions based on the dataset. Ideal skills for this project include: - Data analysis - Market research - Excel proficiency - Understandi...

I'm seeking a professional to enhance the functionality of my Excel sheet. The main focus will be on refining formulas and functions to improve automation and integrating macros for more efficient operation. - Key Areas of Improvement: - Optimizing existing formulas and functions - Implementing automation techniques - Designing and integrating macros Ideal candidates should have extensive experience with Excel, particularly in the area of automation and macro creation. Please provide examples of previous work that demonstrate your ability to improve Excel sheets.

...specific URL, verify it, fetch the corresponding file from Envato, and generate a direct download link for the user. Key Components: - Envato API Integration: Establish a seamless and efficient connection with the Envato API to validate user-provided URLs and retrieve associated files. - User Panel: Design a clean, intuitive interface for users to input URLs and view validated download links post-processing. - Admin Panel: Implement a control center for managing user requests, and configuring API keys, limits, and other system parameters. - File Download: Ensure the system facilitates direct downloads of files sourced from Envato URLs. - Security: Prioritize the security of API connections and download processes. This includes implementing authentication c...

I need assistance with my financial Excel file. The project involves: - Data Entry and Organization: Help me organize my existing data in a more coherent and usable manner. - Formulas and Calculations: Apply relevant formulas and perform necessary calculations to derive insights from the data. - Creating Charts and Graphs: Visualize the data using various charts and graphs to highlight key trends and patterns. The existing data is all in Excel format and I need this data to be incorporated into the analysis and visualization. Ideal Skills: - Proficiency in Excel, including advanced functions and formulas. - Experience in financial data analysis. - Skills in data visualization and creating charts and graphs in...

...suppliers do NOT provide complete data or images. Being able to effectively get the information online efficiently is needed - Proven experience as a Product Manager in the retail industry is a must. - Strong understanding of the B2B market and how to effectively meet its needs. - Deep knowledge of Magento 2 as you will have to create configurable products. - Your job will be to determine attributes / categories for products using information available online (you will have to research the brand of products you are importing) - A deep knowledge of how Magento Manages Attributes is essential - Some suppliers use standardized data (PIES, ACES, Digital Asset) - some other suppliers do NOT use standardized data. It is important to be able to use Standardized data...

I'm seeking an Excel expert to assist with my spreadsheet. I need help with creating and modifying formulas, writing VBA scripts, and troubleshooting existing issues. The spreadsheet has some minor discrepancies that need to be corrected to enhance data accuracy and improve the user interface. Ideal Skills: - Advanced Excel skills - Proficiency in writing and modifying VBA scripts - Strong troubleshooting skills - Experience with data accuracy improvements - User interface design skills in Excel The goal is to tighten up the spreadsheet, improve its performance and make it more user-friendly.

I need assistance extracting data from 100-150 scientific articles. The data to be extracted includes statistical data and references/citations. The extracted statistical data needs to be delivered in an Excel spreadsheet. Additionally, I need data from tables within the articles to be included. Ideal skills for this project include: - Experience with data extraction - Familiarity with scientific literature - Proficiency in Excel The successful freelancer will be detail-oriented and able to work independently.

I'm in need of comprehensive data from Google Scholar for a personal project. The specific data points required include: - Article metadata: This will help me understand the context and relevance of the articles. - Citation counts: This will provide insights on the impact and reach of the articles. - Author profiles: This will assist in identifying key contributors in the field. The data should be delivered in Excel format. Ideal skills for this task include: - Proficiency in data extraction and web scraping - Familiarity with Google Scholar - Expertise in data organization in Excel. Experience in handling academic data and conducting market analysis would also be advantageous. Please ensure you can deliver the data ...

I'm looking for a straightforward Python script that can scrape text posts from Facebook groups I'm a member of. The primary purpose for this is data analysis, and I would like the scraped data to be delivered in a CSV file. Key requirements: - Proficient in Python, with experience in web scraping - Familiarity with Facebook's structure and privacy considerations - Ability to code a solution that filters for text posts only - Can provide the data in a well-structured CSV format This project is ideal for someone who can deliver a reliable and efficient scraping tool, and understands the importance of ethical scraping practices. Please include examples of similar projects you've completed in your bid.

PS : BIDS WITH NO EXAMPLE OF THEIR WORK WILL BE REJECTED I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initia...

I'm looking for an Excel expert to create a comprehensive and dynamic dashboard from my dataset. Key Requirements: - You will be working with 518 rows of data across 36 columns. - A summary sheet needs to be created per my specifications, which will be provided in the attachment. - Each cell in the summary needs to be hyperlinked to the corresponding data point. - The dashboard should be dynamic to accommodate potential future data additions. - All Excel formulas must be shared with me. Communication: - I expect all queries to be answered within 30 minutes of me asking. Preferences: - The summary sheet should feature both visual (bar charts) and tabular representations of the data. - The dashboard should include interactive filters, drill-...

I need a Python developer to integrate a Telegram bot with Python code that will execute predefined terminal commands. The system should take messages which are broadcasted to the bot and execute the corresponding command. Key Requirements: - Python programming skills - Experience with Telegram bot development - Familiarity with terminal commands - Knowledge of MySQL for querying The primary goal of this project is to automate the execution of specific tasks via the Telegram bot. The user will interact with the system by sending MySQL queries, which the bot will interpret and respond to. The ideal freelancer for this project should be able to help me with the following: - Executing predefined commands - Using MySQL queries to trigger these commands - Ensuring the system can take m...

I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Differ...

I require an Excel expert to create macros and VBA scripts to transform my imported Excel data into a specific format. The necessary modifications span across data formatting, calculations, and filtering. You will need to adjust: - Headers - Columns - Rows The data will be imported from another system, so I need a professional who is skilled in data manipulation and can ensure the output is consistently formatted according to my requirements. The format of excel before editing & after editing are attached for your final product should come with a button "Format" which can convert my excels to my required format. NOTE: I need to see your previous works in Excel macros & VBA before awarding this wor...

I'm looking for a freelancer who can scrape a public website for contact details. The information I need includes email addresses, phone numbers, and names. This is a one-time project. ...a public website for contact details. The information I need includes email addresses, phone numbers, and names. This is a one-time project. Ideal Skills and Experience: - Proficient in web scraping techniques and tools - Prior experience in data extraction - Attention to detail to ensure data accuracy - Understanding of privacy laws and ethical standards in data collection This is the website: We need the following information: - Name - Adress - E-Mail - Phone number You find an example in the attached Excel file. Please add all other contacts in the same manner.

...descriptions, promotional materials, and offers from the Lemonsqueezy affiliate network. Download or collect promotional resources from the Lemonsqueezy affiliate backend: Step 2: Tool Verification Visit each provided tool link. Verify if the link corresponds to an online tool or service: If it is a valid online tool or service, proceed to the next step. If it is not, record the reason in an Excel sheet (e.g., "invalid link," "non-tool," etc.) and skip it. Step 3: Organize Tool Content Prepare and organize the following information for each tool: Classification: Choose the appropriate category based on the tool’s primary function. Website Icon: Download or screenshot the tool’s logo from its website. Website Screenshot: Ta...

...Invoice management and payment history. Customer Support Module • - Integrated ticketing system for issue resolution. • - Live chat and chatbot support. • - Knowledge base with FAQs and guides. Quality Assurance Module • - Third-party quality checks at milestones. • - Compliance certification for building codes. • - Post-construction maintenance support options. User Journey Flow For Homeowners • - Download and install the app. • - Sign up and create a profile. • - Select 'New Project' and fill out project details (type, size, budget). • - View cost estimation and approve the project. • - Select materials and services from the marketplace. • - Track progress, milestones, and payments. • - Communicate with ...