A Stock Screener is a powerful tool that helps investors filter stocks based on specific criteria like market cap, price-to-earnings ratio, dividend yield, and more. Whether you’re monitoring blue-chip stocks or tracking the IRFC share price, having a customizable screener in Google Sheets can give you a personalized and flexible way to manage your watchlist.

In this blog, we’ll show you how to build your own stock screener in Google Sheets, step-by-step—without needing advanced coding skills.

Step 1: Open Google Sheets

Start by creating a new spreadsheet in Google Sheets. This will be the base of your screener.

Label your columns as follows:

| Ticker | Company Name | Current Price | Market Cap | PE Ratio | 52 Week High | 52 Week Low |

Step 2: Enter Stock Tickers

List down the stock symbols (tickers) of companies you want to track. For example:

• NS (for IRFC on NSE)
• NS
• NS
• NS

Make sure to use the correct ticker format, especially for Indian stocks listed on NSE or BSE.

Step 3: Use GOOGLEFINANCE Functions

Now comes the magic—using the GOOGLEFINANCE() function.

Example formulas:

• Current Price:
  =GOOGLEFINANCE(A2, “price”)
• Market Cap:
  =GOOGLEFINANCE(A2, “marketcap”)
• PE Ratio:
  =GOOGLEFINANCE(A2, “pe”)
• 52 Week High:
  =GOOGLEFINANCE(A2, “high52”)
• 52 Week Low:
  =GOOGLEFINANCE(A2, “low52”)

Drag these formulas down to apply them for all rows.

Note: The GOOGLEFINANCE function works best for stocks listed on US exchanges, but for Indian stocks like IRFC, some data points like PE or Market Cap may not populate. You may need to manually input or use third-party APIs or data sources for comprehensive data.

Step 4: Add Filters for Screening

To make your sheet act like a screener:

• Click on the header row.
• Go to Data > Create a filter.

Now you can filter based on criteria like PE ratio < 20, Market Cap > 10,000 Cr, etc.

Step 5: Conditional Formatting (Optional)

Use conditional formatting to highlight undervalued stocks or those nearing their 52-week lows.

For example, highlight PE ratios below 15 in green, or flag stocks trading within 5% of their 52-week low.

Why Use Google Sheets for Screening?

• It’s free and customizable.
• You can access it from anywhere.
• It lets you integrate data from multiple sources.
• You control the logic and formulas—tailored to your investing style.

Final Thoughts

While tools like screeners on broker platforms or financial websites are great, building your own Stock Screener in Google Sheets puts you in the driver’s seat. Whether you want to track tech stocks or monitor the IRFC share price, this DIY approach gives you flexibility, control, and insights tailored to your investment goals.

One of the common challenges data analysts face when working with large datasets in SQL is identifying and managing outliers. Outliers are data points that deviate significantly from other observations, and they can distort statistical analyses, leading to misleading conclusions. Effectively handling outliers is critical for ensuring the accuracy and reliability of data-driven insights. This article will explore statistical techniques for identifying and managing outliers in SQL while incorporating key concepts often covered in a data analyst course in Pune.

What Are Outliers and Why Are They Important?

Outliers are data points that lie significantly outside the range of the rest of the data. These points can arise due to errors in data entry or measurement variations or represent rare occurrences that could be interesting for specific analysis. In either case, their presence can impact the integrity of your analysis. For instance, an outlier can skew the mean, inflate variance, and lead to incorrect inferences. Data analysts who are well-versed in a data analyst course understand that outliers must be managed appropriately to ensure the robustness of statistical conclusions.

Identifying Outliers Using SQL

Before managing outliers, they first need to be identified. SQL provides a variety of methods for spotting anomalies in datasets. One common approach uses statistical techniques such as the interquartile range (IQR) or standard deviation. To identify outliers, SQL queries can be written to calculate these statistics and filter out the values that fall beyond acceptable thresholds.

1. Interquartile Range (IQR) Method

The IQR is a measure of statistical dispersion calculated by subtracting the 25th percentile (Q1) from the 75th percentile (Q3) of a dataset. Data points that fall below Q1 – 1.5 * IQR or above Q3 + 1.5 * IQR are often considered outliers. SQL can be used to calculate these quartiles and identify potential outliers using the following query structure:

