Ever wondered if you could design your own stock ticker sheet with details on the price change , volume , turnover etc with control to define conditions and filter the way you needed for making investment decisions. Its possible using a simple method using Google sheet.
Below is a step by step procedure one such ticker using Google sheet. In this example we will use Indian exchange NSE stocks
Pre-requisites- Download the list of stocks symbol names in CSV format from NSE https://www.nseindia.com/market-data/live-equity-market?symbol=NIFTY%20500
- From above file , copy the list of required stocks symbols
Google sheet
- Create a google sheet with 2 columns A and B
- Column A - name the first row heading as Exchange
- Column B - name the first row heading as Symbol
- Add a new column C - name the first row heading as GSymbol
- In column A , enter the row values as "NSE"
- In column B , paste the list of symbol names extracted from the CSV file downloaded from NSE website
- In column C , create a combined name in the format Exchange:Symbol name using the google sheet function =concatenate(A2,':':,B2)
- Now add required columns of the Symbol , say we need the stock latest price and traded volume. Add column D for Price and column E for volume
- Use google sheet function formula for price =googlefinance(C2,"price") , this automatically loads the latest price of the symbol present in cell C2
- Use google sheet function formula for volume =googlefinance(C2,"volume") , this automatically loads the latest volume of the symbol present in cell C2
- Drag the cells which will automatically set the formula for remaining symbols and the values will get loaded automatically.
Likewise required other attributes of the symbol such as Market capitalization , PE ratio , price change etc can be added in multiple columns and automated.
Disclaimer:
The information provided in this article is for educational purposes
only and should not be construed as financial advice. The content is
based on publicly available information and personal opinions. Readers
are encouraged to conduct their own research and consult with a
qualified financial advisor before making any investment decisions. The
author and publisher are not responsible for any financial losses or
damages incurred as a result of following the information provided in
this article.