Excel custom numberpekerjaan

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me?** - **Tailored App...

Looking for a video editor/automation expert to assist in building a video template to replace a section of a scene with a custom image This can either be in code or via some other tool Start your bid with "video template" or it will be ignored

I'm looking for a...jukebox. Key Requirements: - The design must be modern in style - The final deliverable should be in a word or excel format to allow for editing Content: - The title card should include the song title and artist in the right portion - A photo element should also be incorporated for visual appeal in the left portion. I'd like a card similar to the one you see here. It's exactly 18cm wide x 12cm high. However, the photo portion should be smaller, as the text does not contain the Artist, which I need. I have attached some examples here. Photos # 4 5 and 6 are from my actual machine. I need to edit and make 100 of these. There should be 22 columns on the right side for the Number Title and Artist text. Ideally, I would like to fit...

I'm seeking help with uploading products to my Woocommerce site. - Current Product Data: I have my product data available. - Number of Products: I have 150 products to upload - Product Images: I have images for the products too that will need to be uploaded. I'm looking for a freelancer with experience in Woocommerce product uploads, excellent attention to detail, and good communication skills. You need to be fast, and this is an opportunity for the new comers also as it doesn't need much technical skill. Long term working opportunity for the affordable candidates.

...for desktop. I have a vision of how I would like the page to look, and I can provide the default Okta login page HTML code to work with. I will provide an image to show what I want final login page to look like Key Requirements: - Intermediate level of customization: I'm seeking changes beyond just basic color and font alterations. This will involve specific layout changes and the integration of custom graphics. - Desktop focus: The customization should be optimized for desktop users, ensuring seamless functionality and aesthetics on this platform. Your Responsibilities: - Translate my vision: I will provide some graphics and assets, but you may need to create or source other elements to bring the design together. - Implement changes: You will be responsible for implementi...

I'm looking for a skilled developer to create a live data feed plugin for Amibroker, specifically connecting to NSE (National Stock Exchange) in India. Key Requirements: - Real-time stock prices, historical data, and market indices are the primary data types I need the plugin to fetch. - The data should be updated every second, ensuring the most up-to-date information is available for analysis. Ideal Skills and Experience: - Strong experience in plugin development for Amibroker. - Proficient in connecting to NSE data feeds. - Solid understanding of real-time data processing. - Prior experience in developing data plugins for the financial markets will be a plus. The successful candidate will need to ensure the plugin is reliable, accurate, and delivers the data smoothly to Amibrok...

can you help me with just need to customise "batch number" as "not required" field in products and purchase and sale sections, you can see that

...but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in t...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

...- Migrate content: All existing content (text, images, etc.) from the GoDaddy site should be replicated in the new WordPress site. - Implement specific theme: I have a WordPress theme in mind that I'd like to use. Your expertise in applying this theme and ensuring it's visually appealing and functional is crucial. - Integrating E-commerce: Help set up e-commerce capabilities on the new site. - Custom functionalities are already installed Your Skills: - Proficiency in both GoDaddy and WordPress is a must. - Previous experience with GoDaddy to WordPress migrations. - Familiarity with setting up and customizing WordPress themes. - Proven experience in implementing e-commerce and various plugins on WordPress. - Ability to create and integrate contact forms, booking system...

I am in need of an excellently crafted web form that can carry out addition calculations. The main purpose of this form is to accurately calculate the cost of chosen servi...system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal Candidate: - Proven experience in designing excel forms with integrated calculation logic. - Ability to design a user friendly interface. - Eye for detail, as the calculator must produce very accurate results. - Strong knowledge of Excel features and data calculation techniques. - Excellent communication skills to understand requirements and del...

I'm in need of a talented graphic designer who can create an abstract and artistic logo for personal use. Key Requirements: - The l...striking, embodying a sense of abstract artistry. - The design should be minimalist, with a modern aesthetic, yet with a touch of artistic flair that makes it truly one-of-a-kind. Ideal Skills and Experience: - Proven experience in creating abstract logo designs. - Strong sense of artistry and creativity. - Understanding of the importance of minimalism in modern design. - Ability to deliver a unique, custom design that will stand out. This logo will primarily be used for my personal branding, so it is crucial that it truly reflects my personality and style. I look forward to seeing your portfolios and working with a designer who can bring my ...

