How to download?
The download contains
- Nifty500 performance Excel Sheet
You can easily download the sheet using password. You can get the password in easy steps. All you need is use Twitter for the password. You can simply follow me or like me on those social media accounts and message me to get the password.
MoneyPati Twitter Profile – You need to follow my Twitter profile and then message me for the password. The password will be shared to you on Twitter. Using that password you can easily download the file.
Once you have the password you can click on below link and enter the password to download the Excel sheets.
Why I created the Sheet?
Stock price is reflection of Company performance. Price performance considers everything. Note it is important to take Long term price performance. As short term price fluctuations may occur due to news or any other events. In longer term Exchanges bring back everything to normally.
I created this excel sheet for my own analysis. I use various methods to pick my stocks. This is one of the way. I look into Company performance over the longer period of time. This tells me how Company responds to different news and is the Company price performance consistent over a period of time or it is just one off jump or slump in prices.
I like companies which have performed consistently over the years. It means that Company has incrementally improved its performance over the years. There are many Companies which are one time story. The stock prices jump because of some news flow or any particular event. These Companies perform in specific time frame and then fizzle out.
They may give multi baggar returns in span of three to four years. After that they will fall freely trapping innocent retails investors. Big investors typically jump into these stocks early on making good money. Retail investors are late to party and late to leave losing their money.
What the Sheet Contains?
The sheet contains list of all Nifty 500 stocks. Below are the columns present in the sheet. You can add or remove columns as per your own needs.
Note I have used this sheet to get an idea about consistent companies over the years. You can use the sheet for come up with your stock tracking list. The same exercise which I did using the sheet or any other purpose.
- Company Name – Contains NSE Exchange ticker of the Stock
- Start Year – Year Company got listed on NSE. For Old Companies 2002 is used as base
- End Year – 2018 is used as end year for all stock. I will be updating sheet yearly
- Total Years – This is difference between Start Year and End Year. It gives idea how many years Stock is present on exchanges. We will use it in later columns
- Start Price – Price of the Stock in year 2002 or year when it got listed.
- End Price – The price of the stock in on the day sheet was created
- Total Price – This gives difference in Start Price and End price
- Total Price percent – It is percent gain in prices over the years
- Average Total price percent – It is percent gain in stock prices dividend by years it is listed on exchanges. This gives average percent gain in stock prices over the years.
Path Forward
Note Nifty 500 is not static list. It changes with time. Some Companies are included while some are left. The decision is based on stock performance and solely decided by Exchanges.
I will be updating the sheet and mentioning which are left and included but since this is base year I have not done so.
The data is not taken from 1st Jan 2002 to 31st Dec 2018. There is no need of it. Since is is 16 year chart exact precision is not deal breaker. I created the sheet few months back and took the first date and last date with reference to it. Like the sheet was created in Feb or Mar 2019 so end price is of that day.
I will be creating the sheet this way going forward as well. It should be used to get an idea about performance and use the same data to take informed decision about your portfolio or watch list creation.
Download Link – First Get the password from any one of the above social media accounts. If you do not have any of the above accounts then you can comment on this page.