Hi @Midhunjoe, thank you for showing interest.
For any BSE stock, you can just google the company name with ‘stock’ at the end. For example, Advait Infratech stock. There you can see the ticker symbol of the stock under its name.
In this case it is BOM:543230 (Remove the space after ‘:’). Copy this and paste it on the sheet. You can do the same steps for all other stocks.
Alternatively you can visit the google finance website and search the specific stock. After you select the stock, the search bar will show the ticker symbol of the stock.
(While copying remove the space after ‘:’)
In case of SME stocks, what i have understood is that google finance doesn’t support SME stocks currently. I think they are working on it. You can refer this link for more information.
Unfortunately Google finance doesn’t have the sector information as of my knowledge. I have created a separate table for only the stocks that i am currently holding and then manually entered the sectors. (will update the sheet with this table soon.)
Subscribe To Our Free Newsletter |