Magento batch import extension jobs
Needing a specialist in Google Chrome extensions for a small project. Your task will involve: - Working with a pre-existing Google Chrome extension - Making the extension be compatible when right-clicking all types of elements (particularly iframes) The ideal candidate must have significant experience in Google Chrome extensions I look forward to seeing your bid and potentially working with you on this exciting assignment.
I'm looking to upgrade security on my website, , specifically focusing on the Login page, Registration form, and Contact form. I require an experienced coder who understands the nuances of online security, and has previously...who understands the nuances of online security, and has previously implemented recaptcha measures. Key tasks: - Implement recaptcha on the stated webpages - Ensure the recaptcha protection works seamlessly across different web browsers and mobile devices Ideal skills and experience include: - Previous experience with recaptcha implementation - Expertise in coding, particularly in WordPress, Magento, and Drupal - Strong understanding of online security measures Note: I already have a recaptcha account that will be used for the implementation.
I need an experienced developer to work on some key enhancements to our website platform. Your main tasks will include: - Incorporating a third-party API: This task will involve integrating a shipping provider API into the website. This is essential to expand on our existing pricing and process features. - We also have some extension to the sites functionality we would like to add in which include a character counter. Site is built in Laravel with a Vue front end. The codebase is already in operation and we can provide the code base to the winning bid. No time waiters please, upon satisfiable completion there maybe additional work on similar sites. In your bid please add in the comment "I understand the requirements and can work with SCS" this will help we in knowing th...
...Technology**: Proficiency in RF design and signal amplification is crucial. - **Knowledge of Car Electronics**: Familiarity with the electronic systems of automobiles, particularly those related to keyless entry, remote start, and alarm. - **Security Savvy**: An understanding of encryption and security measures to protect against unauthorized signal interception. ### Project Goals: - **Signal Range Extension**: Significantly enhance the range over which the car's keyless entry, remote start, and alarm system can be operated. ### Ideal Candidate: - Has experience with RF communication systems and vehicle electronics. - Demonstrates a clear understanding of automotive security challenges and solutions. - Is innovative in approach, with a track record of problem-solving in el...
...and efficiently moving contacts from Wix to Constant Contact. This project is crucial for the seamless operation of my website and email communication, and I’m prioritizing all tasks equally. Key Responsibilities: - Set up CNAME authentication for Constant Contact to ensure reliable email delivery. - Configure my domain to meet Google Workspace MX requirements for professional email services. - Import existing contacts from Wix to Constant Contact, ensuring no contact is left behind. - Redirect DNS from the current Wix site to my new Hostinger account, guaranteeing a smooth transition with minimal downtime. Ideal Skills and Experience: - Proven experience with DNS management and domain transfers, particularly between Wix and Hostinger. - Familiarity with email marketing t...
We are seeking an experienced MySQL database specialist with expertise in database recovery and repair to address a critical issue with our MySQL Server 8.0 on a Windows environment. Problem description is here: The primary goal of this project is to recover and restore the MySQL database to full functionality without data loss. Required Expertise: - Deep understanding of MySQL, specifically InnoDB engine internals. - Proven experience in database recovery, especially in environments with large numbers of tables and complex TABLESPACE configurations.
I'm looking for an expert to build an WooCommerce extension that allow me automate the process on keeping products up to date based on com files provided by suppliers. requirements: 1. two providers that each one has a different file strucutre, we need to connect to sftp account and download the latest available file and process it. 2. new products should be imported and other updated. some products will be discontinued and those needs to disable on the website too. 3. configuration page where I can store some configurations like how often it runs (like a crontab or if any other conversion of woocommerce) 4. it needs to also map the categories when importing new products. this can be hardcoded. More details: Which platform are you planning to use for your website? WordPres...
As a B2B Lead Manager: you are the key to successfully generating qualified leads. Your job is to identify potential customers and effectively guide those leads through the sales process. Here are the key points of your role: Lead generation: Proactively find and approach potential customers in our target industries. (YOU HAVE TO SEARCH FOR LEADS) Develop sales strategy: Design effective strategies to convert leads into sales and increase our presence in the market. (Either you provide Seqeunces, or I can do, herder I use normally Chatgpt) Business development: Optimize our business processes and identify new growth opportunities. (The more Leads the better) Use email marketing: Since you already have email sending software installed, you can use it for targeted email campaigns. (We...
...professional, proficient in WP All Import Pro. My real estate website is currently plagued with content deletion issues related to property listings. These listings are managed through CSV/XML import and need careful handling to manage this issue. Here's what I need you to resolve: • Examine and repair/fix the recurring content deletion issue with property listings • Ensure seamless property search, listing, and contact forms function Ideal skills and experiences for the job would include: • Extensive knowledge of WordPress • Specific experience with WP All Import Pro • Understanding of CSV/XML files • Prior work on real estate websites Your expertise should ultimately lead to a smooth, efficient real estate website that I ca...
I have a very basic Figma file that illustrates my need and will share it with candidates who can show skills in this area. Needs to be in portrait mode, and should be able to import into Android Studio to support minimum SdkVersion 19, and target SdkVersion 27. no need for menu bar functions. 1, Figma Design 2, Provide all artwork, Figma, exported android layout xml layout files 3, Basic nonfunctioning Android app to demonstrate the above with the given android specifications
...attention to detail Previous experience as a personal assistant or in a similar administrative role Knowledge of U.S. business practices and legal procedures is a plus Duration: This is a part-time position with an initial contract duration of 6 months. The role will continue until Elderman Law establishes a physical office and presence in the United States of America, with the possibility of extension based on the company's evolving needs and the assistant's performance. Pay: Competitive salary commensurate with experience. The compensation structure will be discussed during the interview. The payment frequency will be a bi-weekly fixed salary. This is a remote position, allowing for flexibility and collaboration across different time zones. Applicants based in th...
...team or individual with the right mix of experience and creativity. Here's what I envision: **E-Commerce Website Development:** - Create a visually appealing, user-friendly e-commerce website. - The website should be optimized for performance and mobile devices. - It must include features such as product galleries, checkout systems, and customer reviews. - Experience with platforms like Shopify, Magento, or WooCommerce is preferable. **Social Media Integration:** - Integrate the website with Facebook, Instagram, and Twitter. - Utilize these platforms for product promotions, customer engagement, and support. - Implement features like social login, share and like directly from the website. **Ideal Skills and Experience:** - Proven track record in developing successful e-com...
I need the creation of a 6.4.3+ wordpress plugin that...ANDROID PHONE or IPHONE PHONE, should open and he should be able to take a photo or record a video. He should be able to see the captured photo or video before submitting the form and if he wants, he should be able to delete it and replace it. The submitted photos, should be uploaded and saved in the server without changing quality/size, using file format: {formid}-{entryid}-webcam{number}.extension . Please put them in a directory with no public access. Admin should also, be able to include a link to the photo or video in the form notification emails. When admin sees the entries for a form, he should be able to see all taken photos/videos In your bid, please tell me what other wordpress plugins you have developed. Tha...
I need a professional with MS Access experience to improve a database that stores my employees' work information. The tasks should be completed within 2 days. Detailed requirements are clearly described on file. I'm kindly asking to check carefully all project files before asking informations and make a bid. Do not ask for a budget increase after your bid: your offer will be automatically excluded. These are the first requirements for future engagements on my projects. Deadline is not extendable.
Our Magento CE 2.2.1 version is outdated and we are getting carding attacks on our Braintree payment gateway. We do have Cloudflare but that doesn't seem to prevent them. Hosting suggested that we upgrade our Magento version but due to many extensions for which support is no longer provided and other reasons, that is not an option for us. The next thing they suggested is that we hire a developer that will patch the know vulnerabilities of our Magento version. So here we are. If you are a Magento expert you will know what patches need to be applied to our version to stop the carding attacks. More info on the attacks and the domain can be provided in a private message. There are more tasks and bug fixes we have that need to be fixed in our Magento...
...importing market provide historical import volume and value per ton from 2014 3. Present volume imported and value per ton imported (distinguish between FOB and CIF) from African sources 4. Present total volume imported (from any country) and value per ton imported (distinguish between FOB and CIF) from all sources 5. Present total market size for main markets including domestic production, 1. Breakdown biggest African source markets for these destination markets, with volume exported and value per ton exported (distinguish between FOB and CIF) Market Trends: 1. For each importing market provide historical import volume and value per ton from 2014 2.. Summarize importing markets into geographical groups and provide outline averaging historical import volumes and...
In a vibrant and dynamic world, I am looking for a talented freelancer to develop a state-of-the-art website for fashion to serve both men and women needs. Key Goals: - Must be a shopper-friendly marketplace. - Needs to be developed on an E-commerce platform such as Shopify, Magento etc. - Essential functionality: Must have a streamlined system for product listings to ensure ease of use for our potential sellers. Ideal Skills: - Proficient in using E-commerce platforms (Preferably Shopify, Magento) - Previous experience developing a marketplace website is a plus. - Taste and understanding of fashion industry trends could be beneficial. The end product should be a seamless platform that caters to the unique needs of our fashion-forward consumers. Adept and meticulou...
I'm looking to create an innovative E-commerce/Dropshipping platform, tailored to my unique specifications. Here's what I need: - Custom-built system, not based on Shopify, WooCommerce, or Magento (must !). - Proven experience with AliExpress integration is a must ! - Robust features for automated product imports. - Efficient order processing and fulfillment mechanisms. - Finalized and functional within a month's timeframe. Ideal Candidate Should Have: - Proven experience in custom e-commerce/dropshipping platforms and AliExpress Integration. - Skills in automation and database management. - A portfolio showcasing similar project completions. - Ability to work within tight deadlines. If you possess the expertise in building ground-up e-commerce systems and thrive o...
...be visually appealing and easy to navigate. A clean, user-friendly interface that highlights our products and simplifies the shopping process is essential. **Ideal Skills and Experience:** - Strong background in e-commerce website development, with a portfolio of past projects. - Proven expertise in HTML, CSS, JavaScript, and experience with e-commerce platforms like Shopify, WooCommerce, or Magento. - Knowledge of SEO best practices and the ability to optimize the site for search engines. - Experience integrating payment gateways and implementing secure transaction processes. - Ability to create a scalable website that can grow with our business needs. This website is crucial for our business's online presence and sales, so we're looking for a freelancer who can del...
...will provide an excel sheet with following data to enter Entry fields would be Full Name First Name Last Name Address City State State A- ‘A’ stands for abbreviation Zip Code Phone Number Email Address I Will also provide a list of multiple sites and webpages that I would like the data to be entered and submitted. I need this data to entered to all website web forms all at once as a batch if applicable. Skills and experience: - Experience in web form automation is required. Number of webpages: - The estimated number of webpages to be handled is between 250 and 1200. - Knowledge of web automation tools such as Microsoft Power Automate Desktop. - Attention to detail and ability to handle a large number of webpages efficiently. If you have the necessar...
I'm in need of a designer with the ability to create elegant and sophisticated branding materials for my hair extension business. This project aims to not only increase the visibility of our brand, but also to educate our customers about appropriate hair care, and to promote our current discounts and offers. Key Deliverables: • Hair extension labels • Hair care guide cards • Coupon designs The design style should be elegant and sophisticated. We want to communicate a sense of luxury and refinement, and this should be reflected in all components of the design. A key requirement is incorporation of black and gold color scheme. We believe these colors can effectively communicate the level of sophistication we're looking for. Ideal Skills and Exp...
...online/offline as & when maintainenece work is going on in the back end. I believe Magento does not have that option? but a Word press directory creation in Magento can facilitate that? Please advise: 1. Your expertise in that matter. 2. Time to do this job 3 Total Cost (NOT hourly rate) for this task. FINAL CONFIRMATION for task assignment. As discussed and confirmed. Task 1. Delivery 1 day. Creating a . file in the root directory "Magento allows us to enable maintenance mode by creating a . file in the root directory. However, this method doesn't offer a customizable user experience—it simply prevents access to the site." Task 2. Delivery 2-3 days. Is to create Magento extension that allows you to easily toggle maint...
...goals and ensure consistent messaging across all channels. - Utilize Magento experience and Google Merchant to manage product feeds, ensure accurate data, and optimize listings for maximum visibility and conversion. - Analyze campaign performance using Google Analytics and other tools, providing actionable insights and recommendations for improvement. - Stay up-to-date with industry trends, Google algorithm updates, and best practices to maintain our competitive edge. Qualifications: - Bachelor's degree in Marketing, Business, or related field. - Senior experience managing Google Shopping campaigns, preferably in the fashion or e-commerce sector. - Proficiency in Google Ads, Google Analytics, Google Merchant and Magento is a must. - Strong analytical skills, with the...
We are seeking highly qualified web developers to work with us in creating an impressive online store for our exclusive collection of silk products. We aim to build a powerful and scalable solution based on a modern platform, such as Magento or BigCommerce, with necessary customizations to achieve our unique vision. Key features we wish to implement include: - Klarna payment solution: We want to provide our customers with a seamless and secure payment experience by integrating Klarna as our preferred payment provider. - Responsive design: The online store should adapt to different browsers and devices, ensuring a seamless experience whether customers are using a computer, mobile phone, or tablet. - Advanced security: We prioritize high security to protect both customer information...
I require a skilled developer to ...ensure the AI handles sensitive information securely. Also, in addition to this, I will need to the AI to investigate bank documents, for any discretionary spending or expenses out of the norm, so that when the application process is progressing, questions can be raised by the credit assessor. Usually this is about 3-6 months worth of bank statements I would ideally like the software to have an import feature where the data will be imported into the program , to make it easier This project seeks a detail-oriented and innovative developer capable of creating a reliable and efficient AI system for document verification. Your contribution will significantly enhance our bank's loan application process, reducing manual errors and increasing pr...
...customization of sticker dimensions by the customer, offering choices between small (2"x2"), medium (3"x3"), and large (4"x4") or custom sizes. - The template must automatically populate with a static QR code, which we can generate, and include the name of the order or the order ID. - Ensure the feature is user-friendly, allowing shop employees to easily create and print the stickers as needed in full batch run for the orders in laravel for that day or single. **Ideal Skills and Experience:** - Proficient in Laravel and Shopify integration. - - Strong understanding of web development best practices, especially in creating customizable templates. - Excellent problem-solving skills to ensure seamless functionality across all devices. - A portfolio sho...
I'm in need of a skilled developer who can craft a batch script tailored for a Windows environment. This script's primary function will be to convert Adobe Illustrator (AI) files into GIFs, ensuring a harmonious balance between quality and file size. **Core Requirements:** - **Convert AI to GIF:** The script must efficiently batch convert AI files into GIFs without manual intervention. - **Quality Balance:** Optimize the output for a middle ground between high quality and reasonable file size. **Ideal Skills and Experience:** - Proficiency in scripting on the Windows platform. - Prior experience with image conversion projects, especially involving AI and GIF formats. - Strong understanding of image optimization techniques to balance quality and file size. - Fami...
I need a maritime lawyer adept in handling demurrage charges, particularly for imported goods. I'm dealing with unjust demurrage charges that occurred due to various factors on a UK registered car which I brought back from abroad. Although I don't need assistance in car registration, I am seeking legal a...maritime lawyer adept in handling demurrage charges, particularly for imported goods. I'm dealing with unjust demurrage charges that occurred due to various factors on a UK registered car which I brought back from abroad. Although I don't need assistance in car registration, I am seeking legal advice and aid in resolving issues related to these charges. An understanding of the legalities around car import regulations would be ideal, as well as experience with n...
This should be fairly easy. We need a developer who can make Chrome extension/ plug-in. The extension will be used as an automation tool to enhance productivity. The developer should know languages used to build the extension like HTML, CSS and Javascript.
I'm looking for a Google Ads specialist to help elevate my Beauty Services (lash extension + eyebrow + permanent makeup, etc...) business by focusing on generating leads/sales from local customers. The ultimate goal is to not just increase our online presence but to strategically draw in quality leads that can convert into sales, thereby boosting local business growth. Ideal Skills and Experience: - Proficient in Google Ads with a solid track record of successful campaigns specifically aimed at lead generation/sales increase. - Experience in targeting local markets and tailoring ads to appeal to a localized audience. - Knowledge of the service industry, particularly in consulting and home repair, to understand the unique needs and preferences of our target customers. - Ability...
...BOM will be a vital tool for managing our stock efficiently, helping to avoid overstocking or stockouts, and ensuring that we maintain a cost-effective operation. **Key Requirements:** - **Item Details:** I need the BOM to include multiple layers of item categorization, such as Item Category, Sub Category, and precise Item Name. Additionally, it’s crucial to track each item's Expiry Date and Batch Number to ensure product quality and compliance with regulations. - **Calculations and Formulas:** The excel sheet must include formulas for Cost Calculation, Quantity Calculation, and Total Calculation to allow for real-time inventory valuation and planning. Furthermore, it should have functionality to alert us when items are nearing their expiry dates and when stock leve...
I am seeking an experienced developer to help me directly integrate Cloud Firestore with Looker Studio for a personal, data-driven project. The objective is to generate custom reports focusing on sales data, bypassing the limitations of the two-minute report extension which failed to meet my needs. **Key Requirements:** - Direct integration of Cloud Firestore with Looker Studio. - Efficient retrieval and visualization of sales data. - Creation of insightful, custom reports without using the two-minute report extension. **Ideal Skills and Experience:** - Proficiency in both Cloud Firestore and Looker Studio. - Strong background in data analysis and report generation. - Experience in developing custom integrations for data visualization. - Knowledge in handling and visualizin...
We are looking for a competent developer experienced with HubSpot API and Funnel.io. Our goal is to have these two platforms communicating seamlessly to improve our reporting capabilities. Your key responsibilities will include: - Establish a connection between and HubSpot API. - Configure the integration to import the following data points daily: Advertising Spend, Revenue, and Conversion Rates. Your understanding and experience with , HubSpot API and data integration would make your proposal stand out. We value prompt communication and rigorous attention to detail, as frequent imports and correct data scrapping are crucial to our business operations.
...development - Proficiency in web design, focusing on aesthetics and user experience - Expertise in integrating secure online payment systems - Knowledge of SEO best practices to increase website visibility - Ability to implement responsive design for mobile and tablet compatibility **Skills Needed:** - Strong HTML, CSS, JavaScript knowledge - Experience with eCommerce platforms (e.g., Shopify, Magento, WooCommerce) for backend management - Familiarity with website security measures - Creative design skills to tailor the website’s look and feel - Excellent communication skills to understand my vision and provide suggestions **Ideal Experience:** - A portfolio showcasing previous custom eCommerce projects - Experience with creating high-conversion landing pages - Knowledg...
...existing website to a new Woocommerce products pages. This will require meticulous planning and execution to ensure a seamless transition with zero data loss or downtime. **Ideal Skills and Experience:** - Proficient in WordPress website development and customization. - Experienced in large-scale website content migration with proven track record. - Knowledgeable in database management and data import/export techniques. - Familiarity with various WordPress migration tools and plugins. - Ability to troubleshoot potential issues during the migration process. - Understanding of SEO best practices to maintain page rankings post-migration. The ideal candidate will have a deep understanding of WordPress architecture, including themes and plugins, to not only move the content efficien...
I am looking for an After Effects expert with specific experience in using Element 3D plugin. Do you have element 3d installed? I am busy and could not get this done for my client which is very important. I will send you a 3d fbx file and you need to import in element 3d and break it up in parts. Save the file and send me. Detailed instructions on chat.
Backend Users Credits- Sort function (name date added, credit balance)- Be able to select users to perform batch actions (add, subtract, block, unblock)- Add action to set credit number to specific number, regardless of current credit balance. This action should be available for batch update also. Include an option like.a checkbox for this adjustment that says "update users with credit balance higher than the amount entered" so I have the option of selecting all users and updating all of them to a specific number of credits, or just the ones who have less credits than the number I am entering.- Auto Top Up - Select user(s) to auto top up their credits to a certain number, on a certain frequency that I can choose (daily, fortnightly, monthly). Also with a checkbox i...
I'm in need of an Oracle Human Resource R12 expert who can assist me in customizing my system and exporting tables as per requirement. Goals include: * Adjusting the Oracle HR system according to specified needs. * Import and manage specific tables: Employees table and Job positions table. Key data points for these tables include: * For the Employees table: Names, IDs, Job titles, location, employment status and employee passports. Ideal candidates should have: * Extensive experience with Oracle Human Resources R12. * A solid understanding of managing and customizing HR systems. * Proficient in managing different tables within Oracle HR. Your ability to deliver on these requirements efficiently while ensuring data accuracy is critical. Your input will have a significant...
I'm in need of a WordPress developer who can skillfully navigate the landscape of digital product imports into my eCommerce platform. He should have good experience in managing and mapping product import CSV with woocommerce and restrict content pro. For more info we can discuss further
I need a talented Salesforce developer with a deep understanding of non-profit success pack (NPSP) customisation and external integrations. I want to use this CRM for a charitable Wealth Management practise that is dealing in Sales of Financial Products Key Tasks: - Import and Update Leads - Push Sms and Email - Capture Personal Data - Capture Financial Product requirement using Ticketing system - Capture Sales and track Execution Stage - Capture Revenue due and paid - Send reminders/greetings/dues notification by email/sms Ideal freelancer skills and qualifications: - Proven record in Salesforce CRM customisation, specifically NPSP. - Expertise in integrating platforms with MSG91 for both email and SMS capabilities. - Comprehensive understanding of CRM platforms and their funct...
I am seeking a skilled Joomla developer to begin a long-term, ongoing project collaboration with. The ideal candidate will have experience in and a strong understanding of Joomla template customization, Joomla extension development, and Joomla Migration. Their work will focus primarily on custom module development and custom component development. It is essential for the successful candidate to have experience in working with Joomla 3.x. Please provide examples of your Joomla customization and extension development work when placing your bid.
I am looking for an experienced developer to create a Google Chrome extension that enhances user experience by instantly searching selected text on a specific website. This is an exciting opportunity for developers interested in working with browser extensions and who are adept at JavaScript, HTML, and Chrome API's. Key Features: - Upon selecting text, a new context menu option titled "Check This" will appear. - "Check This" will feature an icon (temporary PNG provided; final icon to be supplied). - When clicked, "Check This" opens a new tab, appending the selected text as a URL variable to "". - The primary function of this new tab is to search the selected text on a specified website, facilitating quick and easy information lookup. Id...
...Mastery**: Proficiency in Google Forms is critical as it's our primary tool for collecting inventory numbers. I have a basic form created that may he useful. - **Google Sheets Integration**: Expertise in Google Sheets is essential. I need to seamlessly import Google Forms responses into a new Google Sheets document each week. I have a sheet that does the min max computation but need the form data to integrate - **Automation and Scripting**: Ideal candidates will have experience in scripting for Google Apps to automate the import process, ensuring a new sheet is generated weekly without manual intervention. - **Data Manipulation**: Ability to manipulate data within Google Sheets to compute our weekly order based on pre-defined minimum and maximum product valu...
I'm looking for a skilled developer to create a Chrome extension that simplifies my workflow by integrating a payment system into it. The core functionality I envision for this extension goes beyond basic features; it should support data scraping, notifications, and customizable settings to ensure a seamless user experience. Most notably, I require the extension to incorporate a robust payment gateway that can accommodate various platforms, which I will specify directly. **Core Requirements:** - Develop a Chrome extension with the following capabilities: - Data scraping - User notifications - Customizable user settings - Integrate a payment system within the extension: - Compatible with major payment gateways (specific platforms will be disc...
...**Reduce Bounce Rates**: High bounce rates harm sender reputation. The service must minimize this by removing invalid, inactive, or non-existent email addresses from the list. **Integration Needs**: - **Batch Processing via File Uploads**: The service must accept batch processing, allowing me to upload lists in a suitable format (CSV, Excel) for validation. A user-friendly interface for uploading and downloading processed files is essential. **Ideal Skills and Experience for the Job**: - Proficiency in email validation software and techniques. - Experience handling large datasets and performing batch processing. - Knowledge of the best practices in email marketing, especially related to list hygiene. - Ability to communicate effectively, providing clear updates an...
VBA Tool to import two kinds of pdf inputs and extract data in one common sheet. Dynamic selection of inputs structure. and Input-2021-Extracted (without account numbers).pdf files conversion to excel output. Scalable and customizable for other input
I'm seeking a skilled developer to create a Chrome extension that revolutionizes how users interact with images online through advanced AI capabilities. The essence of this project is the seamless integration of GPT-4 vision for sophisticated image recognition and analysis directly within web pages, coupled with an additional API aimed at significantly improving the user interface and experience. **Essential Functions:** - Utilize GPT-4 vision to accurately recognize and analyze images on any webpage. - Implement an additional API to enhance the existing user interface, ensuring a seamless and intuitive user experience. **Ideal Skills and Experience:** - Proven experience in Chrome extension development. - Proficiency in working with APIs, particularly in the context o...
Here's a breakdown of programming a Modern Portfolio Theory (MPT) Markowitz setup in Excel using VBA: Objective: Build a VBA program that calculates efficient portfolios based on user-defined inputs, adhering to MPT principles. Inputs: • Import historic prices from Yahoo Finance. I have a functional code that you can uce. • Expected returns: Leave a field in the main excel sheet that allows for the user to input the expected returns for each asset. • Risk-free rate: Leave a field for the user to input the risk-free rate of return. • Log returns: Calculate the log returns on the historical prices, taking into account the dividends. • covariance matrix: A matrix representing the covariance between each pair of assets. • Target return or risk level...
