Stock analysis valuation excel spreadsheet jobs

I'm looking for an experienced Python developer who has previously worked with options Greeks and the Zerodha API. Your main tasks will involve: - add third order greeks to an existing code The ideal candidate should have a strong command over Python, especially the Pandas library, and a thorough understanding of financial markets, particularly options Greeks. Prior experience working with the Zerodha API will be highly beneficial for this role. I look forward to your proposals!

I am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into meaningful analysis...

As the creator of this project, I'm looking for an AI/ML expert to leverage their skills and experience in object recognition and anomaly detect...from surveillance videos to live streams and pre-recorded videos. Key responsibilities include: * Implementing object recognition and tracking techniques to detect anomalies. * Ensuring real-time alerts for any suspicious activities, amplifying the safety measures. * Aiming for improved accuracy in detecting potential safety hazards. * Enhancing the efficiency of video footage monitoring and analysis. The ideal candidate should be proficient in AI/ML, with proven experience in object recognition, anomaly detection, and video analytics. The ability to provide real-time solutions and ensure precision in safety hazard detection is hi...

...experience in designing pitch decks - Be proficient in creating professional and modern designs - Have experience in incorporating financial projections and market analysis into a visual format - Be able to translate complex data into visually appealing infographics - Be able to adhere to strict timelines and deliver quality work within the given timeframe The pitch deck should include: - Financial Projections: This should clearly and effectively present the financial outlook of the event, making it appealing to potential investors. - Market Analysis: A comprehensive and visually engaging representation of the market analysis for the event. - Event Timeline: A clear timeline of the event, showcasing key milestones and expected outcomes. If you have pri...

Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I'm in need of a skilled Python developer to work on a web scraping project. Key Requirements: - I'm primarily focusing on Web scraping as the main functionality for the project. - You should be well-versed in Python and have a proven track record in data analysis. - Knowledge of web scraping is essential to ensure efficient and reliable data extraction.

...match my profile and goals. - Targeted and filtered search - Send LinkedIn messages to recruiters and hiring managers to express my interest and inquire about potential job opportunities. - Utilize my email to contact potential employers if required. - Compensation and Bonuses available if job is secured** discussed during interview - Track job applications and other information via google spreadsheet template I created Ideal Candidate: - Proficient in resume writing, LinkedIn profile enhancement, and cover letter customization. - Familiarity with job search strategies and recruitment processes. - Excellent communication skills, particularly in writing compelling and professional messages. - Previous experience in job search assistance and recruiter outreach will be highly val...

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I'm in need of a skilled JavaScript developer to create a sophisticated web rich text linkage. I'd like this linkage to connect seamlessly with data from a web spreadsheet. The ideal candidate for this project would be comfortable with Onlyoffice, as I'm looking for advanced document collaboration features integrated into the solution. Key Points: - Develop a web rich text linkage that interfaces with a web spreadsheet - Expertise in JavaScript is mandatory - Familiarity with Onlyoffice for advanced document collaboration is a big plus - The solution should be hosted on an on-premise server If you have the skills and experience to deliver a reliable and feature-rich solution, please reach out.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...

I'm in need of a talented individual from Ghana who can assist me with interview transcription and Akan language translation for market resear...Skills/Experience: - Proficiency in Akan language and English - Experience with market research data collection and transcription - Excellent attention to detail - Ability to maintain confidentiality The candidate should be able to translate interview transcripts from English to Akan, while ensuring the accuracy and quality of the data collected. The collected data will be used for qualitative analysis, so the individual should have a good understanding of the market research process. This project will be ongoing, with the possibility of more work in the future. Experience in market research, transcription, and Akan language transla...

...detail, and a tenacious attitude towards unearthing the truth. My project involves delving into some messy details involving freeholder corruption and their lawyer, who had been committing fraud and perjury repeatedly therefore, we can prove it .a background in political and corporate corruption is necessary. Essential Skills: - Investigative Journalism - Political/Corporate corruption exposure - Analysis of legal documents - Interviewing witnesses Project Outline: - The focus will be on exposing corruption within freeholders and their legal advisor. - I offer initial evidence in the form of documents and witness testimonies. - Extracting, corroborating, and confirming the validity of this information will be your duty. While the timeline is flexible, the urgency of the projec...

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes over time...

