Google Sheets: Dividend Tracker (for Indian Stocks)

Blog Owner

ABOUT:

I was working on how to scrape data from Internet in realtime with stock markets of U.S.A. I tried searching for Indian Stocks Tracker but couldn't find any proper sheets which give exact data. So I made my own dividend tracker which can track stock data using google sheets.

DISCLAIMER AND NOTES:

- This project is intended for educational purposes only.
- NSE & BSE do not allow web scraping from their website for trading.
- Google Sheets takes upto 5 minutes to update the live data, hence it is not recommended for day traders. - Pictures can be enlarged by clicking on it.
- This is a sample data of some companies and hence do no represent any of my personal portfolio.

CONTENTS:

- Visual Stats and Data
- Dividend Holdings
- Share Holdings
- Raw

MEDIA:


VISUAL STATS AND DATA

DIVIDEND HOLDINGS
Contents of the sheet:
- Company Name
- Symbol: Also the ticker for Google Finance to track the live prices.
- Shares: Amount of shares purchased.
- Purchase Price: Price at which shares are purchased.
- Purchase Value: Automatically calculates the purchase value of shares.
- Market Price/LTP: Automatically gets realtime/day Market Price ~ Picks data from Ticker.
- Market Value: Automatically calculates the market value of shares.
- Gain/Loss: Automatically calculates the Gain or Loss of the day.
- Growth %: Automatically calculates the Growth % of the day.
- StopLoss: Automatically checks stop-loss and indicates it triggering (can be set in sheet I).
- Target: Automatically checks whether target is achieved or awaiting (can be set in sheet I).

SHARE HOLDINGS
Contents of the sheet:
- Company Name
- Symbol: Also the ticker for Google Finance to track the live prices.
- Shares: Amount of shares purchased.
- Purchase Price: Price at which shares are purchased.
- Purchase Value: Automatically calculates the purchase value of shares.
- Market Price/LTP: Automatically gets realtime/day Market Price ~ Picks data from Ticker.
- Market Value: Automatically calculates the market value of shares.
- Gain/Loss: Automatically calculates the Gain or Loss of the day.
- Growth %: Automatically calculates the Growth % of the day.
- StopLoss: Automatically checks stop-loss and indicates it triggering (can be set in sheet I).
- Target: Automatically checks whether target is achieved or awaiting (can be set in sheet I).
GOOGLE SHEETS: RAW
Contains scraping from various links and stores raw data and coordinate with other sheets.
CREDITS
- Andrei for inspiring me to make this project in first place.
- Shinemartin providing the data link, "Raw" sheet and inspiring me to complete this project.

0 Comments