I am in need of a professional with extensive experience in WordPress to create a detailed website for...Programs & Initiatives Page: Showcase the organization's initiatives/work. - Donations Page: Mechanism for users to contribute financially. - Services Page: Description of the services provided by the NGO. - Picture Gallery: Visual representation of the NGO's work. - Latest Activity: Updates/news on the NGO's actions. -Video Gallery You will need understanding of WordPress, have experience creating custom page layouts, and have skills in both written and visual content design. An understanding of donation platforms or e-commerce integration would be highly beneficial. I need this completed within two weeks. Availability for updates and edits during and after ...

Search engines need to be implemented at 3 cpts, these results must be loaded via Ajax on the same page, and with pagination. 2 of the forms have nested fields, that is, one option is chosen from a list and the other drop-down menu is filled automatically. I send screenshots in the document

I'm in need of an expert in Advanced Custom Fields (ACF) for my WordPress website. I'm looking to create customized content layouts specifically for blog posts. Key Requirements: - Proficient in Advanced Custom Fields (ACF) plugin for WordPress. - Experienced in creating custom content layouts for WordPress blog posts. - Skilled in ensuring the ACF implementation aligns with the website's overall design and user experience. - Capable of setting up ACF in a way that allows easy content management for the website administrator. Your main deliverables will include an ACF setup that enables the website administrator to efficiently manage and update the blog post layouts. This could involve setting up fields for different components of the blog posts, such ...

I would love to have a pic of an Asian dragon, Chinese or Indonesian with wings and a long tail that has one hand/claw up and one hand/claw down. I have pasted a rough idea.

I'm seeking a proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to the chosen freelan...

I need a highly skilled professional in the field of RC remote control systems, preferably with experience in the T10 model from Sky Droid. Key Requirements: - **RC Remote Model**: T10 from Sky Droid - **Primary Application**: Drones - **Specific Features Required**: - Long-range communication - HD video transmission - Real-time telemetry Ideal candidate should have: - Previous experience in developing RC remote control systems - Strong understanding of the T10 model - Proficiency in long-range communication, HD video transmission, and real-time telemetry technologies - Video transmitter experience would be an added advantage Please show examples of related projects you've worked on.

We require an experienced WHMCS PHP programmer with knowledge in WHMCS design to rectify issues with our custom front end. The drawbacks we are facing pertain to: - Navigation glitches: We are specifically having issues accessing certain sections of the platform. - Design inconsistencies: The layout of our site seems to be inconsistent across various pages. - Functionality errors: Although not detailed, we are experiencing significant functionality problems. The ideal candidate for this role should be detail-oriented, have excellent debugging skills, and a solid background in WHMCS interface customization. Please specify your experience with WHMCS in your proposal. We require a skilled WHMCS Programmer who can fix the issues we are facing, on Hourly base.

I'm in search of a skilled freelancer who can aid me in executing a project. Unfortunately, pertinent details have been omitted such as the project type and required functionality. Please provide further information so I can tailor the project to best meet your needs. Your bid should include your expertise and relevant experience in website development, app creation, or logo design. Your communication skills are also important as we'll need to work closely to define the project. Looking forward to your proposal.

I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addresses is crucial. - Time management: Ability to work efficiently ...

I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting that this tool will enhance efficie...

I'm seeking a skilled designer to craft an attention-grabbing homepage for a Security Guard Company, inspired by the Military Infantry division. We prefer the website to be developed using WordPress, utilizing a custom theme rather than an online page builder. Additionally, we anticipate requiring further design enhancements for this website in the future. Im also attaching a copy of the business card so you can see theme of the business card as well.

