naveegator.in

Category: Stock Market

4 years as shareholder of Greenply Industries

4 years ago I invested in Greenply Industries after my thorough research (and I can’t remember what that research was). Over these 4 years I invested only two times. The result were underwhelming until Greenply spun off the medium density fibreboard (MDF) business into Greenpanel Industries and gave me Greenpanel shares in the ratio 1:1. Last one year of rise is all thanks to Greenpanel’s share price rally.

Return

The sharp uptick in Oct 2019 is due to me getting Greenpanel shares in 1:1 ratio.

Profit

After Jun 2018, I was able to see the worth of my investment in green only after Jan 2021.

XIRR

~~I think there is some problem with my XIRR formula, seems like if the worth of my investment goes down below a certain mark the XIRR simply calculates to zero.~~

Update 5-Apr-2021: I was able to figure out the problem with my XIRR and fix it.

March 28, 2021
4 years as shareholder of IDFC First Bank

4 years ago I invested in IDFC First Bank after my thorough research (raj_king on MoneyControl.com forum told that IDFC Bank will become the next HDFC Bank. I am now hoping that HDFC Bank will rename itself to HDFC First Bank).

Over these 4 years I invested only three times. For the majority of time, the worth of my investment has been less than the amount invested. It is only from Jan 2021 I have seen profit. And I don’t know how long will that sustain.

Return

Profit

XIRR

March 23, 2021
Get historical share price for NSE listed companies using Google Sheets
AlphaVantage was my go to API to get the historical share price for NSE listed companies. But some time in Jun’2020, they removed the NSE data. The API works for US companies but does not give data for NSE listed companies. It was probably the simplest (and cheapest), in my opinion, API available.

I looked around for other alternatives, but they were simply too expensive for me. The best free alternative I could find was – Google Sheets.

Open Google Sheets and in the cell A1 enter the GOOGLEFINANCE formula as below. Replace the <SYMBOL> with NSE symbol, for e.g. NSE:HDFCBANK.
```
=GOOGLEFINANCE("<SYMBOL>", "price", DATE(2001,1,1), today(), "DAILY")
```
You can then save this file as CSV using the menu “File > Download > Comma-separated values”. There are a attributes like high, low, volume etc. that can be fetched. This is not the best solution, but hey it works. And its free!
October 10, 2020