SGX Data - Fine tuning database access methods

Finally took some time to look at the database access method used for querying the table.  Made some fine tuning.  Hope it will help fix the web page error issues.

 

SGX Dividend Data getting duplicated data

Just noticed that the dividend data are having duplicates again.  This has affected the dividend history calculations.  Am trying to fix it.

Hosting Server Migration

There is a Hosting Server Migration going on.

Hence pebbleslab.com may not work correctly.  Please be patient while the Hosting Company sorts it out.

 

How to use Portfolio Feature

Someone asked how to use the Portfolio feature.

After you have created an account, go into the detail view of the counter you want to add to your Portfolio.  At the top, there will be 2 boxes for Portfolio feature.  These will only be shown after you have logged in.

You can enter the number of shares and your purchased price and click Submit.  It will bring you to your Portfolio view. 

The URL of Portfolio view is : http://sgxdata.pebbleslab.com/index.asp?m=4

You can bookmark this URL and return to your Portfolio view.  If your browser allows cookies, your user ID will automatically be remembered in your browser's cookie so you do not need to login again.

This arrangement is ideal for browser on your Smartphone.  You just need to login once and bookmark the Portfolio view.

It is actually not necessary for you to enter the number of shares and purchase price if you do not want the auto calculation feature.  You can enter "0" at both box and click the Submit button and that counter will still be added to your Portfolio.

To remove a counter from your Portfolio, enter "-1" in the number of shares box and click Submit.  This will delete the counter from your Portfolio.

 

Removal of Forum in SGXDATA

For the pass few months, I have noticed that there are many spam and botnet hitting the Forum section of the SGXDATA site.  Since the Forum isn't active yet too, I have decided to remove it.  Hope this will help to reduce the botnet traffic.

Website Error

It seems that sometimes the website is getting "500 Internal Server Error".  We are still investigating this issue.  If you encounter this error, please refresh the browser again.

Portfolio Feature

We have added a new Portfolio feature in "A Dividend Seeker".  Once you create an account and login, you can add counters into your portfolio.  Once you had login, a cookie will be added such that you do not need to login again on that device until you logout or clears your browser's cookie.

This will allow you to specify your own list of counter to monitor.  You can bookmark that page and view that page directly.

SGX Dividend Data keep getting duplicated data

Sometimes, you may notice that a stock shows a high dividend percentage.  Some of these may not be correct.  There seems to have duplicated dividend data once awhile.  I will perform a cleanup once every friday, in the evening.

SGX Dividend Data

Had done a big clean up of the SGX Dividend Data.  The dividend data should tally with those given by SGX.com now.  If you notice any inaccuracy, please post a comment to notify me.

Singapore Pools Archive

Fans of 4D and Toto from Singapore Pools, you can access the Singapore Pools Archive here : http://pebbleslab.com/singpools