Please Sign Up or Login to see details.

...the records at the Odoo. 7. Advise and enhance better workflow in accounting with our colleagues. 8. Translation from the Chinese to English from both. “Advance Scope” (I hope you to do) 9. Recording in manner of Managerial Accounting (costing schedule by projects) 10. Communication with clients or vendors regarding accounting matters 11. Assisting the external Auditor, tax representative, and valuation 12. Analyzed the business trend and disclose internal weakness. 13. Understanding Hong Kong business requirement: Company secretary, taxation, Company registration etc....

I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.

...in-depth market research. The task involves identifying and documenting all Amazon lockers situated near rural locations on Google Maps. The deliverable should be an Excel spreadsheet with the following information for each locker: I have provided a sheet with more detailed instructions attached, with list of cities required included. - Name - Address - Picture - Need link to image or image attached. - Operating hours This research is crucial to exploring potential market opportunities. It's essential that the information is detailed and accurate to assist me in making informed decisions. Will need to have provide a and excel or google sheet document with the information requested above. Need at least 1 picture per location. Please I am currently on a $2...

...provide a detailed force analysis, create a CAD model, present concept sketches, generate a Bill of Materials (BOM), conduct Finite Element Analysis (FEA), and provide cost estimates. Key Responsibilities: - Designing a small mechanism (I will specify details if awarded). - Conducting thorough force analysis to ensure the mechanism's efficiency and safety. - Providing a detailed CAD model of the designed mechanism. - Creating concept sketches for visualization. - Developing a Bill of Materials (BOM) for easy procurement of the required parts. - Performing Finite Element Analysis (FEA) to ensure the mechanism's stability. - Providing accurate cost estimates for the entire project. The ideal candidate should have: - Proven experience in mechanism de...

...Suppliers: Identify reliable manufacturers and suppliers, ensuring access to top-quality products. Pricing Insights: Analyze pricing trends to empower informed decision-making. Market Understanding: With a sharp eye for product marketing, provide valuable insights into positioning and promotion strategies. Qualifications: Bachelor’s degree in Marketing, Business, or related field. Proficiency in data analysis tools. Excellent communication skills. Join us in shaping the future of our brand! This is a monthly pay project. During the initial month, the focus will be on evaluating your expertise in online search and your ability to deliver projects promptly....

I am in search of an experienced SEO professional to help my website gain more visibility and increase lead generation. Key responsibilities: - Develop a comprehensive SEO strategy to enhance website traffic, search engine rankings, and lead generation - Implement on-page optimization techniques to improve the website's performance on search engines - Conduct detailed technical SEO analysis and suggest/implement changes - Regularly monitor, report, and adjust SEO campaigns for optimal performance Ideal skills and experience: - Proven experience in SEO management with a track record of increasing website traffic, search engine rankings, and lead generation - In-depth understanding of on-page optimization and technical SEO - Excellent analytical skills to measure effectiveness...

I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus

business profit loss reporting excel(Jan, Feb & March)

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analys...

I need an experienced data entry person to perform research on Twitter(X) for crypto/stock twitter influencers/posters with over 1,000 followers who make predictions on crypto/stocks. @CryptoCapo_ is one example of a desired crypto influencer account. I also want you to find stock and crypto prediction Substack accounts, there is no subscriber minimum. It is your job to find other similar accounts and make a spreadsheet with two sheets, one for twitter and one for substack. the twitter sheet will include the twitter handle and the link to their profile for each account. The substack sheet will include the link to the main substack page, the number of subscribers, and whether the substack is free or paid. if the substack is paid, please have different columns for the...

• Description I'm looking for a part-time administrator to assist with data entry and VAT calculations for half an hour per month initially. Initially, we need monthly half-hour administration support to: 1) Copy and paste the Revolut bank statement into a spreadsheet. Then, select the appropriate category for the item. You also have to copy and paste or calculate the VAT for the item. 2) Copy and paste the bank statements (an estimated 6 bank accounts) and select the appropriate category for each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will be working online remotely. • Experience Please show us your detailed related work experien...