WITH percentiles AS (

SELECT

PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY value) AS q1,

PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY value) AS q3

FROM your_table

)

SELECT *

FROM your_table, percentiles

WHERE value < (q1 – 1.5 * (q3 – q1)) OR value > (q3 + 1.5 * (q3 – q1));

By learning such methods in a data analyst course, analysts effectively gain hands-on skills in filtering outliers.

1. Standard Deviation Method

Another common technique to detect outliers is the standard deviation method. Data points with more than 2 or 3 standard deviations from the mean are typically considered outliers. This method assumes that the data follows a normal distribution, and large deviations indicate that a data point is likely an anomaly. In SQL, the standard deviation can be calculated and used to filter outliers with the following query:

WITH stats AS (

SELECT

AVG(value) AS mean,

STDDEV(value) AS stddev

FROM your_table

)

SELECT *

FROM your_table, stats

WHERE value > (mean + 3 * stddev) OR value < (mean – 3 * stddev);

A solid foundation in a data analytics course would help a professional master such techniques, as understanding statistical methods is crucial for accurate data analysis.

Managing Outliers: Handling Techniques

Once outliers are identified, the next step is determining how to manage them. Depending on the context and the nature of the data, there are several ways to handle outliers in SQL.

1. Removing Outliers

One straightforward approach is to remove outliers entirely from the dataset. While this method effectively ensures that statistical analyses are not skewed, it may not always be appropriate if the outliers contain valuable information. Data analysts learn in a data analyst course in Pune to weigh the pros and cons of removing outliers in specific scenarios. The SQL code for removing outliers using the IQR method might look like this:

WITH percentiles AS (

SELECT

PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY value) AS q1,

PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY value) AS q3

FROM your_table

)

DELETE FROM your_table

WHERE value < (SELECT q1 – 1.5 * (q3 – q1) FROM percentiles)

OR value > (SELECT q3 + 1.5 * (q3 – q1) FROM percentiles);

Analysts can ensure that extreme values do not influence their models and analyses by removing outliers. However, this method requires a deep understanding of the data, which is emphasised in a data analyst course in Pune.

1. Capping Outliers (Winsorizing)

In cases where retaining the outliers is essential for some analytical purpose, capping the extreme values can be an effective strategy. Capping involves replacing extreme outliers with a predefined threshold value, such as the dataset’s maximum or minimum non-outlier value. This approach prevents outliers from distorting statistical measures while preserving their presence.

WITH stats AS (

SELECT

MIN(value) AS min_val,

MAX(value) AS max_val

FROM your_table

)

UPDATE your_table

SET value = (SELECT min_val FROM stats)

WHERE value < (SELECT min_val FROM stats);

Transformation Techniques: Log or Square Root Transformation

Another approach for handling outliers is through data transformation. If outliers are due to skewed data, applying mathematical transformations like a log or square root transformation can help bring the data back into a normal distribution. SQL can be used to perform these transformations:

UPDATE your_table

SET value = LOG(value + 1);

Such transformations are part of any data analyst’s toolkit and are often covered comprehensively in a data analyst course in Pune.

The Role of Data Visualisation

Data visualisation is an essential tool for detecting outliers. While SQL queries can identify outliers programmatically, charts like boxplots, histograms, or scatter plots can visually represent anomalies. Many SQL databases can integrate with data visualisation tools such as Tableau or Power BI, which makes it easier for analysts to spot trends and outliers at a glance.

Conclusion

Effectively handling outliers is crucial for maintaining the integrity of any data analysis. Using SQL for statistical techniques like the IQR method or standard deviation helps analysts identify anomalies efficiently. Additionally, managing outliers through removal, capping, or transformation ensures that extreme values do not distort analyses and models. Data analysts who complete a data analysis course in Pune are equipped with the necessary skills to deal with outliers, ensuring that their data analyses are both accurate and insightful. As the demand for skilled analysts grows, mastering the art of handling outliers will remain vital to any data analyst’s skill set.

Business Name: ExcelR – Data Science, Data Analytics Course Training in Pune