I'm in need of a talented designer to create a modern, eye-catching vehicle wrap for my truck. The design should be contemporary and fresh, and I'm open to creative interpretations. This is a unique and exciting opportunity to showcase your skills in real-world settings. Key requirements: - Design: A modern and engaging vehicle wrap that stands out - Custom colors: I'm looking for a unique color scheme, so feel free to experiment - Attention to detail: The wrap should be of high quality and visually appealing - Branding: The design should reflect my brand's identity Ideal skills and experience: - Proven experience in vehicle wrap design - Strong portfolio showcasing modern design work - Proficiency in graphic design software - Good understanding of branding pri...

I have a specific concept in mind for my logo, and I'm looking for a skilled designer to bring it to life. The logo style I'm aiming for is illustrative, and I also have specific colors in mind. Key Points: - Convert my concept into a custom, illustrative logo - Incorporate the specific color scheme I have in mind - Recommendations and ideas are welcome Ideal Skills and Experience: - Proven experience in custom logo design - A strong portfolio of illustrative work - Ability to bring a client's specific concept to life - Strong understanding of color theory and design aesthetics - Good communication skills to discuss concepts and provide insights - Open to feedback and revisions, given this is a collaborative process.

I am searching for an experienced designer who can recreate a website design to a template that can be used for both and Elementor. This project requires specific skills: - Profound understanding of both platforms, and Elementor. - Experience in custom page development as the template specifically needs a pre-built main page and four attached pages. Understanding the platforms' specifications intimately will be crucial to ensuring compatibility and smooth functionality in both and Elementor. Applicant will have prior experience in creating template designs, and can showcase examples of such work.

I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.

I need floor plans for a single-floor residential building. The plan should accurately map out the following areas: - Bedroom/studio - Kitchenette - Storeroom - Ensuite toilet + shower The ideal freelancer for this job will have extensive experience in architecture or interior design with a sharp eye for detail. The ability to suggest the most efficient use of space, taking into consideration natural light and movement flow, will be highly beneficial. This is a small building with 3 rooms 2 studions with ensuite shower and toilet, and a small storeroom. Size +/-45-50 m2. A simple hip roof &/or another cheaper alternative to build roof eg. slanted flat or skillion. Patio is 0.8m. Roof should extend to cover the 0.8m patio Brick size 290mm x 140mm x 90mm * Floor plan and elevations...

I need a custom gift certificate designed for my business. Skills/Experience Required: - Graphic Design - Creative Design Skills - Experience in Gift Certificate Design - Ability to work with little guidance Please note that details about the type of certificate, its design and redemption method are not provided. Be prepared to discuss these requirements with me directly upon engagement. Thank you.

project for custom landing page

I'm looking for a custom Magento 2 payment module that will seamlessly integrate with a specific payment gateway. The key features and timeline for this project are: - Compatibility with One-Page Checkout: The custom module should be designed to work smoothly with Magento 2's one-page checkout system. - Order Creation and Status: I need the module to create an order with a 'Pending' status. - Redirection to 3rd Party Website: After order creation, the customer should be redirected to a third-party website. The transaction parameters need to be encoded into a base64 string for security. - Timeframe: I would like this project completed ASAP. Upon clicking the Place Order button, the customer will be redirected to a 3rd party website with the order paramete...

I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unl...

I'm looking for a skilled ...like it Key Requirements: - Multiclient Tibia 13.3 with built-in support for Tibia 10 (magebot, elfbot) - A system similar to with the website at least matching this quality - Integration with new quests and monsters to enhance gameplay - Implementation of cast system - Completion within a month Ideal skills and experience: - Prior experience in creating custom Tibia servers - Proficiency in programming languages necessary for this task - Strong understanding of Tibia gameplay mechanics - Ability to implement new quests and monsters - Experience in creating a cast system - Prior history of delivering projects within tight deadlines If you believe you have the skill set to deliver this project, I'd love to hear from you.

