Ever since Yahoo abandoned us, we were left stranded without a data source to fetch stock prices. I previously blogged about an alternative - Bye Yahoo Finance! Hi Alpha Vantage! but it has its limitations too. For unknown reasons, sometimes it just doesn't work/return the price of a particular stock code/counter. I suspected that it could be due to the high number of API calls and added additional control such as retrieving the stock price only if we are still owning them but it still wasn't very successful.
As a result, I even modified my google spreadsheet by having a second and third column to re-call the API if it fails. I even have a "Manual" column to fill in the price on my own if all else fails... Yes, it do happen ~.~"

Regular readers will know that we have been using StocksCafe to track the performance of our portfolio and it

...