Address: 101 A ,1st Floor, Siddh Icon, Baner Rd, opposite Lane To Royal Enfield Showroom, beside Asian Box Restaurant, Baner, Pune, Maharashtra 411045

Phone Number: 098809 13504

Email Id: [email protected]

In addition to being a useful route for your car, your driveway also has a distinctive exterior feature that contributes to the elegant appeal of your house. Expert paving companies ottawa can transform the entrance to your property into a breathtaking display of elegance and intricacy by creating the driveway of your dreams.

Enhancing Curb Appeal:

One of the first things visitors notice when they arrive at your house is the driveway; thus, it plays a crucial role in creating a good first impression. Professionally cleared driveways offer value and appeal, in addition to enhancing your property’s overall curb appeal. With so many different paving materials, styles, and samples available, you may customize your driveway to complement the exterior finish and design of your house, creating a visually appealing and powerful outdoor space.

Creating a Welcoming Entrance:

Your driveway serves as the front door to your house, beckoning both guests and residents with its alluring appearance. Skilled paving can enhance the look and create a cozy, welcoming atmosphere in your house. Whether you choose flawless cobblestone, smooth cement, or country block, the correct paving material can give your driveway personality and appeal, creating a crucial first impression that sets the tone for the rest of your property.

Improving Functionality and Durability

In addition to adding style, professional paving companies ottawa improve the functionality and durability of your driveway. A flat surface that can withstand heavy cars and people walking across it without collapsing or breaking is ensured by professionally installed paving. Superior paving materials are also resistant to fading, cracking, and discoloration, ensuring that your driveway maintains its beauty and functionality for an endless amount of time with minimal maintenance.

Customizing Your Design:

With the many customization options provided by expert paving at Ottawa, you can create a driveway that perfectly reflects your personal preferences and sense of style. There are countless options for plans, ranging from traditional to modern, natural to contemporary. Professional pavers may work with you to revitalize your vision and create a driveway that is uniquely yours, whether you want a smooth and reasonable style or a more multifaceted and resplendent plan.

Creating the driveway of your dreams with professional paving is a wise investment that may transform the exterior of your house and increase its overall appeal. Expert paving enables you to drive in style and create a lasting impression with your home’s entrance by improving control, creating an attractive entrance, enhancing usefulness and solidity, and redesigning your layout.

Transcriptionists play a pivotal role in converting spoken language into written text accurately and efficiently. However, the process of transcribing audio files can be time-consuming and challenging without the right tools. Fortunately, advancements in technology have led to the development of powerful transcription software like Olympus Transcriptionist Software, which empowers transcriptionists to boost their productivity and accuracy levels significantly. In this blog post, we’ll delve into how Olympus Software can unleash your transcription superpowers, enabling you to maximize efficiency and streamline your workflow.

Understanding the Power of Olympus Transcriptionist Software

Olympus Software is a cutting-edge transcription solution designed to simplify the transcription process while maintaining high standards of accuracy. Developed by industry-leading experts at Olympus, this software incorporates advanced features and intuitive tools tailored to the specific needs of transcriptionists.

One of the standout features of Olympus Software is its robust speech recognition capabilities. By leveraging state-of-the-art speech-to-text technology, the software can accurately transcribe audio files in a fraction of the time it would take through manual transcription. This not only accelerates the transcription process but also minimizes the risk of errors, ensuring that your transcripts are of the highest quality.

Streamlining Your Workflow with Olympus Transcriptionist Software

Efficiency is paramount in the world of transcription, where time is of the essence, and deadlines loom large. Olympus Software offers a range of features designed to streamline your workflow and enhance your productivity.