You must be a skilled 3D artist to create a realistic character animation that will be used for my video that will be edited on Wonder Studio. The character must look real. I will share the character I need made with the successful bidder. I will need variations and adjustments of the character made until I am happy with the 3D character design. All work must be 100% original and unique. No copying other peoples designs. Send me samples of your realistic characters you have made. You will need to show me how to use Wonder Studio and show my what apps or plugins are needed. The Robot must look great and look 100% real. The robot design must work perfectly with Wonder Studio to be overlaid over a real person in my videos. I will need daily updates of the design work so I can add my input i...

I'm looking for an experienced music producer to compose a custom song in Studio One for me. Key Requirements: - Genre: The genre is open-ended, and I'm open to suggestions. - Mood: I'm looking for a song that conveys a specific emotional tone. This could be happy, sad, energetic or any other emotion. - Instruments: I would like to incorporate piano, guitar, and drums in the song. Expand your song project by incorporating techniques from the previous projects: Make a recording and import the audio into Studio One Use editing techniques (splicing, fading, transposing, and reversing audio) and plugin effects to manipulate audio (either the recording you make or audio you find--as in a song or field recording) Develop your structure beyond AABA'. Should you a...

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to duplication and missing entries in da...

I am seeking a skilled developer to assist with a custom project, specifics to be discussed. The project scope and purpose will be communicated to you, as well as the audience it is intended for. The project may involve web development, app development, or design work, depending on what is most appropriate. The focus is on creating a high-quality end product that meets the needs of its intended users. The ideal candidate will be versatile and able to adapt to the changing needs of the project, as well as communicative in discussing and refining project requirements. Expertise in relevant technologies and a strong portfolio of past work will be highly valued. Your ability to work with me to understand the project's goals and bring them to life will be crucial.

...and current resistor to accomplish Smoothness and accuracy movement. 2- the joystick use stm32 microcontroller, current resistor with back emf to control speed and compare it with joystick movement , open load detection and other important details. 3- the candidate should not follow the same size of the real joystick BCP shape. any size for the first prototype is acceptable to minimize the number of BCP layers up to 2 and Facilitate design. conditions for successful candidate : 1- limit time for this project is 2 months 2- payment can be done only after Gerber file being design and tested working as accepted. 3- failure to come up with working joystick controller and drivers due to any reasons such as : programing issues or hardware failure will not give you the righ...

I've built a web application using .NET for the backend, Angular for the user interface, and SQL database. Now, I'm looking for someone to help me publish this website on the cloud and make it live. It's a small web app designed for a local business, with a limited number of users (around 15-20). Because of this, I'm aiming to keep costs as low as possible. I'm open to suggestions on which cloud platform would be best suited for this project. If you're interested in taking on this task and helping me get my website up and running, please reach out. Thank you!

I'm on the lookout for a skilled and creative jewelry designer to help me create a new designs and edit old ones to be more current - Materials: I'd like the pieces to be crafted primarily from gold and feature gemstones. Please ensure the quality of the materials used is high. We produce in downtown Los Angeles and need only CAD - Design Style: I'm interested in a range of design styles - from minimalist to vintage to more bold, statement pieces. The ideal candidate will have a good understanding of these design styles and be able to incorporate them effectively into the pieces. Ideal skills and qualifications for this job include: - Proven experience in jewelry design, ideally with a portfolio that demonstrates proficiency in the requested styles and material. - St...

...TradingView's indicator functionalities. The main task is to build a custom indicator that includes Bollinger Bands, Exponential Moving Averages (EMA), and Relative Strength Index (RSI). Key Requirements: - Apply two EMA's within the main window. - Bollinger Bands should also be displayed in the main window. - Integrate Stochastic Oscillators with the above-mentioned two EMAs and RSI below main window This script should also allow specific customization aspects: - Setting the EMA period. - Modifying the Bollinger Bands period. - Adjusting the Bollinger Bands standard deviation. -adjusting %K&D,slowing,price field,method&level -adjusting RSI period,apply to weigh close HLCC/4 Ideal skills: - Proficient in creating custom TradingView s...

