Excel advanced filter date range jobs
...once, converting them into QIF format with ease. - **Automatic Categorization of Transactions:** I'd like the tool to automatically categorize transactions within the converted QIF files. This feature will save time and enhance the usability of the tool. Furthermore, the tool should adhere to specific formatting requirements for the converted QIF files, including: - **Date Format:** The converted QIF files should have the date format specified. - **Account Number Format:** The converted QIF files should have the account number format specified. - **Currency Format:** The converted QIF files should have the currency format specified. The ideal candidate for this project should have experience in software development and a good understanding of financial transaction ...
We're seeking a seasoned lead generation specialist to join us on this exciting journey. Project Details: You'll be responsible for crafting a comprehensive lead generation strategy targeting decision-makers within the FinTech space, specifically early-stage startups. We aim for a steady flow of qualified leads with in-depth information like Name, Email, Title, Company Size, Industry, Revenue Range, and Social Media presence. These leads will be nurtured through targeted email marketing campaigns and social media outreach. Ideal Candidate: We're looking for a freelancer with at least 3 years of B2B lead generation experience within the FinTech industry. You'll be a master of cold email outreach, social media prospecting techniques, and data analysis. Familiar...
...and automate processes, including form submissions that trigger deal creations and associate contacts. - Develop and manage workflows and lifecycle drip email campaigns tailored to different client needs. - Oversee the creation and analysis of custom reports for diverse clients. - Manage sales pipeline visualization and adjustments for various projects. - Train team members on advanced HubSpot functionalities for a range of scenarios. - Ensure seamless data synchronization across connected applications for all clients. - Configure and manage HubSpot chatbots as per client requirements. - Implement SEO strategies within the HubSpot environment to meet diverse client goals. Requirements: - Minimum of 3-4 years of experience as a HubSpot Administrator. - Proven ability to ma...
I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.
I need to display the data from my ACF (Advanced Custom Fields) custom fields on the category page of my website. you need to be good on php wordpress because it's not sio simple
I am looking for assistance in optimizing battery performance through Matlab simulation. Due to the project specifics not being clarified, the professional should be comfortable and experienced in working with a range of battery types such as Lithium-ion, Lead-acid battery and Nickel-metal hydride batteries. Key points to consider for this project: Skills and Experience • Understanding and experience in working with various battery types • Proficiency in Matlab for creating simulations and testing • Strong analytical modeling skills Project Objectives • Provide research and suggestions on optimizing battery life, decreasing charging time and improving power output. • Develop a comprehensive Matlab model suitable for variety of scenario...
I'm in search of a seasoned Magento professional to assist our agency across a range of projects. The majority of our development team is based in India so we are seeking an additional person to assist during AU business hours from 9am - 2pm AEST. Key Responsibilities: - Resolving website crashes: Websites occasionally crash and need immediate fixes to ensure smooth operation. - Performance optimisation: - Security updates: Ideal Skills/Experience: - Proficiency in Magento: A deep understanding of Magento platform and its various versions is crucial. - Bug Fixing: Proven track record in resolving bugs and troubleshooting related issues efficiently. - Performance Optimization: Experience in enhancing performance and addressing slow page load times. - Security: Strong knowled...
I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.
...Backend: Construct a robust admin panel to oversee order processing, site settings, and overall platform management. System Overview: Showcase popular services through a slider on the front end, adjustable by the admin. Customize service display based on date, name, or cost, with admin control. Implement a commission structure for admin's revenue, configurable via the admin panel. Key Features: User Authentication and Registration Product/Service Listings with Descriptions and Pricing Search and Filter Options Shopping Cart and Secure Checkout Process Comprehensive Order Management User Reviews and Ratings Personalized User and Supplier Profiles Centralized Admin Dashboard for Platform Management Inventory Manageme...
Targeted party(s): 2 Company, 6 Individuals PLEASE FIND THE JOB DESCRIPTIONS & REQUIREMENTS BELOW: Conduct research the provided [individual(s) or Party(s)] in all litigation sources in both native language and English. Conduct research the provided [individual(s) or Party(s)] in all bankruptcy and insolvency sources in both native language and English. ...PROJECT DURATION: 4 hrs– 8 hrs (maximum) SKILLSETS: Experienced in internet research, related to the local law; Experienced in Pre-employment background checks, legal check or HR is a plus Strong in both local and English language proficiency DELIVERY ELEMENTS: All relevant news, if reported in native language must be translated into English Weblink of the news, together with: Source link, News date, and Summary of th...
I'm in need of a professional and experienced C++ developer to convert my existing Matlab code to C++, with an advanced level of optimization. The primary goal of this conversion is to ensure that the C++ code runs seamlessly on a different platform.
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strategies in terms of customer se...
Description: I am seeking an experienced WordPress developer to create a custom user profile management system for my franchise. This system is...not limited to personal information, investment history, contact details, etc. Backend Management: The system should be manageable entirely from the WordPress admin panel, with capabilities to add, edit, and view investor profiles. Privacy and Security: Ensure that the data is securely stored and that privacy measures are properly implemented since this information is sensitive. Experience with Advanced Custom Fields (ACF), Admin Columns, or similar plugins is highly preferred. The ideal candidate will have prior experience in developing custom user management systems on WordPress and should provide examples of similar projects they have ...
...customizing core of Perfex CRM, then you'll easily understand requirements. I have a detailed list of features I need developed, I'll share that document with those who are shortlisted for this project. You must mention "Dell" in the proposal in order to be noticed. Here is a brief for List of Features. 1. Invoice Currency Conversion using API and storing conversion rate in the database with date 2. Storing invoice value in base currency that is calculated based on conversion rate in the database so the total revenue is correct. 3. Invoice Custom Field Behavior changing, width of dropdown, custom field value and description 4. Invoice Total in Words in Customer Currency and Base Currency 5. Testing possibility to integrate Amazon S3 for file storage on...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.
Bid only if you have ...seamless integration for user login via credentials on both platforms. I'm not entirely certain about the status of our APIs, so the candidate should be prepared to either integrate with existing ones or possibly contribute to their development alongside the project tasks. Ideal Skills and Experience: • Experience with iOS app development. • Familiarity with Amazon Alexa and its integration. • Advanced skills in API integration or development. • Ability to interpret and execute tasks based on voice commands. • Experience in creating seamless login and user credential integration across platforms. Please include relevant experiences in your proposal. I look forward to a professional who can carry out this Alexa-to-app voice com...
I'm seeking a skilled data visualisation professional to create a Power BI dashboard. The dashboard should be capable of pulling metrics, specifically likes, impressions, etc, clicks, from Facebook and Google APIs. Key requirements include: - Be able to adjust the timeframe of pulled data, with options including (but not limited to) the last 7 days, last 30 days, as well as custom date ranges. - Please note, though, that there's a need for detailed breakdowns by geographic location, age group, or gender. Ideal skills for this task involve proficiency in Power BI, data visualisation, as well as experience working with Facebook and Google's APIs. Your ability to deliver a user-friendly and functional dashboard that meets the specified requirements will be greatly val...
I'...experienced SEO specialist to help improve the search engine ranking of several product listing websites. Key Aspects: - I need your expertise for 4 or more websites. - The primary goal is to enhance search engine ranking. - These websites are mainly comprised of product listings. Skills required: - Proven track record in SEO, particularly in e-commerce and product listing websites. - Up-to-date knowledge of search engine algorithms. - Experience in increasing search engine ranking, not just traffic. - Excellent communication skills and ability to provide clear reports and recommendations. Your role will be pivotal in boosting the visibility of these websites online, so that they can attract more potential customers. Please include relevant examples of your past wo...
I'm looking to hire an SEO backlink expert who can significantly improve my website's search engine rankings on Google. International businesses in the same industry currently form my main competition, so an advanced understanding of global SEO tailored strategies is crucial. The ideal candidate should: - Be proficient in creating high-quality backlinks - Have proven experience in improving Google search engine rankings - Understand international SEO best practices and have a keen ability to analyze and strategize against international competition. With your assistance, we will aim to move our web presence to the next level. Your skills and experience will be integral in increasing our visibility, thereby changing the dynamics of our competition.
...clauses are easy to navigate, with clear headings and subheadings. - **Formatting:** Elevate the document using professional formatting standards, ensuring it's not only compliant but also visually appealing. - **Ideal Skills and Experience:** - Expertise in legal document formatting, particularly separation agreements. - Proficiency with MS Word or similar software, especially in using advanced features for professional document layout. - Attention to detail to ensure accuracy in captioning and numbering. - Ability to work swiftly without compromising quality, given the urgency of the project. Your expertise will turn a crucial legal document into a clear, well-structured, and professional-looking agreement. If you're skilled in transforming complex documen...
I am seeking an experienced .NET developer to build a highly dynamic REST API using the .NET 8 framework. The API will be designed to manage interactions with a database using a single, generic controller capable of handling all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single, generic cont...
...entry-level professionals. Involves assisting with product photography and videography for my new online store opening. If you have a knack for capturing stunning, unique images and are ready to bring your creative flair to my product range, I want to hear from you! Responsibilities: • Assist in setting up photography scenes with limited props, a trip(s) to purchase necessary items will likely be involved. • Provide guidance on lighting techniques, photography methods, and tips to capture the best images of various products. • Photograph and video a range of products, predominantly jewelry and candles, with additional apparel, bags, and miscellaneous items. • Collaborate creatively to ensure the images and videos stand out...
I need an experienced analyst well-versed in Palisade Decision Tools. My project involves: - Detailed data analysis - Comprehensive risk assessment - Creation and interpretation of statistical models The main goal is to identify patterns and trends in historical data. Proficiency in using Palisade Decision Tools is a major requirement, as it's my preferred software for this project. The ideal freelancer should have a deep understanding of business analytics, risk management and statistical modeling. Enhancing my capacity to grasp hidden insights and trends is vital in this project.
...manager to help source gear and car parts for our MajikBus tour across the USA. Key Responsibilities: - Sourcing Camping Gear: As we journey across the states, we'll need essential camping gear for shelter and comfort in various environments. - Car Parts Management: The Skoolie needs to be in top shape to ensure our safety and mobility. You'll be required to source and coordinate sponsorship for a range of car parts including Tires, Suspension, Turbo, Water Pump, Air Bags, Roof Deck, Solar Panels, Brush Guard, LED Lights, Lift, Incinerating Toilet and Paint Job. - Adventure Gear Acquisition: We're also in need of specific adventure gear such as winches and rescue boards to support our journey. Ideal Candidate: - Experience in Sponsorship Management: You must ha...
...goal of this project is to establish an online platform for selling our products. It should be user-friendly, look professional and inspire confidence in potential customers. - **Integration with Payment Gateways**: I'll need the site to be integrated with PayPal and Stripe. This will require the implementation of these payment gateways' APIs to ensure smooth and secure transactions. - **Product Range**: Initially, we plan to list less than 50 products on the site. It's essential that the site is designed to allow easy updates and additions to the product catalog. Ideal Skills and Experience: - Proven experience in e-commerce website development, particularly for small to medium-sized businesses. - A strong background in using and integrating payment gateways su...
I'm in need of a skilled and experienced individual who can develop an anti-counterfeiting platform using NTAG 424 DNA NFC tags. The platform needs to ensure that genuine products can be authenticated securely and also prevent counterfeiting. Ideal Candidate: - Strong understanding and experience with NTAG 424 DNA NFC tags - Proficient in developing secure, dynamic NFC authentication systems - Experience in developing anti-counterfeiting platforms for the pharmaceutical, fashion and luxury goods, and electronics industries - Proficient in creating user-friendly mobile applications -NXP Key Requirements: -understanding of The security features like the SUN (Secure Unique NFC) message feature and CMAC (cipher-based MAC). -Native app development . -database integration
...listing application for both iOS and Android platforms. Key Features: - Property listing with detailed information and images - Intuitive search functionality - Contact forms for easy communication between users Additional Functionalities: - Image gallery for each property - User authentication for security and personalized experience - Push notifications to keep users informed - User Profiles - Advanced Search Filters - Geolocation Services - Integrated Messaging System - Review and Rating System - Offline Access - Integration with Social Media - Secure Payment Gateway - Analytics Dashboard - Multilingual Support Design: I prefer a modern and minimalist design for the mobile application. The interface should be user-friendly and visually appealing, ensuring a seamless user e...
I'm seeking a skilled MEAN Stack developer to improve our existing web application. Your tasks will involve multiple areas including: - Modifying existing features for better functionality - Reworking the user interface - Enhanc...and have previous experience with Azure resources. A working knowledge of Agile or Scrum methodologies, unit testing and code coverage is also required. It's important that you have proven experience with both the front and back-end of web development, as this is a full-stack position. While it's not required for this job, experience with e-commerce functionality, social networking features, or advanced search options could be considered a plus for future tasks. Please, only apply if you have a demonstrated record in MEAN Stack developme...
We are looking to build a 2D top-down design app with a 3d rendering - Similar to The frontend bootstrap5 template is complete. The GLTF models are complete and we have a range of textures. We have a backend developer in the company to integrate and I have worked in the kitchen industry - Retail and manufacturing for over 15 years.
**The Impact of Technology on Work and Personal Life: Benefits and Challenges** Technology has become one of the most significant factors that have drastically changed over the past few decades, revolutionizing how work is organized, communication methods, and personal lifestyles. The modern technological advancements offer a wide range of opportunities and challenges that individuals and societies, in general, must face. **Benefits:** 1. **Increased Productivity:** Modern technology enhances productivity and streamlines processes, enabling more achievements in less time. 2. **Improved Communication:** Easy access to modern communication tools like email and messaging apps enhances communication among individuals in the workplace and beyond. 3. **Time Saving:** Technology allow...
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth anal...
We are seeking a highly skilled PCB designer to develop a custom board featuring the RP2040 microchip to control multiple DC motors and MOSFETs, with integrated voltage regulation. This project requi...Proficient in electronic design automation (EDA) tools. Strong analytical skills and attention to detail. Proposal Requirements: Portfolio showcasing relevant projects, especially those involving power management and microcontroller integration. Detailed proposal including timeline, milestones, and budget estimation. We are excited to collaborate with a professional who is passionate about bringing advanced electronics projects to life. If you have the expertise we are looking for, please submit your proposal and let’s discuss how you can contribute to the success of this innov...
We are seeking an experienced online instructor to create and record French courses for our trucking industry training platform. You will be provided with a 9-hour English dispatching course, which you must condense into a 6-hour French course. Deliverables include recording 3 hours per week, resulting in a complete 6-hour course over two weeks. Recordings should feature your face in a small circle within the video. Candidates should be fluent in French, experienced in online course production, and able to independently research and adapt content.
...post the actual price not a price just to get my attention.) My project consists of two items. Part A: Part A has a single function that function is to transmit a signal. The part needs to be housed in a waterproof container and be powered by a rechargeable battery preferably through USB. This part will actually go on a dogs collar. The device can either transmit vi. RF, USB or any other short range signal. Part B: Part B its job is to have two functions. The first function is to receive a signal from Part A, the second job of Part B is to transmit a specified RF signal to Part C when Part A is within 2 to 3 feet of Part B. Part B, needs to also be housed in a waterproof container and be able to be charged via USB. Part C: Part C, is a separate module that is already created ...
I require a webpage which will primarily serve to display information by filtering it. Key functionality would involve options to add, remove, edit the items (by me only). Most importantly to filter them by anyone visiting the website. The items are filtered by multiple tags that the items should have, they can have 0, 1, 2 or many of the same “category” types. They also need to have categories for easy separation. The webpage will have roughly 100-200 items. More detailed information can be given privately. This webpage is for personal and group of friends use, not professional. The items themselves will consist of an icon of the item (32x32 pixel) and will follow the information on the items for the remaining 95% of the "item card"
...looking for a talented and creative Digital Designer who specializes in e-commerce merchandise. - The ideal candidate will have experience in designing visually appealing apparel and accessories that resonate with our cause. You will be responsible for creating designs that will be printed on various products using the Printify platform. Responsibilities: - Create and revise engaging designs for a range of products including t-shirts, hats, bags, and other accessories. - Work closely with our team to understand design requirements and translate them into compelling graphics. - Prepare and adjust graphic files for production, ensuring they meet Printify’s specifications. - Stay updated on the latest design trends and techniques in e-commerce merchandise. Requirements: - ...
...skills required include: - Proficient in TradingView Pinescript coding - Ability to create simple, straightforward scripts As the selected freelancer, you'll be expected to produce a script with a user-friendly interface that works flawlessly on the TradingView platform and setup the stock indicators below the chart. I want the scan results calculated using a one hour period and one month time range to pinpoint when the PPO line is about to cross or has just crossed the PPO signal line and the +DI line is about to cross or has just crossed the -DI line. The indicators are below the stock chart in the order of PPO, ADX, Williams% R, Full Stochastics %K, ATR, RSI, Accumulation / Distribution and MFI. The stock chart will show the EMA(9) and the EMA(15), candlesticks a...
...looking for a skilled video editor capable of advanced editing techniques and motion graphics creation. The project involves editing a video intended for social media use for an NGO, with a runtime of less than a minute. My NGO has recently hosted an event and I'm looking for a video editor that can edit the footage that was taken during the event! The videos need to be edit because there is a lot of blown light. I need someone creative, that can produce an video that is going to be engaging for the audience and look professional! Your tasks: - Advanced video editing, including trimming, scene transitions, and color corrections - Incorporating motion graphics for animated titles and visual elements Ideal candidates are experienced with advanced editing fea...
...down. The core essence of footage should be preserved while unnecessary parts are trimmed away. The end-product should be clear, concise, and engaging for the audience. Features & Requirements: - Basic video editing including cutting, trimming and sequencing - No additional visual effects or graphics required - Ability to work within a specified deadline and communicate well Ideal Skills: - Advanced proficiency in video editing software like Adobe Premiere Pro, Final Cut Pro etc. - A keen storytelling perspective to maintain the core narrative - Patience to sift through 1-3 hours of raw footage - Excellent attention to detail. Experience in basic video editing without any fancy effects is ideal for this project. If you have previously accomplished such tasks successful...
...NEGOTIATE OR CHANGE THE PRICE, YOU WILL BE BLOCKED, RISKING EXCLUSION FROM FUTURE PROJECTS OF MINE. Project Description: Development of a mobile application "Easy Moovie" for Android and iOS using Flutter. The app aims to enhance the urban mobility experience by providing an integrated platform that supports various modes of transport (trains, buses, metro, shuttles, trams). It will utilize advanced geolocation and user interface technologies to deliver innovative features. Technical Requirements and Features: Fastest Route Tracking: Implementation using Google Maps API to calculate real-time routes, managing events like delays or cancellations. Direct Localization: GPS integration to display the current user location and nearby transportation options. U...
...comprehensive analysis of 8-10 critical factors that will inform our decision on which location to choose for our business. Key Requirements: - Conducting a thorough analysis: You will need to explore the economic environment of each city in detail, with a focus on the factors impacting the feasibility of our business in that location. - Detail-oriented research: The study should be in-depth, with a range of data sources cited to ensure the accuracy and reliability of the findings. - Written Report: The end deliverable should be a comprehensive written report, well-structured and easy to comprehend by team members who are not necessarily economics experts. Ideal Skills and Experience: - Strong research capabilities, particularly in the field of economics and business feasibili...
I am seeking an experienced developer who is well-versed in React JS and Node JS for the development of an e-commerce platform. This platform will be designed to support a range of e-commerce functions, with the main focus being on product search and filter options. Key responsibilities & requirements: - Proficiency in React JS for front-end development - Experience with Node JS for back-end development - Strong understanding of e-commerce structures and functionalities - Ability to integrate user-friendly product search and filter options The ideal candidate should be someone who has not only the technical expertise, but also the vision and creativity to enhance the user experience through these key functionalities. A portfolio showcasing previous e-commerce ...
As the owner of a diverse range of products, I need a skilled copywriter to create engaging and informative product descriptions. Following in-depth knowledge and understanding of my product line will be necessary, with the intent of showcasing their distinct features and benefits. - I need assistance in creating an appealing copy that will captively describe each product whilst also promoting their unique qualities and advantages. - To gain a comprehensive understanding of the products, I will provide detailed product specifications, competitor product descriptions, and user testimonials. - Expertise in creating compelling and captivating copy, coupled with an understanding of selling strategies and product marketing is ideal. - A keen eye for detail and strong research skills ...
READ ALL BEFORE BIDDING Seeking a highly competent and proactiv...is ideal for someone looking to leverage their organizational and management skills in a substantial and impactful manner. When submitting proposals, please include your expected monthly compensation that you consider generous. I have a payment structure (including base + bonus) already defined, but it is essential for me that you feel your compensation is generous. Only include amounts in your range that you believe are truly generous. If my payment structure aligns with your definition of generous compensation and your resume stands out, I will contact you. Please attach your resume or send me you web link, as proposals without these will not be considered. The budget you can see here is not a reference just a rand...
I'm in need of expert assistance in pushing my Quotex trading themed YouTube channel to the top of search results. My channel hosts over 50 videos and has already had some SEO optimization done, but I need a seasoned professional to drive further growth and visibility. Expectations from this project include: - Conducting detailed SEO analysis on current content - Designing and executing an SEO strategy for improving rankings - Recommending changes and improvements to video titles, descriptions, tags, etc., and where required, boarding new SEO-focused content Ideal skills for this job: - In-depth knowledge of YouTube's algorithm and ranking factors - Excellent record in SEO strategy and implementation for YouTube channels - Familiarity and understanding of the Quotex trading...
