Stock Market

How to create a custom stock alert using google sheets

Google Sheets is a web-based spreadsheet application that allows users to create, edit, and collaborate on spreadsheets in real-time. As part of Google’s suite of productivity tools, it supports functions similar to Microsoft Excel, such as calculations, graphing, and data organization. Its cloud-based nature ensures that changes are automatically saved and accessible from any device with an internet connection. With features like sharing, permissions, and integration with other Google services (like Forms and Drive), Google Sheets makes team collaboration seamless and efficient.

Formula for Google Sheets retrieves the current stock price

=GOOGLEFINANCE(A1,”price”)

in Google Sheets retrieves the current stock price of the company whose ticker symbol is stored in cell A1. The “price” attribute fetches the latest trading price for that particular stock. By using Google Finance’s real-time market data, this function is useful for tracking and monitoring stock prices directly within a Google Sheet. The formula dynamically updates as the stock price changes throughout the trading day.

Conditional statement in Google Sheets that checks if the value in cell B1 is greater than 1780.

=IF(B1>1780, “Value exceeds 1780”, “Value is below “)

  • If B1 is greater than 1780, it returns the text “Value exceeds 1780.”
  • If B1 is less than or equal to 1780, it returns the text “Value is below.”

This type of formula is useful for creating dynamic messages based on specific conditions in a spreadsheet.

The formula checks if the word “exceeds” is present in cell C1.

=IF(ISNUMBER(SEARCH(“exceeds”, C1)), “Invest”, “Wait”)

  • SEARCH("exceeds", C1) looks for the text “exceeds” in C1. If found, it returns the position of the word; otherwise, it returns an error.
  • ISNUMBER checks if the result of SEARCH is a number (meaning “exceeds” was found).
  • If true, it returns “Invest,” and if false, it returns “Wait.”

This formula is helpful for making decisions based on text content in a cell.

Nifty 50 Stock Ticker Symbols

LIST ALL THE NIFTY 50 STOCK TICKER ADD PREFIX NSE: WITHOUT SPACE