• Description I'm looking for a part-time administrator to assist with data entry and VAT calculations for half an hour per month initially. Initially, we need monthly half-hour administration support to: 1) Copy and paste the Revolut bank statement into a spreadsheet. Then, select the appropriate category for the item. You also have to copy and paste or calculate the VAT for the item. 2) Copy and paste the bank statements (an estimated 6 bank accounts) and select the appropriate category for each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will be working online remotely. • Experience Please show us your detailed related work experien...

Being familiar with grocery industry finances, I need an expert to conduct a detailed analysis regarding a store's annual profitability. This involves but is not confined to: - Breaking down costs and expenses - Calculating and understanding profit margins The ideal professional must have experience in financial data analysis with exquisite accuracy. Favorably, knowledge or background within the grocery retail sector is advantageous. The final analysis report should be delivered in a well-structured PowerPoint presentation that encompasses all key findings. It's important for the report to be clear, and easy to understand for non-finance personnel. I am open for any approaches or suggestions, as long as they fulfill the core objective of this project: gaining...

...artificial intelligence (AI) and education to develop an engaging seminar for college students. The aim is not only to build upon their basic understanding of AI, but also to highlight its ethical usage in an academic context and potential repercussions of AI-enabled cheating. Your responsibilities will include: - Creating a comprehensive presentation that explains AI's role in research and data analysis. - Demonstrating how AI can be used effectively for school purposes while also maintaining academic integrity. - Addressing the possible consequences of AI cheating in a straightforward and memorable way. Ideal candidates should have: - A solid background in AI and a deep understanding of its application in education. - Proven experience creating engaging educational conte...

...causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previo...

...business case and financial analysis document specifically tailored to secure financing and government approval for a real estate project. Key Aspects: - Market Analysis and Trends: The document should provide a thorough examination of the target market's demographics, a comprehensive competitor analysis and an in-depth look at supply and demand dynamics. - Risk Assessment and Mitigation Strategies: I need someone who can analyze potential risks associated with the project and suggest effective mitigation strategies to counteract them. - Projected Financial Performance: The document should include detailed financial projections for the project, outlining expected returns and potential challenges. Ideal Skills and Experience: - Extensive experience in financ...

As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...

I'm looking for an expert who can put together a precise and comprehensive multifamily proforma that focuses on cash flow details. Specifics Required: - Include data on net operating income, debt service, and cash on cash return. - An in-d...can put together a precise and comprehensive multifamily proforma that focuses on cash flow details. Specifics Required: - Include data on net operating income, debt service, and cash on cash return. - An in-depth monthly breakdown of these values. Skills & Experience: - Proven track record in financial analysis, specifically real estate and multifamily property market. - Professional approach with strong attention to detail. - High-level proficiency in using proforma software or Excel. - Understanding of the specifics of r...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

I'm seeking a professional to create an Information Memorandum specifically aimed at securing financing from venture capitalists...seeking a professional to create an Information Memorandum specifically aimed at securing financing from venture capitalists and or private equity. This document should include detailed financial information, such as: - Revenue projections - Profit and loss statement - Balance sheet - Adopt government statistics - Market & Industry Analysis - Design funding models The ideal candidate for this job should have a solid background in finance, business analysis, and experience in creating successful Information Memorandums for the Australian market. They should be able to present complex financial data in a clear and concise manner to appe...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

...collaborate with a skilled freelancer to develop a comprehensive online module on research methodology. This module is aimed at non-clinical staff and graduate students who are beginners in the field of research methodology. Key Objectives: - Develop a module consisting of 5 to 10 engaging lectures - Covering key topics such as Introduction to Research Methodology, Data Collection Methods, Data Analysis Techniques, Basic Statistics, and Writing Manuscripts for Publication - Ensure the content is beginner-friendly Ideal Skills and Experience: - Experience in developing educational content or courses in the field of research methodology - Strong understanding of research methodology and the ability to simplify complex concepts for beginners - Good knowledge of basic statistics an...

I have a simple python script that interact with an API that takes data from said api and outputs it in a table. The service where I use the API also has a website where I can see in the same table format the exact same data. Pandas know how will help. My problem is that the data from API and from service is mismatching. Your job is too look and identify where the problem is. You will receive both program (simple streamlit app that runs locally) and login details to website to cross check.

I am seeking a proficient Revit and AUTOCAD and ETABS. Looking forward to working with you. Thank you.

