Existing to release the Malaysia Dividends Calculator free version. With that say, you will able to calculate your past dividends income, in case you didn’t make a tracking on paper. Below is the details what you can get and what you need to setup in order to get it.
What You Can Get From the Dividends Calculator?
Before the setup, above is one example what you will see from the calculator. Simply insert the counter you wanted to check, and press refresh, and you will see the total dividend income from the past.
Besides that, you can see the breakdown of the each time distribution from the counters according to the ex date (not payment date), as you entitled for dividends as long as before Ex date.
Dividends Calculator Setup
Follow below steps to setup the calculator:
- Make a copy of the Google Sheet below to your drive.
https://docs.google.com/spreadsheets/d/1nS-9SnjDuVdNqTKrx3K4oKnUvsLH4ccdUTNOGrNaMqU/copy
2. You should now see a copy of the google sheet.
3. At the Menu bar, select Tools and Script Editor.
4. Press “Refresh”. You should see below “Authorization Required”. You will need to setup for the first time.
5. Press Continue and select your Google account to use the Google Sheet. If you do not have the Google Account, you will need to register one.
6. Click Advanced and Click Go to Dy_Calculator (unsafe)
7. Click “Allow”.
8. You are all done.