1. Seamless Integration: Olympus Software seamlessly integrates with a variety of audio file formats, allowing you to effortlessly import recordings from different sources. Whether you’re transcribing interviews, lectures, or dictations, the software supports a wide range of audio formats, eliminating the need for time-consuming file conversions.
2. Customizable Templates: Another notable feature of Olympus Software is its customizable templates, which enable you to create tailored transcription formats to suit your specific requirements. Whether you prefer verbatim transcripts or clean, edited copies, you can create templates that align with your preferred style and formatting guidelines, saving you valuable time on post-transcription editing.
3. Time-saving Shortcuts: Time is of the essence in transcription, and Olympus Software offers a range of time-saving shortcuts and hotkeys to expedite the transcription process. From playback controls to text formatting commands, these shortcuts allow you to navigate through audio files and transcribe text with unparalleled speed and efficiency.
4. Intelligent Editing Tools: In addition to its transcription capabilities, Olympus Transcriptionist Software boasts a suite of intelligent editing tools to help you fine-tune your transcripts with ease. From spell checkers to grammar correction features, the software helps ensure that your transcripts are error-free and polished, saving you time on manual proofreading and editing tasks.

Enhancing Accuracy and Quality

While speed is important, accuracy remains paramount in transcription. Olympus Software prioritizes accuracy through a combination of advanced speech recognition algorithms and powerful editing tools.

1. Advanced Speech Recognition: Powered by cutting-edge speech recognition technology, Olympus Software can accurately transcribe audio files with high levels of precision. By converting spoken words into text in real time, the software minimizes the risk of errors and discrepancies, ensuring that your transcripts are faithful representations of the original recordings.
2. Intelligent Error Correction: Despite its advanced speech recognition capabilities, no transcription software is infallible. However, Olympus Software mitigates the risk of errors through its intelligent error correction features. From automatic punctuation insertion to context-aware correction suggestions, the software helps you identify and rectify errors quickly and effectively, thereby enhancing the overall quality of your transcripts.
3. Quality Assurance Tools: In addition to error correction features, Olympus Transcriptionist Software offers a range of quality assurance tools to help you maintain high standards of accuracy and consistency. From audio waveform visualization to timestamp alignment tools, these features enable you to cross-reference audio recordings with transcribed text, ensuring that every word is captured correctly.

Collaboration and Accessibility

In today’s digital age, collaboration and accessibility are key considerations for transcriptionists working in diverse settings. Olympus Software addresses these needs through its collaborative features and multi-platform accessibility.

1. Cloud Integration: With cloud integration capabilities, Olympus Software enables seamless collaboration among transcriptionists working remotely or across different locations. By storing transcripts securely in the cloud, the software facilitates real-time collaboration, allowing multiple users to access and edit transcripts simultaneously.
2. Multi-Platform Support: Whether you’re working on a desktop computer, laptop, or mobile device, Olympus Software offers multi-platform support for unparalleled flexibility and accessibility. Transcribe on the go or switch between devices seamlessly, knowing that your work is always synchronized and up-to-date.
3. Secure Sharing Options: When it comes to sharing transcripts with clients or colleagues, security is paramount. Olympus Software provides secure sharing options, allowing you to encrypt transcripts and control access permissions to safeguard sensitive information.

Conclusion

In conclusion, Olympus Transcriptionist Software is a game-changer for transcriptionists seeking to maximize efficiency, accuracy, and productivity. With its advanced speech recognition capabilities, intuitive workflow tools, and collaborative features, the software empowers transcriptionists to unleash their transcription superpowers and tackle even the most demanding transcription tasks with ease. Whether you’re a seasoned professional or just starting out in the world of transcription, Olympus Software is your ultimate ally in the quest for transcription excellence.

In the realm of electrical systems, efficiency and performance are paramount. Whether you’re managing a residential property, a commercial building, or an industrial facility, the heart of your electrical infrastructure lies in the switchboard. Often overlooked, switchboards play a critical role in distributing power safely and effectively throughout your premises. However, as technology advances and energy demands grow, it’s crucial to ensure that your switchboard is up to the task. This is where switchboard upgrades come into play, offering a transformative solution to enhance efficiency and performance while ensuring safety and compliance.

Understanding Switchboard Upgrades

Before diving into the benefits of board upgrades, let’s first grasp what they entail. A switchboard serves as the central hub for distributing electricity from the main power source to various circuits within a building or facility. Over time, factors such as wear and tear, technological advancements, and increased power demands can render existing switchboards inadequate.

