Excel macro yahoo stock prices jobs
I am in search of a seasoned data analyst who will perform a comprehensive analysis on a large Excel dataset, with more than 10,000 rows. The range of tasks to be undertaken includes: - Data Cleaning: Ensuring the data quality, eliminating any errors or redundancies. - Data Visualization: Creating intuitive charts and graphs to illustrate the data trends and patterns. - Statistical Analysis: Implementing statistical methods like Regression Analysis, Time Series Analysis, and Hypothesis Testing to interpret the data and draw conclusions. This demands a great deal of experience in Excel, data cleaning, statistical analysis, as well as in working with large datasets. A solid understanding of regression analysis, time series analysis, and hypothesis testing is strongly requir...
I require an expert in Excel macros that can help me with a specific task. I have numerous .dl files from which I need certain sections of text extracted. Here's what I need: - Development of a reliable Excel macro that can accurately identify and extract the necessary data from .dl files. - The macro should be robust enough to handle any inconsistencies or errors within the .dl files. In the event of an issue, rather than stopping entirely or skipping the file, the macro should create a log file noting the inconsistency or error for later review. Ideal skills: - Experience in Excel macro development - Familiarity with .dl file structure - Attention to detail - Problem-solving skills, particularly regarding file inconsistencies or...
Hello, 1: you will create aspx webpage, and load data from mssql table to gridview with paging. 2: when user check some checkboxes, and enter value in textboxes and click on a button, it will store those values in session and save in database table. 3: when user enter some values in page 1 or anyother page and go to next page like page#2 and come back to page#1, the values he entered must...and save in database table. 3: when user enter some values in page 1 or anyother page and go to next page like page#2 and come back to page#1, the values he entered must show and not loss. Note: has the gridlayout. ischecked and grosspremium are editable checkbox and textbox I included the vb code as well in endorsements-vb The datasource contains 86 rows and attached as excel.
...si/COBISS/bibliografije/ Your job is to find a contact email address or/and online form for authors to submit a book proposal for each of the publishers on the list. Most of them have an online form. Get the www link. For each of them, get a contact email address. If there is no email address for authors, get some other general contact email address of the press. You will submit an Excel file with three columns: name of the publisher, email, www link with a form (if there is an online form). In this list I provided, for some publushers there are two names (left and right) or more than two names (one left and several right). In these cases of multiple names, you just need to do it for one name/publisher, not more. If one of the few names has a word “press” in it,...
I have python script to copy title and keywords from excel sheet to image metadata , I need to add category to subject filed and price to comment filed so excel sheet will be title , keywords , category , price , data will be copied to image metadata
We have a quick project for a Google Sheets / Excel Expert We have a Google Sheet that we need to filter and match customer names up to a sales rep. Essentially it needs to work like this: - Master customer data will go in sheet 1. This contains a list of customer names in column 1, and the corresponding sales rep in column 2. - Each week, we create a new sheet with payment data. - The payment data contains the payment and customer name. - we need the filter to match the customer name in the new sheet with the rep and insert the sales rep name in a new column. This will probably need to be done with a scrip - we need a proficient and experienced person to do this. If you have the experience, please message and I'll give you a loom video explaining fully and showing the do...
I'm in need of a skilled developer to create an AI bot within GoHighlevel that can perform the following tasks: - Pull prices from both Google Sheets and Google Docs - Quote customers based on device conditions with variable pricing - Collect essential customer information such as name, number, and email - Schedule appointments for customers The AI bot will also need to be integrated with our CRM system, making it a vital part of our customer management process. Experience with AI bot development, GoHighlevel, and CRM systems is preferred. The successful candidate will have the ability to create a system that is reliable, efficient, and user-friendly.
I am urgently in need of an expert to assist me with a set of complex electrical circuit problems. Your task would be to: - Solve higher order ODE circuit problems - Assist with convolution problems - Tackle Laplace transfer issues The successful accomplishment of this project will result in: - Finding the transfer function - Analyzing the frequency response - S...Analyzing the frequency response - Solving for the circuit variables This project requires a great understanding of electrical engineering principles, particularly, higher order ODE, convolution problems, and Laplace transfer. Proficiency in complex problem-solving under limited time conditions is an added advantage. I need this job completed ASAP. If this sounds like the kind of project that you'd excel at, pleas...
I am in need of a skilled Bookkeeper with a sound understanding of quotes, POs, and invoices. I require 2 hours of these services everyday to maintain and organize my financial records. I currently manage my accounts using Excel, so ability to work with it effectively is key. Key Tasks: - Maintain financial transactions - Manage and update financial records Ideal Skills: - Proven track record in bookkeeping - Familiarity with technology sector taxes - Proficient in Excel - Great attention to detail and accuracy. Experience working in a similar role within the technology sector would be highly beneficial. If you have the necessary skills and experience, I look forward to receiving your proposal.
...from a CSV file, xlsx file , track the status of each order, and update it when necessary. In addition, it should provide me with insightful inventory and order history reports, enabling us to monitor our stock levels and analyze our order trends effectively. Ideally, freelancers would have prior experience in web application development, with a particular emphasis on order and inventory management solutions. Some knowledge of CSV file manipulation and report generation would be a definite plus. Major Task which we need to accomplish with this system. 1- Upload daily order files - EXCEL/CSV. 2. Update daily orders , quanity, status (avaiable/not avaiable, when avaiable with dates) etc. 3- Genarate procurement orders sheet to market 4- Genarate adress sheet to feed into sh...
Consolidated Sales Calendar report put in excel spread sheet.
...dropshipping store manager to help me optimize my Shopify store's performance and drive a higher return on investment. The ideal candidate should have a proven track record in the following areas: - Recruitment: I need help in recruiting the right products that will attract our target market, specifically women interested in jewellery. - Pricing: The manager will be responsible for setting competitive prices for our products, taking into account market trends and competition. - Market Analysis: Regularly conduct market analysis to identify new opportunities, customer preferences, and potential threats. - Placement: Ensure our products are strategically placed across various platforms to maximize ROI. This role requires the candidate to be detail-oriented, data-driven, and ...
More details: Small Business Beauty Salon excel program required Inventory management: Track products in stock, Set reorder points for products, Generate purchase orders Point of Sale (POS): Cash, Credit/Debit cards, Mobile payments for Retail products [GST&PST] and services Daily Reports: Sales report, Inventory report, Employee productivity report Client management: History records or services done with client details and specification Employee management: Information; Timesheets; Vacation Payroll: Run semi-monthly payroll with hourly rate vs commission rate [Canadian payroll information] Salon supplies: Calculate and track supplies used during services to add to POS on checkout Schedule: Appointment schedule for clients with ability to send reminders.
...skilled professional to create an Excel workbook that provides user-specific access control. Unfortunately, I am unable to provide specifics about the type of access control, so flexibility and adaptability will be crucial for this project. Freelancers interested in this project should: - Demonstrate proven experience in Excel, particularly working with workbook-level protections and user access controls. - Have a strong background in data analysis, as this will be a key function of the workbook. Primary responsibilities will include: - Developing a user-friendly Excel workbook with user-specific access. - Incorporating data analysis functions into the workbook to streamline and enhance my workflow. Please remember to include your relevant experience in Excel...
*** PLEASE DO NOT ASK "WHAT IS YOUR BUDGET" YOUR BID AMOUNT SHOULD BE THE AMOUNT YOU INTEND TO DO ... PO Details to return a single row of data for each Invoice Detail record that matches the LATEST po line item within the same ITEM and SHIP TO CITY. The current SQL is generating duplicate records because it is matching against multiple PO details instead of the LATEST (newest) PO detail for that Item/Ship To City match. FILES INCLUDED: SQL File For Table/Data Query File for SELECT Statement Excel spreadsheet showing duplicate entries highlighted Key Tasks: - Correct SQL query to eliminate duplicate entries Seeking someone proficient in MySQL database design and query optimization. Previous experience with troubleshooting and resolving similar query issues would be a si...
I'm in need of an expert in data visualization to assist me with setting up PowerBI and creating a dashboard for my business. Key Responsibilities: - Setting up PowerBI with a focus on data visualization - Integrating databases and Excel/CSV files as data sources - Creating a dashboard that presents Sales data, Website traffic and Product inventory in an easy to understand visual format Ideal Skills and Experience: - Extensive experience with PowerBI - Strong background in data visualization - Proficient in integrating databases and Excel/CSV files - Previous experience in creating comprehensive business intelligence dashboards - Ability to understand and visualize complex data sets This project is suitable for someone who enjoys working with data, has a keen ...
I have a project to hand over to someone well-versed in both Shopify and Amazon platforms. Your primary responsibility will be the list of selected products from our client's Shopify store to Amazon. Your tasks will include: - Gathering the necessary product details from Shopify, including names, descriptions, images, prices, inventory, and shipping information. - Completing the onboarding process for Amazon, including the required documentations. The perfect candidate for this job will be detail-oriented and able to understand and work within the nuances of both platforms seamlessly. Additionally, prior experience with Shopify and Amazon product listings is a must. I look forward to receiving your bids.
I need a GUI designed from scratch based on an existing Excel sheet. The GUI will primarily handle textual data. The key features the GUI must have are: - Data visualization: Show data in a user-friendly, visually appealing format. - Data filtering: Allow users to filter data based on certain criteria. The main purpose of the GUI is to present data, providing clear, easy-to-understand visuals of complex datasets. Ideal freelancers for this project should have experience in GUI design, particularly in relation to data visualization and filtering. Knowledge and experience with textual data handling is also a plus.
Need someone who can analize data from a excel and contact customer with missing data
I'm in need of a professional to set up an open-source ERP system specifically for inventory management of office supplies in our workplace. -Key Functions: 1. Inventory Tracking: The system should accurately track our inventory of office supplies, providing real-time updates on what's in stock. 2. Reporting and Analytics: I want the ability to generate useful reports and insights, such as inventory usage trends and re-order reminders. 3. Create bar codes for each item that contains info about the item, item location, age of item, manufacturer, retailer. -In terms of access, less than 10 users should be accommodated. It's crucial that the system you set up is user-friendly and easy to understand. -Ideal skills: You should have considerable experience in setting u...
I'm in need of a skilled Python developer for web development and automation scripting for a stock trading website. The tasks would include: - Building a user-friendly trading website with the following features: * A sophisticated trading simulator * Efficient user account management system It's important for the hired developer to have in-depth Python Knowledge, and proficiency in web development and automation scripting. Experience in finance or trading platforms would be a huge plus as it pertains to understanding the specifics of a stock trading website. The ideal candidate should be adept at creating user-friendly interfaces and should prioritize the safety of user data.
I need prices on a Website (on 4 pages) so that it shows the correct prices and works with Paypal integration.
...barcode scanners to facilitate easy identification and processing of products. 2-Product Tracking: A system that allows detailed information to be recorded for each product, including product name, code, description, price, quantity, etc. 3-Inventory Management: Automatic deduction or addition of products from/to inventory based on incoming and outgoing goods, enabling real-time monitoring of stock levels. 4-Shipment Management: Managing the receipt of incoming products into the warehouse and the dispatch of outgoing products. Tracking, timing, and reporting of these processes are crucial. 5-Shelf Management: Shelf management feature for recording the location of products within the warehouse and facilitating easy retrieval. 6-Supplier Management: Recording supplier informat...
...metric is specified by the company admin when the material is created. It could be pieces, centimeters, millimeters and so on. Note that this amount of the materials will be taken of the amount attached to the user (see feature: warehouse stock) Step 7: Note. Here the employee can add free text notes. Step 8: Summary. Here all the previous information will be shown in a shorter way, summarizing the report. The submitted report will have status "Waiting for approval" then the admin can approve or deny the report. 3. Material stock function - Warehouse stock In this feature the employees will scan the materials that they take from the warehouse. It will be logged connected to their name so the company admin can see what employee took out what material. When...
...need of a dynamic Excel sheet that automatically updates with real-time stock prices for the S&P 500 companies from the New York Stock Exchange (NYSE). This needs to be updated every minute. The main focus will be on delivering accurate, up-to-date, and reliable data. Key Features Required: - Real-time NYSE stock prices; - Ability to track up to 500 stocks from S&P 500; - Automatic updates every minute. Ideal Skills and Experience: - Proficient in Microsoft Excel; - Experience with real-time data tracking; - Knowledge or experience within the stock market realm; - Familiar with NYSE workings. Given the technical nature of this project, the successful freelancer should have adequate experience working with real-time da...
I'm looking for a professional with proficiency in Excel to carry out a data entry task involving text and images. The text data is currently formatted in an Excel spreadsheet and I would like to maintain that format for the entered data. Key tasks include: - Transcribing text data from Excel sheets - Efficiently importing and categorizing images Ideal candidates should have: - Previous experience in Excel-based data entry - Excellent attention to detail - Efficiency in handling images in Excel - Ability to maintain and replicate existing file structure Please note, the final output should also be in Excel spreadsheet format.
(Apply only if you can start ASAP and be able to draft the Gantt Chart in a few hours) I'm seeking a freelancer to make a Gantt chart using MS Project. The timetable for this project is stringent, so prompt delivery is paramount. I will provide all the details in Excel , you just need to put into MS Project and make a Gantt chart Key Features of the Project: - Focus on both subtasks and milestones when creating the Gantt chart. - The freelancer needs to be proficient in MS Project since it's the required software for this job. Ideal Candidate - Proven experience in creating/extensive knowledge about Gantt chart. - Prior usage of MS Project 2016. - Effective time management skills. Your prompt response will be greatly appreciated.
I have a sheet that collects check-in/out times, project names and employee names. The sheet is updated by a google form. Names and projects on the form can change. I need this s...Google sheet as text (OCCUPIED/CLEAR) next to the project name or change color (red/green) of project name. - Weekly time report: The time report can be in Google Sheets format. - Technology/Platform: You are free to choose the best technology or platform to automate this process. Ideal Skills: - Proficiency in data analysis and automation - Experience in project management and time tracking - Excel expertise - Strong problem-solving skills and attention to detail. Looking forward to seeing your proposals!
More details: We have an internal excel worksheet that has currently not been put into production, we would like this converted to an editable PDF document that only selected boxes are editable and once finished we can then fill and sign to use on an Ipad, Iphone or Desktop if amendments were needed to be made. We would need a slightly bigger signature box at the bottom to allow our engineers to the click on the box and sign with either their finger or an Apple Pencil.
am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books ). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise, meticulous, incredibly organized, and possess th...
As per requirement, I will deliver the required district's School details in Excel format
I am looking for a professional and resourceful freelancer to develop a stock screener that specializes in the Indian market. Here are the main requirements: - Ability to pull real-time data - Features customizable filters - Includes technical indicators - It should have a professional and corporate interface - The screener should be able to be created online using WordPress or other innovative platforms - As a bonus, the inclusion of user account capabilities that allow premium users to save their preferences or searches would be fantastic. For this project, it would be ideal if you have experience in financial technology, web development, particularly with WordPress, and a strong attention to detail. Stocks market understanding and a portfolio of similar projects will give y...
WebBed API Integration in Woocommerce, what we need the API to do is pull the prices - the actual bookings can wait. The tours are already programmed with dates and the hotels, these details sent to RateHawk or Webbeds and whatever the price it returns needs updating in the system to save me doing it manually.
I'm in need of a skilled developer to craft a price alert system for Unisat and OKX Wallet. This system must: - Keep track of specific coins or pairs we choose - Send push notifications when those prices fall within a particular range - Allow us to update the price ranges on a daily basis Moreover, the alert system must be flexible, capable of monitoring prices across all coins, with our focus not restrained to Bitcoin, Ethereum, or Ripple. The notification trigger would be set for when prices fall within a certain range. For the price range, it must be customizable according to our needs, rather than being fixed to going above or below a certain price only. Ideal candidates for this project should have experience in Cryptocurrency tracking systems and devel...
I'm looking for a skilled statistician who can calculate the winning probability and the probability of a specific number appearing in ...number appearing in a number game I'm working on. The winning probability should be calculated under specific conditions that I will provide. I want the calculations to be presented in a clear and concise Excel sheet. The Excel sheet should be basic, focusing on essential calculations. Role Requirements: - Proficiency in statistical analysis and probability calculations - Advanced Excel skills for creating clear and concise spreadsheets - Ability to follow specific instructions for conditional probability calculations Ideal Skills: - Statistical analysis - Probability calculations - Excel - Data presentation - A...
I need a talented and experienced designer who can help me execute an extensive redesign of my Canva project. Ideally, you should have excellent skills in working with Canva and a keen eye for aesthetics. Specifically, the project will involve: - Text modifications: The font style will have to be changed while al...- Image replacements: Replace existing images with those I will provide. Skills and Experience: - Proven experience in managing Canva design projects - Excellent eye for detail - Strong graphic design skills - Good understanding of fonts, colors and layouts - Excellent communication skills to understand and translate my vision into the project design If this sounds like a project you can excel at, I invite you to place your bid. I look forward to seeing your ama...
I'm looking for a skilled professional who can create a VBA solution in Excel that can interact with a MySQL database. The system should be able to perform the following CRUD operations: Insert, Select, Update, and Delete. This will be a continuous requirement. Key requirements: - Proficiency in MySQL and Excel VBA - Strong understanding of SQL ODBC connections from Excel VBA - Ability to deliver the project within timelines. Your main task would be to create a reliable, easy-to-use, and efficient system to automate the specified database operations from Excel. In addition, the final solution should be well-documented for future reference. If you have experience in similar projects and can commit to the timeline, I'd love to hear from you.
...me updated about the service of the equipment as well as other crucial features. Key Features Needed: - Equipment Service Updates: The software should provide timely updates about equipment servicing, maintenance schedules, and any upcoming service requirements. - Inventory Management: An essential component of the software would be the ability to manage and track equipment inventory, including stock levels, procurement, and storage. - Service Request Tracking: The software should have a comprehensive system for users to log service requests, track progress, and receive updates on the status of their requests. Integrations: - Equipment Database: The software should be able to integrate with an equipment database, to facilitate seamless data interchange. - Email Notifications: I...
I have less than 10 columns of text and numbers data, currently in scanned documents that need to be accurately typed into an Excel sheet. I am looking for someone highly detail-oriented with: - Proven experience in data entry or similar roles - Excellent typing speed and accuracy - Proficient in using Excel - Experience in digitizing scanned documents is a plus Responsibilities include: - Typing text and numbers data from scanned documents into Excel accurately - Ensuring no data is missed or misrepresented - Completing project within the agreed deadline. Looking forward to working with a diligent and efficient freelancer.
please see the sheet and what can be done for best reporting format using this data
I need assistance to convert an Excel file into the RES2DINV software for the purpose of visualizing and interpreting my data. The Excel file's content type isn't specified but it may contain geophysical measurements, soil resistivity, or survey data. This turnaround for this task needs to be as soon as possible. Ideal skills and experience: - Proficiency in utilizing RES2DINV software - Strong understanding of geophysical data interpretation - Experience in data conversion from Excel to RES2DINV - Ability to work on tight timelines.
...to work full time for a minimum of 2 months with potential for a permanent position within the company. We are a stock market data company providing real-time and historical trade analysis tracking over 10,000 stocks in the US market and looking to go live within 50 days. We are redoing an existing project from scratch and require imaginative people to help bring our data to life focusing on the user experience. I need a developer who can handle the front-end development of my React application by implementing: - User authentication - Integrating API calls - Knowledge of web sockets and populating live data to the UI - Knowledge of Zoho API integration - Knowledge of the stock market and charting application integrations such as TradingView - Strong Linux skills (Ubun...
I am in need of an Excel expert who can create a formula that will allow for real-time updating across multiple sheets. This formula should automatically transfer all inputs from sheet one to both sheet 2 and sheet 3. Key requirements: - Expertise in Excel and formula creation - Experience with real-time data updating in Excel - Ability to automate data transfer across multiple sheets The assignments from sheet 1 should appear as the words written and not "assignment" in the weekly and monthly calendars.
...straightforward internal order confirmation system to streamline the purchasing process and manage inventory. The ideal system for me would: - Create weekly order templates when at office - Open ordertemplate and write in customer and order - Generate automatic emails and printable PDF documents for order confirmations - Include detailed information in the confirmations such as products, quantities, prices, and customer's name and contact details - also save order on webserver in text file or database - installation on internal webserver See example of weekly order See order Freelancers with experience in inventory management systems and programming automatic emails would be a good fit for this job. Strong knowledge in creating PDF documents will be a bonus. Excellent
Description: We are seeking a highly skilled and experienced Python developer to create a comprehensive option trading application. The application will be available on both desktop and Android platforms, enabling users to perform scalping orders, manage positions, and access real-time market...the app. 5. One-Click Exit: Implement a one-click exit feature for users to quickly exit positions when necessary. 6. Stop Loss and Target with Index: Users should have the option to set stop loss and target levels based on index values. 7. Live Option Chain Data: The app should fetch and display real-time option chain data, ensuring users have access to the latest market information. 8. Top Stock Tracking: Users should be able to track the top-performing stocks from Nifty, BankNifty, and...
I am seeking a proficient Java developer to generate a line chart that illustrates the moving averages and volume indicators of BANK OF BARODA stock data. - You will need to accommodate CSV data format, as I will provide the historical stock data for this institution in a specified timeframe. - This task will require proficiency in data visualization libraries, preferably matplotlib or seaborn. - Experience in financial data analysis will be advantageous. - A deep understanding of financial indicators such as moving averages and volume indicators is crucial. In all, I am looking for a quick turnaround, accuracy, and clarity in the task performed. Reading and parsing of the csv file in intellij idea is done as provided in the image. I need help with this particular task...