You have to deliver by Monday or Tuesday end of day I am looking to bring in someone to create a GoHighLevel landing page for client onboarding. There are 3 pages: Page 1: A Sales Report Form that our Sales Rep will fill out. Page 2: A landing page with doc, custom fields and signature field Page 3: Welcome Video, Onboarding Form and Calendar embedded Loom explanation here:

I'm looking for a skilled developer to create a custom Tibia 8.6 server that integrates various unique features, aimed at attracting and retaining a significant player base. Key Requirements: - Development of a Tibia 8.6 server with integrated bot, automatic events, and a custom map containing numerous cities. - Inclusion of custom monsters, additional quests, improved PvP system, cast system, hunted system, and tasks for players. These elements are crucial for enhancing the game's depth, challenge, and appeal. Key Skills & Experience: - Extensive experience in Tibia 8.6 server development, including the integration of bots, event systems, and unique map creation. - Strong understanding of game design and mechanics, particularly in the context of MM...

...unlimited number of user roles. Ability to define an unlimited number of permissions. User Activity Log to track user actions. Avatar upload functionality with a crop feature. Built using Bootstrap 4 for responsive design. Active Sessions Management to view and manage all active sessions. Client-side and server-side form validation for data integrity. Fully customizable settings section for easy configuration. Submission Guidelines: 1. Please provide a demonstration or screenshots of the admin panel. 2. Include details about the technology stack used, including Laravel version and any additional packages or libraries. 3. Specify any customization options available. 4. Mention if ongoing support or maintenance is provided. Note: 1. We are only interested in ready-m...

I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are successfully retrieved and integrated. Please bid wit...

I'm looking for someone to create a custom JSON API to scrape specific data from a website. The main goals for this project are: - Scraping product information and pricing details: The API should be able to gather and provide product names, descriptions, prices, image URLs, and all rooms and prices available on the site. - Organization and presentation of data: The scraped data must be organized and presented in a JSON format. This will involve structuring the JSON output to include the prioritized fields and attributes as mentioned above. Ideal Skills: - Proficiency in web scraping: Experience with extracting data from websites in a structured and efficient manner is essential. You should be able to implement the scraping process in a way that ensures the integrity and acc...

I'm urgently seeking someone with expertise in Microsoft Word and PowerPoint. As the core tasks involve: - Formatting documents: Revamping and structuring multiple existing ones with professional formatting. - Creating templates: Building clean, easy-to-navigate custom Word and PowerPoint templates for future use. - Designing presentations: Enhancing PowerPoint presentations with engaging design. Ideal professionals would be quick responders, experienced in advanced functionalities of Microsoft Office, and possess creative design skills to make presentations visually engaging. As the project needs to be completed ASAP, please apply only if you can commit to a fast-paced timeline.

Sila Dafter atau Log masuk untuk melihat butiran.

We're seeking an exper...Facebook Domain name: Ionos (SSL) **THIRD PARTY APPS** These have been integrated: -Contabo or AWS server -AWS email -Braintree -PayPal -AWS email automation (all membership emails, notifications, requested reminders etc) -Zendesk (set up by Zendesk specialist in conjunction with web developer; API, macros, articles) -MailerLite (API syncing members for company newsletter) -Admin panel (custom) -Google Developer -Apple Developer -Facebook Developer -Userway (ADA) plug in -A few plug-ins text formatting etc. You will be required to sign an NDA. Chosen developer company will sign a monthly Service Agreement. This project is for hire. Completed project is our intellectual property and will pass on to us. Thank you for your interes...

...seeking a skilled developer to integrate a custom data source into Tradingview charts in real-time. I’ve attached a screen shot pointing with yellow arrow the area on the pane where i want my custom data to be displayed. Process is as follows ; 1.) Fetching Data: Using Python to fetch data from the API endpoint periodically. 2.) Formatting Data: Extract relevant numerical timeseries data from the API response and format it into a structure compatible with the "Plot Custom Data" indicator on TradingView. 3.) Inputting Data into TradingView: Utilize the TradingView REST API to update the settings of the "Plot Custom Data" indicator with the formatted data. Please check the following on tradingview to get clear idea - Trade-o-Sc...