Board upgrades involve replacing or modernizing components of the existing switchboard to meet current safety standards, accommodate higher loads, improve reliability, and incorporate new technologies. These upgrades can range from simple component replacements to complete overhauls, depending on the specific requirements of the electrical system.

Enhancing Safety and Compliance

Safety should always be the top priority when it comes to electrical systems. Outdated switchboards pose significant risks, including electrical fires, equipment malfunctions, and personnel injuries. By investing in switchboard upgrades, you not only mitigate these risks but also ensure compliance with industry regulations and standards.

Modern switchboards are designed with advanced safety features such as circuit protection devices, ground fault detection, and overload safeguards. Upgrading to these newer components minimizes the likelihood of electrical hazards and ensures that your facility meets the latest safety codes and regulations, providing peace of mind for both occupants and stakeholders.

Improving Efficiency and Reliability

Efficiency and reliability are essential for maintaining uninterrupted operations and minimizing downtime. Outdated switchboards may struggle to handle the increasing demands placed on them, leading to inefficiencies, voltage fluctuations, and frequent breakdowns. This can result in costly repairs, productivity losses, and even damage to sensitive equipment.

Board upgrades address these issues by optimizing the distribution of electrical power, reducing energy losses, and enhancing system reliability. Modern components such as digital meters, power factor correction units, and energy management systems enable better monitoring and control of electricity usage, resulting in improved efficiency and reduced operational costs over time.

Accommodating Growth and Expansion

As businesses grow and expand, so do their electrical needs. Outdated switchboards may lack the capacity to support additional equipment, machinery, or facilities, limiting scalability and hindering growth opportunities. Switchboard upgrades allow you to future-proof your electrical infrastructure by increasing capacity, adding new circuits, and integrating scalability features.

Whether you’re expanding your operations, upgrading your equipment, or implementing new technologies, a modernized switchboard can accommodate these changes seamlessly. This flexibility not only supports your current needs but also prepares your facility for future advancements, ensuring long-term sustainability and competitiveness.

Harnessing Advanced Technologies

The advent of digitalization and smart technologies has revolutionized the way we manage electrical systems. Board upgrades offer the opportunity to harness these advancements and optimize your operations through automation, remote monitoring, and predictive maintenance.

Smart switchboards equipped with IoT sensors, communication interfaces, and data analytics capabilities provide real-time insights into energy usage, performance metrics, and equipment health. This allows for proactive maintenance, timely interventions, and informed decision-making, ultimately maximizing uptime and productivity.

Ensuring Business Continuity

In today’s fast-paced world, downtime is not an option. Any disruption to electrical services can have far-reaching consequences, impacting productivity, revenue, and customer satisfaction. Switchboard upgrades play a crucial role in ensuring business continuity by minimizing the risk of unexpected failures and outages.

By investing in reliable and resilient switchboard solutions, you can minimize downtime, optimize operational efficiency, and maintain continuity of critical services. Whether it’s a commercial facility, manufacturing plant, or data center, having a robust electrical infrastructure is essential for sustaining operations and meeting customer expectations.

Future-Proofing Your Investment

Investing in board upgrades isn’t just about addressing immediate needs—it’s about future-proofing your investment for long-term success. With technology evolving at a rapid pace, today’s cutting-edge solutions may become outdated tomorrow. However, by choosing modern switchboards that are adaptable and scalable, you can future-proof your electrical infrastructure against obsolescence and technological advancements.

Look for switchboards that support modular designs, software updates, and expansion capabilities, allowing you to adapt to changing requirements and emerging trends without the need for costly replacements. By future-proofing your investment, you ensure that your facility remains agile, resilient, and competitive in the face of evolving industry landscapes and technological disruptions.

Conclusion

Switchboard upgrades are more than just a maintenance task; they’re a strategic investment in the performance, safety, and sustainability of your electrical infrastructure. By embracing modernization and leveraging advanced technologies, you can unleash the full potential of your electrical systems, driving efficiency, reliability, and business growth.

Whether you’re looking to enhance safety and compliance, improve efficiency and reliability, or prepare for future expansion, board upgrades offer a comprehensive solution to meet your needs. Don’t wait until problems arise—take proactive steps to upgrade your switchboard and unlock a new era of power and performance for your facility.