4 Stocks Down Over 25% from Peak – Track All Nifty 50 Losers | Ultimate Tracker #Finance

The top 50 companies in India are called NIFTY50. This index has only stable companies with a huge market cap. Among those stable companies, … the stock prices of some have corrected by 35%, 30%, or 25% from their peak. How would it be if we could see data on such fallen stocks in one

place? Not only that, the stock’s trend, its 52-week high, 52-week low, also its PE ratio, and more details can be tracked in one place anytime. Not only these stocks, but also to track the details of our favorites in one place. Let’s see about that tool detailed in this CashNews.co.

Greetings! my name is Boosan. This channel is Finance Boosan. While recording this CashNews.co, IndusInd Bank is the most crashed stock in NIFTY50. It has nearly crashed by 38%. Next, Tata

Motors has fallen by almost 30% from its 52-week high. Others in the list include … big companies like Hero Motor and Bajaj Auto have crashed more than 20%, If a stock crashes by 20%, it’s called a crash and also as bearish. The data we see here is during the time of this recording. If

another stock falls tomorrow, it will be automatically added to this list. Stock data is automatically updated time to time … to show stocks that have fallen significantly or given high returns. Let’s look at how to do this step-by-step. Let’s take NIFTY50 data. NIFTY50 refers to

the NSE’s top 50 companies. SO search "NSE India NIFTY50" to access the official NSE website. From there we can download the list of NIFTY50 companies as a CSV file. We can download and save the CSV. After saving, import this data into Google Sheets. If you aren’t aware of

Google Sheets … Google Sheets is a excel like free tool from Google. It’s accessible on any device if you have a Google account. It can be accessed freely. If we save an excel file in the device, we could only access it in that device. If we had it in computer, then we can’t

access it from mobile. But we can access Google Sheets online from any device. To open a New sheet, search "sheets.new" in browser. Name the sheet as "NIFTY50 tracker". After naming, go to the file and click import … to import the NIFTY50’s stocks list. After

importing, we can see the stock name, sector, and symbol. Basically we have the 50 stocks list here. If we take a random stock name from here, … and check its share price from Google, we will get all its share details. We can see its 1 month data, 1 year data, 5 year data. They would have

given a symbol under the name of the stock. This is the symbol that Google Finance uses to understand the stock. If we look at the listing in NSE, they would have given as NSE : that

stock’s symbol. So basically, NSE: for NSE. For listings in BSE, they would have given as BSE. First what we are going to do in this sheet is, we need to import the NSE symbol for all the stocks. It is very simple to import it. We have the symbol in the data that we have already imported.

Prefix to that, we have to add "NSE :" So, let’s put a formula in this sheet… and fill this data for all the columns. Next, we need the current price of the stock. To find the current price, there is a formula called Google

style="font-weight: bold; color: #1a73e8; text-decoration: none;">Finance. If we enter Google Finance and the symbol here, it will automatically fill the price of the stock. After filling

it, we can copy this formula to all the stocks. Now, we can see the current price of all the stocks here. A while ago, when we typed the price of a stock in Google, we got a data, right? That data is the Google text-decoration: none;">Finance data. So basically, both are the same API. The data comes from there … and that data is automatically filled. We can take many things from this Google none;">Finance formula. For example, the stock’s 52-week high, 52-week low, EPS, PE ratio. Not only that, in the historical data, we can automatically get the price of the stock at any time period. Now, in our sheet, we are going to fill the 52-week low and 52-week high. For this too,

using the same Google Finance formula, if we enter the symbol and type low 52, we will get the 52-week low. After getting this, if we copy this and put it for all the stocks, we will get the

52-week low for all the stocks. So basically, why is it called 52-week low and 52-week high? There will be 52 trading weeks in a year. To represent that, to represent how much has gone up and how much has gone down in a year, we use the 52-week low and 52-week high. Just like we filled the 52-week

low, we can fill the 52-week high here. After filling this, if we compare it with the 52-week low from today’s price, we can see how much it has gone up. So basically, how do we find that out? If we find out the difference between the 52-week low and today’s price, and divide it with

the 52-week low, we will get the percentage. From the low, this is the percentage that has gone up. We will fill this for all the stocks. Similarly, we will fill the distance between 52-week high and today’s price. If we want to see this data visually, we can format this in a proper

conditional format. Dark red means it has fallen a lot. Light red means it has fallen a little. We can format in this way. Similarly, we can format the next column as well. I have also filled some other important data in this sheet. We can see how much returns this stock has given in the past year.

Similarly, we can also see this stock’s trend in the past year. For example, if we pick a stock from here … and compare it with the data in Google, it will be the same. Starting with this chart pattern, the 52-week low, 52-week high, current price and its P.E. ratio, all the data will

match. Now, we can order the data here. For example, to know which stocks have fallen a lot from the 52-week high, if we order according to that column, it will all come up. Here, IndusInd Bank, Tata Motors, Trent have all fallen a lot and they have listed up. Similarly, to find out which stocks

have risen a lot in NIFTY50, if we sort according to the 52-week low, we will be able to find out. Here, we can see Trent. It means that … Trent has already given a big run-up, and has slightly corrected from there. Next, Bharat Electronics, Mahindra and Mahindra … have given more than

100% returns. Bajaj Auto, even if it has fallen by 20%, if we see from its low, it has risen by more than 80%. Now, we have seen Nifty 50 stocks as an example. Here, you can see this data automatically with any stock symbol. Whatever stocks you want to put in the watch list, you can fill it here

and track it yourself. For me, a very important column is this notes column. When you track a company, you can note down your opinion on it, the details of your history on it in this notes column. If you want to buy, note down when you want to buy. Not only that, if you are looking at some data,

and if that data is relevant, note it down. So that, when you read the same data after 3 or 6 months, it will be helpful for us to track the situation of the stock. Generally, they will charge ₹500 – ₹600 to share these tools & trackers with us. But when they share it, they will hide

the formula or how it works. But, Google Sheets is completely free. Since there is no awareness about it, many people don’t use it. Instead of simply showing the stock information, If I explain how to use this tool, I felt that many people can use it in advance or in a more useful way.

That’s why I made this CashNews.co. But to prepare this and to prepare this content, it will take a lot of effort. To recognize that effort, or if you want to see more content like this, like this CashNews.co now. Only through your like or comment, I can know whether there is an encouragement

for such content or not. You can use this tracker completely for free. For this, you can go to the courses page in www.Financeboosan.in website, and access this free tracker.

Its link is in the description and comment section. If you want to know more useful information or real-time updates about the market, you can join the learners community. The link for that is also in the description and comment section. Here, I will share my Portfolio activity and

market updates in real-time. Check the link for that as well. If you find the information in this CashNews.co new or useful, kindly like this CashNews.co : ) If you haven’t subscribed to this channel yet, do subscribe and click on the bell icon next to it, and select All to get instant

notification of new CashNews.cos uploaded on this channel. — Thanks! Friends — ( Subtitled by DWARAKA )