Summary
We need to code a strategy where using corporate actions nsepython api, we will fetch the data of all the companies who have declared dividend in the next 6 months and this data will be dumped in google sheet.
The sheet will contain the following items:
- Company Name
- Ex-dividend date
- Dividend Amount
- Whether the stocks lies in FnO or not. If yes then what is the lot size of a future of that respective stock?
- Current Market Price of the stock.
- Dividend yield which is (Dividend amount/CMP)
- Stock Exchange on which the stock is listed.
Please see that this script should run every night at 5PM and update all the entries