I am see...strategies and motion control algorithms will be required. - Providing real-time position feedback to the user. Your extensive understanding of feedback mechanisms particular to these types of systems is a must. Ideal expertise for the job includes: - Comprehensive knowledge in machine systems control and design. - A thorough understanding of motion control strategies. - A background in data analysis and logs processing. The machine is a Bandsaw to cut small logs into planks. The 2-off, NEMA 23 stepper motor movements are sequential, ie, first one moves then the second stepper moves. The controller is a Raspberry Pi 4, the prefered language is Python. Input to the controller via R Pi 7inch Touchscreen. File is to big to attach I look forward to ...

I'm in need of a freelancer to assist with labeling text tweets by topic (to aid in machine learning research). Key Requirements: - Labeling 1,000 tweets as to whether they are about the topic sustainability - Must be labeled by hand (no machine learning or AI) by a native English speaker Task: -Open the attached spreadsheet -Read the FULL TEXT of each tweet. Also read the brand handle and sector for reference. Make sure to pay attention to any hashtags included. -You do not need to open any URLs. Make your judgment based only on the text. -If the tweet is about sustainability, enter "1" in column E. If it is not about sustainability, enter "0" in column E. -Note that "sustainability" is a broad topic -- it is often a judgment call as to whethe...

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-function...

I ordered a 16’ x 24’ storage shed from Heartland Sheds company, but they could not install it due to my steep slope here. But I already submitted my permit request for it and it was approved. The contractor who supposed to assemble the shed on site suggested to build a cinder block foundation than he could put the shed on it. I did that, but now the building inspector wants me to get an Appendix G form filled out and stamped by a PE to verify the footer and foundation meets NC building codes. Luckily I have plenty of photos and receipts documenting the entire project from excavation to finish. I offer $1,000.00 to get the job done.

I'm in need of a skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. Your task will be to fetch data, analyze it, ...

I am seeking a YouTube analytics expert to help improve the watch time analytics of my channel. Key Responsibilities: - Anal...Responsibilities: - Analyze current watch time patterns and identify areas for improvement - Provide recommendations to boost viewer engagement and retention - Suggest strategies to enhance the overall analytics of my channel Ideal Candidate: - Proven experience in improving watch time analytics on YouTube - Strong understanding of viewer behavior and engagement on the platform - Excellent data analysis skills - Up-to-date knowledge of YouTube algorithms and best practices - Experience in the entertainment content industry would be a plus Please note, I am looking for someone who can not only analyze the data but also provide actionable strategies for im...

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualizati...

I'm looking for a skilled freelancer with prior experience in data scraping to help me extract specific text content and URLs from a public site. Key Details: - Your main task will be to collect the text content and URLs from the site. - Previous experience in a similar project is a must. - Please provide me with details regarding your experience in your application. The purpose...freelancer with prior experience in data scraping to help me extract specific text content and URLs from a public site. Key Details: - Your main task will be to collect the text content and URLs from the site. - Previous experience in a similar project is a must. - Please provide me with details regarding your experience in your application. The purpose of this data scraping project is for market ...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19....

...downloading the pdf file of the translated article, readers will need to register an account. Service is free of charge. a demo website will be available soon for more calrity. Key Components: - Market Analysis and Strategy: The plan should include an in-depth market analysis and outline our strategic approach to reaching and engaging our target audience. - Operational Plan and Technology Requirements: You'll need to detail the operational structure, technology stack, and any other technical prerequisites. - Financial Projections and Funding Needs: I’m looking for a detailed financial analysis and projections, as well as an outline of our funding needs and potential sources. - Human and Non-Human Resources: The plan should cover the staffing requirements...

...their roles, and responsibilities. Contents: List of team members, roles, contact information, and options to add/edit/remove members. Task Creation Page: Form to create new tasks and assign them to team members. Contents: Task details, assignment options, deadlines, and priority levels. Checkin/Checkout Page: View information about indivuals who are going to checkin and checkout. Stock Management Page: Manage stock on a given property. Reservation Management Page: Manage guest information, reservations, and communication. Contents: List of upcoming guests, reservation details, and communication tools. Billing and Invoicing Page Automate and manage billing and invoicing for property owners. Contents: Invoice creation, payment tracking, financial reports, and transaction hi...